557 lines
40 KiB
Transact-SQL
557 lines
40 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_ZHGL')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_ZHGL'
|
|
--go
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('2572CDC8-BA26-4C74-B6F7-CB3D63E91E72','安全体系','',10,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('BED3F4D3-0B2D-4018-950F-0D9CCA690954','安全组织体系','ZHGL/HSSESystem/HSSEOrganize.aspx',10,'2572CDC8-BA26-4C74-B6F7-CB3D63E91E72','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FC86B3BC-2741-4E67-8AFE-FB8358CA20EB','BED3F4D3-0B2D-4018-950F-0D9CCA690954','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9E702263-6700-491C-81BB-17D081D16E30','BED3F4D3-0B2D-4018-950F-0D9CCA690954','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('BB5775B5-B6E2-4F30-AE12-FD30DE9AB32A','BED3F4D3-0B2D-4018-950F-0D9CCA690954','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E8ED52D7-E483-493A-BE88-7DA00DBAAAE0','BED3F4D3-0B2D-4018-950F-0D9CCA690954','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B2C51E47-4173-43CD-B096-B332DD5F3F55','安全管理机构','ZHGL/HSSESystem/HSSEManage.aspx',20,'2572CDC8-BA26-4C74-B6F7-CB3D63E91E72','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B1228712-1458-41DD-BBDF-2C2359EE4D17','B2C51E47-4173-43CD-B096-B332DD5F3F55','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('47AD1E9E-631B-47C7-8C77-3FAC421AEA75','B2C51E47-4173-43CD-B096-B332DD5F3F55','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1483ED7A-952D-4184-AE73-E2F32988111B','B2C51E47-4173-43CD-B096-B332DD5F3F55','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('608743DD-061C-453F-9BAF-6DF15A7D3952','B2C51E47-4173-43CD-B096-B332DD5F3F55','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B0FDF8C2-A902-456A-8B5B-43E4B1C8BBE2','安全制度','ZHGL/HSSESystem/SafetyInstitution.aspx',30,'2572CDC8-BA26-4C74-B6F7-CB3D63E91E72','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('0CD46065-D178-45B8-B36B-A779C78F87BC','B0FDF8C2-A902-456A-8B5B-43E4B1C8BBE2','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('83515ADE-4A96-487B-A53E-57C446D8217E','B0FDF8C2-A902-456A-8B5B-43E4B1C8BBE2','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('21F1F6A4-8520-4E0F-B153-3CF8BE855ED6','B0FDF8C2-A902-456A-8B5B-43E4B1C8BBE2','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3E341FD3-7E5C-42BC-8C42-6BD138E4FBE7','B0FDF8C2-A902-456A-8B5B-43E4B1C8BBE2','保存',4)
|
|
GO
|
|
|
|
--人员管理
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('175FAEE8-F6B3-483D-839B-001AF4B45D0A','人员管理','',15,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8E229597-B2D8-407B-8192-787E65E5052E','企业总部人员','ZHGL/Person/CompanyPerson.aspx',10,'175FAEE8-F6B3-483D-839B-001AF4B45D0A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('BC370144-AA46-4AD3-B26C-DF3E995388C4','8E229597-B2D8-407B-8192-787E65E5052E','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('62AC6438-952A-49BE-81BA-580F7C060E33','8E229597-B2D8-407B-8192-787E65E5052E','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9B133AF0-CA02-4383-9AB8-9B13BC6A84CE','8E229597-B2D8-407B-8192-787E65E5052E','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A8EA6A33-090C-4D92-9CFB-225ED38FAE93','8E229597-B2D8-407B-8192-787E65E5052E','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('FE342650-9E64-4B9C-8023-34399E198B6F','分支机构人员','ZHGL/Person/BranchPerson.aspx',20,'175FAEE8-F6B3-483D-839B-001AF4B45D0A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CB3CDFC7-1B77-4948-A431-683D197E5684','FE342650-9E64-4B9C-8023-34399E198B6F','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('232A054B-E244-4412-852B-670AA5F6CC24','FE342650-9E64-4B9C-8023-34399E198B6F','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C29706B8-8092-4733-83C6-811F5F195EC9','FE342650-9E64-4B9C-8023-34399E198B6F','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D4A95692-847A-41C6-97EF-B36E04AFB335','FE342650-9E64-4B9C-8023-34399E198B6F','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D2C91885-974A-448A-9BA5-0EEAE8FA98CA','项目现场人员','ZHGL/Person/ProjectPerson.aspx',30,'175FAEE8-F6B3-483D-839B-001AF4B45D0A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('13369C09-3301-4BA8-B0DC-7BC2B41981C9','D2C91885-974A-448A-9BA5-0EEAE8FA98CA','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('16DD0C20-AAB5-46C3-A927-B0A159B39706','D2C91885-974A-448A-9BA5-0EEAE8FA98CA','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F19E234F-D938-45BD-8C32-8F7F8C35BD07','D2C91885-974A-448A-9BA5-0EEAE8FA98CA','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('4E93A42D-BEAB-4991-8396-0A6E51BF1AF1','D2C91885-974A-448A-9BA5-0EEAE8FA98CA','保存',4)
|
|
GO
|
|
|
|
--安全报表(集团)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D','安全报表(集团)','',20,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','安全信息上报','',10,'4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3156A9F0-276D-4AD4-BF84-45CF6DFC215C','百万工时安全统计月报','ZHGL/Information/MillionsMonthlyReport.aspx',10,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('8C0E3DDA-8883-4A8E-B288-C009B807C39D','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('8C720351-FD57-4C2D-9FCB-C8BB7FE48E65','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9084F09C-AA75-42B4-8357-6CDD0661CE8D','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('00C79282-699E-4CCA-988E-1F36671C2F37','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1889FE33-E72D-4E70-B51D-2AE411E08693','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','保存并上报',5)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('08C103D2-6DB3-435E-A3DC-0C1F99CC51FF','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','提交',6)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AE5A454F-578E-4C52-969B-20AB87006A73','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','导入',7)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('88D736EA-3ADC-4100-B17E-A1A1F16D9D2A','3156A9F0-276D-4AD4-BF84-45CF6DFC215C','打印',8)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4BC71D2E-7D94-48C1-A61A-139637825AA5','职工伤亡事故原因分析报','ZHGL/Information/AccidentCauseReport.aspx',20,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9D7EDCF0-32CD-4BB6-AA0F-6914E2B0F2D1','4BC71D2E-7D94-48C1-A61A-139637825AA5','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FB9C1CDD-3CB8-4AEC-B940-563B3BA59E17','4BC71D2E-7D94-48C1-A61A-139637825AA5','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FABAAF0B-C618-43B7-907A-217B6A1E5F6E','4BC71D2E-7D94-48C1-A61A-139637825AA5','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('385833BA-BD03-4DB2-9380-C76395368782','4BC71D2E-7D94-48C1-A61A-139637825AA5','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('34472641-62F3-4E40-BEB3-770C3D833D03','4BC71D2E-7D94-48C1-A61A-139637825AA5','保存并上报',5)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1CBB8571-E8D1-4EE0-AB08-4C3305BE27C6','4BC71D2E-7D94-48C1-A61A-139637825AA5','提交',6)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A71F1236-204F-4B34-B887-19B31CE56F63','4BC71D2E-7D94-48C1-A61A-139637825AA5','导入',7)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C90343CD-4DBE-4C3B-BEDD-888C9B514F8B','4BC71D2E-7D94-48C1-A61A-139637825AA5','打印',8)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','安全生产数据季报','ZHGL/Information/SafetyQuarterlyReport.aspx',30,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AD2043D6-871F-47FE-B6CC-0CA5CD50C0BA','A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('19657A9D-6AEB-47BA-BC3F-B916C68B515B','A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('07E601FD-AE73-4F2B-A9D2-613B34ED654A','A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D3BBA6C4-4D71-4533-9A47-9459AA30C2D2','A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('90ED2D85-1184-4E46-8832-8C1215B6C59D','A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','保存并上报',5)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('BED22C29-BA30-4BD2-A244-8588F2A0635B','A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','导入',6)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C4922011-37CD-4B79-820A-D8CAAE39144D','A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','打印',7)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('7985C759-8EB9-4B7D-AC65-00541280B46C','应急演练开展情况季报','ZHGL/Information/DrillConductedQuarterlyReport.aspx',40,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3D866C54-0A39-4A56-B771-7F3C63CF6A32','7985C759-8EB9-4B7D-AC65-00541280B46C','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F65F199A-5D28-42D0-B08F-390376CAAC31','7985C759-8EB9-4B7D-AC65-00541280B46C','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7FA97C99-A026-4934-95AC-50FF173B889D','7985C759-8EB9-4B7D-AC65-00541280B46C','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1689FECD-6F18-4B1E-8190-706F2124B4C6','7985C759-8EB9-4B7D-AC65-00541280B46C','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6358C4DD-5B0E-4DB5-8FD1-AED403EF1D43','7985C759-8EB9-4B7D-AC65-00541280B46C','保存并上报',5)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C1E0471F-568C-4B85-ADED-FCDD27F8C3DA','7985C759-8EB9-4B7D-AC65-00541280B46C','提交',6)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('5231B22C-BF0B-478B-92DD-1C1B30BC7270','7985C759-8EB9-4B7D-AC65-00541280B46C','导入',7)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('25A11FB5-AB22-42CC-9E94-29FF9221B25B','7985C759-8EB9-4B7D-AC65-00541280B46C','打印',8)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('70DEB27A-D6FF-4D57-879B-0270F2967FA0','应急演练工作计划半年报','ZHGL/Information/DrillPlanHalfYearReport.aspx',50,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A034BF05-9859-4920-97F0-20190D94E6F4','70DEB27A-D6FF-4D57-879B-0270F2967FA0','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A821D1EC-5E54-4386-80E8-D1718CF00E7D','70DEB27A-D6FF-4D57-879B-0270F2967FA0','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6345E13D-F311-4839-927E-ADEF36D7CB5E','70DEB27A-D6FF-4D57-879B-0270F2967FA0','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A4115079-DDEC-4B42-836D-4B79B999E011','70DEB27A-D6FF-4D57-879B-0270F2967FA0','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DE6CADAC-6981-45F6-BF19-0BFC6F1F2AFE','70DEB27A-D6FF-4D57-879B-0270F2967FA0','保存并上报',5)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C495E44F-DF2C-4071-829C-8C06DA30F9FE','70DEB27A-D6FF-4D57-879B-0270F2967FA0','提交',6)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F287B0ED-D725-4CD3-B422-5319112F452B','70DEB27A-D6FF-4D57-879B-0270F2967FA0','导入',7)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('30F188D4-84D4-4D3C-8ECE-B499ACB1C3C8','70DEB27A-D6FF-4D57-879B-0270F2967FA0','打印',8)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA','安全信息分析','',20,'4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('598568A0-A338-499F-888C-1B73665837F9','人工时费用分析','ZHGL/Information/AnalyseWorkTimeCost.aspx',10,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('8A76D0BB-417C-44C4-B042-5AA74E60738B','598568A0-A338-499F-888C-1B73665837F9','统计',1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8396C9E2-3376-4144-978A-CC6041EC6C6A','安全事故分析','ZHGL/Information/AnalyseSafeAccident.aspx',20,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CC64B935-25EB-41D0-9D8E-D6D97151D2C5','8396C9E2-3376-4144-978A-CC6041EC6C6A','统计',1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('5B645281-A055-4AA1-9245-DACBD984C76F','安全隐患分析','ZHGL/Information/AnalyseHiddenDanger.aspx',30,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('ACF63F9B-692D-4610-A8F9-5FDBFEAA2551','5B645281-A055-4AA1-9245-DACBD984C76F','统计',1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('195D508D-E929-4B91-891E-307DC4E4338F','资源来源统计','ZHGL/Information/AnalyseResource.aspx',40,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3B462DFF-C9BB-4646-92B0-7E8AB52FBC1E','195D508D-E929-4B91-891E-307DC4E4338F','统计',1)
|
|
GO
|
|
|
|
--HSSE管理工作报告
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('70E51ABF-81C8-49CB-89AC-CF0542A201D6','HSSE管理工作报告','',30,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
--本部HSSE管理工作报告下子菜单
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D67D1C85-3798-47A9-A0DB-B4DB47FF2E7D','报表上报情况','ZHGL/ManagementReport/ReportRemind.aspx',10,'70E51ABF-81C8-49CB-89AC-CF0542A201D6','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6122B0C7-E76F-4283-A30F-05B8BDC1E6C4','D67D1C85-3798-47A9-A0DB-B4DB47FF2E7D','删除',1)
|
|
GO
|
|
|
|
--企业安全大检查
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('CD9FC4C8-4B02-4619-8B02-50DA6AE6146E','企业安全大检查','',40,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('40387C48-95A0-435C-82FB-57AF0A81B9D4','安全监督检查报告','ZHGL/Supervise/SuperviseCheckReport.aspx',10,'CD9FC4C8-4B02-4619-8B02-50DA6AE6146E','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D5465075-BB0C-447D-95EC-4030A25A98ED','40387C48-95A0-435C-82FB-57AF0A81B9D4','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('126A4582-EB43-4A46-9E28-E0A780E425ED','40387C48-95A0-435C-82FB-57AF0A81B9D4','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('ACA5D163-C3B4-403F-A1D0-13F343289DF4','40387C48-95A0-435C-82FB-57AF0A81B9D4','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CF9ED9A9-D40F-4501-A4D4-929E6FCCB97A','40387C48-95A0-435C-82FB-57AF0A81B9D4','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('A02E0365-383C-49A0-BF1A-B3E42052959B','安全监督检查整改','ZHGL/Supervise/SuperviseCheckRectify.aspx',20,'CD9FC4C8-4B02-4619-8B02-50DA6AE6146E','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('ECE3BCFB-4B56-4FDD-8557-D5128A3172DD','A02E0365-383C-49A0-BF1A-B3E42052959B','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7A4EE5DF-FC8C-418B-A130-88ECA4EFADDE','A02E0365-383C-49A0-BF1A-B3E42052959B','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C8656544-FF83-4D68-AE09-EFAB5DE7EF23','A02E0365-383C-49A0-BF1A-B3E42052959B','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C01A5167-2001-43E9-9DEE-EEA406FF1FF9','A02E0365-383C-49A0-BF1A-B3E42052959B','保存并上报',5)
|
|
GO
|
|
|
|
--集团安全监督
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DEAA1931-C0D7-4277-9B34-23963D1C538A','集团安全监督','',50,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1969C3C3-9257-49CD-977D-546CA18DC91C','安全监督检查通知单','ZHGL/ServerCheck/CheckNotice.aspx',5,'DEAA1931-C0D7-4277-9B34-23963D1C538A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B9950CB5-C47A-4C0A-A6CC-C7DDBBDE7D1E','企业上报监督检查报告','ZHGL/ServerCheck/UpCheckReport.aspx',10,'DEAA1931-C0D7-4277-9B34-23963D1C538A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CF8120E3-17CD-4237-AEC6-5FB824CE6960','B9950CB5-C47A-4C0A-A6CC-C7DDBBDE7D1E','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B0D365B4-8A99-4D9B-8F72-535937457E83','B9950CB5-C47A-4C0A-A6CC-C7DDBBDE7D1E','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('BBFF157D-AB21-4CCD-B1DC-32395E3645BE','B9950CB5-C47A-4C0A-A6CC-C7DDBBDE7D1E','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('4590DDA7-5F0B-4327-B6A8-A44B328176F4','B9950CB5-C47A-4C0A-A6CC-C7DDBBDE7D1E','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CD2FB445-1C0B-4F13-85EE-36F26F4A6180','B9950CB5-C47A-4C0A-A6CC-C7DDBBDE7D1E','保存并上报',5)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3D1CFA31-96A9-496E-9A94-318670C9D658','企业安全文件上报','ZHGL/ServerCheck/SubUnitReport.aspx',20,'DEAA1931-C0D7-4277-9B34-23963D1C538A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7075349F-B55F-457E-8EA3-0CBAD0863DB0','3D1CFA31-96A9-496E-9A94-318670C9D658','增加',1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('12C61C54-D3B3-4B07-AAA9-8B9FAA176E75','3D1CFA31-96A9-496E-9A94-318670C9D658','修改',2)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CD5B2ADD-36C0-43AC-AB31-4BE79EC4E957','3D1CFA31-96A9-496E-9A94-318670C9D658','删除',3)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('457BE203-8D81-4421-BDFE-75CE47E4DF67','3D1CFA31-96A9-496E-9A94-318670C9D658','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4A87774E-FEA5-479A-97A3-9BBA09E4862E','集团下发监督检查整改','ZHGL/ServerCheck/CheckRectify.aspx',30,'DEAA1931-C0D7-4277-9B34-23963D1C538A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9F683E31-9E50-49AE-9782-EBD0CB82DDD8','4A87774E-FEA5-479A-97A3-9BBA09E4862E','修改',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A0FACD5D-87F5-4D52-83D4-3B641D5E58E9','4A87774E-FEA5-479A-97A3-9BBA09E4862E','保存',2)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('091D7D24-E706-465A-95FD-8EF359CB8667','集团下发监督检查报告','ZHGL/ServerCheck/CheckInfoReport.aspx',40,'DEAA1931-C0D7-4277-9B34-23963D1C538A','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
--安全会议
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('BFFBE172-7473-486E-9833-49F13B359C6C','安全会议','',60,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B911B4F8-DDFD-4F37-9EAC-EB104F753432','企业安委会','ZHGL/Meeting/CompanySafetyMeeting.aspx',10,'BFFBE172-7473-486E-9833-49F13B359C6C','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('27DD0084-A559-4723-90B9-5F68DF3B61C4','B911B4F8-DDFD-4F37-9EAC-EB104F753432','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1F841CFB-1AFC-4C9C-A56F-681E407B52F9','B911B4F8-DDFD-4F37-9EAC-EB104F753432','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('60142F0A-3362-4264-876C-F27FFB533891','B911B4F8-DDFD-4F37-9EAC-EB104F753432','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('05901FC0-D482-442D-9764-7DE5EA4ED991','B911B4F8-DDFD-4F37-9EAC-EB104F753432','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('2497EF13-C052-4228-B388-EBC5C18963BC','企业专题会','ZHGL/Meeting/CompanySpecialMeeting.aspx',20,'BFFBE172-7473-486E-9833-49F13B359C6C','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('58BC6E5C-E45F-47A2-A7FC-D02F91DEF058','2497EF13-C052-4228-B388-EBC5C18963BC','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('92627BA3-A14A-4886-805E-038324E9747A','2497EF13-C052-4228-B388-EBC5C18963BC','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('395E1B2B-AF35-4867-A8F0-E471FB10C25D','2497EF13-C052-4228-B388-EBC5C18963BC','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1DF4AADF-2207-4A9E-83D0-8899E21E91BA','2497EF13-C052-4228-B388-EBC5C18963BC','保存',4)
|
|
GO
|
|
|
|
--职业健康
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('E0A00DAC-2276-4AC5-B67B-60887C91DD62','职业健康','',70,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D4802FF6-0AE0-4F9B-9D69-FD895CF9F5C0','危害检测','ZHGL/OccupationHealth/HazardDetection.aspx',10,'E0A00DAC-2276-4AC5-B67B-60887C91DD62','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DB06084F-742F-49F1-A9B9-1100919E49DB','体检管理','ZHGL/OccupationHealth/PhysicalExamination.aspx',20,'E0A00DAC-2276-4AC5-B67B-60887C91DD62','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('52DA3277-DCC1-4612-8083-A576BF85953A','职业病事故','ZHGL/OccupationHealth/OccupationalDiseaseAccident.aspx',30,'E0A00DAC-2276-4AC5-B67B-60887C91DD62','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
|
|
--环境保护
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B441D5ED-DA97-4E2B-98C1-6E8E5D08EF7B','环境保护','',80,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('FD4E234C-265F-4B45-A35A-C9659AF9C173','环境监测数据','ZHGL/Environmental/EnvironmentalMonitoring.aspx',10,'B441D5ED-DA97-4E2B-98C1-6E8E5D08EF7B','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('6C36DBFF-E765-4FC9-B978-51ADBE696C10','突发环境事件','ZHGL/Environmental/UnexpectedEnvironmental.aspx',20,'B441D5ED-DA97-4E2B-98C1-6E8E5D08EF7B','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('6A8EAA9C-08E9-4F1F-B824-67B60D49258A','环境事件应急预案','ZHGL/Environmental/EnvironmentalEmergencyPlan.aspx',30,'B441D5ED-DA97-4E2B-98C1-6E8E5D08EF7B','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('FB943BD9-33A5-4680-82C1-29A4741D8636','环评报告','ZHGL/Environmental/EIAReport.aspx',40,'B441D5ED-DA97-4E2B-98C1-6E8E5D08EF7B','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
--安全事故
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('192147D8-FFD1-44BD-8BC4-9DCA3E73D708','安全事故','',90,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DC871FCA-FBA8-4533-B5D6-DF64BCE40287','事故快报','ZHGL/ProjectAccident/AccidentReport.aspx',10,'192147D8-FFD1-44BD-8BC4-9DCA3E73D708','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('909965F2-74EB-459C-9CED-048B1E7209E2','DC871FCA-FBA8-4533-B5D6-DF64BCE40287','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7F2A59B1-D432-4020-93B3-4A2DCB14AB94','DC871FCA-FBA8-4533-B5D6-DF64BCE40287','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CD262F07-6DE4-4483-BC18-35AE4E510EC6','DC871FCA-FBA8-4533-B5D6-DF64BCE40287','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E408C483-28D2-4C28-90B5-ACC5714BEE12','DC871FCA-FBA8-4533-B5D6-DF64BCE40287','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('BE2F6161-7C17-41FF-A314-8C0AE323D5A4','事故处理','ZHGL/ProjectAccident/AccidentStatistics.aspx',20,'192147D8-FFD1-44BD-8BC4-9DCA3E73D708','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('35BE5ECC-1C60-443A-A4CF-D50DE1AEF6A9','BE2F6161-7C17-41FF-A314-8C0AE323D5A4','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('79EF2D71-10C5-431D-B32C-E2B763499DE2','BE2F6161-7C17-41FF-A314-8C0AE323D5A4','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('8546C60C-7F22-444D-9E7E-6B43041A7506','BE2F6161-7C17-41FF-A314-8C0AE323D5A4','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F6A09314-E743-4BE2-9AF7-D392F453D32D','BE2F6161-7C17-41FF-A314-8C0AE323D5A4','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('71A5556F-1590-4D4C-9A31-703DCD5C2910','事故统计','ZHGL/ProjectAccident/AccidentAnalysis.aspx',30,'192147D8-FFD1-44BD-8BC4-9DCA3E73D708','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F8C602CA-9C88-454C-9911-9EABCD07263E','71A5556F-1590-4D4C-9A31-703DCD5C2910','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('876AC7CB-B33C-4E2F-A1D0-24056FAA0CC6','71A5556F-1590-4D4C-9A31-703DCD5C2910','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A7E8F8B4-501F-4567-B52D-E8A98B7202C6','71A5556F-1590-4D4C-9A31-703DCD5C2910','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AFCAAAF4-60F8-4E27-AFAC-D41D7B9A714D','71A5556F-1590-4D4C-9A31-703DCD5C2910','保存',4)
|
|
GO
|
|
|
|
--本部安全事故子菜单
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('6F2C0F0A-3CF6-4B28-AFE2-FB7415ECDB91','事故台账','ZHGL/ProjectAccident/AccidentData.aspx',40,'192147D8-FFD1-44BD-8BC4-9DCA3E73D708','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DFBD3C31-5742-402E-8FE8-07DF2B6AFB63','6F2C0F0A-3CF6-4B28-AFE2-FB7415ECDB91','删除',1)
|
|
GO
|
|
|
|
--信息管理 ：通知、项目图片
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3CF6CF02-6994-4D90-9061-E4D837AA5FDA','信息管理','',100,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('278DF0FE-35E2-470F-9AE4-23C57EDF797F','项目图片','ZHGL/InformationProject/Picture.aspx',20,'3CF6CF02-6994-4D90-9061-E4D837AA5FDA','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
--文件柜 ：项目资料、集团检查资料
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C4BD5635-39BC-4DE8-85CF-652B2C33CBB4','文件柜','',110,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('6621CF4A-EAD4-40AF-9FFE-51DA4348C10C','文件柜A(检查类)','ZHGL/InformationProject/FileCabinetA.aspx',10,'C4BD5635-39BC-4DE8-85CF-652B2C33CBB4','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DDD1CE30-F8B9-4011-A20F-7AC60B34788C','文件柜B(内业)','ZHGL/InformationProject/FileCabinetB.aspx',20,'C4BD5635-39BC-4DE8-85CF-652B2C33CBB4','Menu_ZHGL',1,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D78C6E54-4240-4E82-B9B5-8ED76CF62981','劳务实名制对接','',120,'0','Menu_ZHGL',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1E451E0C-A125-4117-B8AC-14E74011B52B','同步设置','ZHGL/RealName/SynchroSet.aspx',10,'D78C6E54-4240-4E82-B9B5-8ED76CF62981','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2FCB1DAC-E572-44F7-BD81-568CC33D2F80','1E451E0C-A125-4117-B8AC-14E74011B52B','保存',1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C0B52610-ED93-4881-AC61-1764C243F84A','基础数据','ZHGL/RealName/BasicData.aspx',20,'D78C6E54-4240-4E82-B9B5-8ED76CF62981','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2895D298-1283-4C45-B830-BA5CD3DC467D','C0B52610-ED93-4881-AC61-1764C243F84A','保存',1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F36E6C54-E39F-4032-874D-548EE090A35B','同步记录','ZHGL/RealName/SynchroRecord.aspx',30,'D78C6E54-4240-4E82-B9B5-8ED76CF62981','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4882C5F0-9D49-4B2E-BA30-E806D3CDF6FA','离岗人员修正','ZHGL/RealName/LeavePost.aspx',40,'D78C6E54-4240-4E82-B9B5-8ED76CF62981','Menu_ZHGL',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('214A1AE1-816E-4DDA-8E6E-04EB35F02A12','在岗人员','ZHGL/RealName/OnPost.aspx',50,'D78C6E54-4240-4E82-B9B5-8ED76CF62981','Menu_ZHGL',1,1,1)
|
|
GO
|
|
----本部综合管理
|
|
--INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
--VALUES('A57CBE1D-B9F4-4FB6-A428-10197734AAB6','数据统计','',30,'0','Menu_ZHGL',1,0,1)
|
|
--INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
--VALUES('BFBFCFB4-0716-4E55-931F-153EDA4D7141','安全检查统计','ZHGL/DataStatistics/CheckStatistics.aspx',10,'A57CBE1D-B9F4-4FB6-A428-10197734AAB6','Menu_ZHGL',1,1,1)
|
|
--INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
--VALUES('2D79CBCF-20A6-4146-B832-58368315FC96','隐患整改统计','ZHGL/DataStatistics/RectifyNoticesStatistics.aspx',20,'A57CBE1D-B9F4-4FB6-A428-10197734AAB6','Menu_ZHGL',1,1,1)
|
|
--INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
--VALUES('69EEFFAB-166E-4419-A334-E53EDFE7D9D7','安全会议统计','ZHGL/DataStatistics/MeetStatistics.aspx',30,'A57CBE1D-B9F4-4FB6-A428-10197734AAB6','Menu_ZHGL',1,1,1)
|
|
--GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3BBFCD70-D7A3-435C-9571-DD499D5ED7B8','应急信息','',120,'0','Menu_ZHGL',0,0,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D12C2412-E12A-4F78-9AEF-1EE8AC84A561','应急预案管理清单','ZHGL/Emergency/EmergencyList.aspx',10,'3BBFCD70-D7A3-435C-9571-DD499D5ED7B8','Menu_ZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('4A638D22-1515-4967-B149-8362F81E3A95','D12C2412-E12A-4F78-9AEF-1EE8AC84A561','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('11F44E2B-F3EB-4189-B324-69DB226CF39B','D12C2412-E12A-4F78-9AEF-1EE8AC84A561','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('826C9DEB-7A48-4B70-9312-FC5D0D5D2555','D12C2412-E12A-4F78-9AEF-1EE8AC84A561','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C4A17D4C-25A7-4F37-B6CF-F07526AECBC2','D12C2412-E12A-4F78-9AEF-1EE8AC84A561','保存',4)
|
|
GO
|
|
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('172F25E0-F5E2-42E3-AD67-AC824D4E0FBB','应急演练开展情况','ZHGL/Emergency/DrillRecordList.aspx',20,'3BBFCD70-D7A3-435C-9571-DD499D5ED7B8','Menu_ZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9F63FB64-5F34-4CD4-B266-59F6E8FF4FA5','172F25E0-F5E2-42E3-AD67-AC824D4E0FBB','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2193449B-4C40-49DA-9C23-82A94126AE05','172F25E0-F5E2-42E3-AD67-AC824D4E0FBB','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7C866795-2E56-47CD-B937-C468C46DB007','172F25E0-F5E2-42E3-AD67-AC824D4E0FBB','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('27E0EE6E-D96F-4300-9574-423F378D79C4','172F25E0-F5E2-42E3-AD67-AC824D4E0FBB','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('53D8CED2-9AA7-43EA-B27D-EA10A06DF713','开车人员绩效管理','',160,'0','Menu_ZHGL',0,0,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('383290E0-60AE-4D16-8B5E-3899B85EC2ED','开车绩效评分标准','ZHGL/TestRunPerformance/TestRunPerformanceStandard.aspx',10,'53D8CED2-9AA7-43EA-B27D-EA10A06DF713','Menu_ZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('988B984C-8B74-4D15-B0A7-3A00776984FB','383290E0-60AE-4D16-8B5E-3899B85EC2ED','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B4923645-FCBE-4670-8F27-C85B8FE4C48F','383290E0-60AE-4D16-8B5E-3899B85EC2ED','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('5D005176-CE4C-4CDF-8720-505A8BB273F7','383290E0-60AE-4D16-8B5E-3899B85EC2ED','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A14DE61A-2E1B-4F4D-84E8-D87DBB2C5F4D','383290E0-60AE-4D16-8B5E-3899B85EC2ED','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C1240FCB-4C72-445E-82B5-EBFAA87D0AC6','开车人员月绩效报告','ZHGL/TestRunPerformance/TestRunPerformanceMonthReport.aspx',20,'53D8CED2-9AA7-43EA-B27D-EA10A06DF713','Menu_ZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('05767250-EF45-4C24-8E19-E887E9267F48','C1240FCB-4C72-445E-82B5-EBFAA87D0AC6','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('5A13E8B5-7932-4922-8DD8-0F85B3A30F13','C1240FCB-4C72-445E-82B5-EBFAA87D0AC6','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3C844A2A-0C2D-482C-90B7-1C94B5C76F92','C1240FCB-4C72-445E-82B5-EBFAA87D0AC6','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EF60AF57-C14D-47C7-87E9-F9182B1C2D6A','C1240FCB-4C72-445E-82B5-EBFAA87D0AC6','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('0C6BB051-6BD1-4E35-90CE-9376F3C2D454','开车人员月技术总结','ZHGL/TestRunPerformance/TestRunMonthSummaryReport.aspx',30,'53D8CED2-9AA7-43EA-B27D-EA10A06DF713','Menu_ZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2560BCB3-F7E5-4D11-97A3-14D70849FC0D','0C6BB051-6BD1-4E35-90CE-9376F3C2D454','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F5E5667D-B48D-44E7-8C5D-9ACADD5BFF50','0C6BB051-6BD1-4E35-90CE-9376F3C2D454','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6C9CF7C9-54FC-41E7-A2E2-71BE01675B13','0C6BB051-6BD1-4E35-90CE-9376F3C2D454','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('76A70721-DA8D-45BB-91B4-4DE3FC22CE2E','0C6BB051-6BD1-4E35-90CE-9376F3C2D454','保存',4)
|
|
GO
|