From f7bcd87b19bf265d0fa157f110632d6b661ec22d Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期一, 25 九月 2023 15:25:03 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/mapper/WrkMastMapper.java |   83 +++++++++++++++++++++++++++++++++++++++--
 1 files changed, 79 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
index 1517399..b9b6e3f 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
@@ -174,21 +174,96 @@
      */
     List<WrkMast> selectRgvOutWorking(@Param("rgvNo")Integer rgvNo);
 
-    /*================================================RGV浠诲姟缁戝畾鐩稿叧 ==================================================*/
+    /*..............................寰愬伐姹変簯..............浠ヤ笅.............涓婇ザ姹熼摐..............................*/
+    /*...............................Created by Monkey D. Luffy on 2023.07.19................................*/
+
+    /*=========================================== RGV浠诲姟缁戝畾鐩稿叧 ========================================*/
 
     /**
-     * 鏌ユ壘鏄惁瀛樺湪RGV姝ｅ湪鍑哄簱宸ヤ綔涓殑浠诲姟
+     * 鑾峰彇绛夊緟缁戝畾RGV鐨勪换鍔�
+     * @return
+     */
+    List<WrkMast> selectWaitBindRGV();
+
+    /**
+     * 鏌ユ壘鏄惁瀛樺湪鍏ュ嚭搴撳伐浣滀腑绛夊緟RGV鎼繍鐨勪换鍔�
+     *
+     * @param rgvNo
+     * @return
+     */
+    List<WrkMast> selectIoRgvNo(@Param("rgvNo") Integer rgvNo);
+
+    /**
+     * 鏌ユ壘鏄惁瀛樺湪鍏ュ簱宸ヤ綔涓鍦ㄨ蛋鍚慠GV鐨勪换鍔�
      * @param wrkNo
      * @return
      */
     WrkMast selectRgvInSteWrkNo(@Param("wrkNo")Integer wrkNo);
+
     /**
-     * 鏌ユ壘鏄惁瀛樺湪RGV姝ｅ湪鍑哄簱宸ヤ綔涓殑浠诲姟
+     * 鏌ユ壘鏄惁瀛樺湪鍑哄簱宸ヤ綔涓鍦ㄨ蛋鍚慠GV鐨勪换鍔�
      * @param wrkNo
      * @return
      */
     WrkMast selectRgvOutSteWrkNo(@Param("wrkNo")Integer wrkNo);
 
+    /**
+     * 鏌ユ壘鏄惁瀛樺湪鍏ュ簱宸ヤ綔涓瓑寰匯GV鎼繍鐨勪换鍔�
+     * @param rgvNo
+     * @return
+     */
+    WrkMast selectRgvInSteNo(@Param("rgvNo")Integer rgvNo);
 
-    /*================================================RGV浠诲姟缁戝畾鐩稿叧 ==================================================*/
+    /**
+     * 鏌ユ壘鏄惁瀛樺湪鍑哄簱宸ヤ綔涓瓑寰匯GV鎼繍鐨勪换鍔�
+     * @param rgvNo
+     * @return
+     */
+    WrkMast selectRgvOutSteNo(@Param("rgvNo")Integer rgvNo);
+
+
+    /*=========================================== RGV浠诲姟缁戝畾鐩稿叧 ========================================*/
+
+    /*=========================================== 鑷姩琛ョ┖鏉跨浉鍏� ========================================*/
+
+    /**
+     * 鏌ユ壘鏄惁瀛樺湪鍑哄簱宸ヤ綔涓瓑寰匯GV鎼繍鐨勪换鍔�
+     */
+//    List<WrkMast> selectDischargingMachineOutputTray();
+
+    /**
+     * 鐮佸灈瀹屾垚椹卞姩鎵樼洏涓嬩竴姝ユ壂鐮佸叆搴�
+     */
+//    List<WrkMast> selectStackingCompletionDriveTray();
+//    /**
+//     * 鐮佸灈瀹屾垚椹卞姩鎵樼洏涓嬩竴姝ユ壂鐮佸叆搴�
+//     * @param wrkNo
+//     */
+//    @Update("update asr_wrk_mast set wrk_sts=44 where 1=1 and wrk_no=#{wrkNo}")
+//    int updateStackingCompletionDriveTray(@Param("wrkNo")Integer wrkNo);
+
+//    int selectConfigCount10468N();
+    // update Config  -- Y
+//    @Update("update sys_config set value='Y' where 1=1 and id=10468 and value = 'N'")
+//    int updateConfig10468Y();
+    /*=========================================== 鑷姩琛ョ┖鏉跨浉鍏� ========================================*/
+
+    /**
+     * 鏌ユ壘鏄惁瀛樺湪鎷嗗灈鍗曟瀹屾垚鐨勫伐浣滄。
+     */
+    WrkMast selectWrkMastUnstackingOne202(@Param("sourceStaNo")Integer sourceStaNo);
+
+    WrkMast selectWrkMastLabelingOne54();
+
+    List<WrkMast> selectWaitBindRGVRgvNo(@Param("rgvNo") Integer rgvNo);
+    List<WrkMast> selectWaitBindRgvNo2(@Param("rgvNo") Integer rgvNo);
+    void insertRgvMast(@Param("wrkNo") Integer wrkNo);
+    void updateRgvMast(@Param("wrkNo") Integer wrkNo);
+
+    WrkMast selectWaitBindRgvNoOneWrkNo(@Param("wrkNo") Integer wrkNo);
+
+
+
+
+    /*..............................涓婇ザ姹熼摐..............浠ヤ笂.............寰愬伐姹変簯..............................*/
 }

--
Gitblit v1.9.1