From 01107e8aadfaf1e84a971d8eeb9ab37e1c5569f3 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期五, 01 十二月 2023 09:38:56 +0800 Subject: [PATCH] feat: 部门退回/报废公用接口 --- consum-base/src/main/java/com/consum/base/service/FinWarehouseLedgerServiceImpl.java | 10 ++++++---- 1 files changed, 6 insertions(+), 4 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/FinWarehouseLedgerServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/FinWarehouseLedgerServiceImpl.java index aa681ad..5429a66 100644 --- a/consum-base/src/main/java/com/consum/base/service/FinWarehouseLedgerServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/FinWarehouseLedgerServiceImpl.java @@ -34,8 +34,9 @@ } //鏈烘瀯 if (param.getAgencyId() != null) { - sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); - paramts.put("lengthAgencyId", param.getAgencyId()); +// sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); + sql.append(" and ware.AGENCY_ID = :agencyId"); +// paramts.put("lengthAgencyId", param.getAgencyId()); paramts.put("agencyId", param.getAgencyId()); } //浠撳簱绫诲瀷 @@ -141,8 +142,9 @@ } //鏈烘瀯 if (param.getAgencyId() != null) { - sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); - paramts.put("lengthAgencyId", param.getAgencyId()); +// sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); + sql.append(" and ware.AGENCY_ID = :agencyId"); +// paramts.put("lengthAgencyId", param.getAgencyId()); paramts.put("agencyId", param.getAgencyId()); } //浠撳簱绫诲瀷 -- Gitblit v1.9.1