chen.llin
2 天以前 35c26fb50cc90b85a8cf924f7b47e3ab412cabb5
src/main/java/com/zy/mapper/WrkMastMapper.java
@@ -112,4 +112,25 @@
    WrkMast selectPickStep2(@Param("barcode")String barcode);
    WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo);
    /**
     * 获取一条到104站点的出库任务
     * @return 工作主档
     */
    WrkMast selectBy104();
    @Update({
            "<script>",
            "UPDATE asr_wrk_mast",
            "SET call_agv = 1",
            "WHERE wrk_no IN",
            "<foreach item='item' collection='workNos' open='(' separator=',' close=')'>",
            "#{item}",
            "</foreach>",
            "AND io_type IN (101,110,103,104,107)",
            "AND wrk_sts IN (14,15)",
            "AND call_agv = 0",
            "</script>"
    })
    void updateCallAgvBatch(@Param("workNos") List<Integer> workNos);
}