From c3510da29a7974c6af7ff3de1ade3db429d6f848 Mon Sep 17 00:00:00 2001
From: 李宇 <986321569@qq.com>
Date: 星期三, 18 八月 2021 14:27:59 +0800
Subject: [PATCH] 申购管理申请履历显示所有历史单据,提交时如有无效试剂耗材报错

---
 src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java |   72 ++++++++++++++++++++++++++----------
 1 files changed, 52 insertions(+), 20 deletions(-)

diff --git a/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java b/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java
index 4e1daf7..4beb892 100644
--- a/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java
+++ b/src/main/java/com/nanometer/smartlab/controller/LaboratoryMngController.java
@@ -2,16 +2,15 @@
 
 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.SysLaboratoryContainerService;
+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;
@@ -45,7 +44,11 @@
 	@Resource
 	private SysLaboratoryService sysLaboratoryService;
 	@Resource
+	private SysLaboratoryContainerService sysLaboratoryContainerService;
+	@Resource
 	private BaseMetaService baseMetaService;
+	@Resource
+	private SysProjectService sysProjectService;
 	/**
 	 * 数据源
 	 */
@@ -60,6 +63,7 @@
 	private List<SysLaboratory> selectedList;
 	private String type;
 	private String name;
+	private String project;
 
 	private int action;
 
@@ -84,7 +88,7 @@
 
 	public void exportLab2Excel(){
 		try {
-			List<Map> list = sysLaboratoryService.exportLabList(type, name);
+			List<Map> list = sysLaboratoryService.exportLabList(type, name,project);
 			sysLaboratoryService.exportLab2Excel(list);
 			FacesUtils.info("导出成功");
 		}catch (Exception e){
@@ -150,8 +154,9 @@
 
 					}
 					valuesList.add(cellInfo);
-
-
+				}
+				if (valuesList.size() != 8){
+					break;
 				}
 				System.out.println("value :     "+valuesList);
 				SysLaboratory laboratory=new SysLaboratory();
@@ -162,6 +167,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);
@@ -226,6 +245,9 @@
 					return;
 				}
 
+				//实体类重新获取项目组信息
+				sysLaboratory.setProject(null);
+				sysLaboratory.getProject();
 				this.sysLaboratoryService.updateSysLaboratory(sysLaboratory);
 
 				FacesUtils.info("修改成功。");
@@ -245,6 +267,7 @@
 			}
 
 			this.sysLaboratoryService.deleteSysLaboratory(this.selectedList);
+			this.sysLaboratoryContainerService.delBySlcIds(this.selectedList);
 
 			FacesUtils.info("删除成功。");
 		} catch (Exception e) {
@@ -262,11 +285,12 @@
 						Map<String, Object> filters) {
 					List<SysLaboratory> list = null;
 					try {
-						int count = sysLaboratoryService.getSysLaboratoryTotalCount(type, name);
+						int count = sysLaboratoryService.getSysLaboratoryTotalCount(type, name,project);
 						this.setRowCount(count);
 						if (count > 0) {
-							list = sysLaboratoryService.getSysLaboratoryList(type, name, first, pageSize);
+							list = sysLaboratoryService.getSysLaboratoryList(type, name,project, first, pageSize);
 						}
+						selectedList = new ArrayList<> ();
 					} catch (Exception e) {
 						logger.error(e);
 					}
@@ -275,17 +299,17 @@
 
 				@Override
 				public SysLaboratory getRowData(String rowKey) {
-					Iterator<SysLaboratory> iterator = this.iterator();
-					if (iterator != null) {
-						SysLaboratory su = null;
-						while (iterator.hasNext()) {
-							su = iterator.next();
-							if (rowKey.equals(su.getId())) {
-								return su;
-							}
-						}
-					}
-					return null;
+//					Iterator<SysLaboratory> iterator = this.iterator();
+//					if (iterator != null) {
+//						SysLaboratory su = null;
+//						while (iterator.hasNext()) {
+//							su = iterator.next();
+//							if (rowKey.equals(su.getId())) {
+//								return su;
+//							}
+//						}
+//					}
+					return sysLaboratoryService.getSysLaboratory(rowKey);
 				}
 			};
 		}
@@ -327,4 +351,12 @@
 	public void setType(String type) {
 		this.type = type;
 	}
+
+	public String getProject() {
+		return project;
+	}
+
+	public void setProject(String project) {
+		this.project = project;
+	}
 }

--
Gitblit v1.9.2