package im.zhaojun.system.mapper;

import im.zhaojun.system.model.Sbtdspsr;
import im.zhaojun.system.model.SbtdspsrParam;
import org.apache.ibatis.annotations.Param;
import tk.mybatis.mapper.additional.dialect.oracle.InsertListMapper;
import tk.mybatis.mapper.common.BaseMapper;
import tk.mybatis.mapper.common.ConditionMapper;

import java.util.List;

public interface SbtdspsrMapper extends BaseMapper<Sbtdspsr>, ConditionMapper<Sbtdspsr>, InsertListMapper<Sbtdspsr>  {

    String getMinUpdateTime();

    String getMaxUpdateTime();

    /**
     * ��ȡ����ʱ���ڵ��豸��Ϣ
     * @param startTime ��ʼʱ��
     * @param endTime ����ʱ��
     * @return �豸��Ϣlist
     */
    List<Sbtdspsr> getSbtdspsrList(@Param("startTime") String startTime, @Param("endTime") String endTime);

    List<Sbtdspsr> selectAllSbbhAndTdbh(@Param("xzbh") String xzbh);

    List<Sbtdspsr> selectBySbbh(@Param("sbbh") String sbbh, @Param("tdbh") Integer tdbh);

    List<SbtdspsrParam> selectDeviceWrite();
}