From 453a86294c2a31e92c543ab5d75fdf4a15f23243 Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期一, 26 七月 2021 15:05:40 +0800
Subject: [PATCH] 社区后台基础数据库bug修改
---
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java | 24 ++++++++++++++----------
1 files changed, 14 insertions(+), 10 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java
index 260ebe2..b68f0ff 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngPopulationServeExcelListen.java
@@ -122,7 +122,7 @@
index++;
continue;
}
- vo.setCardNo(oneData.get(1));
+ vo.setCardNo(oneData.get(1).toUpperCase());
//根据身份证号码解析年龄以及性别
//获取用户生日
String birthday = vo.getCardNo().substring(6, 14);
@@ -330,16 +330,20 @@
vo.setWorkCompany(oneData.get(24).trim());
}
if(StringUtils.isNotEmpty(oneData.get(25))){
- Integer isOk = PopulOutOrLocalEnum.getCodeByName(oneData.get(25));
- if(isOk.equals(-1)){
- ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
- importErrorVO.setErrorPosition("第" + index + "行，第26列");
- importErrorVO.setErrorMsg("您填写的本地/外地有误");
- populationImportErrorVOList.add(importErrorVO);
- index++;
- continue;
+ if (StringUtils.isNotBlank(oneData.get(25).trim())){
+ Integer isOk = PopulOutOrLocalEnum.getCodeByName(oneData.get(25));
+ if(isOk.equals(-1)){
+ ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
+ importErrorVO.setErrorPosition("第" + index + "行，第26列");
+ importErrorVO.setErrorMsg("您填写的本地/外地有误");
+ populationImportErrorVOList.add(importErrorVO);
+ index++;
+ continue;
+ }
+ vo.setOutOrLocal(isOk);
+ }else {
+ vo.setOutOrLocal(1);
}
- vo.setOutOrLocal(isOk);
}
if(StringUtils.isNotEmpty(oneData.get(26))){
vo.setCensusRegister(oneData.get(26).trim());
--
Gitblit v1.7.1