From e4ce58dbf41ba490d9c68bfd90a078c229a93bc7 Mon Sep 17 00:00:00 2001
From: 野心家 <1051256694@qq.com>
Date: 星期三, 15 三月 2023 13:04:24 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 3 +++
1 files changed, 3 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 6bfd8f0..122f6c8 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
@@ -109,5 +109,8 @@
Integer selectExistInEmpty();
+ @Select("select * from 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 WrkMast selectTop1(@Param("wrkNo")List<Integer> wrkNo);
}
--
Gitblit v1.9.1