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