From 7a9fd36cadbd5f0d8737955f0edd79e38ef19eaf Mon Sep 17 00:00:00 2001
From: 郑永安 <zyazyz250@sina.com>
Date: 星期二, 20 六月 2023 14:48:59 +0800
Subject: [PATCH] SQL异常修复
---
src/main/java/com/nanometer/smartlab/service/OpeUseFlowService.java | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/service/OpeUseFlowService.java b/src/main/java/com/nanometer/smartlab/service/OpeUseFlowService.java
index 2e97dae..a543c22 100644
--- a/src/main/java/com/nanometer/smartlab/service/OpeUseFlowService.java
+++ b/src/main/java/com/nanometer/smartlab/service/OpeUseFlowService.java
@@ -38,15 +38,15 @@
OpeUseFlow getOpeUseFlowByCode(String reagentCode);
- void updateReceiptNumber(String code, String receiptNumber);
+ void updateReceiptNumber(String code, String receiptNumber,String note);
- void updateReceiptNumberByCode(List<OpeApplyReserve> codeTmp,String receiptNumber);
+ void updateReceiptNumberByCode(List<OpeApplyReserve> codeTmp,String receiptNumber,String note);
Map<String, Integer> getRegentInfoFromReceiptNumber(String receiptNumber);
Map<String,String> getApplyUserByReagentCode(String reagentCode);
- void updateReceiptNumberByCode2(List<OpeWarehouseReserve> codeTmp, String receiptNumber);
+ void updateReceiptNumberByCode2(List<OpeWarehouseReserve> codeTmp, String receiptNumber,String note);
int getPersonalUseInfoCount(String reagentCode,String userId, Date startTime, Date endTime, String receiptNumber, String department, String project,String applyPerson,String reagentName);
@@ -67,4 +67,8 @@
List<Map> selectAll(String houseName, String reagentId, String reagentCode, String containerCode, String userId, Date startDate, Date endDate);
boolean export2Excel(List<Map> list) throws Exception;
+
+ List<Map> selectExportDetail(String reagentCode, String userId, Date startTime, Date endTime, String receiptNumber, String department, String project, String applyPerson, String reagentName);
+
+ boolean export22Excel(List<Map> list) throws Exception;
}
--
Gitblit v1.9.2