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