From ff1be9fa2dba6eaffc449d09e62998348ea3b830 Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期二, 19 九月 2023 08:00:36 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/mapper/BasDevpMapper.java |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/mapper/BasDevpMapper.java b/src/main/java/com/zy/asrs/mapper/BasDevpMapper.java
index 668d2ca..37b4f93 100644
--- a/src/main/java/com/zy/asrs/mapper/BasDevpMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/BasDevpMapper.java
@@ -15,4 +15,18 @@
     List<Integer> getAvailableInSite(@Param("typeNo") Integer typeNo);
 
     List<Integer> getAvailableOutSite(@Param("typeNo") Integer typeNo);
+
+    BasDevp selectByWrkNo(Integer wrkNo);
+
+    BasDevp queryByLocNo(String locNo);
+
+    BasDevp queryByQrCode(Integer qrCodeValue);
+
+    List<BasDevp> selectLevSite();
+
+    //鑾峰彇鎸囧畾妤煎眰鏈夋彁鍗囨満鍙风殑杈撻�佺珯鐐�
+    List<BasDevp> selectHasLiftNoByLev(Integer lev);
+
+    //鑾峰彇鎸囧畾妤煎眰銆佹寚瀹氭彁鍗囨満鍙峰搴旂殑杈撻�佺珯鐐�
+    BasDevp selectByLevAndLiftNo(Integer lev, Integer liftNo);
 }

--
Gitblit v1.9.1