From 24fc98301c0b38a76b7d5aa704fe79a2e385e584 Mon Sep 17 00:00:00 2001
From: 石广澎 <shiguangpeng@163.com>
Date: 星期三, 29 十一月 2023 14:20:41 +0800
Subject: [PATCH] feat: 1、物品分发部门查询 2、分发新增数量校验
---
consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java
index 7c362d8..4488427 100644
--- a/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java
@@ -1,9 +1,38 @@
package com.consum.base.service;
+import com.consum.model.po.SDictData;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;
+import org.springframework.util.CollectionUtils;
+
+import java.util.HashMap;
+import java.util.List;
@Service
public class SDictDataServiceImpl extends BaseServiceImpl {
+ /**
+ * @Description 鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/11/2
+ */
+ public List<SDictData> selectByScrappedCodeList(List<String> scrappedCodeList) {
+ if (CollectionUtils.isEmpty(scrappedCodeList)) {
+ log.error("鍙傛暟閿欒");
+ return null;
+ }
+ StringBuilder sql = new StringBuilder("SELECT * FROM s_dict_data WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+
+ sql.append(" and dict_code in ( ");
+ for (int i = 0; i < scrappedCodeList.size(); i++) {
+ sql.append(scrappedCodeList.get(i));
+ if (i < scrappedCodeList.size() - 1) {
+ sql.append(",");
+ }
+ }
+ sql.append(" ) ");
+
+ return this.select(sql.toString(), paramts, new SDictData());
+ }
}
--
Gitblit v1.9.1