| | |
|---|
| | | public interface AgvLocMastMapper extends BaseMapper<AgvLocMast>{ |
|---|
| | | |
|---|
| | | //@Delete("delete from agv_loc_mast") |
|---|
| | | @Delete("delete from agv_loc_mast where floor = '3'") |
|---|
| | | @Delete("delete from agv_loc_mast") |
|---|
| | | public void deleteAll(); |
|---|
| | | |
|---|
| | | @Update("update agv_loc_mast set loc_type2 = ${locType2}" + |
|---|
| | |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM agv_loc_mast WHERE lev1 = #{lev} And floor = #{floor}") |
|---|
| | | List<AgvLocMast> selectLocByLevAndFloor(@Param("lev")int lev, @Param("floor")int floor); |
|---|
| | | |
|---|
| | | @Select("SELECT loc_type2 FROM agv_loc_mast WHERE loc_type1 = #{locType1} AND loc_type2 IS NOT NULL GROUP BY loc_type2") |
|---|
| | | List<String> queryContainerTypeByLocType1(@Param("locType1")Short locType1); |
|---|
| | | } |
|---|
