From c1ac6d13630b04b4e11d6f383858e4f8fa64f924 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期六, 02 十二月 2023 17:24:34 +0800
Subject: [PATCH] 盘点查询返回结果修改
---
consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 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..32cac01 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,41 @@
package com.consum.base.service;
+import com.consum.model.po.SDictData;
import com.walker.jdbc.service.BaseServiceImpl;
+import org.apache.commons.lang3.StringUtils;
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 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 ( ").append(
+ StringUtils.join(scrappedCodeList, ",")).append(")");
+
+// 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