package com.zy.asrs.mapper;

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

@Mapper
@Repository
public interface AgvBasMapMapper extends BaseMapper<AgvBasMap> {

    @Select("select top 1 * from agv_bas_map where lev = #{lev} and floor = #{floor} order by id desc")
    BasMap selectLatestMap(@Param("lev")Integer lev, @Param("floor")Integer floor);//获取最新地图数据

    boolean deleteByLev(Integer lev);//删除指定楼层地图

}