From 7c40b902af2ae09b353525f913056d66af12caf1 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期六, 09 十二月 2023 17:02:43 +0800 Subject: [PATCH] feat: 1.新增人员机构错误 2.修改使用人时设置可用数量 3.重复预警 4.部门物品退回时设置调拨单信息 5.统计报表删除一列 --- 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