From d81fca8baf1b14bfe372cb1e3d85c0afa7350db7 Mon Sep 17 00:00:00 2001
From: yz <yz_0812@outlook.com>
Date: 星期四, 04 三月 2021 02:11:56 +0800
Subject: [PATCH] 修改bug

---
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLaborTroubleServiceImpl.java    |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java  |   27 ++++++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpPhysicalExamServiceImpl.java    |   14 +++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpUnemploymentServiceImpl.java    |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBadRecordServiceImpl.java       |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccidentCasesServiceImpl.java   |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java                |    2 
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpContractInfoServiceImpl.java    |   32 +++++--
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpRemarkInfoServiceImpl.java      |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpInsuranceServiceImpl.java       |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpOccupationalServiceImpl.java    |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpDimissionAttendServiceImpl.java |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpResignServiceImpl.java          |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java       |   13 ++
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java        |   23 ++++-
 15 files changed, 190 insertions(+), 38 deletions(-)

diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java
index 965314e..d89d194 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java
@@ -190,4 +190,6 @@
      * @return cc.mrbird.febs.server.hr.entity.EmpBaseInfo
      */
     EmpBaseInfo addInEmpBaseInfo(EmpBaseInfo empBaseInfo);
+
+    Long getEmpIdByEmpNumb(String empNumb);
 }
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccidentCasesServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccidentCasesServiceImpl.java
index 3aa246b..9ec5af3 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccidentCasesServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccidentCasesServiceImpl.java
@@ -11,6 +11,7 @@
 import cc.mrbird.febs.common.core.exception.FebsException;
 import cc.mrbird.febs.server.hr.constant.MyConstant;
 import cc.mrbird.febs.server.hr.entity.EmpUnemployment;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cn.hutool.core.util.StrUtil;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
@@ -51,6 +52,7 @@
 
 	private final RedisService redisService;
 	private final EmpAccidentCasesMapper empAccidentcasesMapper;
+	private final IEmpBaseInfoService empBaseInfoService;
 	private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser()).map(u -> u.getUserId().toString())
 			.orElse("1");
 
@@ -186,11 +188,18 @@
 			empAccidentcases.setAccidentId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
 			empAccidentcases.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-			Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+			Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
 			if (null == dept) {
-				returnList.add(StrUtil.format("导入员工意外险案件异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+				returnList.add(StrUtil.format("导入员工意外险案件异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
 				continue;
 			}
+			Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+			if (null == empId){
+				returnList.add(StrUtil.format("导入员工意外险案件异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+				continue;
+			}
+			empAccidentcases.setDelFlag(2);
+			empAccidentcases.setEmpId(empId);
 			empAccidentcases.setDeptName(list.get(1).toString());
 			empAccidentcases.setDeptId(dept.getDeptId());
 			empAccidentcases.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBadRecordServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBadRecordServiceImpl.java
index 7782cfe..9027d66 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBadRecordServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBadRecordServiceImpl.java
@@ -8,6 +8,7 @@
 import cc.mrbird.febs.server.hr.entity.EmpBadRecord;
 import cc.mrbird.febs.server.hr.mapper.EmpBadRecordMapper;
 import cc.mrbird.febs.server.hr.service.IEmpBadRecordService;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cn.hutool.core.date.DateUtil;
 
 import cn.hutool.core.util.StrUtil;
@@ -45,6 +46,7 @@
 
 	private final RedisService redisService;
     private final EmpBadRecordMapper empBadrecordMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -162,11 +164,18 @@
     		empBadrecord.setBadId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
     		empBadrecord.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入员工不良记录信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入员工不良记录信息异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            empBadrecord.setDelFlag(2);
+            empBadrecord.setEmpId(empId);
 			empBadrecord.setDeptName(list.get(1).toString());
 			empBadrecord.setDeptId(dept.getDeptId());
 			empBadrecord.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java
index 25c29d7..dab475f 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java
@@ -14,6 +14,7 @@
 import cc.mrbird.febs.server.hr.entity.EmpDimissionLog;
 import cc.mrbird.febs.server.hr.entity.EmpJobChange;
 import cc.mrbird.febs.server.hr.feign.IRemoteUserService;
+import cc.mrbird.febs.server.hr.mapper.EmpContractInfoMapper;
 import cc.mrbird.febs.server.hr.properties.FebsServerHrProperties;
 import cc.mrbird.febs.server.hr.service.IEmpContractInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpDimissionLogService;
@@ -48,6 +49,7 @@
 import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import lombok.RequiredArgsConstructor;
 import org.springframework.util.FileSystemUtils;
+import org.springframework.validation.annotation.Validated;
 
 import javax.servlet.http.HttpServletResponse;
 
@@ -69,7 +71,7 @@
     private final EmpBaseInfoMapper empBaseInfoMapper;
     private final IEmpDimissionLogService dimissionLogService;
     private final IEmpJobChangeService jobChangeService;
-    private final IEmpContractInfoService empContractInfoService;
+    private final EmpContractInfoMapper empContractInfoMapper;
     private final FebsServerHrProperties properties;
     private final IRemoteDeptService remoteDeptService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
@@ -300,14 +302,15 @@
             switch (flag) {
                 case 1:
                     //解除合同
-                    empContractInfoService.terminateContract(empDimissionLog.getEmpIds(), operatorId);
+
+                    empContractInfoMapper.terminateContract(new ArrayList<>(Arrays.asList(empDimissionLog.getEmpIds().split(StringConstant.COMMA))), operatorId);
                     break;
                 case 2:
                     //禁用账户
                     iRemoteUserService.updateStatus(empDimissionLog.getCertificateNumb());
                     break;
                 case 3:
-                    empContractInfoService.terminateContract(empDimissionLog.getEmpIds(), operatorId);
+                    empContractInfoMapper.terminateContract(new ArrayList<>(Arrays.asList(empDimissionLog.getEmpIds().split(StringConstant.COMMA))), operatorId);
                     iRemoteUserService.updateStatus(empDimissionLog.getCertificateNumb());
                     break;
             }
@@ -375,7 +378,7 @@
                 continue;
             }
             if (this.count(new LambdaQueryWrapper<EmpBaseInfo>().eq(EmpBaseInfo::getEmpNumb,list.get(1).toString()).ne(EmpBaseInfo::getDelFlag,1))>0){
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}员工编号重复",listObject.indexOf(list),list.get(1).toString()));
+                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}员工编号重复",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
             EmpBaseInfo empBaseInfo = new EmpBaseInfo();
@@ -387,7 +390,7 @@
             empBaseInfo.setDeptName(list.get(3).toString());
             Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(3).toString()));
                 continue;
             }
             empBaseInfo.setDeptId(dept.getDeptId());
