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 | 42 +++++++++++++++++++++++++++++++++++++----- 1 files changed, 37 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 3df1220..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; @@ -15,6 +16,9 @@ @SuppressWarnings("rawtypes") List<OpeReagentStatus> getOpeReagentStatusList(Map params) throws DataAccessException; + List<OpeReagentStatus> getOpeReagentStatusList22(Map params) throws DataAccessException; + + @SuppressWarnings("rawtypes") int getOpeReagentStatusTotalCount(Map params) throws DataAccessException; @@ -30,31 +34,59 @@ 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; - void syncOpeReagentStatus(Map params) throws DataAccessException; + int syncOpeReagentStatus(Map params) throws DataAccessException; int updateOpeReagentStatusForInterface(OpeReagentStatus opeReagentStatus); 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); int countReagentByArticleAndWarehouse(Map params); void updateArticleNumberByRCode(String code, String articleNumber); + + List<Map> selectExportList(Map params); + + 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