1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| package com.zy.asrs.mapper;
|
| 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);
| }
|
|
