From 5d1f03e3277517aa41af68b0b6d2fb3d008a867e Mon Sep 17 00:00:00 2001 From: ZY <zc857179121@qq.com> Date: 星期三, 02 四月 2025 16:57:44 +0800 Subject: [PATCH] 1 --- src/main/resources/四期sql/4.初始化1.txt | 44 +++++++++++++++++++++++--------------------- 1 files changed, 23 insertions(+), 21 deletions(-) diff --git "a/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt" "b/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt" index b938ee5..1b41e81 100644 --- "a/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt" +++ "b/src/main/resources/\345\233\233\346\234\237sql/4.\345\210\235\345\247\213\345\214\2261.txt" @@ -1,43 +1,45 @@ --- 鍒濆鍖栦竴銆佷簩銆佷笁妤间竴灞傚簱浣峬ap浣嶇疆 --- UPDATE [dbo].[agv_loc_mast] SET map_row1 = row1,map_bay1 = bay1, right_side = 0 WHERE lev1 = 1 + -- 璁剧疆涓�妤间竴灞傚簱浣嶉棿闅� --- 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) + 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) + 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 + 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) +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) + 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 + 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) + 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) -- 璁剧疆浜屾ゼ涓�灞俶ap浣嶇疆 - -- 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 + 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) \ No newline at end of file + 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 \ No newline at end of file -- Gitblit v1.9.1