From 24c4699005da96f45562d7057d80c103b8e428a2 Mon Sep 17 00:00:00 2001
From: WangHan <wwh_work@126,com>
Date: 星期五, 03 一月 2025 10:32:34 +0800
Subject: [PATCH] 子级分类在用删除
---
consum-base/src/main/java/com/consum/base/service/impl/LWhProcureModelServiceImpl.java | 18 ++++++++++++++++--
1 files changed, 16 insertions(+), 2 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 906d9f7..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
@@ -36,7 +36,6 @@
public List<LWhProcureModel> getModelByForm(WhBusinessEnum businessType, Long businessId) {
StringBuilder sql = new StringBuilder(GET_MODEL_BY_FORM);
HashMap<String, Object> paramts = new HashMap<>();
- // 椤圭洰闃舵id
if (businessType != null) {
sql.append(" and BUSINESS_TYPE=:businessType ");
paramts.put("businessType", businessType.getValue());
@@ -64,7 +63,6 @@
public List<Map<String, Object>> getFfOrderByGoodsIdAndDept(Long goodsTemplateId, Long departmentId) {
StringBuilder sql = new StringBuilder(GET_FF_ORDER_BY_GOODS_ID_AND_DEPT);
HashMap<String, Object> paramts = new HashMap<>();
- // 椤圭洰闃舵id
if (goodsTemplateId != null) {
sql.append(" AND baseTemp.ID=:goodsTemplateId ");
paramts.put("goodsTemplateId", goodsTemplateId);
@@ -174,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