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<MesQcRetentionSampleDO> {
|
|
default PageResult<MesQcRetentionSampleDO> selectPage(MesQcRetentionSamplePageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesQcRetentionSampleDO>()
|
.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);
|
}
|
|
}
|