@@ -909,4 +912,14 @@
             return dbEmpInfo;
         }
     }
+
+    @Override
+    public Long getEmpIdByEmpNumb(String empNumb) {
+        try {
+            return this.getOne(new LambdaQueryWrapper<EmpBaseInfo>().eq(EmpBaseInfo::getEmpNumb,empNumb).ne(EmpBaseInfo::getDelFlag,1)).getEmpId();
+        }catch (Exception e){
+            return  null;
+        }
+
+    }
 }
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpContractInfoServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpContractInfoServiceImpl.java
index 02268bf..99f9d9c 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpContractInfoServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpContractInfoServiceImpl.java
@@ -11,6 +11,7 @@
 import cc.mrbird.febs.common.core.entity.system.DicItem;
 import cc.mrbird.febs.common.core.utils.CastUtil;
 import cc.mrbird.febs.common.redis.service.RedisService;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cn.hutool.core.util.StrUtil;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
@@ -48,6 +49,7 @@
 
     private final RedisService redisService;
     private final EmpContractInfoMapper empContractinfoMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -170,11 +172,18 @@
 			contractInfo.setContractId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
 			contractInfo.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入员工合同信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入员工合同信息异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            contractInfo.setDelFlag(2);
+            contractInfo.setEmpId(empId);
 			contractInfo.setDeptName(list.get(1).toString());
 			contractInfo.setDeptId(dept.getDeptId());
 			contractInfo.setJobName(list.get(2).toString());
@@ -183,15 +192,20 @@
 			if (StringUtils.isNotBlank(list.get(5).toString())) {
 				contractInfo.setSigningDate(DateUtil.parseDate(list.get(5).toString()));
 			}
-			if (StringUtils.isNotBlank(list.get(6).toString())) {
-				contractInfo.setEndDate(DateUtil.parseDate(list.get(6).toString()));
-			}
+            if (StringUtils.isNotBlank(list.get(6).toString())) {
+                contractInfo.setBeginDate(DateUtil.parseDate(list.get(6).toString()));
+            }
+
 			if (StringUtils.isNotBlank(list.get(7).toString())) {
-				contractInfo.setContractPeriod(Integer.valueOf(list.get(7).toString()));
+				contractInfo.setEndDate(DateUtil.parseDate(list.get(7).toString()));
 			}
