From 47a751cb301d05276ae5d75145d57b2d090fe4e1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: Mon, 01 Jul 2024 10:58:35 +0800
Subject: [PATCH] change
---
src/main/java/com/nanometer/smartlab/controller/LaboratoryContainerMngController.java | 94 ++++++++++++++++++++++++++--------------------
1 files changed, 53 insertions(+), 41 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/controller/LaboratoryContainerMngController.java b/src/main/java/com/nanometer/smartlab/controller/LaboratoryContainerMngController.java
index 95e1f42..967f163 100644
--- a/src/main/java/com/nanometer/smartlab/controller/LaboratoryContainerMngController.java
+++ b/src/main/java/com/nanometer/smartlab/controller/LaboratoryContainerMngController.java
@@ -2,16 +2,13 @@
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.SysLaboratory;
-import com.nanometer.smartlab.service.SysLaboratoryService;
+import com.nanometer.smartlab.service.*;
import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
@@ -29,9 +26,6 @@
import com.nanometer.smartlab.entity.SysController;
import com.nanometer.smartlab.entity.SysLaboratoryContainer;
-import com.nanometer.smartlab.service.BaseMetaService;
-import com.nanometer.smartlab.service.SysControllerService;
-import com.nanometer.smartlab.service.SysLaboratoryContainerService;
import com.nanometer.smartlab.util.Constants;
import com.nanometer.smartlab.util.FacesUtils;
@@ -55,6 +49,8 @@
private BaseMetaService baseMetaService;
@Resource
private SysLaboratoryService sysLaboratoryService;
+ @Resource
+ private SysProjectService sysProjectService;
/**
* 数据源
*/
@@ -62,7 +58,7 @@
/**
* 数据模型
*/
- private SysLaboratoryContainer sysLaboratoryContainer;
+ private SysLaboratoryContainer sysLaboratoryContainer=new SysLaboratoryContainer();
/**
* 选中的list
*/
@@ -213,8 +209,8 @@
return;
}
- sysLaboratoryContainer.setProject(null);
- sysLaboratoryContainer.getProject();
+// sysLaboratoryContainer.setProject(null);
+// sysLaboratoryContainer.getProject();
this.sysLaboratoryContainerService.updateSysLaboratoryContainer(sysLaboratoryContainer);
@@ -230,7 +226,7 @@
public void export2Excel(){
try {
- List<Map> list = sysLaboratoryContainerService.exportExcelList(laboratoryType, laboratoryName);
+ List<Map> list = sysLaboratoryContainerService.exportExcelList(laboratoryType, laboratoryName,project,controllerName);
sysLaboratoryContainerService.export2Excel(list);
}catch (Exception e){
e.printStackTrace();
@@ -294,18 +290,34 @@
}
valuesList.add(cellInfo);
}
+ if (valuesList.size() != 10){
+ break;
+ }
System.out.println("value : "+valuesList);
SysLaboratoryContainer sysLaboratoryContainer=new SysLaboratoryContainer();
sysLaboratoryContainer.setLaboratoryId(getLabId(sysLaboratories,valuesList.get(0)));
- sysLaboratoryContainer.setControllerCode(getConCode(sysControllers,valuesList.get(1)));
- sysLaboratoryContainer.setContainerCode(valuesList.get(2));
- sysLaboratoryContainer.setType(getBaseMetaId(typeList,valuesList.get(3)));
- sysLaboratoryContainer.setInfoCode(valuesList.get(4));
- sysLaboratoryContainer.setStructure(getBaseMetaId(struList,valuesList.get(5)));
- sysLaboratoryContainer.setName(valuesList.get(6));
- if(valuesList.get(3).equals("智能柜")){
- sysLaboratoryContainer.setCharacterLeft(getBaseMetaId(charList,valuesList.get(7)));
- sysLaboratoryContainer.setCharacterRight(getBaseMetaId(charList,valuesList.get(8)));
+ if (!valuesList.get(1).replace(" ","").isEmpty()){
+ List<String> projects = Arrays.asList(valuesList.get(1).split(","));
+ for (String project : projects) {
+ //不存再就直接推出
+ if (!sysProjectService.isExistProject(project)) {
+ throw new Exception("课题组不存在,（" + i + "行）");
+ }
+ }
+ //都存在就设置
+ sysLaboratoryContainer.setProject(valuesList.get(1).replace(" ",""));
+ }else{
+ sysLaboratoryContainer.setProject(null);
+ }
+ sysLaboratoryContainer.setControllerCode(getConCode(sysControllers,valuesList.get(2)));
+ sysLaboratoryContainer.setContainerCode(valuesList.get(3));
+ sysLaboratoryContainer.setType(getBaseMetaId(typeList,valuesList.get(4)));
+ sysLaboratoryContainer.setInfoCode(valuesList.get(5));
+ sysLaboratoryContainer.setStructure(getBaseMetaId(struList,valuesList.get(6)));
+ sysLaboratoryContainer.setName(valuesList.get(7));
+ if(valuesList.get(4).equals("智能柜")){
+ sysLaboratoryContainer.setCharacterLeft(getBaseMetaId(charList,valuesList.get(8)));
+ sysLaboratoryContainer.setCharacterRight(getBaseMetaId(charList,valuesList.get(9)));
}
sysLaboratoryContainers.add(sysLaboratoryContainer);
}
@@ -317,8 +329,8 @@
}
}
- public String getBaseMetaId(List<BaseMeta> list,String name){
- String id="";
+ public Long getBaseMetaId(List<BaseMeta> list,String name){
+ Long id=null;
for(int i=0;i<list.size();i++){
if(name.equals(list.get(i).getMetaValue())){
id=list.get(i).getId();
@@ -327,8 +339,8 @@
return id;
}
- public String getLabId(List<SysLaboratory> list,String name){
- String id="";
+ public Long getLabId(List<SysLaboratory> list,String name){
+ Long id=null;
for(int i=0;i<list.size();i++){
if(list.get(i).getName().equals(name)){
id=list.get(i).getId();
@@ -386,12 +398,13 @@
List<SysLaboratoryContainer> list = null;
try {
int count = sysLaboratoryContainerService.getSysLaboratoryContainerTotalCount(laboratoryType,
- laboratoryName,null,project,controllerName);
+ laboratoryName,null,project);
this.setRowCount(count);
if (count > 0) {
list = sysLaboratoryContainerService.getSysLaboratoryContainerList(laboratoryType,
- laboratoryName,null,project,controllerName, first, pageSize);
+ laboratoryName,null,project, first, pageSize);
}
+ selectedList = new ArrayList<> ();
} catch (Exception e) {
logger.error(e);
}
@@ -400,17 +413,18 @@
@Override
public SysLaboratoryContainer getRowData(String rowKey) {
- Iterator<SysLaboratoryContainer> iterator = this.iterator();
- if (iterator != null) {
- SysLaboratoryContainer su = null;
- while (iterator.hasNext()) {
- su = iterator.next();
- if (rowKey.equals(su.getId())) {
- return su;
- }
- }
- }
- return null;
+// Iterator<SysLaboratoryContainer> iterator = this.iterator();
+// if (iterator != null) {
+// SysLaboratoryContainer su = null;
+// while (iterator.hasNext()) {
+// su = iterator.next();
+// if (rowKey.equals(su.getId())) {
+// return su;
+// }
+// }
+// }
+ Long id=Long.valueOf(rowKey);
+ return sysLaboratoryContainerService.getSysLaboratoryContainer(id);
}
};
}
@@ -462,10 +476,8 @@
}
public List<SysController> getControllers() {
- if(controllers == null)
- {
this.controllers = sysControllerService.getAllControllerList();
- }
+
return controllers;
}
--
Gitblit v1.9.2