From c96fbc66ec97d88baf95a75fa18092ccfc3f416c Mon Sep 17 00:00:00 2001 From: zhangchao <zc857179121@qq.com> Date: 星期一, 26 八月 2024 20:08:43 +0800 Subject: [PATCH] 偶发bug(任务号丢失) --- src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 9 +++++++++ 1 files changed, 9 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..2e59546 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java @@ -25,6 +25,8 @@ // @Select("select top 1 * from asr_wrk_mast where source_sta_no=#{sourceStaNo} and wrk_sts=2 and barcode=#{barcode} and (io_type=1 or io_type=10) order by io_pri desc,io_time,wrk_no ASC") WrkMast selectPakInStep1(@Param("sourceStaNo")Integer sourceStaNo, @Param("barcode")String barcode); + WrkMast selectPakInStepBarcode(@Param("barcode")String barcode); + WrkMast selectPakInStep11(@Param("sourceStaNo")Integer sourceStaNo); // 鍏ュ簱绗簩姝ワ紝褰撴墭鐩樼墿鏂欏湪鍫嗗灈鏈哄叆搴撶珯鏃舵椂鏌ヨ @@ -103,4 +105,11 @@ WrkMast selectWorkingPakin(@Param("sourceStaNo")Integer sourceStaNo); WrkMast selectWorkingPakout(@Param("sourceStaNo")Integer sourceStaNo); + + WrkMast selectPakoutEmpty(@Param("staNo")Integer outSite); + + + WrkMast selectPickStep2(@Param("barcode")String barcode); + + WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo); } -- Gitblit v1.9.1