liulin
6 天以前 2b5c36b4830adf4227f248d4e10bdb90b1e5f3d8
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
package com.fengdu.gas.repository.mapper;
 
import com.fengdu.gas.repository.BasicMapper;
import com.fengdu.gas.repository.po.DataUploadRecordPO;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
/**
 * 数据上报记录 mapper
 * @author zr
 */
public interface DataUploadRecordMapper extends BasicMapper<DataUploadRecordPO> {
    @Select("SELECT point_id,point_name,facility_id,facility_name,columns_code,column_value,upload_time  FROM data_upload_record " +
            " WHERE is_delete=0 AND upload_time BETWEEN  #{startTime} AND #{endTime}")
    List<DataUploadRecordPO> getByTime(Long startTime, Long endTime);
}