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/dao/OpeUseFlowDao.java | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/dao/OpeUseFlowDao.java b/src/main/java/com/nanometer/smartlab/dao/OpeUseFlowDao.java
index 5dbf82c..ba5c1f8 100644
--- a/src/main/java/com/nanometer/smartlab/dao/OpeUseFlowDao.java
+++ b/src/main/java/com/nanometer/smartlab/dao/OpeUseFlowDao.java
@@ -1,6 +1,7 @@
package com.nanometer.smartlab.dao;
import com.nanometer.smartlab.entity.OpeUseFlow;
+import com.nanometer.smartlab.entity.dto.PersonUseDetail;
import org.apache.ibatis.annotations.Param;
import org.springframework.dao.DataAccessException;
@@ -29,4 +30,29 @@
int updateTimeByCode(Map params);
OpeUseFlow getOpeUseFlowByCode(@Param("reagentCode") String reagentCode);
+
+ void updateReceiptNumber(String code, String receiptNumber,String note);
+
+ List<Map> getRegentInfoFromReceiptNumber(String receiptNumber);
+
+ Map getUserIdByReagentCode(String reagentCode, String id);
+
+ int countPersonalUseInfo(Map params);
+
+ List<OpeUseFlow> selectPersonalUseInfo(Map params);
+
+ List<PersonUseDetail> getApplyInfo(Map params);
+
+ int getApplyInfoSize(Map params);
+
+ int countOpeUseFlow(OpeUseFlow opeUseFlow);
+
+ OpeUseFlow selectById(@Param("id") String id);
+
+ OpeUseFlow selectByReceiptNumber(Map params);
+
+ List<Map> selectAll(Map params);
+
+ List<Map> selectDetail(Map<String, Object> params);
+
}
--
Gitblit v1.9.2