From 7d4ee817ca92f1d28a8a292bee5172bd3cbd2c7e Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期三, 28 十月 2026 14:26:10 +0800
Subject: [PATCH] feat(mes): 实现批次绑定托盘和吨袋的分页查询功能

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedQualityMapper.java |   22 ++++++++++++++++++++++
 1 files changed, 22 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedQualityMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedQualityMapper.java
index 98e3ea2..8078d31 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedQualityMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedQualityMapper.java
@@ -17,12 +17,34 @@
                 .likeIfPresent(MesQcSeedQualityDO::getCode, reqVO.getCode())
                 .likeIfPresent(MesQcSeedQualityDO::getBatchCode, reqVO.getBatchCode())
                 .eqIfPresent(MesQcSeedQualityDO::getResult, reqVO.getResult())
+                .eqIfPresent(MesQcSeedQualityDO::getWorkflowStatus, reqVO.getWorkflowStatus())
                 .orderByDesc(MesQcSeedQualityDO::getInspectedAt)
                 .orderByDesc(MesQcSeedQualityDO::getId));
     }
     default MesQcSeedQualityDO selectByCode(String code) {
         return selectOne(new LambdaQueryWrapperX<MesQcSeedQualityDO>().eq(MesQcSeedQualityDO::getCode, code));
     }
+    default List<MesQcSeedQualityDO> selectListByCodes(java.util.Collection<String> codes) {
+        if (codes.isEmpty()) return List.of();
+        return selectList(new LambdaQueryWrapperX<MesQcSeedQualityDO>().in(MesQcSeedQualityDO::getCode, codes));
+    }
+    default List<MesQcSeedQualityDO> selectListByCodesForUpdate(java.util.Collection<String> codes) {
+        if (codes.isEmpty()) return List.of();
+        return selectList(new LambdaQueryWrapperX<MesQcSeedQualityDO>().in(MesQcSeedQualityDO::getCode, codes).last("FOR UPDATE"));
+    }
+    default MesQcSeedQualityDO selectByCodeForUpdate(String code) {
+        return selectOne(new LambdaQueryWrapperX<MesQcSeedQualityDO>().eq(MesQcSeedQualityDO::getCode, code).last("FOR UPDATE"));
+    }
+    default MesQcSeedQualityDO selectByIdForUpdate(Long id) {
+        return selectOne(new LambdaQueryWrapperX<MesQcSeedQualityDO>().eq(MesQcSeedQualityDO::getId, id).last("FOR UPDATE"));
+    }
+    default List<MesQcSeedQualityDO> selectListByIdsForUpdate(java.util.Collection<Long> ids) {
+        if (ids.isEmpty()) return List.of();
+        return selectList(new LambdaQueryWrapperX<MesQcSeedQualityDO>()
+                .in(MesQcSeedQualityDO::getId, ids)
+                .orderByAsc(MesQcSeedQualityDO::getId)
+                .last("FOR UPDATE"));
+    }
 
     default List<MesQcSeedQualityDO> selectListByBatchCode(String batchCode) {
         return selectList(new LambdaQueryWrapperX<MesQcSeedQualityDO>()

--
Gitblit v1.9.3