From 3990ae574c221e3764ce9cbc2e4e3eb71b7b1b52 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期六, 24 十月 2026 23:41:23 +0800
Subject: [PATCH] fix(mes): 修复批次正反向追溯链路
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/mps/MesProMpsMapper.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/mps/MesProMpsMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/mps/MesProMpsMapper.java
index 6225ad7..bbb7b79 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/mps/MesProMpsMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/mps/MesProMpsMapper.java
@@ -64,14 +64,20 @@
}
default MesProMpsDO selectBySaleOrderItemId(Long saleOrderItemId) {
- return selectOne(MesProMpsDO::getSaleOrderItemId, saleOrderItemId);
+ return selectOne(new LambdaQueryWrapperX<MesProMpsDO>()
+ .eq(MesProMpsDO::getSaleOrderItemId, saleOrderItemId)
+ .orderByDesc(MesProMpsDO::getId)
+ .last("LIMIT 1"));
}
default List<MesProMpsDO> selectListBySaleOrderItemIds(Collection<Long> saleOrderItemIds) {
if (saleOrderItemIds == null || saleOrderItemIds.isEmpty()) {
return Collections.emptyList();
}
- return selectList(MesProMpsDO::getSaleOrderItemId, saleOrderItemIds);
+ // 鍚屼竴閿�鍞槑缁嗗彲鑳藉瓨鍦ㄢ�滄棫璁″垝宸插彇娑堛�佹柊璁″垝閲嶆柊鍒涘缓鈥濈殑鍘嗗彶璁板綍锛涙寜 ID 鍗囧簭锛岃皟鐢ㄦ柟鍙栨渶鍚庝竴鏉″嵆鏈�鏂拌鍒�
+ return selectList(new LambdaQueryWrapperX<MesProMpsDO>()
+ .in(MesProMpsDO::getSaleOrderItemId, saleOrderItemIds)
+ .orderByAsc(MesProMpsDO::getId));
}
/**
--
Gitblit v1.9.3