| | |
|---|
| | | 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; |
|---|
| | | |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | default MesMdWorkstationMachineDO selectByMachineryId(Long machineryId) { |
|---|
| | | return selectOne(MesMdWorkstationMachineDO::getMachineryId, machineryId); |
|---|
| | | // 存量数据可能存在同一设备绑定多个工作站，这里取最早一条，避免 selectOne 抛 TooManyResultsException |
|---|
| | | return selectOne(new LambdaQueryWrapperX<MesMdWorkstationMachineDO>() |
|---|
| | | .eq(MesMdWorkstationMachineDO::getMachineryId, machineryId) |
|---|
| | | .orderByAsc(MesMdWorkstationMachineDO::getId) |
|---|
| | | .last("LIMIT 1")); |
|---|
| | | } |
|---|
| | | |
|---|
| | | default void deleteByWorkstationId(Long workstationId) { |
|---|
