From a67b4bdc466d965c1cc4563711ad75c34b52c16a Mon Sep 17 00:00:00 2001 From: gdg <764716047@qq.com> Date: 星期二, 12 一月 2021 11:12:07 +0800 Subject: [PATCH] 模块:实验室管理 修改:导入新增课题组 提出:秦老师 --- src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java | 22 ++++++++++++++++++---- 1 files changed, 18 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java b/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java index 5153a26..86ff06f 100644 --- a/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java +++ b/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java @@ -2,16 +2,14 @@ import java.io.InputStream; import java.math.BigDecimal; -import java.util.ArrayList; -import java.util.Iterator; -import java.util.List; -import java.util.Map; +import java.util.*; import javax.annotation.Resource; import com.nanometer.smartlab.entity.BaseMeta; import com.nanometer.smartlab.entity.SysReagent; import com.nanometer.smartlab.service.BaseMetaService; +import com.nanometer.smartlab.service.SysProjectService; import org.apache.log4j.Logger; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Row; @@ -46,6 +44,8 @@ private SysLaboratoryService sysLaboratoryService; @Resource private BaseMetaService baseMetaService; + @Resource + private SysProjectService sysProjectService; /** * 数据源 */ @@ -162,6 +162,20 @@ laboratory.setLocation1(valuesList.get(4)); laboratory.setLocation2(valuesList.get(5)); laboratory.setDepartment(returnDepartId(departList,valuesList.get(6))); + + if (valuesList.size() > 7 && !valuesList.get(7).replace(" ","").isEmpty()){ + List<String> projects = Arrays.asList(valuesList.get(7).split(",")); + for (String project : projects) { + //不存再就直接推出 + if (!sysProjectService.isExistProject(project)) { + throw new Exception("课题组不存在,(" + i + "行)"); + } + } + //都存在就设置 + laboratory.setProject(valuesList.get(7).replace(" ","")); + }else{ + laboratory.setProject(null); + } sysLaboratories.add(laboratory); } sysLaboratoryService.insertSysReagentList(sysLaboratories); -- Gitblit v1.9.2