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/SysReagentService.java | 25 +++++++++++++++++++++++--
1 files changed, 23 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/service/SysReagentService.java b/src/main/java/com/nanometer/smartlab/service/SysReagentService.java
index b51db5b..206a80a 100644
--- a/src/main/java/com/nanometer/smartlab/service/SysReagentService.java
+++ b/src/main/java/com/nanometer/smartlab/service/SysReagentService.java
@@ -3,6 +3,7 @@
import com.nanometer.smartlab.entity.SysReagent;
import com.nanometer.smartlab.entity.SysUser;
+import java.math.BigDecimal;
import java.util.List;
import java.util.Map;
@@ -20,12 +21,12 @@
public int insertSysReagentList(List<SysReagent> sysReagentList);
public int insertSysReagentList2(List<SysReagent> sysReagentList);
- int getSysReagentTotalCountNew(String name, String cas, String supplierId, Integer type);
+ int getSysReagentTotalCountNew(String name, String cas, String supplierId, Integer type,String productSn);
public List<SysReagent> query();
Map getReagentDetail(String id);
- public List<SysReagent> getSysReagentListNew(String name, String cas, String supplierId, Integer type, Integer first, Integer pageSize);
+ public List<SysReagent> getSysReagentListNew(String name, String cas, String supplierId, Integer type, Integer first, Integer pageSize,String productSn);
int favorCount(SysUser user, String name, String cas, String supplierId, String productSn,Integer favorFlag);
@@ -38,4 +39,24 @@
String getReagentUnitByReagentId(String reagentId);
List<SysReagent> getReagent(String name, String cas, String factory, String specifications, String packing);
+
+ List<SysReagent> selectReagentSafetyNum();
+
+ void updateSafetyNum(SysReagent sysReagent);
+
+ /**
+ * @Description: 根据detail的参数获取试剂id
+ * @date 2021/6/21 9:42
+ */
+ SysReagent getReagentByDetail(Map<String, Object> detail);
+
+ SysReagent getRowData(String rowKey);
+
+ SysReagent getSysReagentListNewRowData(String rowKey);
+
+ boolean export2Excel(List<Map> list, Integer type) throws Exception;
+
+ List<Map> selectAll(String name, String cas, String supplierId, Integer type, String productSn);
+
+ void updateSysReagentPrice(String reagentId, BigDecimal applyPrice);
}
--
Gitblit v1.9.2