From e7afed8cdb301a311dbad5ed23c7ff9f826b2c48 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期三, 30 十月 2024 11:11:06 +0800 Subject: [PATCH] update import --- assess-system/src/main/java/com/gkhy/assess/system/excel/ExpertExcelListener.java | 40 +++++++++++++++++++++++----------------- 1 files changed, 23 insertions(+), 17 deletions(-) diff --git a/assess-system/src/main/java/com/gkhy/assess/system/excel/ExpertExcelListener.java b/assess-system/src/main/java/com/gkhy/assess/system/excel/ExpertExcelListener.java index 296877f..dca3e67 100644 --- a/assess-system/src/main/java/com/gkhy/assess/system/excel/ExpertExcelListener.java +++ b/assess-system/src/main/java/com/gkhy/assess/system/excel/ExpertExcelListener.java @@ -40,6 +40,8 @@ public void invoke(SysExpertInfoExcelVO sysExpertInfoExcelVO, AnalysisContext analysisContext) { if(!StringUtils.isBlank(sysExpertInfoExcelVO.getName())){ cachedDateList.add(sysExpertInfoExcelVO); + }else{ + System.out.println("ffffff"); } if(cachedDateList.size()>=BATCH_COUNT){ saveData(); @@ -55,24 +57,28 @@ SysExpertInfo existExpertInfo = SpringUtil.getBean(SysExpertInfoService.class).getOne(Wrappers.<SysExpertInfo>lambdaQuery() .eq(true, SysExpertInfo::getIdCard, idCard) .last(" limit 1")); - direction=direction.replace("安全生产:","").trim(); - String[] splits = direction.split("、"); - List<String> safetyArray=new ArrayList<>(); - for(String str:splits){ - str=str.trim(); - String code="1"; - if(str.equals("现场检查")){ - code="1"; - }else if(str.equals("调查评估")){ - code="2"; - }else if(str.equals("咨询服务")){ - code="3"; - }else if(str.equals("教育培训")){ - code="4"; - }else{ - code="5"; + List<String> safetyArray = new ArrayList<>(); + if(!StringUtils.isBlank(direction)) { + direction = direction.replace("安全生产:", "").trim(); + String[] splits = direction.split("、"); + for (String str : splits) { + str = str.trim(); + String code = "1"; + if (str.equals("现场检查")) { + code = "1"; + } else if (str.equals("调查评估")) { + code = "2"; + } else if (str.equals("咨询服务")) { + code = "3"; + } else if (str.equals("教育培训")) { + code = "4"; + } else { + code = "5"; + } + safetyArray.add(code); } - safetyArray.add(code); + }else{ + safetyArray.add("5"); } if(existExpertInfo!=null){ existExpertInfo.setState(2); -- Gitblit v1.9.2