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