package cn.iocoder.yudao.module.mes.dal.mysql.qc.retentionsample; 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.qc.retentionsample.vo.MesQcRetentionSamplePageReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.qc.retentionsample.MesQcRetentionSampleDO; import org.apache.ibatis.annotations.Mapper; /** * MES 留样记录 Mapper * * @author 超级管理员 */ @Mapper public interface MesQcRetentionSampleMapper extends BaseMapperX { default PageResult selectPage(MesQcRetentionSamplePageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .likeIfPresent(MesQcRetentionSampleDO::getCode, reqVO.getCode()) .likeIfPresent(MesQcRetentionSampleDO::getWorkOrderCode, reqVO.getWorkOrderCode()) .eqIfPresent(MesQcRetentionSampleDO::getWorkOrderId, reqVO.getWorkOrderId()) .eqIfPresent(MesQcRetentionSampleDO::getSaleOrderId, reqVO.getSaleOrderId()) .likeIfPresent(MesQcRetentionSampleDO::getSaleOrderNo, reqVO.getSaleOrderNo()) .eqIfPresent(MesQcRetentionSampleDO::getProductId, reqVO.getProductId()) .eqIfPresent(MesQcRetentionSampleDO::getBatchCode, reqVO.getBatchCode()) .eqIfPresent(MesQcRetentionSampleDO::getKeeperUserId, reqVO.getKeeperUserId()) .betweenIfPresent(MesQcRetentionSampleDO::getSampleDate, reqVO.getSampleDate()) .betweenIfPresent(MesQcRetentionSampleDO::getExpiryDate, reqVO.getExpiryDate()) .betweenIfPresent(MesQcRetentionSampleDO::getCreateTime, reqVO.getCreateTime()) .orderByDesc(MesQcRetentionSampleDO::getId)); } default MesQcRetentionSampleDO selectByCode(String code) { return selectOne(MesQcRetentionSampleDO::getCode, code); } default MesQcRetentionSampleDO selectByWorkOrderId(Long workOrderId) { return selectOne(MesQcRetentionSampleDO::getWorkOrderId, workOrderId); } }