package cn.huge.module.ctuser.service; import cn.huge.base.common.constant.GzRegionBaseEnum; import cn.huge.base.common.dto.SelectTermDTO; import cn.huge.base.common.exception.ServiceException; import cn.huge.base.common.utils.DateUtils; import cn.huge.base.common.utils.IdUtils; import cn.huge.base.common.utils.ObjectUtils; import cn.huge.base.common.utils.SelectTermUtils; import cn.huge.module.client.api.impl.UtilsClientImpl; import cn.huge.module.constant.BaseConsts; import cn.huge.module.ctuser.dao.mapper.CtUnitMapper; import cn.huge.module.ctuser.domain.po.*; import cn.huge.module.ctuser.dto.CtUnitWeChatCountDTO; import cn.huge.module.cust.constant.RoleBaseEnum; import cn.huge.module.cust.constant.UserBaseConsts; import cn.huge.module.cust.dto.CtUnitDTO; import cn.huge.module.cust.dto.CtUserDTO; import cn.huge.module.kind.domain.po.SyRegion; import cn.huge.module.kind.service.SyRegionService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.extern.slf4j.Slf4j; import org.apache.commons.collections.CollectionUtils; import org.apache.commons.lang3.StringUtils; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellType; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageImpl; import org.springframework.data.domain.PageRequest; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.DigestUtils; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.MultipartHttpServletRequest; import java.io.InputStream; import java.text.SimpleDateFormat; import java.util.*; import java.util.stream.Collectors; /** * @author liyj * @version 1.0.0 * @title: Excel表格操作业务逻辑处理 * @Description Excel表格操作业务逻辑处理 * @company hugeinfo * @Time 2024-08-19 20:04:19 */ @Slf4j @Service public class ExcelOperCtunitService { @Autowired private UtilsClientImpl utilsClient; @Autowired private CtUnitService ctUnitService; @Autowired private CtDeptService ctDeptService; @Autowired private CtUserService ctUserService; @Autowired private CtAccountService ctAccountService; @Autowired private CtUseroleService ctUseroleService; @Autowired private SyRegionService syRegionService; /** * 获取单元格数据 * * @param sheet 表示Excel工作表对象，从中获取指定单元格的数据 * @param r 表示单元格所在的行索引，从0开始计数 * @param c 表示单元格所在的列索引，从0开始计数 * @return 返回指定单元格中的数据，如果单元格为空或者工作表为空则返回null */ public String transform(Sheet sheet, int r, int c) { // 检查工作表是否为空 if (ObjectUtils.isNotEmpty(sheet)) { // 获取指定行和列的单元格 Cell cell = sheet.getRow(r).getCell(c); // 检查单元格是否为空 if (ObjectUtils.isNotEmpty(cell)) { // 注意：setCellType方法已弃用，可考虑使用其他替代方法 cell.setCellType(CellType.STRING); // 获取单元格中的字符串值 String val = cell.getStringCellValue(); // 去除字符串中的空格并返回 return val.replace(" ", ""); } else { // 单元格为空，返回null return null; } } else { // 工作表为空，返回null return null; } } /** * 通过Excel创建单位和账号 * * @param request */ public void inputByExcel241124(MultipartHttpServletRequest request) { try { Iterator itr = request.getFileNames(); while (itr.hasNext()) { MultipartFile file = request.getFile(itr.next()); String fileSuffix = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf(".")); if (".xls".equals(fileSuffix) || ".xlsx".equals(fileSuffix) || "xls".equals(fileSuffix) || "xlsx".equals(fileSuffix)) { InputStream inputStream = file.getInputStream(); Workbook wb = null; //当excel是2003时 if (".xls".equals(fileSuffix)) { wb = new HSSFWorkbook(inputStream); } else { wb = new XSSFWorkbook(inputStream); } //得到第一个shell Sheet sheet = wb.getSheetAt(0); //得到Excel的行数 int totalRows = sheet.getPhysicalNumberOfRows(); //人员信息 Date nowDate = DateUtils.getNowDate(); for (int r = 1; r < totalRows; r++) { try { // 获取数据 String area = this.transform(sheet, r, 0); String areaName = this.transform(sheet, r, 1); String road = this.transform(sheet, r, 2); String roadName = this.transform(sheet, r, 3); String village = this.transform(sheet, r, 4); String villageName = this.transform(sheet, r, 5); String id = this.transform(sheet, r, 6); String unitName = this.transform(sheet, r, 7); String parentId = this.transform(sheet, r, 8); String level = this.transform(sheet, r, 9); String unitGrade = this.transform(sheet, r, 10); String unitType = this.transform(sheet, r, 11); String trueName = this.transform(sheet, r, 12); String mobile = this.transform(sheet, r, 13); String idcard = this.transform(sheet, r, 14); String cipher = this.transform(sheet, r, 15); if (StringUtils.isBlank(cipher)) { // 默认密码 cipher = UserBaseConsts.MR_CIPHER_GZ; } // 新增单位 CtUnit ctUnit = new CtUnit(); ctUnit.setId(id); ctUnit.setLevel(Integer.parseInt(level)); ctUnit.setParentId(parentId); ctUnit.setUnitGrade(Integer.parseInt(unitGrade)); ctUnit.setUnitFun(UserBaseConsts.UNIT_FUN_1); ctUnit.setUnitType(Integer.parseInt(unitType)); ctUnit.setCourtStatus(UserBaseConsts.COURT_STATUS_0); ctUnit.setUnitName(unitName); if (UserBaseConsts.UNIT_GRADE_2 == ctUnit.getUnitGrade()) { ctUnit.setUnitDes(unitName); } else { ctUnit.setUnitDes(roadName + "-" + unitName); } ctUnit.setJoinWay(UserBaseConsts.JOIN_WAY_1); ctUnit.setProv(GzRegionBaseEnum.PROV_1.getIndex()); ctUnit.setProvName(GzRegionBaseEnum.PROV_1.getDes()); ctUnit.setCity(GzRegionBaseEnum.CITY_1.getIndex()); ctUnit.setCityName(GzRegionBaseEnum.CITY_1.getDes()); ctUnit.setArea(area); ctUnit.setAreaName(areaName); ctUnit.setRoad(road); ctUnit.setRoadName(roadName); ctUnit.setVillage(village); ctUnit.setVillageName(villageName); ctUnit.setAddr(ctUnit.getUnitDes()); ctUnit.setFindStatus(UserBaseConsts.FIND_STATUS_0); ctUnit.setDispStatus(UserBaseConsts.DISP_STATUS_0); ctUnit.setDeleteStatus(BaseConsts.DELETE_STATUS_0); ctUnit.setCreateTime(nowDate); ctUnit.setUpdateTime(nowDate); try { ctUnitService.save(ctUnit); } catch (Exception e) { log.error("已存在"); } // 新增人员 CtUser ctUser = new CtUser(); ctUser.setId(utilsClient.getNewTimeId()); ctUser.setTrueName(trueName); ctUser.setAcc(mobile); if (StringUtils.isNotBlank(idcard)) { ctUser.setMobile(mobile); } ctUser.setIdcard(idcard); ctUser.setUnitId(ctUnit.getId()); ctUser.setUnitName(ctUnit.getUnitName()); ctUser.setCreateTime(nowDate); ctUser.setJoinWay(UserBaseConsts.JOIN_WAY_1); ctUser.setRealStatus(UserBaseConsts.REAL_STATUS_0); ctUser.setStatus(UserBaseConsts.USER_STATUS_1); ctUser.setFindStatus(UserBaseConsts.FIND_STATUS_0); ctUser.setDispStatus(UserBaseConsts.DISP_STATUS_0); ctUser.setDeleteStatus(BaseConsts.DELETE_STATUS_0); ctUser.setCustId("-1"); ctUser.setCreateTime(nowDate); ctUser.setUpdateTime(nowDate); ctUserService.save(ctUser); // 新增人员账号 CtAccount ctAccount = new CtAccount(); ctAccount.setId(utilsClient.getNewTimeId()); ctAccount.setCustId(ctUser.getCustId()); ctAccount.setUserId(ctUser.getId()); ctAccount.setAccType(UserBaseConsts.ACC_TYPE_1); ctAccount.setAcc(ctUser.getAcc()); ctAccount.setCipher(DigestUtils.md5DigestAsHex(cipher.getBytes())); ctAccount.setCipherOpen(cipher); ctAccount.setDeleteStatus(BaseConsts.DELETE_STATUS_0); ctAccount.setCustId("-1"); ctAccount.setCreateTime(nowDate); ctAccount.setCipherTime(nowDate); ctAccount.setUpdateTime(nowDate); ctAccountService.save(ctAccount); // 新增人员角色关系-单位管理员 CtUserole ctUserole1 = new CtUserole(); ctUserole1.setId(utilsClient.getNewTimeId()); ctUserole1.setUserId(ctUser.getId()); ctUserole1.setRoleId(RoleBaseEnum.ROLE_3.getIndex()); ctUserole1.setRoleCode(RoleBaseEnum.ROLE_3.getIndex()); ctUserole1.setRoleName(RoleBaseEnum.ROLE_3.getDes()); ctUserole1.setCustId("-1"); ctUserole1.setCreateTime(nowDate); ctUserole1.setUpdateTime(nowDate); ctUseroleService.save(ctUserole1); // 新增人员角色关系-纠纷化解人员 CtUserole ctUserole2 = new CtUserole(); ctUserole2.setId(utilsClient.getNewTimeId()); ctUserole2.setUserId(ctUser.getId()); ctUserole2.setRoleId(RoleBaseEnum.ROLE_4.getIndex()); ctUserole2.setRoleCode(RoleBaseEnum.ROLE_4.getIndex()); ctUserole2.setRoleName(RoleBaseEnum.ROLE_4.getDes()); ctUserole2.setCustId("-1"); ctUserole2.setCreateTime(nowDate); ctUserole2.setUpdateTime(nowDate); ctUseroleService.save(ctUserole2); } catch (Exception e) { log.error(e.getMessage(), e); continue; } } } } } catch (Exception e) { log.error("[ExcelOperCtunitService.inputByExcel241124]调用失败，异常信息：" + e, e); throw new ServiceException("ExcelOperCtunitService.inputByExcel241124", e); } } /** * 通过Excel创建单位和账号 * * @param request */ public void inputByExcel250304(MultipartHttpServletRequest request) { String errorInfo = ""; try { SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd"); String custId = sdf.format(new Date()); Iterator itr = request.getFileNames(); while (itr.hasNext()) { MultipartFile file = request.getFile(itr.next()); String fileSuffix = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf(".")); if (".xls".equals(fileSuffix) || ".xlsx".equals(fileSuffix) || "xls".equals(fileSuffix) || "xlsx".equals(fileSuffix)) { InputStream inputStream = file.getInputStream(); Workbook wb = null; //当excel是2003时 if (".xls".equals(fileSuffix)) { wb = new HSSFWorkbook(inputStream); } else { wb = new XSSFWorkbook(inputStream); } //得到第一个shell Sheet sheet = wb.getSheetAt(0); //得到Excel的行数 int totalRows = sheet.getPhysicalNumberOfRows(); //人员信息 Date nowDate = DateUtils.getNowDate(); // 调解组织所属区名称 String areaName = this.transform(sheet, 0, 0); // 调解组织所属区 String area = GzRegionBaseEnum.getIndex(areaName); for (int r = 2; r < totalRows; r++) { try { // 调解组织所属街道名称 String roadName = this.transform(sheet, r, 0); // 调解组织名称 String unitName = this.transform(sheet, r, 1); // 调解组织类型 String unitGradeStr = this.transform(sheet, r, 2); int unitGrade = Integer.parseInt(unitGradeStr); // 调解组织类型 String unitTypeStr = this.transform(sheet, r, 3); int unitType = Integer.parseInt(unitTypeStr); // 人员姓名 String trueName = this.transform(sheet, r, 4); // 人员联系方式 String mobile = this.transform(sheet, r, 5); // 人员身份证号 String idcard = this.transform(sheet, r, 6); // 调解组织地址 String addr = this.transform(sheet, r, 7); // 默认密码 String cipher = "Gzs@2025"; if (GzRegionBaseEnum.AREA_1.getIndex().equals(area)) { cipher = "Gzth@2025"; } else if(GzRegionBaseEnum.AREA_2.getIndex().equals(area)) { cipher = "Gzhz@2025"; }else if(GzRegionBaseEnum.AREA_3.getIndex().equals(area)) { cipher = "Gzlw@2025"; }else if(GzRegionBaseEnum.AREA_4.getIndex().equals(area)) { cipher = "Gzyx@2025"; }else if(GzRegionBaseEnum.AREA_5.getIndex().equals(area)) { cipher = "Gzpy@2025"; }else if(GzRegionBaseEnum.AREA_6.getIndex().equals(area)) { cipher = "Gzhd@2025"; }else if(GzRegionBaseEnum.AREA_7.getIndex().equals(area)) { cipher = "Gzby@2025"; }else if(GzRegionBaseEnum.AREA_8.getIndex().equals(area)) { cipher = "Gzns@2025"; }else if(GzRegionBaseEnum.AREA_9.getIndex().equals(area)) { cipher = "Gzhp@2025"; }else if(GzRegionBaseEnum.AREA_10.getIndex().equals(area)) { cipher = "Gzzc@2025"; }else if(GzRegionBaseEnum.AREA_11.getIndex().equals(area)) { cipher = "Gzch@2025"; } QueryWrapper syRegionQueryWrapper = new QueryWrapper<>(); syRegionQueryWrapper.eq("parent_id", area).like("name", roadName); SyRegion roadSyRegion = syRegionService.getOne(syRegionQueryWrapper); // 查询是否存在该单位 QueryWrapper ctUnitQueryWrapper = new QueryWrapper<>(); ctUnitQueryWrapper.eq("area", area) .eq("unit_grade", unitGrade) .eq("unit_type", unitType) .eq("unit_name", unitName); if (UserBaseConsts.UNIT_GRADE_3 == unitGrade || UserBaseConsts.UNIT_GRADE_4 == unitGrade) { ctUnitQueryWrapper.eq("road", roadSyRegion.getId()); } List ctUnitList = ctUnitService.list(ctUnitQueryWrapper); CtUnit ctUnit = null; if (CollectionUtils.isEmpty(ctUnitList)) { // 新增单位 ctUnit = new CtUnit(); // 主键 ctUnit.setId(utilsClient.getNewTimeId()); // 层级 ctUnit.setLevel(unitGrade); // 父级组织 todo if (UserBaseConsts.UNIT_GRADE_2 == unitGrade) { if (UserBaseConsts.UNIT_TYPE_101 == unitType){ // 综治中心，父级是广州市综治中心 ctUnitQueryWrapper.clear(); ctUnitQueryWrapper.eq("city", GzRegionBaseEnum.CITY_1.getIndex()) .eq("unit_type", UserBaseConsts.UNIT_TYPE_101) .eq("unit_grade", UserBaseConsts.UNIT_GRADE_1); List zzzxList = ctUnitService.list(ctUnitQueryWrapper); ctUnit.setParentId(zzzxList.get(0).getId()); }else { // 其他，父级是区综治中心 ctUnitQueryWrapper.clear(); ctUnitQueryWrapper.eq("area", area) .eq("unit_type", UserBaseConsts.UNIT_TYPE_101) .eq("unit_grade", UserBaseConsts.UNIT_GRADE_2); List zzzxList = ctUnitService.list(ctUnitQueryWrapper); ctUnit.setParentId(zzzxList.get(0).getId()); } }else if (UserBaseConsts.UNIT_GRADE_3 == unitGrade) { if (UserBaseConsts.UNIT_TYPE_101 == unitType){ // 综治中心，父级是区综治中心 ctUnitQueryWrapper.clear(); ctUnitQueryWrapper.eq("area", area) .eq("unit_type", UserBaseConsts.UNIT_TYPE_101) .eq("unit_grade", UserBaseConsts.UNIT_GRADE_2); List zzzxList = ctUnitService.list(ctUnitQueryWrapper); ctUnit.setParentId(zzzxList.get(0).getId()); }else { // 其他，父级是街道综治中心 ctUnitQueryWrapper.clear(); ctUnitQueryWrapper.eq("area", area) .eq("unit_type", UserBaseConsts.UNIT_TYPE_101) .eq("unit_grade", UserBaseConsts.UNIT_GRADE_3) .eq("road", roadSyRegion.getId()); List zzzxList = ctUnitService.list(ctUnitQueryWrapper); ctUnit.setParentId(zzzxList.get(0).getId()); } }else if (UserBaseConsts.UNIT_GRADE_4 == unitGrade){ ctUnitQueryWrapper.clear(); ctUnitQueryWrapper.eq("area", area) .eq("unit_type", UserBaseConsts.UNIT_TYPE_101) .eq("unit_grade", UserBaseConsts.UNIT_GRADE_3) .eq("road", roadSyRegion.getId()); List zzzxList = ctUnitService.list(ctUnitQueryWrapper); ctUnit.setParentId(zzzxList.get(0).getId()); } // 组织级别 ctUnit.setUnitGrade(unitGrade); // 组织职能 ctUnit.setUnitFun(UserBaseConsts.UNIT_FUN_1); // 组织职能 ctUnit.setUnitType(unitType); // 是否是法院 if (UserBaseConsts.UNIT_TYPE_104 == unitType) { ctUnit.setCourtStatus(UserBaseConsts.COURT_STATUS_1); }else { ctUnit.setCourtStatus(UserBaseConsts.COURT_STATUS_0); } // 组织名称 ctUnit.setUnitName(unitName); // 组织描述 if (UserBaseConsts.UNIT_GRADE_3 == unitGrade && UserBaseConsts.UNIT_TYPE_102 == unitType) { ctUnit.setUnitName(roadName+unitName); ctUnit.setUnitDes(roadName + "-" + unitName); } else if (UserBaseConsts.UNIT_GRADE_3 == unitGrade && UserBaseConsts.UNIT_TYPE_106 == unitType) { ctUnit.setUnitName(roadName+unitName); ctUnit.setUnitDes(roadName + "-" + unitName); } else if (UserBaseConsts.UNIT_GRADE_2 == unitGrade && UserBaseConsts.UNIT_TYPE_102 == unitType) { ctUnit.setUnitName(roadName+unitName); ctUnit.setUnitDes(roadName + "-" + unitName); } else if (UserBaseConsts.UNIT_GRADE_2 == unitGrade && UserBaseConsts.UNIT_TYPE_104 == unitType) { ctUnit.setUnitName(roadName+unitName); ctUnit.setUnitDes(roadName + "-" + unitName); } else if (UserBaseConsts.UNIT_GRADE_2 == unitGrade && UserBaseConsts.UNIT_TYPE_105 == unitType) { ctUnit.setUnitName(roadName+unitName); ctUnit.setUnitDes(roadName + "-" + unitName); } else { ctUnit.setUnitDes(unitName); } ctUnit.setJoinWay(UserBaseConsts.JOIN_WAY_1); ctUnit.setProv(GzRegionBaseEnum.PROV_1.getIndex()); ctUnit.setProvName(GzRegionBaseEnum.PROV_1.getDes()); ctUnit.setCity(GzRegionBaseEnum.CITY_1.getIndex()); ctUnit.setCityName(GzRegionBaseEnum.CITY_1.getDes()); ctUnit.setArea(area); ctUnit.setAreaName(areaName); // 查询街道编码 if (UserBaseConsts.UNIT_GRADE_3 == unitGrade || UserBaseConsts.UNIT_GRADE_4 == unitGrade) { ctUnit.setRoad(roadSyRegion.getId()); ctUnit.setRoadName(roadName); // 村级编码 if (UserBaseConsts.UNIT_GRADE_4 == unitGrade) { syRegionQueryWrapper.clear(); syRegionQueryWrapper.eq("parent_id", ctUnit.getRoad()).like("name", unitName.replace("居委会", "")); SyRegion villageSyRegion = syRegionService.getOne(syRegionQueryWrapper); if (ObjectUtils.isNotEmpty(villageSyRegion)) { ctUnit.setVillage(villageSyRegion.getId()); ctUnit.setVillageName(villageSyRegion.getName()); } } } ctUnit.setAddr(addr); ctUnit.setFindStatus(UserBaseConsts.FIND_STATUS_0); ctUnit.setDispStatus(UserBaseConsts.DISP_STATUS_0); ctUnit.setDeleteStatus(BaseConsts.DELETE_STATUS_0); ctUnit.setCustId(custId); ctUnit.setCreateTime(nowDate); ctUnit.setUpdateTime(nowDate); try { ctUnitService.save(ctUnit); } catch (Exception e) { errorInfo = errorInfo+unitName+";"; log.error("liyj添加单位报错", e); } }else { ctUnit = ctUnitList.get(0); } // 新增人员 if (StringUtils.isEmpty(trueName)) { QueryWrapper ctUserQueryWrapper = new QueryWrapper<>(); ctUserQueryWrapper.eq("true_name", trueName) .eq("idcard", idcard); List ctUserList = ctUserService.list(ctUserQueryWrapper); if (CollectionUtils.isEmpty(ctUserList)) { CtUser ctUser = new CtUser(); ctUser.setId(utilsClient.getNewTimeId()); ctUser.setTrueName(trueName); ctUser.setAcc(mobile); if (StringUtils.isNotBlank(idcard)) { ctUser.setMobile(mobile); } ctUser.setIdcard(idcard); ctUser.setUnitId(ctUnit.getId()); ctUser.setUnitName(ctUnit.getUnitName()); ctUser.setCreateTime(nowDate); ctUser.setJoinWay(UserBaseConsts.JOIN_WAY_1); ctUser.setRealStatus(UserBaseConsts.REAL_STATUS_0); ctUser.setStatus(UserBaseConsts.USER_STATUS_1); ctUser.setFindStatus(UserBaseConsts.FIND_STATUS_0); ctUser.setDispStatus(UserBaseConsts.DISP_STATUS_0); ctUser.setDeleteStatus(BaseConsts.DELETE_STATUS_0); ctUser.setCustId(custId); ctUser.setCreateTime(nowDate); ctUser.setUpdateTime(nowDate); ctUserService.save(ctUser); // 新增人员账号 CtAccount ctAccount = new CtAccount(); ctAccount.setId(utilsClient.getNewTimeId()); ctAccount.setCustId(ctUser.getCustId()); ctAccount.setUserId(ctUser.getId()); ctAccount.setAccType(UserBaseConsts.ACC_TYPE_1); ctAccount.setAcc(ctUser.getAcc()); ctAccount.setCipher(DigestUtils.md5DigestAsHex(cipher.getBytes())); ctAccount.setCipherOpen(cipher); ctAccount.setDeleteStatus(BaseConsts.DELETE_STATUS_0); ctAccount.setCustId(custId); ctAccount.setCreateTime(nowDate); ctAccount.setCipherTime(nowDate); ctAccount.setUpdateTime(nowDate); ctAccountService.save(ctAccount); // 新增人员角色关系-单位管理员 CtUserole ctUserole1 = new CtUserole(); ctUserole1.setId(utilsClient.getNewTimeId()); ctUserole1.setUserId(ctUser.getId()); ctUserole1.setRoleId(RoleBaseEnum.ROLE_3.getIndex()); ctUserole1.setRoleCode(RoleBaseEnum.ROLE_3.getIndex()); ctUserole1.setRoleName(RoleBaseEnum.ROLE_3.getDes()); ctUserole1.setCustId(custId); ctUserole1.setCreateTime(nowDate); ctUserole1.setUpdateTime(nowDate); ctUseroleService.save(ctUserole1); // 新增人员角色关系-纠纷化解人员 CtUserole ctUserole2 = new CtUserole(); ctUserole2.setId(utilsClient.getNewTimeId()); ctUserole2.setUserId(ctUser.getId()); ctUserole2.setRoleId(RoleBaseEnum.ROLE_4.getIndex()); ctUserole2.setRoleCode(RoleBaseEnum.ROLE_4.getIndex()); ctUserole2.setRoleName(RoleBaseEnum.ROLE_4.getDes()); ctUserole2.setCustId(custId); ctUserole2.setCreateTime(nowDate); ctUserole2.setUpdateTime(nowDate); ctUseroleService.save(ctUserole2); } } } catch (Exception e) { errorInfo = errorInfo+r+"行，"; log.error("liyj解析报错1", e); continue; } } } } } catch (Exception e) { log.error("liyj解析报错2", e); throw new ServiceException("ExcelOperCtunitService.inputByExcel250304", e); }finally { log.info("报错数据："+errorInfo); } } }