From 7ad6e2d4018bc72c5e602107d17f04a71534868a Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期六, 06 一月 2024 15:22:09 +0800
Subject: [PATCH] #空托入库+配置文件

---
 src/main/java/com/zy/asrs/mapper/WrkMastMapper.java |   10 ++++++++++
 1 files changed, 10 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 8c1d459..c6318bf 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
@@ -103,4 +103,14 @@
 
     WrkMast selectWorkingPakin(@Param("sourceStaNo")Integer sourceStaNo);
     WrkMast selectWorkingPakout(@Param("sourceStaNo")Integer sourceStaNo);
+
+    WrkMast selectPakoutEmpty(@Param("staNo")Integer outSite);
+
+
+    Integer selectExistInEmpty();
+
+    @Select("select * from asr_wrk_mast  where crn_no=#{crnNo} and wrk_sts=11 and io_type>100 order by io_pri desc,io_time desc,wrk_no ASC")
+    public List<WrkMast> selectWrkIoType(@Param("crnNo") Integer crnNo);
+
+    public  List<WrkMast> selectWaitPakIn(@Param("wrkNos")List<Integer> wrkNos);
 }

--
Gitblit v1.9.1