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 { default PageResult selectPage(MesDcDevicePageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .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 selectSimpleList() { return selectList(new LambdaQueryWrapperX() .orderByAsc(MesDcDeviceDO::getCode)); } }