-			contractInfo.setContractStatus(list.get(8).toString());
-			contractInfo.setTransactor(list.get(9).toString());
-			contractInfo.setRemark(list.get(10).toString());
+			if (StringUtils.isNotBlank(list.get(8).toString())) {
+				contractInfo.setContractPeriod(Integer.valueOf(list.get(8).toString()));
+			}
+			contractInfo.setContractStatus(list.get(9).toString());
+			contractInfo.setTransactor(list.get(10).toString());
+			contractInfo.setRemark(list.get(11).toString());
+
 			this.save(contractInfo);
 		}
 	}
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpDimissionAttendServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpDimissionAttendServiceImpl.java
index c163d46..131c400 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpDimissionAttendServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpDimissionAttendServiceImpl.java
@@ -5,6 +5,7 @@
 import cc.mrbird.febs.server.hr.entity.EmpDimissionAttend;
 import cc.mrbird.febs.server.hr.entity.EmpDimissionAttend;
 import cc.mrbird.febs.server.hr.mapper.EmpDimissionAttendMapper;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpDimissionAttendService;
 
 import cn.hutool.core.util.StrUtil;
@@ -43,6 +44,7 @@
 
 	private final RedisService redisService;
     private final EmpDimissionAttendMapper empDimissionattendMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -150,11 +152,18 @@
 			dimissionAttend.setDimissionAttendId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
 			dimissionAttend.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入离职当月考勤异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入离职当月考勤异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            dimissionAttend.setDelFlag(2);
+            dimissionAttend.setEmpId(empId);
 			dimissionAttend.setDeptName(list.get(1).toString());
 			dimissionAttend.setDeptId(dept.getDeptId());
 			dimissionAttend.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpInsuranceServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpInsuranceServiceImpl.java
index 3b0ef3d..6c1936f 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpInsuranceServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpInsuranceServiceImpl.java
@@ -8,6 +8,7 @@
 import cc.mrbird.febs.server.hr.entity.EmpUnemployment;
 import cc.mrbird.febs.server.hr.entity.EmpInsurance;
 import cc.mrbird.febs.server.hr.mapper.EmpInsuranceMapper;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpInsuranceService;
 import cn.hutool.core.date.DateUtil;
 
@@ -45,6 +46,7 @@
 
     private final RedisService redisService;
     private final EmpInsuranceMapper empInsuranceMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser()).map(u -> u.getUserId().toString())
             .orElse("1");
 
@@ -168,11 +170,18 @@
             empInsurance.setInsuranceId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
             empInsurance.setEmpNumb(list.get(0).toString());
             List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入社保申请服务异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入社保申请服务异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            empInsurance.setDelFlag(2);
+            empInsurance.setEmpId(empId);
             empInsurance.setDeptName(list.get(1).toString());
             empInsurance.setDeptId(dept.getDeptId());
             empInsurance.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLaborTroubleServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLaborTroubleServiceImpl.java
index c565ecd..32bdecb 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLaborTroubleServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLaborTroubleServiceImpl.java
@@ -8,6 +8,7 @@
 import cc.mrbird.febs.server.hr.entity.*;
 import cc.mrbird.febs.server.hr.entity.EmpLaborTrouble;
 import cc.mrbird.febs.server.hr.mapper.EmpLaborTroubleMapper;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpLaborTroubleService;
 import cn.hutool.core.date.DateUtil;
 
@@ -47,6 +48,7 @@
 
 	private final RedisService redisService;
     private final EmpLaborTroubleMapper empLabortroubleMapper;
