package cn.iocoder.yudao.module.mes.dal.mysql.md.workstation;
|
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.workstation.MesMdWorkstationMachineDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
/**
|
* MES 设备资源 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface MesMdWorkstationMachineMapper extends BaseMapperX<MesMdWorkstationMachineDO> {
|
|
default List<MesMdWorkstationMachineDO> selectListByWorkstationId(Long workstationId) {
|
return selectList(MesMdWorkstationMachineDO::getWorkstationId, workstationId);
|
}
|
|
default MesMdWorkstationMachineDO selectByMachineryId(Long machineryId) {
|
// 存量数据可能存在同一设备绑定多个工作站，这里取最早一条，避免 selectOne 抛 TooManyResultsException
|
return selectOne(new LambdaQueryWrapperX<MesMdWorkstationMachineDO>()
|
.eq(MesMdWorkstationMachineDO::getMachineryId, machineryId)
|
.orderByAsc(MesMdWorkstationMachineDO::getId)
|
.last("LIMIT 1"));
|
}
|
|
default void deleteByWorkstationId(Long workstationId) {
|
delete(MesMdWorkstationMachineDO::getWorkstationId, workstationId);
|
}
|
|
}
|
