From fce41585f6c4e09c12c7e2a3150d4dfbf1f46bb0 Mon Sep 17 00:00:00 2001
From: 李宇 <986321569@qq.com>
Date: 星期二, 12 一月 2021 10:27:26 +0800
Subject: [PATCH] 修改申购试剂查询

---
 src/main/java/com/nanometer/smartlab/service/SysLaboratoryContainerServiceImpl.java |   38 ++++++++++++++++++++++++++++++++++----
 1 files changed, 34 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/nanometer/smartlab/service/SysLaboratoryContainerServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/SysLaboratoryContainerServiceImpl.java
index 00be2a7..be5eac7 100644
--- a/src/main/java/com/nanometer/smartlab/service/SysLaboratoryContainerServiceImpl.java
+++ b/src/main/java/com/nanometer/smartlab/service/SysLaboratoryContainerServiceImpl.java
@@ -1,15 +1,13 @@
 package com.nanometer.smartlab.service;
 
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 
 import javax.annotation.Resource;
 
 import com.google.common.collect.ImmutableBiMap;
 import com.nanometer.smartlab.entity.*;
 import com.nanometer.smartlab.entity.enumtype.ArrivalStatus;
+import com.nanometer.smartlab.util.ExcelUtils;
 import org.apache.commons.lang.StringUtils;
 import org.apache.log4j.Logger;
 import org.springframework.dao.DataAccessException;
@@ -259,4 +257,36 @@
 		}
 	}
 
+    @Override
+    public List<Map> exportExcelList(String laboratoryType, String laboratoryName) {
+		Map<String, String> params = new HashMap<>();
+		params.put("type", laboratoryType);
+		params.put("name", laboratoryName);
+		return sysLaboratoryContainerDao.exportExcelList(params);
+    }
+
+	@Override
+	public void export2Excel(List<Map> list) throws Exception {
+		Map<String, String> map = new LinkedHashMap<>();
+		map.put("labType", "实验室类型");
+		map.put("labName", "实验室名称");
+		map.put("controlName", "主控名称");
+		map.put("containerCode", "临时存储库条码");
+		map.put("containerType", "临时存储库类型");
+		map.put("infoCode", "临时存储库状态码");
+		map.put("structure", "临时存储库结构");
+		map.put("name", "临时存储库名称");
+		ExcelUtils.export2Excel(list,"实验室临时存储库管理",map);
+
+	}
+
+    @Override
+    public List<String> selectProjectsByContainerCode(String containerCode) {
+		String projects = sysLaboratoryContainerDao.selectProjectsByContainerCode(containerCode);
+		if (projects != null){
+			return Arrays.asList(projects.split(","));
+		}
+		return null;
+    }
+
 }

--
Gitblit v1.9.2