package cn.iocoder.yudao.module.mes.dal.mysql.qc.patrol;
|
|
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.patrol.vo.MesQcPatrolPageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.qc.patrol.MesQcPatrolDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
/**
|
* MES 质量巡检记录 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface MesQcPatrolMapper extends BaseMapperX<MesQcPatrolDO> {
|
|
default PageResult<MesQcPatrolDO> selectPage(MesQcPatrolPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesQcPatrolDO>()
|
.likeIfPresent(MesQcPatrolDO::getCode, reqVO.getCode())
|
.likeIfPresent(MesQcPatrolDO::getName, reqVO.getName())
|
.eqIfPresent(MesQcPatrolDO::getItemId, reqVO.getItemId())
|
.likeIfPresent(MesQcPatrolDO::getReelNo, reqVO.getReelNo())
|
.likeIfPresent(MesQcPatrolDO::getBatchCode, reqVO.getBatchCode())
|
.eqIfPresent(MesQcPatrolDO::getInspectorUserId, reqVO.getInspectorUserId())
|
.betweenIfPresent(MesQcPatrolDO::getInspectDate, reqVO.getInspectDate())
|
.orderByDesc(MesQcPatrolDO::getId));
|
}
|
|
default MesQcPatrolDO selectByCode(String code) {
|
return selectOne(MesQcPatrolDO::getCode, code);
|
}
|
|
}
|
