161 lines
11 KiB
Transact-SQL
161 lines
11 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_Transfer')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_Transfer'
|
|
--go
|
|
/****移交管理******/
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('48545C6A-9D10-47F4-810F-DAB0CFCD5BF9','Project Set up','Transfer/ProjectSetup.aspx',10,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6E970072-9DFC-40CE-A3A6-9F5A015FEA22','48545C6A-9D10-47F4-810F-DAB0CFCD5BF9','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('39235E4D-19FB-46B8-BB7A-4BC5E3F1AB6A','48545C6A-9D10-47F4-810F-DAB0CFCD5BF9','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E1D85DB5-8707-47DF-9EB3-93A2A99C75EA','48545C6A-9D10-47F4-810F-DAB0CFCD5BF9','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E5CDF4A0-82B2-4DEA-B268-0F5D3301A445','48545C6A-9D10-47F4-810F-DAB0CFCD5BF9','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D94C1BA4-9DFD-4514-AE12-6F886C5D8C9B','Piping','Transfer/Piping.aspx',20,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AD0B5CEF-B899-457C-ACF8-A67B4DEF878A','D94C1BA4-9DFD-4514-AE12-6F886C5D8C9B','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('70EED055-CC6A-4865-8B2E-114C35E82E39','D94C1BA4-9DFD-4514-AE12-6F886C5D8C9B','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('5FEE485E-6467-4E46-96A3-6BBA9E6F1286','D94C1BA4-9DFD-4514-AE12-6F886C5D8C9B','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A7261F8E-0125-44AE-AF83-BDA183449AD8','D94C1BA4-9DFD-4514-AE12-6F886C5D8C9B','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('982F746C-084C-445C-9AE8-8C37BDFE7994','Static Equipment','Transfer/StaticEquipment.aspx',30,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E2741AC7-5C4C-4139-88CD-12222DC2A4E3','982F746C-084C-445C-9AE8-8C37BDFE7994','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('60049873-F545-41B3-8B08-0DEA553F81FA','982F746C-084C-445C-9AE8-8C37BDFE7994','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('44481C00-0BF4-4EE3-AFC3-411A4F5B881C','982F746C-084C-445C-9AE8-8C37BDFE7994','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FD7E6267-969E-4901-8049-450C2880872F','982F746C-084C-445C-9AE8-8C37BDFE7994','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('7E2FB5F9-FB99-4455-B68F-460F1F9A2676','Rotating Equipment','Transfer/RotatingEquipment.aspx',40,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B09F73C4-167E-4804-9B20-1C7E7ABA96DB','7E2FB5F9-FB99-4455-B68F-460F1F9A2676','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D5F7C2ED-05D9-43DA-81A9-0034B50AD7DB','7E2FB5F9-FB99-4455-B68F-460F1F9A2676','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('757A58C3-D376-4F19-ACB6-565F5B015DA0','7E2FB5F9-FB99-4455-B68F-460F1F9A2676','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F6EB21B0-E7AD-41E5-BDE2-1DC0CE4CEDD4','7E2FB5F9-FB99-4455-B68F-460F1F9A2676','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('88F51059-55B4-4CD5-A38C-36404E5029F6','Instrumentation','Transfer/Instrumentation.aspx',50,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('889D04B0-5F40-468E-BE65-ED9B576EF313','88F51059-55B4-4CD5-A38C-36404E5029F6','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C91D3869-B79E-4454-8C1B-2B1301FC56C5','88F51059-55B4-4CD5-A38C-36404E5029F6','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('08A02910-BF88-4B9F-A8CB-D54706E81184','88F51059-55B4-4CD5-A38C-36404E5029F6','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CEA055B3-9520-456C-8D70-8C820D51BBBE','88F51059-55B4-4CD5-A38C-36404E5029F6','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('296E75D2-192A-4D1F-8471-DD34263F8691','Electrical','Transfer/Electrical.aspx',60,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9CF430F0-596E-4BCC-943E-FE799DF72C72','296E75D2-192A-4D1F-8471-DD34263F8691','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AAA49312-75D0-44FE-AD32-3DA1880FD450','296E75D2-192A-4D1F-8471-DD34263F8691','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('62C002B0-7389-49CD-9352-B83405957158','296E75D2-192A-4D1F-8471-DD34263F8691','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EA70F6FF-580A-4B34-952D-E73CD600FDDC','296E75D2-192A-4D1F-8471-DD34263F8691','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('95C39F86-C060-452E-BA37-D891C466A39B','Civil Structure','Transfer/CivilStructure.aspx',70,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CC878775-8A81-4CA5-985F-FB98F395BA80','95C39F86-C060-452E-BA37-D891C466A39B','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('40EB1B73-264C-4D13-BD78-8459BC095BAC','95C39F86-C060-452E-BA37-D891C466A39B','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E01E66DA-0D6E-4C21-83FA-BDBE3C7AEF6D','95C39F86-C060-452E-BA37-D891C466A39B','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9CEF63B4-B30E-4649-836C-FC1FCDEA2BE3','95C39F86-C060-452E-BA37-D891C466A39B','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('794E64E2-FDD2-4B7D-8408-F7FB06F9C92A','Firefighting','Transfer/Firefighting.aspx',80,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F3047B05-5EAB-4790-B3BE-7CAF33518A3E','794E64E2-FDD2-4B7D-8408-F7FB06F9C92A','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('4EAD0DCD-2E73-4E0F-BA98-0FFFB92BEDB1','794E64E2-FDD2-4B7D-8408-F7FB06F9C92A','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('76104629-1A9C-4608-BDE7-4BE57DE3984D','794E64E2-FDD2-4B7D-8408-F7FB06F9C92A','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3A4C20E2-8CEF-43C2-BDA6-445C1409B32F','794E64E2-FDD2-4B7D-8408-F7FB06F9C92A','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('58FFBD80-ACB9-4830-A18A-E025D9600D94','Telecom','Transfer/Telecom.aspx',90,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('902C9E46-B643-4A66-90D1-E21E62F8EF58','58FFBD80-ACB9-4830-A18A-E025D9600D94','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B88B8F80-DAC2-4B23-931F-01AD574B1792','58FFBD80-ACB9-4830-A18A-E025D9600D94','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D21FDD31-16CB-4092-AD70-7E850816014B','58FFBD80-ACB9-4830-A18A-E025D9600D94','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('63834C81-A947-4314-94B4-B000B5BB7844','58FFBD80-ACB9-4830-A18A-E025D9600D94','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('95295BF7-FB51-480D-9902-6ADA4E8427FC','Plumbing','Transfer/Plumbing.aspx',100,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DEE3945E-8B3D-41B5-B44F-9B0D9F18839E','95295BF7-FB51-480D-9902-6ADA4E8427FC','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('13D22364-0BF2-4A1D-8174-31853C0525EC','95295BF7-FB51-480D-9902-6ADA4E8427FC','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9BB59439-4DF9-4FCC-80DA-7653F4D60333','95295BF7-FB51-480D-9902-6ADA4E8427FC','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B3932022-EAFD-40A6-B39A-581B6E5B8E65','95295BF7-FB51-480D-9902-6ADA4E8427FC','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('05442049-1310-45B1-9D3D-CAAE759D8F3E','HVAC','Transfer/HVAC.aspx',110,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AF3AC8AB-7BE5-4ED2-9718-AE64410A653B','05442049-1310-45B1-9D3D-CAAE759D8F3E','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B4AA5DC3-7790-4975-988F-D521175655E1','05442049-1310-45B1-9D3D-CAAE759D8F3E','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('87048E37-3EF0-4DD5-B1BF-5A752136A3EB','05442049-1310-45B1-9D3D-CAAE759D8F3E','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D4F571DD-C656-46DF-B70B-A242A2B4CB6E','05442049-1310-45B1-9D3D-CAAE759D8F3E','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('016903B1-3B86-4CF5-AFF8-FF8BE389BEE5','Punchlist from','Transfer/PunchlistFrom.aspx',120,'0','Menu_Transfer',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1C032535-64B2-4E4C-95CF-E58547017E14','016903B1-3B86-4CF5-AFF8-FF8BE389BEE5','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DA7C63D5-771A-4B95-993D-6051A306A301','016903B1-3B86-4CF5-AFF8-FF8BE389BEE5','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CF082A4F-D87C-4DC7-AFE0-70880D94F840','016903B1-3B86-4CF5-AFF8-FF8BE389BEE5','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('18C8F0AF-C903-462C-989F-0B30D1B2F75C','016903B1-3B86-4CF5-AFF8-FF8BE389BEE5','保存',4)
|
|
GO |