From 53813b862f027c97c967415bb7773ffbf6b6ea3d Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期五, 01 十二月 2023 14:51:49 +0800 Subject: [PATCH] feat: 部门报废 --- consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java | 28 +++++++++++++++------------- 1 files changed, 15 insertions(+), 13 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 f895602..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,8 +1,8 @@ package com.consum.base.service; -import com.consum.model.po.BaseGoodsModels; -import com.consum.model.po.S_dict_data; +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; @@ -13,11 +13,11 @@ public class SDictDataServiceImpl extends BaseServiceImpl { /** - * @Description 鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀 + * @Description 鏍规嵁鎶ュ簾鍘熷洜code鏌ヨ鏁版嵁瀛楀吀 * @Author 鍗㈠簡闃� * @Date 2023/11/2 */ - public List<S_dict_data> selectByScrappedCodeList(List<String> scrappedCodeList) { + public List<SDictData> selectByScrappedCodeList(List scrappedCodeList) { if (CollectionUtils.isEmpty(scrappedCodeList)) { log.error("鍙傛暟閿欒"); return null; @@ -25,15 +25,17 @@ 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(")"); - return this.select(sql.toString(), paramts, new S_dict_data()); +// 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