| | |
| | | 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; |
| | |
| | | } |
| | | } |
| | | |
| | | @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); |
| | | |
| | | } |
| | | |
| | | } |