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/service/SysControllerServiceImpl.java | 35 +++++++++++++++++++++++++++++------ 1 files changed, 29 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/service/SysControllerServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/SysControllerServiceImpl.java index a1c6c0f..4a1b80d 100644 --- a/src/main/java/com/nanometer/smartlab/service/SysControllerServiceImpl.java +++ b/src/main/java/com/nanometer/smartlab/service/SysControllerServiceImpl.java @@ -10,6 +10,7 @@ import com.nanometer.smartlab.entity.BaseMeta; import com.nanometer.smartlab.entity.SysLaboratoryContainer; import com.nanometer.smartlab.entity.enumtype.ValidFlag; +import com.nanometer.smartlab.util.ExcelUtils; import org.apache.commons.lang.StringUtils; import org.apache.log4j.Logger; import org.apache.poi.hssf.usermodel.HSSFWorkbook; @@ -37,8 +38,6 @@ SysControllerDao sysControllerDao; @Resource(name = "sysLaboratoryContainerDao") SysLaboratoryContainerDao sysLaboratoryContainerDao; - @Resource(name = "sysControllerService") - SysControllerService sysControllerService; @Resource(name = "baseMetaService") BaseMetaService baseMetaService; @Override @@ -61,7 +60,7 @@ throw new BusinessException(ExceptionEnumCode.DB_ERR, MessageUtil.getMessageByCode(ExceptionEnumCode.DB_ERR.getCode()), e); } - + } @Override @@ -113,7 +112,7 @@ @Override public void uploadFile(FileUploadEvent event) throws Exception{ - List<SysController> sysControllers=sysControllerService.getAllControllerList(); + List<SysController> sysControllers=this.getAllControllerList(); List<BaseMeta> typeList=baseMetaService.getBaseMetaList("controller_type"); //主控名字和条码 HashSet<String> controllerInfo = new HashSet<>(); @@ -172,6 +171,11 @@ } valuesList.add(cellInfo); } + + if (valuesList.size() != 3){ + break; + } + //重名判断 String controlName = valuesList.get(0); if (controllerInfo.contains(controlName)){ @@ -195,12 +199,31 @@ sysController.setControllerCode(controlCode); sysController.setControllerName(controlName); sysController.setType(typeMap.get(controlType)); - sysControllerService.insertSysController(sysController); + this.insertSysController(sysController); + controllerInfo.add(controlName); + controllerInfo.add(controlCode); } } - @Override + @Override + public List<Map> exportExcelList(String name, String code) { + Map<String, String> params = new HashMap<>(); + params.put("name", name); + params.put("code", code); + return sysControllerDao.exportExcelList(params); + } + + @Override + public void export2Excel(List<Map> list) throws Exception { + Map<String, String> map = new LinkedHashMap<>(); + map.put("name", "设备名称"); + map.put("code", "设备代码"); + map.put("type", "设备类型"); + ExcelUtils.export2Excel(list,"主控设备信息",map); + } + + @Override public SysController getSysController(Integer id) { try { return this.sysControllerDao.getSysController(id); -- Gitblit v1.9.2