From a7a6b5d7ed7b6e5b96866b24fd1cb7ba3dcc19d1 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期三, 22 十一月 2023 14:24:47 +0800
Subject: [PATCH] feat: 物品统计前后端
---
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