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
46
47
48
49
50
51
52
53
| DECLARE @locno VARCHAR(50); -- 声明 locno 字段，指定长度
| DECLARE @locsts NVARCHAR(50);
| DECLARE @row1 INT = 27;
| DECLARE @bay1 INT = 14;
| DECLARE @lev1 INT = 1;
| DECLARE @fullplt VARCHAR(1); -- 假设 fullplt 只需要一个字符
| DECLARE @loctype1 INT = 6;
| DECLARE @ft DATETIME;
| DECLARE @mt DATETIME;
| DECLARE @apt DATETIME;
| DECLARE @et DATETIME;
| DECLARE @stas INT;
| DECLARE @floor INT;
| DECLARE @maprow INT = 21;
| DECLARE @mapbay INT = 14;
| DECLARE @rightside INT = 0;
| DECLARE @plttype INT = 777;
|
|
|
| -- 使用 WHILE 循环来控制 row1 的范围
| WHILE @row1 <= 38
| BEGIN
| -- 在每次循环中，更新 lev1 的值
| SET @bay1 = 14; -- 重置 lev1
| SET @mapbay = 14; -- 重置 lev1
|
| WHILE @bay1 <= 33
| BEGIN
| -- 生成 locno 和其他字段的值
| SET @locno = 'YZ_0' + CAST(@row1 AS VARCHAR(2)) + '_0' + RIGHT('00' + CAST(@bay1 AS VARCHAR(2)), 2) + '_0' + CAST(@lev1 AS VARCHAR(2)) + 'F2';
| SET @locsts = 'O';
| SET @fullplt = 'N';
| SET @ft = GETDATE();
| SET @mt = GETDATE();
| SET @apt = GETDATE();
| SET @et = GETDATE();
| SET @stas = 0;
| SET @floor = 2;
|
| -- 插入数据
| INSERT INTO agv_loc_mast (loc_no, plt_type,loc_sts, row1, bay1, lev1, full_plt,loc_type1, first_time, modi_time, appe_time, error_time, status, floor,map_row1,map_bay1,right_side)
| VALUES (@locno, @plttype, @locsts, @row1, @bay1, @lev1, @fullplt,@loctype1, @ft, @mt, @apt, @et, @stas, @floor,@maprow,@mapbay,@rightside);
|
| -- 更新 lev1
| SET @bay1 = @bay1 + 1;
| SET @mapbay = @mapbay + 1;
| END
|
| -- 更新 row1
| SET @row1 = @row1 + 1;
| SET @maprow = @maprow + 1;
| END
|
|
