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/LWhProcureModelServiceImpl.java | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java index 809348f..7dbf735 100644 --- a/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java @@ -172,4 +172,20 @@ }); return goodsModelList; } + + @Override + public List<LWhProcureModel> getModelByForm1(WhBusinessEnum businessType, Long businessId) { + StringBuilder sql = new StringBuilder("SELECT * FROM L_WH_PROCURE_MODEL WHERE 1=1 "); + HashMap<String, Object> paramts = new HashMap<>(); + if (businessType != null) { + sql.append(" and BUSINESS_TYPE=:businessType "); + paramts.put("businessType", businessType.getValue()); + } + if (businessId != null) { + sql.append(" and BUSINESS_ID=:businessId "); + paramts.put("businessId", businessId); + } + List<LWhProcureModel> select = select(sql.toString(), paramts, new LWhProcureModel()); + return select; + } } -- Gitblit v1.9.1