package com.flightfeather.monitor.dustexceptionanalysis.database;

import com.flightfeather.monitor.pojo.DustExceptionSetting;
import com.flightfeather.monitor.pojo.DustSiteData;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface DustRepository {



    /*读取指定时间段的扬尘数据*/
    @Select("select * from ja_t_dust_site_data_info where lst between #{beginTime} and #{endTime}")
    public List<DustSiteData> getDustData(String beginTime, String endTime);

    @Select("select * from dust_exception_setting order by update_time desc limit 1")
    public List<DustExceptionSetting> readExceptionSetting();
}