From fae8a9349499cd045bc73e8fd22aeae52618a46c Mon Sep 17 00:00:00 2001 From: WangHan <wwh_work@126,com> Date: 星期四, 19 十二月 2024 10:02:02 +0800 Subject: [PATCH] 采购明细查询修改,查询本级及以下 --- consum-base/src/main/java/com/consum/base/service/impl/BaseWarehouseServiceImpl.java | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/impl/BaseWarehouseServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/BaseWarehouseServiceImpl.java index 4eff7a9..b59b416 100644 --- a/consum-base/src/main/java/com/consum/base/service/impl/BaseWarehouseServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/impl/BaseWarehouseServiceImpl.java @@ -93,11 +93,11 @@ if (param.getAgencyId() != null) { Integer lv = currentUser.getLv(); if (lv != 1) { - sql.append(" and AGENCY_ID =:AGENCY_ID "); - paramts.put("AGENCY_ID", param.getAgencyId()); + sql.append(" and AGENCY_ID =:agencyId "); + paramts.put("agencyId", param.getAgencyId()); } else { - sql.append(" and AGENCY_ID like :AGENCY_ID "); - paramts.put("AGENCY_ID", param.getAgencyId() + StringUtils.CHAR_PERCENT); + sql.append(" and AGENCY_ID like :agencyId "); + paramts.put("agencyId", param.getAgencyId() + StringUtils.CHAR_PERCENT); } } // 鐘舵�� -- Gitblit v1.9.1