From 618030e495a9520291ebfd709c80c4c8a8b73451 Mon Sep 17 00:00:00 2001
From: quxin <592870522@qq.com>
Date: 星期五, 04 九月 2026 11:36:26 +0800
Subject: [PATCH] 修复: 生产领料后的退料应该是选择领料的记录,不是选择库存的记录(同时库存数据需要根据领料退料变动,比如库存100,领用80,然后领用80中退料30,库存应由原来的20变成50)

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/workorder/MesProWorkOrderParamRecordMapper.java |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/workorder/MesProWorkOrderParamRecordMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/workorder/MesProWorkOrderParamRecordMapper.java
index adbefc4..6322627 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/workorder/MesProWorkOrderParamRecordMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/workorder/MesProWorkOrderParamRecordMapper.java
@@ -7,6 +7,7 @@
 import cn.iocoder.yudao.module.mes.dal.dataobject.pro.workorder.MesProWorkOrderParamRecordDO;
 import org.apache.ibatis.annotations.Mapper;
 
+import java.util.Collection;
 import java.util.List;
 
 /**
@@ -27,10 +28,23 @@
                 .orderByDesc(MesProWorkOrderParamRecordDO::getId));
     }
 
+    default MesProWorkOrderParamRecordDO selectFirstByTaskId(Long taskId) {
+        return selectOne(new LambdaQueryWrapperX<MesProWorkOrderParamRecordDO>()
+                .eq(MesProWorkOrderParamRecordDO::getTaskId, taskId)
+                .orderByAsc(MesProWorkOrderParamRecordDO::getId)
+                .last("LIMIT 1"));
+    }
+
     default List<MesProWorkOrderParamRecordDO> selectListByWorkOrderId(Long workOrderId) {
         return selectList(new LambdaQueryWrapperX<MesProWorkOrderParamRecordDO>()
                 .eq(MesProWorkOrderParamRecordDO::getWorkOrderId, workOrderId)
                 .orderByDesc(MesProWorkOrderParamRecordDO::getId));
     }
 
+    default List<MesProWorkOrderParamRecordDO> selectListByTaskIds(Collection<Long> taskIds) {
+        return selectList(new LambdaQueryWrapperX<MesProWorkOrderParamRecordDO>()
+                .in(MesProWorkOrderParamRecordDO::getTaskId, taskIds)
+                .orderByAsc(MesProWorkOrderParamRecordDO::getId));
+    }
+
 }

--
Gitblit v1.9.3