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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
|
| -- 设置一楼一层库位间隔
| 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
|
|
