-- 设置一楼一层库位间隔
 UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 1 AND lev1 = 1 AND bay1 IN (1,3,5,7,9,11,13,15,17,19)

-- 初始化一楼二层库位
-- 引用sql

-- 设置一楼二层库位间隔
 UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 1 AND lev1 = 2 AND row1 IN (29,31,33,35,37,39,41,43,45,47,49,51,53,55,57)

-- 删除多余库位 1
 DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 > 45 AND bay1 > 9

-- 删除多余库位 2
DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 IN(46,50,54,55)  AND bay1 in(4,9)

-- 删除多余库位 3
 DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 IN(32,36,37,41)  AND bay1 in(4,9,14)

-- 删除多余库位 4
 DELETE FROM [dbo].[agv_loc_mast] WHERE plt_type = 666 AND row1 > 28 AND bay1 = 8

-- 设置二楼一层库位间隔
 UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 2 AND lev1 = 1 AND row1 IN (2,4,6,7,8,10,12,13,15,17,19,20,22,24,28,30,32,34,36,38)


	-- 设置二楼一层map位置
	 DECLARE @startBay1 INT = 21;
	 DECLARE @setMapbay1 INT = 33;

	 WHILE @startBay1 <= 26
	 BEGIN

	 	UPDATE [dbo].[agv_loc_mast] SET map_row1 = @setMapbay1  WHERE  floor = 2 AND lev1 = 1 AND row1 = @startBay1
	 	-- 更新 lev1
	 	SET @startBay1 = @startBay1 + 1;
	 	SET @setMapbay1 = @setMapbay1 + 1;
	 END
	
-- 设置三楼一层间隔
 UPDATE [dbo].[agv_loc_mast] SET right_side = 1 WHERE  floor = 3 AND lev1 = 1 AND row1 IN (1,3,5,7,8,9,11,13,14,16,18,20,21,23,25)


 UPDATE [dbo].[agv_loc_mast] SET loc_type2 = 31 WHERE  loc_type1 = 6