From c28812eb7e5afa79cb5e2f4fbee7f96c7d7767ed Mon Sep 17 00:00:00 2001
From: skyouc <creaycat@gmail.com>
Date: 星期五, 03 四月 2026 14:33:22 +0800
Subject: [PATCH] AGV出库，立库查询库存优化
---
src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 4 ++++
1 files changed, 4 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 9e5d84a..30fdc9e 100644
--- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
@@ -13,6 +13,8 @@
@Repository
public interface LocMastMapper extends BaseMapper<LocMast> {
+ List<LocMast> selectLocByLev(Integer lev);
+
LocMast queryFreeLocMast(@Param("row") Integer row, @Param("locType1") Short locType1,@Param("whsType") Long whsType);
@Select("select loc_no from asr_loc_mast where 1=1 and loc_sts = 'O' and crn_no = #{crnNo}")
@@ -60,4 +62,6 @@
* @return 搴撲綅鍙�
*/
String findFirstFrozenLocNo(@Param("locNoList") List<String> locNoList);
+
+ LocMast selectNotFull(@Param("locType")Long locType, @Param("id")Long id);
}
--
Gitblit v1.9.1