1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
package com.iailab.module.data.point.dao;
 
import com.iailab.framework.common.pojo.PageResult;
import com.iailab.framework.mybatis.core.mapper.BaseMapperX;
import com.iailab.framework.mybatis.core.query.LambdaQueryWrapperX;
import com.iailab.framework.tenant.core.db.dynamic.TenantDS;
import com.iailab.module.data.point.entity.DaPointBadHistoryEntity;
import com.iailab.module.data.point.vo.DaPointBadHistoryPageReqVO;
import org.apache.ibatis.annotations.Mapper;
 
 
/**
 * @author Jay
 */
@TenantDS
@Mapper
public interface DaPointBadHistoryDao extends BaseMapperX<DaPointBadHistoryEntity> {
 
    default PageResult<DaPointBadHistoryEntity> selectPage(DaPointBadHistoryPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<DaPointBadHistoryEntity>()
                .likeIfPresent(DaPointBadHistoryEntity::getPointNo, reqVO.getPointNo())
                .likeIfPresent(DaPointBadHistoryEntity::getPointName, reqVO.getPointName())
                .likeIfPresent(DaPointBadHistoryEntity::getTagNo, reqVO.getTagNo())
                .geIfPresent(DaPointBadHistoryEntity::getCollectTime, reqVO.getStartTime())
                .leIfPresent(DaPointBadHistoryEntity::getCollectTime, reqVO.getEndTime())
                .orderByDesc(DaPointBadHistoryEntity::getCreateTime));
    }
 
}