From b9863f4bba1b11ebbaa51328abc7a7bd01fdf22a Mon Sep 17 00:00:00 2001 From: gdg <764716047@qq.com> Date: 星期三, 09 十二月 2020 09:45:30 +0800 Subject: [PATCH] 模块:实验室存储管理 新增:导出 提出:秦老师 --- src/main/java/com/nanometer/smartlab/service/SysLaboratoryContainerServiceImpl.java | 29 +++++++++++++++++++++++++---- 1 files changed, 25 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..d0fded3 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,27 @@ } } + @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); + + } + } -- Gitblit v1.9.2