From e997eee6b747c343e432783111371aca0bd89306 Mon Sep 17 00:00:00 2001 From: 李宇 <986321569@qq.com> Date: 星期二, 29 六月 2021 13:15:24 +0800 Subject: [PATCH] 导出试剂 --- src/main/java/com/nanometer/smartlab/service/SysReagentServiceImpl.java | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 51 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/service/SysReagentServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/SysReagentServiceImpl.java index 6dca8bf..eb22dbe 100644 --- a/src/main/java/com/nanometer/smartlab/service/SysReagentServiceImpl.java +++ b/src/main/java/com/nanometer/smartlab/service/SysReagentServiceImpl.java @@ -8,6 +8,7 @@ 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; @@ -21,10 +22,7 @@ import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; -import java.util.ArrayList; -import java.util.HashMap; -import java.util.List; -import java.util.Map; +import java.util.*; /** * Created by johnny on 17/11/29. @@ -192,6 +190,55 @@ return sysReagentDao.getSysReagentListNewRowData(rowKey); } + @Override + public boolean export2Excel(List<Map> list, Integer type) throws Exception { + Map<String,String> map = new LinkedHashMap<>(); + if (type == 0){ + map.put("kind", "种类"); + map.put("name", "名称"); + map.put("productSn", "产品编号"); + map.put("cas", "CAS"); + map.put("reagentType", "试剂类型"); + map.put("reagentCharacter", "危险性质"); + map.put("supplierName", "供应商"); + map.put("productHomeName", "厂家"); + map.put("reagentFormat", "规格"); + map.put("reagentUnit", "包装"); + map.put("price", "含税售价"); + map.put("perBox", "每箱数量"); + ExcelUtils.export2Excel(list,"耗材列表",map); + }else { + map.put("kind", "种类"); + map.put("name", "试剂名称"); + map.put("control_products_name", "管制品"); + map.put("productSn", "产品编号"); + map.put("cas", "CAS"); + map.put("reagentType", "试剂类型"); + map.put("reagentCharacter", "危险性质"); + map.put("supplierName", "供应商"); + map.put("productHomeName", "厂家"); + map.put("reagentFormat", "规格"); + map.put("reagentUnit", "包装"); + map.put("price", "含税售价"); +// map.put("originprice", "原始售价"); + map.put("perBox", "每箱数量"); + map.put("safetynum", "安全库存"); + ExcelUtils.export2Excel(list,"试剂列表",map); + } + return true; + } + + @Override + public List<Map> selectAll(String name, String cas, String supplierId, Integer type, String productSn) { + Map<String, Object> params = new HashMap<String, Object>(); + params.put("name", name); + params.put("cas", cas); + params.put("supplierId", supplierId); + params.put("type", type); + params.put("productSn", productSn); + return sysReagentDao.selectAll(params); + } + @Transactional(propagation = Propagation.REQUIRED) public int getSysReagentTotalCount(String name, String cas, String supplierId,Integer type) { -- Gitblit v1.9.2