罗元桥
2021-08-11 929ff93a7a9db5b9fb0e3ce8e45a66ce59ea1767
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java
@@ -302,45 +302,51 @@
                        continue;
                    }
                    vo.setDoorNo(oneData.get(7).trim());
                    if(StringUtils.isEmpty(oneData.get(8))){
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行,第9列");
//                        importErrorVO.setErrorMsg("楼排号不可为空");
//                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        ComMngPopulationMistakeExcelVO mistake = new ComMngPopulationMistakeExcelVO();
                        setMistake(oneData, mistake);
                        mistake.setMistake("楼排号不可为空");
                        mistakes.add(mistake);
                        continue;
//                    if(StringUtils.isEmpty(oneData.get(8))){
////                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
////                        importErrorVO.setErrorPosition("第" + index + "行,第9列");
////                        importErrorVO.setErrorMsg("楼排号不可为空");
////                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        ComMngPopulationMistakeExcelVO mistake = new ComMngPopulationMistakeExcelVO();
//                        setMistake(oneData, mistake);
//                        mistake.setMistake("楼排号不可为空");
//                        mistakes.add(mistake);
//                        continue;
//                    }
                    if(StringUtils.isNotEmpty(oneData.get(8))) {
                        vo.setFloor(oneData.get(8).trim());
                    }
                    vo.setFloor(oneData.get(8).trim());
                    if(StringUtils.isEmpty(oneData.get(9))){
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行,第10列");
//                        importErrorVO.setErrorMsg("单元号不可为空");
//                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        ComMngPopulationMistakeExcelVO mistake = new ComMngPopulationMistakeExcelVO();
                        setMistake(oneData, mistake);
                        mistake.setMistake("单元号不可为空");
                        mistakes.add(mistake);
                        continue;
//                    if(StringUtils.isEmpty(oneData.get(9))){
////                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
////                        importErrorVO.setErrorPosition("第" + index + "行,第10列");
////                        importErrorVO.setErrorMsg("单元号不可为空");
////                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        ComMngPopulationMistakeExcelVO mistake = new ComMngPopulationMistakeExcelVO();
//                        setMistake(oneData, mistake);
//                        mistake.setMistake("单元号不可为空");
//                        mistakes.add(mistake);
//                        continue;
//                    }
                    if(StringUtils.isNotEmpty(oneData.get(9))) {
                        vo.setUnitNo(oneData.get(9).trim());
                    }
                    vo.setUnitNo(oneData.get(9).trim());
                    if(StringUtils.isEmpty(oneData.get(10))){
//                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
//                        importErrorVO.setErrorPosition("第" + index + "行,第11列");
//                        importErrorVO.setErrorMsg("户室不可为空");
//                        populationImportErrorVOList.add(importErrorVO);
                        index++;
                        ComMngPopulationMistakeExcelVO mistake = new ComMngPopulationMistakeExcelVO();
                        setMistake(oneData, mistake);
                        mistake.setMistake("户室不可为空");
                        mistakes.add(mistake);
                        continue;
//                    if(StringUtils.isEmpty(oneData.get(10))){
////                        ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
////                        importErrorVO.setErrorPosition("第" + index + "行,第11列");
////                        importErrorVO.setErrorMsg("户室不可为空");
////                        populationImportErrorVOList.add(importErrorVO);
//                        index++;
//                        ComMngPopulationMistakeExcelVO mistake = new ComMngPopulationMistakeExcelVO();
//                        setMistake(oneData, mistake);
//                        mistake.setMistake("户室不可为空");
//                        mistakes.add(mistake);
//                        continue;
//                    }
                    if(StringUtils.isNotEmpty(oneData.get(10))) {
                        vo.setHouseNo(oneData.get(10).trim());
                    }
                    vo.setHouseNo(oneData.get(10).trim());
                    if(StringUtils.isNotEmpty(oneData.get(11))){
                        vo.setBuildPurpose(oneData.get(11).trim());
                    }