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