| | |
| | | // 入库第三步,当堆垛机把货放入库位时 |
| | | // @Select("select top 1 from dbo.asr_wrk_mast where wrk_no=#{workNo}") |
| | | WrkMast selectPakInStep3(@Param("workNo")Integer workNo); |
| | | WrkMast selectWrkMastUnstackingOne212(); |
| | | |
| | | WrkMast selectPakInStep4(@Param("staNo")Integer staNo,@Param("sheetNo")String sheetNo); |
| | | WrkMast selectPakInStep5(@Param("staNo")Integer staNo,@Param("sheetNo")String sheetNo); |
| | | |
| | | // 拣料再入库时,站点有物且需求时查询 |
| | | // @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)") |
| | |
| | | // 出库第二步,从堆垛机出库站到目标出库站,堆垛机出库站有物时执行 |
| | | // @Select("select top 1 * from dbo.asr_wrk_mast where source_sta_no=#{sourceStaNo} and wrk_sts=12 and io_type>100 order by io_pri desc,io_time desc,wrk_no ASC") |
| | | WrkMast selectPakOutStep2(@Param("sourceStaNo")Integer sourceStaNo); |
| | | |
| | | WrkMast selectPakOutStep3(@Param("sourceStaNo")Integer sourceStaNo); |
| | | |
| | | // 库位移转工作档,在进行一次入出库作业后紧跟库位移转 |
| | | // @Select("select top 1 * from dbo.asr_wrk_mast where wrk_sts=11 and (io_type=11 or io_type=110) and crn_no=#{crnNo} order by io_time,wrk_no") |
| | |
| | | */ |
| | | List<WrkMast> selectRgvOutWorking(@Param("rgvNo")Integer rgvNo); |
| | | |
| | | /*================================================RGV任务绑定相关 ==================================================*/ |
| | | /*..............................徐工汉云..............以下.............上饶江铜..............................*/ |
| | | /*...............................Created by Monkey D. Luffy on 2023.07.19................................*/ |
| | | |
| | | /*=========================================== RGV任务绑定相关 ========================================*/ |
| | | |
| | | /** |
| | | * 获取等待绑定RGV的任务 |
| | | * @return |
| | | */ |
| | | List<WrkMast> selectWaitBindRGV(); |
| | | |
| | | /** |
| | | * 查找是否存在入出库工作中等待RGV搬运的任务 |
| | | * |
| | | * @param rgvNo |
| | | * @return |
| | | */ |
| | | List<WrkMast> selectIoRgvNo(@Param("rgvNo") Integer rgvNo); |
| | | |
| | | /** |
| | | * 查找是否存在入库工作中正在走向RGV的任务 |
| | |
| | | WrkMast selectRgvOutSteNo(@Param("rgvNo")Integer rgvNo); |
| | | |
| | | |
| | | /*================================================RGV任务绑定相关 ==================================================*/ |
| | | /*=========================================== RGV任务绑定相关 ========================================*/ |
| | | |
| | | /*=========================================== 自动补空板相关 ========================================*/ |
| | | |
| | | /** |
| | | * 查找是否存在出库工作中等待RGV搬运的任务 |
| | | */ |
| | | // 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 selectWrkMastUnstackingOne202Two(@Param("sourceStaNo")Integer sourceStaNo); |
| | | WrkMast selectWrkMastUnstackingOne145(@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); |
| | | |
| | | |
| | | |
| | | |
| | | /*..............................上饶江铜..............以上.............徐工汉云..............................*/ |
| | | } |