package com.zy.asrs.mapper;
|
|
import com.baomidou.mybatisplus.mapper.BaseMapper;
|
import com.zy.asrs.entity.AgvLocMast;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.List;
|
|
@Mapper
|
public interface AgvLocMastMapper extends BaseMapper<AgvLocMast>{
|
|
@Delete("delete from agv_loc_mast")
|
public void deleteAll();
|
|
@Update("update agv_loc_mast set loc_type2 = ${locType2}" +
|
"where (row1 >= ${startRow} and row1 <= ${endRow})" +
|
"and (bay1 >= ${startBay} and bay1 <= ${endBay})" +
|
"and (lev1 >= ${startLev} and lev1 <= ${endLev})" +
|
"and floor = ${floor}")
|
public void updateLocType2(@Param("locType2") int locType2, @Param("startRow")int startRow, @Param("endRow")int endRow, @Param("startBay")int startBay, @Param("endBay")int endBay, @Param("startLev")int startLev, @Param("endLev")int endLev, @Param("floor")int floor);
|
|
List<AgvLocMast> queryFreeLocMast2(Short locType1, Integer rowBeg, Integer rowEnd, Integer bayBeg, Integer bayEnd, Integer levBeg, Integer levEnd);
|
|
}
|
