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 selectByScrappedCodeList(List scrappedCodeList) { if (CollectionUtils.isEmpty(scrappedCodeList)) { log.error("参数错误"); return null; } StringBuilder sql = new StringBuilder("SELECT * FROM s_dict_data WHERE 1 = 1 "); HashMap paramts = new HashMap<>(); sql.append(" and dict_code in ( ").append(StringUtils.join(scrappedCodeList, ",")).append(")"); return this.select(sql.toString(), paramts, new SDictData()); } }