缓存库位id优化

chen.llin

1 天以前 3d100caf5453681293eb0c50f8b01e41e74735b1

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

@@ -1,12 +1,30 @@
package com.zy.asrs.mapper;

import com.zy.asrs.entity.BasStation;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.BasStation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface BasStationMapper extends BaseMapper<BasStation> {

    /**
     * 更新库位状态
     */
    @Update({
            "<script>",
            "UPDATE agv_bas_station",
            "SET loc_sts = #{sts}",
            "WHERE dev_no IN",
            "<foreach collection='siteList' item='item' open='(' separator=',' close=')'>",
            "#{item}",
            "</foreach>",
            "</script>"
    })
    void updateLocStsBatch(@Param("siteList") List<String> siteList, @Param("sts") String sts);
}