package com.hzjt.mapper;


import com.hzjt.domain.Sbtdspsr;
import com.hzjt.domain.SbtdspsrParam;
import org.apache.ibatis.annotations.Mapper;
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;

@Mapper
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();

    List<String> selectAllWbbh();
}