package com.consum.base.service.impl;
|
|
import com.consum.base.service.SDictDataService;
|
import java.util.HashMap;
|
import java.util.List;
|
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.CollectionUtils;
|
|
import com.consum.model.po.SDictData;
|
import com.walker.jdbc.service.BaseServiceImpl;
|
|
@Service
|
public class SDictDataServiceImpl extends BaseServiceImpl implements SDictDataService {
|
|
/**
|
* @Description 根据报废原因code查询数据字典
|
* @Author 卢庆阳
|
* @Date 2023/11/2
|
*/
|
@Override
|
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(")");
|
|
return this.select(sql.toString(), paramts, new SDictData());
|
}
|
}
|