| | |
| | | package com.nanometer.smartlab.dao; |
| | | |
| | | import com.nanometer.smartlab.entity.SysReagent; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springframework.dao.DataAccessException; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | |
| | | */ |
| | | public interface SysReagentDao { |
| | | |
| | | public SysReagent getSysReagent(String id) throws DataAccessException; |
| | | public SysReagent getSysReagentByCas(SysReagent sysReagent) throws DataAccessException; |
| | | public SysReagent getSysReagent(Long id) throws DataAccessException; |
| | | public List<SysReagent> getSysReagentByCas(SysReagent sysReagent) throws DataAccessException; |
| | | public SysReagent getSysReagentByCas2(SysReagent sysReagent) throws DataAccessException; |
| | | public List<SysReagent> getSysReagentList(Map params) throws DataAccessException; |
| | | public List<SysReagent> getSysReagentListNew(Map params) throws DataAccessException; |
| | |
| | | public void insertSysReagent(SysReagent sysReagent) throws DataAccessException; |
| | | public int updateSysReagent(SysReagent sysReagent) throws DataAccessException; |
| | | public int updateSysReagentForExport(SysReagent sysReagent) throws DataAccessException; |
| | | public int deleteSysReagent(List<String> ids) throws DataAccessException; |
| | | public int deleteSysReagent(List<Long> ids) throws DataAccessException; |
| | | |
| | | public List<SysReagent> query(); |
| | | //试剂库总数 |
| | | int reagentCount(Map params); |
| | | List<SysReagent> reagentList(Map params); |
| | | |
| | | List<SysReagent> reagentSimpleInfoList(Map params); |
| | | |
| | | int reagentSimpleInfoCount(Map params); |
| | | int favorCount(Map params); |
| | | List<SysReagent> favorList(Map params); |
| | | Map getSysReagentDetail(String id); |
| | | Map getSysReagentDetail(Long id); |
| | | |
| | | String getReagentUnitByReagentId(String reagentId); |
| | | String getReagentUnitByReagentId(Long reagentId); |
| | | |
| | | List<SysReagent> getReagent(Map params); |
| | | |
| | | List<SysReagent> selectReagentSafetyNum(); |
| | | |
| | | void updateSafetyNum(@Param("id") Long id, @Param("safetynum") Integer safetynum); |
| | | |
| | | /** |
| | | * @Description: 根据Map里的详细传参 查询试剂个数 |
| | | * @date 2021/6/21 9:07 |
| | | */ |
| | | List<SysReagent> countReagentByDetail(@Param("params") Map detail); |
| | | |
| | | SysReagent getRowData(@Param("id") Long rowKey); |
| | | |
| | | SysReagent getSysReagentListNewRowData(@Param("id")Long rowKey); |
| | | |
| | | List<Map> selectAll(Map params); |
| | | |
| | | void updateSysReagentPriceById(@Param("reagentId") Long reagentId,@Param("price") BigDecimal price); |
| | | } |