package cn.iocoder.yudao.module.erp.dal.mysql.mapping;
|
|
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.erp.controller.admin.mapping.vo.ErpMesWarehouseMappingPageReqVO;
|
import cn.iocoder.yudao.module.erp.dal.dataobject.mapping.ErpMesWarehouseMappingDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
/**
|
* ERP仓库与MES仓库映射 Mapper
|
*/
|
@Mapper
|
public interface ErpMesWarehouseMappingMapper extends BaseMapperX<ErpMesWarehouseMappingDO> {
|
|
default ErpMesWarehouseMappingDO selectByErpWarehouseId(Long erpWarehouseId) {
|
return selectOne(new LambdaQueryWrapperX<ErpMesWarehouseMappingDO>()
|
.eq(ErpMesWarehouseMappingDO::getErpWarehouseId, erpWarehouseId)
|
.eq(ErpMesWarehouseMappingDO::getStatus, 1)); // 只查询启用状态
|
}
|
|
default ErpMesWarehouseMappingDO selectByMesWarehouseId(Long mesWarehouseId) {
|
return selectOne(new LambdaQueryWrapperX<ErpMesWarehouseMappingDO>()
|
.eq(ErpMesWarehouseMappingDO::getMesWarehouseId, mesWarehouseId));
|
}
|
|
default PageResult<ErpMesWarehouseMappingDO> selectPage(ErpMesWarehouseMappingPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<ErpMesWarehouseMappingDO>()
|
.eqIfPresent(ErpMesWarehouseMappingDO::getErpWarehouseId, reqVO.getErpWarehouseId())
|
.eqIfPresent(ErpMesWarehouseMappingDO::getMesWarehouseId, reqVO.getMesWarehouseId())
|
.eqIfPresent(ErpMesWarehouseMappingDO::getStatus, reqVO.getStatus())
|
.orderByDesc(ErpMesWarehouseMappingDO::getId));
|
}
|
|
}
|