From d54fbc9d4f8981fa0f7f613b33a28a8cd4f764ea Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期日, 25 十月 2026 16:29:53 +0800
Subject: [PATCH] feat(system): 优化用户搜索功能并完善ERP和MES模块验证逻辑
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/mps/MesProMpsMapper.java | 12 +++++++++---
1 files changed, 9 insertions(+), 3 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 80152be..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
@@ -18,7 +18,7 @@
/**
* MES 鐢熶骇涓昏鍒掞紙MPS锛塎apper
*
- * @author 鑺嬮亾婧愮爜
+ * @author 瓒呯骇绠＄悊鍛�
*/
@Mapper
public interface MesProMpsMapper extends BaseMapperX<MesProMpsDO> {
@@ -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