From 39d6fc5c2983a6afd757ed271301ebe65ac871b7 Mon Sep 17 00:00:00 2001
From: gdg <764716047@qq.com>
Date: 星期二, 08 十二月 2020 16:59:42 +0800
Subject: [PATCH] 模块:实验室管理 新增:导出 提出:秦老师

---
 src/main/java/com/nanometer/smartlab/service/SysLaboratoryServiceImpl.java |   35 +++++++++++++++++++++++++++++++----
 1 files changed, 31 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/nanometer/smartlab/service/SysLaboratoryServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/SysLaboratoryServiceImpl.java
index 2e19650..e4c01c7 100644
--- a/src/main/java/com/nanometer/smartlab/service/SysLaboratoryServiceImpl.java
+++ b/src/main/java/com/nanometer/smartlab/service/SysLaboratoryServiceImpl.java
@@ -6,10 +6,12 @@
 import com.nanometer.smartlab.exception.AlarmException;
 import com.nanometer.smartlab.exception.BusinessException;
 import com.nanometer.smartlab.exception.ExceptionEnumCode;
+import com.nanometer.smartlab.util.ExcelUtils;
 import com.nanometer.smartlab.util.IDUtils;
 import com.nanometer.smartlab.util.MessageUtil;
 import org.apache.commons.lang.StringUtils;
 import org.apache.log4j.Logger;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 import org.springframework.dao.DataAccessException;
 import org.springframework.dao.DataIntegrityViolationException;
 import org.springframework.dao.DuplicateKeyException;
@@ -18,10 +20,12 @@
 import org.springframework.transaction.annotation.Transactional;
 
 import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import javax.faces.context.FacesContext;
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
+import java.io.InputStream;
+import java.util.*;
 
 /**
  * Created by cmower on 17/11/20.
@@ -224,6 +228,29 @@
 		}
 	}
 
+    @Override
+    public void exportLab2Excel(List<Map> list) throws Exception {
+
+		Map<String, String> map = new LinkedHashMap<>();
+		map.put("type", "类型");
+		map.put("name", "名称");
+		map.put("infoCode", "状态码");
+		map.put("barCode", "地址码");
+		map.put("location", "地址");
+		map.put("department", "部门");
+		ExcelUtils.export2Excel(list,"实验室信息",map);
+
+
+	}
+
+	@Override
+	public List<Map> exportLabList(String type, String name) {
+		Map<String,String> params = new HashMap<>();
+		params.put("type", type);
+		params.put("name", name);
+		return sysLaboratoryDao.exportLabList(params);
+	}
+
 	@Override
 	@Transactional(propagation = Propagation.REQUIRED)
 	public List<SysLaboratory> getSysLaboratoryListByDep(String depId) {

--
Gitblit v1.9.2