package cn.iocoder.yudao.module.mes.dal.mysql.dc.device;
|
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.module.mes.controller.admin.dc.device.vo.MesDcDevicePageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.dc.device.MesDcDeviceDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
/**
|
* MES 数据采集设备 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface MesDcDeviceMapper extends BaseMapperX<MesDcDeviceDO> {
|
|
default PageResult<MesDcDeviceDO> selectPage(MesDcDevicePageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesDcDeviceDO>()
|
.likeIfPresent(MesDcDeviceDO::getCode, reqVO.getCode())
|
.likeIfPresent(MesDcDeviceDO::getName, reqVO.getName())
|
.eqIfPresent(MesDcDeviceDO::getDeviceType, reqVO.getDeviceType())
|
.eqIfPresent(MesDcDeviceDO::getStatus, reqVO.getStatus())
|
.eqIfPresent(MesDcDeviceDO::getWorkOrderId, reqVO.getWorkOrderId())
|
.likeIfPresent(MesDcDeviceDO::getWorkOrderCode, reqVO.getWorkOrderCode())
|
.orderByAsc(MesDcDeviceDO::getCode)
|
.orderByDesc(MesDcDeviceDO::getId));
|
}
|
|
default MesDcDeviceDO selectByCode(String code) {
|
return selectOne(MesDcDeviceDO::getCode, code);
|
}
|
|
default List<MesDcDeviceDO> selectSimpleList() {
|
return selectList(new LambdaQueryWrapperX<MesDcDeviceDO>()
|
.orderByAsc(MesDcDeviceDO::getCode));
|
}
|
|
}
|