From c7338c0fc1513507c05c1a7fd00bff8c11ad5d1e Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期四, 24 十月 2024 08:49:01 +0800
Subject: [PATCH] 生成移库时寻找库位不占用备货区
---
src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
index 9fd1d06..1232af6 100644
--- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
@@ -22,6 +22,11 @@
LocMast queryFreeLocMast(@Param("row") Integer row, @Param("locType1") Short locType1);
+ /**
+ * 妫�绱㈠彲鐢ㄥ簱浣�,涓嶅崰鐢ㄥ璐у尯
+ */
+ LocMast queryFreeLocMastNotBay(@Param("row") Integer row, @Param("locType1") Short locType1,@Param("bay") Integer bay);
+
@Select("select loc_no from asr_loc_mast where 1=1 and loc_sts = 'O' and crn_no = #{crnNo}")
List<String> queryGroupEmptyStock(Integer crnNo);
--
Gitblit v1.9.1