From 5e6c61b8753870ef2f8cde60eef47e3eeefe89e6 Mon Sep 17 00:00:00 2001 From: luqingyang <lqy5492@163.com> Date: 星期四, 02 十一月 2023 17:35:48 +0800 Subject: [PATCH] 报废单 相关代码 --- consum-base/src/main/java/com/consum/base/service/SDictDataServiceImpl.java | 30 ++++++++++++++++++++++++++++++ 1 files changed, 30 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..f895602 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,39 @@ package com.consum.base.service; +import com.consum.model.po.BaseGoodsModels; +import com.consum.model.po.S_dict_data; 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<S_dict_data> 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 S_dict_data()); + } } -- Gitblit v1.9.1