From de27c6f2d428632ed21a015dc6bfb73cc07f31a3 Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期四, 30 三月 2023 10:43:55 +0800
Subject: [PATCH] 四向穿梭车入库模式完善
---
src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
index 415a87d..80a0f32 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
@@ -32,6 +32,7 @@
// 鍏ュ簱绗笁姝ワ紝褰撳爢鍨涙満鎶婅揣鏀惧叆搴撲綅鏃�
// @Select("select top 1 from dbo.asr_wrk_mast where wrk_no=#{workNo}")
WrkMast selectCrnWaiting(@Param("workNo")Integer workNo);
+ WrkMast selectCrnWaiting2(@Param("workNo")Integer workNo);
WrkMast selectPakInStep45(@Param("workNo")Integer workNo);
@@ -87,4 +88,15 @@
WrkMast selectWorkingByCrn(@Param("crnNo")Integer crnNo);
+ WrkMast selectPakinWorkingByGroupLoc(@Param("locNos")List<String> locNos);
+
+ WrkMast selectPakoutWorkingByGroupLoc(@Param("locNos")List<String> locNos);
+
+ List<WrkMast> selectAll(@Param("staNo")Integer staNo);
+
+ WrkMast selectAllC();
+
+ WrkMast selectRackInStep48(Short workNo,Integer sourceStaNo);
+
+ WrkMast selectByWorkNo59(Integer workNo);
}
--
Gitblit v1.9.1