From edc87e2fc3760cd7d1230bc058acf5620ea2c465 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期六, 02 十二月 2023 15:03:15 +0800
Subject: [PATCH] 部门分发添加,分发单型号查询
---
consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java | 23 +++++++++++++----------
1 files changed, 13 insertions(+), 10 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 4488427..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
@@ -2,6 +2,7 @@
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;
@@ -12,11 +13,11 @@
public class SDictDataServiceImpl extends BaseServiceImpl {
/**
- * @Description 鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀
+ * @Description 鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀
* @Author 鍗㈠簡闃�
* @Date 2023/11/2
*/
- public List<SDictData> selectByScrappedCodeList(List<String> scrappedCodeList) {
+ public List<SDictData> selectByScrappedCodeList(List scrappedCodeList) {
if (CollectionUtils.isEmpty(scrappedCodeList)) {
log.error("鍙傛暟閿欒");
return null;
@@ -24,14 +25,16 @@
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(" ) ");
+ 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