#

luxiaotao1123

2022-09-18 42fb81ed45edd0a2106f12e8aa6ce1c77babe18b

#

 src/main/java/com/zy/crm/manager/controller/CstmrController.java

@@ -15,6 +15,8 @@
import com.zy.crm.manager.entity.CstmrType;
import com.zy.crm.manager.service.CstmrService;
import com.zy.crm.manager.service.CstmrTypeService;
import com.zy.crm.system.entity.Dic;
import com.zy.crm.system.service.DicService;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
@@ -39,6 +41,8 @@
    private CstmrService cstmrService;
    @Autowired
    private CstmrTypeService cstmrTypeService;
    @Autowired
    private DicService dicService;

    @RequestMapping(value = "/cstmr/{id}/auth")
    @ManagerAuth
@@ -236,11 +240,26 @@
                // 备注
                cstmr.setRemarks(row.getCell(6).getStringCellValue());
                // 省
                cstmr.setProvince(row.getCell(7).getStringCellValue());
                String province = row.getCell(7).getStringCellValue();
                Dic dicProvince = dicService.selectByName(province);
                if (Cools.isEmpty(dicProvince)) {
                    throw new CoolException("第" + i + "行省名不合法，请重新导入");
                }
                cstmr.setProvince(dicProvince.getCode());
                // 市
                cstmr.setCity(row.getCell(8).getStringCellValue());
                String city = row.getCell(8).getStringCellValue();
                Dic dicCity = dicService.selectByName(city);
                if (Cools.isEmpty(dicCity)) {
                    throw new CoolException("第" + i + "行市名不合法，请重新导入");
                }
                cstmr.setCity(dicCity.getCode());
                // 区
                cstmr.setDistrict(row.getCell(9).getStringCellValue());
                String district = row.getCell(9).getStringCellValue();
                Dic dicDistrict = dicService.selectByName(district);
                if (Cools.isEmpty(dicDistrict)) {
                    throw new CoolException("第" + i + "行县名不合法，请重新导入");
                }
                cstmr.setDistrict(dicDistrict.getCode());
                // 详细地址
                cstmr.setAddr(row.getCell(10).getStringCellValue());
                // 区分

 src/main/java/com/zy/crm/system/mapper/DicMapper.java

@@ -9,4 +9,6 @@
@Repository
public interface DicMapper extends BaseMapper<Dic> {

    Dic selectByName(String name);

}

 src/main/java/com/zy/crm/system/service/DicService.java

@@ -5,4 +5,6 @@

public interface DicService extends IService<Dic> {

    Dic selectByName(String name);

}

 src/main/java/com/zy/crm/system/service/impl/DicServiceImpl.java

@@ -9,4 +9,8 @@
@Service("dicService")
public class DicServiceImpl extends ServiceImpl<DicMapper, Dic> implements DicService {

    @Override
    public Dic selectByName(String name) {
        return this.baseMapper.selectByName(name);
    }
}

 src/main/resources/mapper/DicMapper.xml

@@ -10,4 +10,11 @@

    </resultMap>

    <select id="selectByName" resultMap="BaseResultMap">
        select top 1 *
        from sys_dic
        where 1=1
        and name = #{name}
    </select>

</mapper>