From c3510da29a7974c6af7ff3de1ade3db429d6f848 Mon Sep 17 00:00:00 2001 From: 李宇 <986321569@qq.com> Date: 星期三, 18 八月 2021 14:27:59 +0800 Subject: [PATCH] 申购管理申请履历显示所有历史单据,提交时如有无效试剂耗材报错 --- src/main/java/com/nanometer/smartlab/service/SysSupplierServiceImpl.java | 21 +++++++++++++++++++++ 1 files changed, 21 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/service/SysSupplierServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/SysSupplierServiceImpl.java index 195e741..f194a80 100644 --- a/src/main/java/com/nanometer/smartlab/service/SysSupplierServiceImpl.java +++ b/src/main/java/com/nanometer/smartlab/service/SysSupplierServiceImpl.java @@ -6,6 +6,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; @@ -217,6 +218,9 @@ } valuesList.add(cellInfo); } + if (valuesList.size() != 4){ + break; + } SysSupplier sysSupplier = new SysSupplier(); //这一行有供应商是数据库里的就跳过 @@ -239,4 +243,21 @@ } + @Override + public List<Map> exportExcelList(String name) { + Map<String, String> params = new HashMap<>(); + params.put("name", name); + return sysSupplierDao.exportExcelList(params); + } + + @Override + public void export2Excel(List<Map> list) throws Exception { + Map<String,String> map = new LinkedHashMap<>(); + map.put("name", "供应商名"); + map.put("personName", "联系人"); + map.put("phone", "电话"); + map.put("memo", "备注"); + ExcelUtils.export2Excel(list,"供应商信息",map); + } + } -- Gitblit v1.9.2