package com.nanometer.smartlab.dao;

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;

import java.util.List;
import java.util.Map;

/**
 * Created by maweiqing on 17/12/8.
 */
public interface OpeReagentStatusDao {

    @SuppressWarnings("rawtypes")
    List<OpeReagentStatus> getOpeReagentStatusList(Map params) throws DataAccessException;
    List<OpeReagentStatus> getOpeReagentStatusList22(Map params) throws DataAccessException;


    @SuppressWarnings("rawtypes")
    int getOpeReagentStatusTotalCount(Map params) throws DataAccessException;

    @SuppressWarnings("rawtypes")
    List<OpeReagentStatus> getOpeReagentStatusListForLab(Map params) throws DataAccessException;
    @SuppressWarnings("rawtypes")
    int getOpeReagentStatusTotalCountForLab(Map params) throws DataAccessException;

    @SuppressWarnings("rawtypes")
    int getPersonReagentStatusTotalCount(Map params) throws DataAccessException;
    @SuppressWarnings("rawtypes")
    List<OpeReagentStatus> getPersonReagentStatusList(Map params) throws DataAccessException;


    void insertOpeReagentStatus(OpeReagentStatus opeReagentStatus) throws DataAccessException;

    int batchInsertOpeReagentStatus(List<OpeReagentStatus> opeReagentStatusList);
    OpeReagentStatus getOpeReagentStatusByReagentCode(String reagentCode) throws DataAccessException;
    OpeReagentStatus getOpeReagentStatusByReagentCode2(OpeReagentStatus opeReagentStatus) 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;

    int syncOpeReagentStatus(Map params) throws DataAccessException;

    int updateOpeReagentStatusForInterface(OpeReagentStatus opeReagentStatus);

    void deleteByReagentCode(@Param("reagentCode")String reagentCode);

    List<OpeReagentStatus> getReagentStatusByContainerId(@Param("containerId") Long id);
    int updateTimeByCode(Map params);
    void updateStatusByCode(Map params);

    List<OpeReagentStatus> selectByReId(Long id);
    public int updateByReId(Map params);

    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);

}