From 648449c0dc1db4531889a4689d45f0a442032d3a Mon Sep 17 00:00:00 2001
From: 李宇 <986321569@qq.com>
Date: 星期二, 26 十月 2021 17:05:35 +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