+	private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -179,11 +181,18 @@
 			empLabortrouble.setArbitrationId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
 			empLabortrouble.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-			Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+			Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
 			if (null == dept) {
-				returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+				returnList.add(StrUtil.format("导入员工劳资案件异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
 				continue;
 			}
+			Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+			if (null == empId){
+				returnList.add(StrUtil.format("导入员工劳资案件异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+				continue;
+			}
+			empLabortrouble.setDelFlag(2);
+			empLabortrouble.setEmpId(empId);
 			empLabortrouble.setDeptName(list.get(1).toString());
 			empLabortrouble.setDeptId(dept.getDeptId());
 			empLabortrouble.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java
index bbb548f..ca6251c 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java
@@ -11,6 +11,7 @@
 import cc.mrbird.febs.common.redis.service.RedisService;
 import cc.mrbird.febs.server.hr.entity.EmpLeaveInfo;
 import cc.mrbird.febs.server.hr.mapper.EmpLeaveInfoMapper;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpLeaveInfoService;
 import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.util.StrUtil;
@@ -43,6 +44,7 @@
 
 	private final RedisService redisService;
     private final EmpLeaveInfoMapper empLeaveinfoMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -147,11 +149,18 @@
 			leaveInfo.setLeaveId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
 			leaveInfo.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入员工请假记录异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入员工请假记录异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            leaveInfo.setDelFlag(2);
+            leaveInfo.setEmpId(empId);
 			leaveInfo.setDeptName(list.get(1).toString());
 			leaveInfo.setDeptId(dept.getDeptId());
 			leaveInfo.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpOccupationalServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpOccupationalServiceImpl.java
index f9e62d6..c387345 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpOccupationalServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpOccupationalServiceImpl.java
@@ -7,6 +7,7 @@
 import java.util.List;
 import java.util.Optional;
 
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cn.hutool.core.util.StrUtil;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
@@ -47,6 +48,7 @@
 
 	private final RedisService redisService;
     private final EmpOccupationalMapper empOccupationalMapper;
+	private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -168,11 +170,18 @@
     		empOccupational.setOccupationalId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
     		empOccupational.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-			Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+			Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
 			if (null == dept) {
-				returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+				returnList.add(StrUtil.format("导入员工工伤案件异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
 				continue;
 			}
+			Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+			if (null == empId){
+				returnList.add(StrUtil.format("导入员工工伤案件异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+				continue;
+			}
+			empOccupational.setDelFlag(2);
+			empOccupational.setEmpId(empId);
 			empOccupational.setDeptName(list.get(1).toString());
 			empOccupational.setDeptId(dept.getDeptId());
 			empOccupational.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpPhysicalExamServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpPhysicalExamServiceImpl.java
index ac4990a..5a7fb60 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpPhysicalExamServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpPhysicalExamServiceImpl.java
@@ -12,6 +12,7 @@
 import cc.mrbird.febs.common.core.utils.CastUtil;
 import cc.mrbird.febs.common.redis.service.RedisService;
 import cc.mrbird.febs.server.hr.entity.EmpBaseInfo;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cn.hutool.core.util.StrUtil;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
@@ -49,6 +50,7 @@
 
     private final RedisService redisService;
     private final EmpPhysicalExamMapper empPhysicalexamMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -178,11 +180,19 @@
 			physicalExam.setEmpNumb(list.get(0).toString());
 			physicalExam.setDeptName(list.get(1).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入员工体检信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入员工体检信息异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            physicalExam.setDelFlag(2);
+            physicalExam.setEmpId(empId);
+            physicalExam.setDeptName(list.get(1).toString());
 			physicalExam.setDeptId(dept.getDeptId());
 			physicalExam.setJobName(list.get(2).toString());
 			physicalExam.setEmpName(list.get(3).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpRemarkInfoServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpRemarkInfoServiceImpl.java
index aafe0bb..9279b56 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpRemarkInfoServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpRemarkInfoServiceImpl.java
@@ -5,6 +5,7 @@
 import cc.mrbird.febs.server.hr.entity.EmpRemarkInfo;
 import cc.mrbird.febs.server.hr.entity.EmpRemarkInfo;
 import cc.mrbird.febs.server.hr.mapper.EmpRemarkInfoMapper;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpRemarkinfoService;
 import cn.hutool.core.date.DateUtil;
 
@@ -43,6 +44,7 @@
 
 	private final RedisService redisService;
     private final EmpRemarkInfoMapper empRemarkinfoMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -145,11 +147,18 @@
     		empRemarkinfo.setRemarkId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
     		empRemarkinfo.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入员工备注信息服务异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入员工备注信息服务异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            empRemarkinfo.setDelFlag(2);
+            empRemarkinfo.setEmpId(empId);
 			empRemarkinfo.setDeptName(list.get(1).toString());
 			empRemarkinfo.setDeptId(dept.getDeptId());
 			empRemarkinfo.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpResignServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpResignServiceImpl.java
index 41f70f9..77edc80 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpResignServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpResignServiceImpl.java
@@ -8,6 +8,7 @@
 import cc.mrbird.febs.server.hr.entity.EmpResign;
 import cc.mrbird.febs.server.hr.entity.EmpUnemployment;
 import cc.mrbird.febs.server.hr.mapper.EmpResignMapper;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpResignService;
 import cn.hutool.core.date.DateUtil;
 
@@ -46,6 +47,7 @@
 
 	private final RedisService redisService;
     private final EmpResignMapper empResignMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -162,11 +164,18 @@
 			resign.setResignId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
 			resign.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入员工辞职申请异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入员工辞职申请异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            resign.setDelFlag(2);
+            resign.setEmpId(empId);
 			resign.setDeptName(list.get(1).toString());
 			resign.setDeptId(dept.getDeptId());
 			resign.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpUnemploymentServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpUnemploymentServiceImpl.java
index f66dacd..692afaf 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpUnemploymentServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpUnemploymentServiceImpl.java
@@ -9,6 +9,7 @@
 import cc.mrbird.febs.common.core.exception.FebsException;
 import cc.mrbird.febs.server.hr.constant.MyConstant;
 import cc.mrbird.febs.server.hr.entity.EmpLaborTrouble;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cn.hutool.core.util.StrUtil;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
@@ -49,6 +50,7 @@
 
 	private final RedisService redisService;
     private final EmpUnemploymentMapper empUnemploymentMapper;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
@@ -166,11 +168,18 @@
     		empUnemployment.setUnemploymentId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
     		empUnemployment.setEmpNumb(list.get(0).toString());
 			List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
-            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(3).toString())).findFirst().orElse(null);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
             if (null == dept) {
-                returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list),list.get(3).toString()));
+                returnList.add(StrUtil.format("导入失业金领取异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入失业金领取异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            empUnemployment.setDelFlag(2);
+            empUnemployment.setEmpId(empId);
 			empUnemployment.setDeptName(list.get(1).toString());
 			empUnemployment.setDeptId(dept.getDeptId());
 			empUnemployment.setJobName(list.get(2).toString());
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java
index 7bf0598..59be955 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java
@@ -1,15 +1,20 @@
 package cc.mrbird.febs.server.hr.service.impl;
 
 import cc.mrbird.febs.common.core.constant.ModuleCode;
+import cc.mrbird.febs.common.core.entity.system.Dept;
+import cc.mrbird.febs.common.core.utils.CastUtil;
 import cc.mrbird.febs.common.core.utils.FebsUtil;
 import cc.mrbird.febs.common.core.utils.SequenceUtil;
+import cc.mrbird.febs.common.redis.service.RedisService;
 import cc.mrbird.febs.server.hr.entity.EmpBaseInfo;
 import cc.mrbird.febs.server.hr.entity.EmpWorkExperience;
 import cc.mrbird.febs.server.hr.feign.IRemoteDeptService;
 import cc.mrbird.febs.server.hr.mapper.EmpWorkExperienceMapper;
+import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 import cc.mrbird.febs.server.hr.service.IEmpWorkExperienceService;
 import cn.hutool.core.date.DateUtil;
 
+import cn.hutool.core.util.StrUtil;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
@@ -40,9 +45,11 @@
 
     private final EmpWorkExperienceMapper empWorkexperienceMapper;
     private final IRemoteDeptService remoteDeptService;
+    private final IEmpBaseInfoService empBaseInfoService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
+    private final RedisService redisService;
 
     @Override
     public IPage<EmpWorkExperience> findEmpWorkExperiences(QueryRequest request, EmpWorkExperience empWorkexperience) {
@@ -64,8 +71,8 @@
             queryWrapper.like("a.jobContent", empWorkexperience.getJobContent());
         }
         Page<EmpWorkExperience> page = new Page<>(request.getPageNum(), request.getPageSize());
-        
-        queryWrapper.in("c.deptId", remoteDeptService.userRightDepts());
+
+        queryWrapper.in("c.dept_Id", remoteDeptService.userRightDepts());
         return this.empWorkexperienceMapper.selectPageVo(page, queryWrapper);
     }
 
@@ -139,7 +146,20 @@
             if (list.size()==0){
                 continue;
             }
+            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
+            if (null == empId){
+                returnList.add(StrUtil.format("导入失业金领取表异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+            List<Dept> depts = CastUtil.castList(redisService.get("depts"), Dept.class);
+            Dept dept = depts.stream().filter(d -> d.getDeptName().equals(list.get(1).toString())).findFirst().orElse(null);
+            if (null == dept) {
+                returnList.add(StrUtil.format("导入失业金领取表异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
+                continue;
+            }
 			EmpWorkExperience workExperience = new EmpWorkExperience();
+            workExperience.setDeptName(list.get(1).toString());
+            workExperience.setDeptId(dept.getDeptId());
 			workExperience.setWorkExperienceId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
 			workExperience.setEmpNumb(list.get(0).toString());
 			workExperience.setEmpName(list.get(1).toString());
@@ -153,6 +173,9 @@
 				workExperience.setEndDate(DateUtil.parseDate(list.get(6).toString()));
 			}
 			workExperience.setJobContent(list.get(7).toString());
+			workExperience.setCreator(FebsUtil.getUserId());
+			workExperience.setModifier(FebsUtil.getUserId());
+			workExperience.setDelFlag(2);
 			this.save(workExperience);
 		}
 	}

--
Gitblit v1.8.0