From a4273f1a1a6e63b7543acb2472b2af806fe44f41 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期四, 21 十二月 2023 14:28:08 +0800 Subject: [PATCH] 库管员设置过滤禁用部门与用户 --- 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