#

18516761980

2022-10-06 35fa78e3f0b49c9e5d94c1bcf3bd2ae2f1212b4d

 src/main/java/com/zy/asrs/mapper/WrkMastMapper.java

@@ -70,4 +70,32 @@
    @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();

    /**
     * 查找堆垛机号对应所有待出库工作档
     * @param crnNO
     * @param sourceStaNo
     * @return
     */
    List<WrkMast> selectPakOutStep11(@Param("crnNo")Integer crnNO, @Param("sourceStaNo")Integer sourceStaNo);
}