From 47a751cb301d05276ae5d75145d57b2d090fe4e1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期一, 01 七月 2024 10:58:35 +0800
Subject: [PATCH] change

---
 src/main/java/com/nanometer/smartlab/dao/OpeReagentStatusDao.java |   34 +++++++++++++++++++++++++++++-----
 1 files changed, 29 insertions(+), 5 deletions(-)

diff --git a/src/main/java/com/nanometer/smartlab/dao/OpeReagentStatusDao.java b/src/main/java/com/nanometer/smartlab/dao/OpeReagentStatusDao.java
index 9ff5320..94b8fa4 100644
--- a/src/main/java/com/nanometer/smartlab/dao/OpeReagentStatusDao.java
+++ b/src/main/java/com/nanometer/smartlab/dao/OpeReagentStatusDao.java
@@ -2,6 +2,7 @@
 
 import com.nanometer.smartlab.entity.OpeApply;
 import com.nanometer.smartlab.entity.OpeReagentStatus;
+import com.nanometer.smartlab.entity.SysLaboratory;
 import org.apache.ibatis.annotations.Param;
 import org.springframework.dao.DataAccessException;
 
@@ -33,9 +34,14 @@
 
 
     void insertOpeReagentStatus(OpeReagentStatus opeReagentStatus) throws DataAccessException;
+
+    int batchInsertOpeReagentStatus(List<OpeReagentStatus> opeReagentStatusList);
     OpeReagentStatus getOpeReagentStatusByReagentCode(String reagentCode) throws DataAccessException;
     OpeReagentStatus getOpeReagentStatusByReagentCode2(OpeReagentStatus opeReagentStatus) throws DataAccessException;
-    OpeReagentStatus getOpeReagentStatus(String id) throws DataAccessException;
+    OpeReagentStatus getOpeReagentStatusByCode(String reagentCode) throws DataAccessException;
+
+    OpeReagentStatus getOpeReagentStatusById(Long id) throws DataAccessException;
+
 	int updateOpeReagentStatusDao(OpeReagentStatus opeReagentStatus);
 
     List<OpeReagentStatus> getOpeReagentStatusInfoList(Map params) throws DataAccessException;
@@ -46,14 +52,14 @@
 
     void deleteByReagentCode(@Param("reagentCode")String reagentCode);
 
-    List<OpeReagentStatus> getReagentStatusByContainerId(@Param("containerId") String id);
+    List<OpeReagentStatus> getReagentStatusByContainerId(@Param("containerId") Long id);
     int updateTimeByCode(Map params);
     void updateStatusByCode(Map params);
 
-    List<OpeReagentStatus> selectByReId(String id);
+    List<OpeReagentStatus> selectByReId(Long id);
     public int updateByReId(Map params);
 
-    List<String> selectReagentCodesByReId(String reagentId);
+    List<String> selectReagentCodesByReId(Long reagentId);
 
     void insertOpeReagentStatus2(OpeReagentStatus ors);
 
@@ -63,6 +69,24 @@
 
     List<Map> selectExportList(Map params);
 
-    OpeReagentStatus getStatus(@Param("reagentId") String reagentId,@Param("reagentCode") String reagentCode);
+    OpeReagentStatus getStatus(@Param("reagentId") Long reagentId,@Param("reagentCode") String reagentCode);
+
+    /**
+     * 根据课题id获取实验室列表
+     * @param projectId
+     * @return
+     */
+    List<SysLaboratory> getLabNoContainerByProjectId(Long projectId);
+
+    /**
+     * 根据条码更新试剂状态
+     * @param opeReagentStatus
+     */
+    void updateOpeReagentStatusByCode(OpeReagentStatus opeReagentStatus);
+
+    void batchUpdateReagentStatusByIds(@Param("ids") List<Long>ids,@Param("houseId")Long houseId,@Param("containerId")Long containerId,@Param("status")Integer status);
+
+
+    Integer getReagentStatusCountByApplyCode(String applyCode);
 
 }

--
Gitblit v1.9.2