pang.jiabao
2025-11-20 52ad49fed7108445edc8178a98cf4cca36fe0eb0
src/main/java/com/zy/mapper/WrkMastMapper.java
@@ -118,4 +118,19 @@
     * @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);
}