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());
|
}
|
}
|
