package cn.iocoder.yudao.module.mes.dal.mysql.qc.outsourcetest;
|
|
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.outsourcetest.vo.MesQcOutsourceTestPageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.qc.outsourcetest.MesQcOutsourceTestDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
/**
|
* MES 委外检测/试验单 Mapper
|
*
|
* @author xiaoyi
|
*/
|
@Mapper
|
public interface MesQcOutsourceTestMapper extends BaseMapperX<MesQcOutsourceTestDO> {
|
|
default MesQcOutsourceTestDO selectByCode(String code) {
|
return selectOne(MesQcOutsourceTestDO::getCode, code);
|
}
|
|
default PageResult<MesQcOutsourceTestDO> selectPage(MesQcOutsourceTestPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesQcOutsourceTestDO>()
|
.likeIfPresent(MesQcOutsourceTestDO::getCode, reqVO.getCode())
|
.likeIfPresent(MesQcOutsourceTestDO::getName, reqVO.getName())
|
.eqIfPresent(MesQcOutsourceTestDO::getTestType, reqVO.getTestType())
|
.eqIfPresent(MesQcOutsourceTestDO::getResult, reqVO.getResult())
|
.eqIfPresent(MesQcOutsourceTestDO::getStatus, reqVO.getStatus())
|
.betweenIfPresent(MesQcOutsourceTestDO::getTestDate, reqVO.getTestDate())
|
.orderByDesc(MesQcOutsourceTestDO::getId));
|
}
|
|
}
|
