From 57a7240d24ce7e6e07e704a7b82916a1c8a93c9b Mon Sep 17 00:00:00 2001 From: 18516761980 <4761516tqsxp> Date: 星期四, 26 五月 2022 14:04:34 +0800 Subject: [PATCH] Merge branch 'klswcs2' of http://47.97.1.152:5880/r/zy-wcs into klswcs2 --- src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 23 ++++++++++++++++++++++- 1 files changed, 22 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java index d767828..26517b8 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java @@ -35,7 +35,7 @@ // 鎷f枡鍐嶅叆搴撴椂锛岀珯鐐规湁鐗╀笖闇�姹傛椂鏌ヨ // @Select("select top 1 * from asr_wrk_mast where wrk_no=#{workNo} and wrk_sts=14 and (io_type=103 or io_type=107 or io_type=104)") - WrkMast selectPickStep(@Param("workNo")Integer workNo); + WrkMast selectPickStep(@Param("barcode")String barcode); // 鍑哄簱绗竴姝ワ紝浠庡簱浣嶅埌鍫嗗灈鏈哄嚭搴撶珯 // @Select("select top 1 * from dbo.asr_wrk_mast where crn_no=#{crnNo} and wrk_sts=11 and io_type>100 order by io_pri desc,io_time,wrk_no asc") @@ -70,4 +70,25 @@ @Update("update cust_wait_pakin set io_status='F' where zpallet = #{barcode}") int updateWaitPakInStep2(String barcode); + WrkMast selectWorkingPakin(); + + WrkMast selectWorkingPakout(); + + /** + * 鍫嗗灈鏈烘槸鍚﹀瓨鍦ㄥ嚭搴撲换鍔� + * @param crnNo + * @return + */ + WrkMast selectCrnWorking(@Param("crnNo")Integer crnNo); + + /** + * 杈撻�佺嚎鏄惁瀛樺湪鍏ュ簱浠诲姟 + * @param crnNo + * @return + */ + WrkMast selectDevWorking(@Param("crnNo")Integer crnNo); + + + List<WrkMast> selectPick(); + } -- Gitblit v1.9.1