zhanghj
/
ChengDa_English
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
ChengDa_English/DataBase/InitData_(OLD).sql

1031 lines
71 KiB
Transact-SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

--初始化系统管理员账户
INSERT INTO dbo.Sys_User(UserId,Account,[Password],UserName,IsPost)
VALUES ('AF17168B-87BD-4GLY-1111-F0A0A1158F9B','sysgly',
'B59C67BF196A4758191E42F76670CEBA','系统管理员',1)
GO
--公共临时账户
INSERT INTO dbo.Sys_User(UserId,Account,[Password],UserName,IsPost,UnitId)
VALUES ('A8547452-751F-41B7-8E4B-5862EA4E9411','sedin','202CB962AC59075B964B07152D234B70','公共账号',1,'d72a27c9-4ba9-41c5-ab0b-c010409f20f2')
GO
/************************************v一级菜单，及其下的子菜单***********************/
--安全合规
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('FDVXFGDS-5THM-CCDE-DCS2-TGHNO48F7UKM','安全合规','',10,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('F4B02718-0616-4623-ABCE-885698DDBEB1','安全法律法规','Law/LawRegulationList.aspx',10,'FDVXFGDS-5THM-CCDE-DCS2-TGHNO48F7UKM')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7F244336-348F-469F-AF23-ED6768821119','F4B02718-0616-4623-ABCE-885698DDBEB1','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('805DDE79-CEAB-4517-99F4-8D9B3314A52A','F4B02718-0616-4623-ABCE-885698DDBEB1','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4A0F39F4-1944-4073-BB85-266F4B02177F','F4B02718-0616-4623-ABCE-885698DDBEB1','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CBD3064D-33EF-407F-9E16-C673357655F3','F4B02718-0616-4623-ABCE-885698DDBEB1','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('81E43E18-F69E-4691-8FAB-7F7212925997','F4B02718-0616-4623-ABCE-885698DDBEB1','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CE782A12-96A4-4266-A746-218DD783483F','F4B02718-0616-4623-ABCE-885698DDBEB1','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DC755DFE-592A-4F98-88D2-9CB1F3EECB6E','F4B02718-0616-4623-ABCE-885698DDBEB1','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8CD66895-29D4-4ACE-A29F-3B62D11DC785','F4B02718-0616-4623-ABCE-885698DDBEB1','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','安全标准规范','Law/HSSEStandardList.aspx',20,'FDVXFGDS-5THM-CCDE-DCS2-TGHNO48F7UKM')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('FCA3B862-2B93-49DE-9319-ED65AE19542D','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5E16BBE6-E4E7-4F30-B90C-2953FBD9CF32','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A618BFC3-CC3B-4D84-BF73-FE34D5CFDD5A','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9B6B4CA2-792C-48CA-89C4-0E79FFF8CD5F','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('50284667-5F9A-47E2-AF4A-B315F413F72F','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('FA6E3B5B-2036-4C2F-AD72-9E3EB8E70B20','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5314D7A3-3D41-495D-A62A-FBC558197D8F','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A3C2EBB2-4174-45E4-B62F-4276C09FE512','EFDSFVDE-RTHN-7UMG-4THA-5TGED48F8IOL','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('DF1413F3-4CE5-40B3-A574-E01CE64FEA25','政府部门安全规章','Law/RulesRegulations.aspx',30,'FDVXFGDS-5THM-CCDE-DCS2-TGHNO48F7UKM')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DC57A24D-5749-464B-941B-5922A3FEC823','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D727320A-FD3E-442A-A4A6-D3B7060A72C2','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('74B62D73-E985-4899-A045-216CA83C7DBA','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2C3E968B-4A35-4D33-B931-B16D3C8315E7','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('768DFD4F-B955-4D0E-8B8D-4815DEDA8239','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','上传资源',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('427E3B6A-5A3D-43F9-B8BC-58B43E4836A0','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','保存并上报',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D871BFB8-38C1-47CF-9CED-B441F07FE0D1','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5D0C52D3-404C-4FAB-8577-4E2F410FE5DA','DF1413F3-4CE5-40B3-A574-E01CE64FEA25','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('56960940-81A8-43D1-9565-C306EC7AFD12','安全管理规定','Law/ManageRule.aspx',40,'FDVXFGDS-5THM-CCDE-DCS2-TGHNO48F7UKM')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('120CF71E-ADE4-431D-9B60-19708CB7437D','56960940-81A8-43D1-9565-C306EC7AFD12','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('15E81BA7-C256-4CF6-9962-F4BDD8755E9E','56960940-81A8-43D1-9565-C306EC7AFD12','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8AB2E341-83A4-40A8-A766-E5EC2C35A396','56960940-81A8-43D1-9565-C306EC7AFD12','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0016B7C1-D472-4E3C-BA07-D99189C2BA39','56960940-81A8-43D1-9565-C306EC7AFD12','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('EFBA4E8A-A519-4FC0-A22D-E253D749688F','56960940-81A8-43D1-9565-C306EC7AFD12','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('F401B953-9CE2-4592-934D-C9D4E8E1EEE2','56960940-81A8-43D1-9565-C306EC7AFD12','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B744E503-7624-40F1-B176-69B43281FA11','56960940-81A8-43D1-9565-C306EC7AFD12','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B4FAB0DF-C50B-4C57-85B3-7AD91F4654E4','56960940-81A8-43D1-9565-C306EC7AFD12','导出',8)
--4.安全体系
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','安全体系','',20,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','安全组织体系','HSSESystem/HSSEOrganize.aspx',10,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('F2A62F79-1DE3-45A1-968A-8F4E3A4B86F5','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C94F1D8C-6136-4537-B292-D24B5576BE78','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CAFE85FE-3E1C-4085-B712-3B5472C5AC1B','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D8753465-5A46-43D0-9DB0-8EB3CF428160','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('32F5CC8C-E0F4-456C-AB88-77E36269FA50','安全管理机构','HSSESystem/HSSEManage.aspx',20,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('80C2E451-230E-4745-9181-57110932CC5B','32F5CC8C-E0F4-456C-AB88-77E36269FA50','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1EA5718F-1F20-450F-9DE4-CCE15FA6449D','32F5CC8C-E0F4-456C-AB88-77E36269FA50','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8EF9CA97-59D8-45C9-8B80-DD18C12CD3C2','32F5CC8C-E0F4-456C-AB88-77E36269FA50','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('475C9311-B934-4FB7-9748-1689D46DDF01','32F5CC8C-E0F4-456C-AB88-77E36269FA50','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','安全主体责任','HSSESystem/HSSEMainDuty.aspx',30,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('73BEE65F-3468-425E-9F5A-F84485CAA4D5','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E597E5C5-FCA3-4EAF-9369-323D3A674002','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C361F7CC-08B8-4BE0-9427-6C31C9E66F91','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('17BAD7BE-802B-49F2-B1CE-B96C216DA369','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','保存',4)
--5.安全教育
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('E26D223B-4CA2-4A6D-82D0-224CC9C8676D','安全教育','',30,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('9D99A981-7380-4085-84FA-8C3B1AFA6202','培训教材库','EduTrain/TrainDB.aspx',10,'E26D223B-4CA2-4A6D-82D0-224CC9C8676D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5A41DAD8-B2C6-4610-95D7-A8B176200F5B','9D99A981-7380-4085-84FA-8C3B1AFA6202','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7EE19F24-F601-4FF4-9A2F-3322F24D71DB','9D99A981-7380-4085-84FA-8C3B1AFA6202','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('34650B63-6A3A-4459-A9A6-0E484C1249BE','9D99A981-7380-4085-84FA-8C3B1AFA6202','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('58199BA4-0E11-486E-9B4B-4AD7FD1AE126','9D99A981-7380-4085-84FA-8C3B1AFA6202','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('551A32B1-4857-443F-B34C-9A2E79BD830C','9D99A981-7380-4085-84FA-8C3B1AFA6202','上传资源',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0838D65D-77B8-49E1-BB62-D2A740956EE9','9D99A981-7380-4085-84FA-8C3B1AFA6202','审核',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C6897F44-C261-47E6-B831-785D886DF88A','9D99A981-7380-4085-84FA-8C3B1AFA6202','导出',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('31D862E7-95AB-4FF7-ABF4-5C0F38CC3C69','9D99A981-7380-4085-84FA-8C3B1AFA6202','保存并上报',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','安全试题库','EduTrain/TrainTestDB.aspx',20,'E26D223B-4CA2-4A6D-82D0-224CC9C8676D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7A670B04-B2D5-4943-88F6-9C87B2838EAC','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('6A71170F-43FE-447B-9144-A40742DED4F9','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('3F66D20D-2F2E-47F1-A8D7-DC5FAB932FCD','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A91D76BF-AAC2-4CAA-8787-3E3A9C1D89D2','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8118EBF6-9385-492D-9143-C10AFF1ADE2A','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('EE8F534B-C645-41FE-BD9D-192643210F0C','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('370D217D-9E21-402D-989F-F17030730A72','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2B138B36-7EB8-4249-BBE6-B7AF5003C878','F58EE8ED-9EB5-47C7-9D7F-D751EFEA44CA','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('D86917DB-D00A-4E18-9793-C290B5BBA84C','事故案例库','EduTrain/AccidentCase.aspx',30,'E26D223B-4CA2-4A6D-82D0-224CC9C8676D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4CB28816-E27D-4196-B9A9-608DADCFD041','D86917DB-D00A-4E18-9793-C290B5BBA84C','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('134F8DF9-3540-46B7-B92E-74882E00A12E','D86917DB-D00A-4E18-9793-C290B5BBA84C','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('615B7022-6DFE-452A-82A3-84D9B3355782','D86917DB-D00A-4E18-9793-C290B5BBA84C','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A31B6309-D844-4AA0-AFC0-6A5DB5326008','D86917DB-D00A-4E18-9793-C290B5BBA84C','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8F8075CF-0B95-4400-A265-F1B131D56F00','D86917DB-D00A-4E18-9793-C290B5BBA84C','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('F3706286-8DE3-44D2-A2C1-B97988510EA5','D86917DB-D00A-4E18-9793-C290B5BBA84C','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('743A0399-55D3-412F-8ABB-40D2F362177E','D86917DB-D00A-4E18-9793-C290B5BBA84C','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E8CE61E9-1C90-472B-8120-CFF0E0411321','D86917DB-D00A-4E18-9793-C290B5BBA84C','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('AB7A3D78-2D89-4488-97E3-8F8616BDDE30','应知应会库','EduTrain/KnowledgeDB.aspx',40,'E26D223B-4CA2-4A6D-82D0-224CC9C8676D')
GO
--EduTrain/OnlineCheck.aspx
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('77813713-90A4-493D-92E6-19309B3468C1','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A2102C03-A35C-4290-AF4C-F21DF3F9E494','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2B17D09C-B8BB-485B-BA5D-35174A3269D5','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('266C798E-F1DF-4E3E-8BE6-29D302BBE8E5','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0A2ADB54-CA32-4CA0-A2D4-AC562C9E161F','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('884E9CB6-A39A-4203-928F-02067E63BC21','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7A226554-8E73-44F6-802E-772BFBF528F1','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8B9940AC-F594-4A70-82BF-68B753E04583','AB7A3D78-2D89-4488-97E3-8F8616BDDE30','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('D1A8637F-D2D2-40D9-89A6-10C428D0C90E','在线学习考核','',50,'E26D223B-4CA2-4A6D-82D0-224CC9C8676D')
GO
/*在线学习考核*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('C7454B8C-017F-4C8A-B9C7-D9D2F46F3CB1','试题库维护','OnlineCheck/TestDB.aspx',10,'D1A8637F-D2D2-40D9-89A6-10C428D0C90E')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('87C9E315-79AF-4D8B-8DA9-23748FAA5284','C7454B8C-017F-4C8A-B9C7-D9D2F46F3CB1','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1AFD2021-E891-4BD3-8BD3-8FC6045EA183','C7454B8C-017F-4C8A-B9C7-D9D2F46F3CB1','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4BF74F31-691B-4F0D-B06D-0DEB6BE6529E','C7454B8C-017F-4C8A-B9C7-D9D2F46F3CB1','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('87AC4A17-2379-41E0-9E4A-F1CF1B64AB1D','C7454B8C-017F-4C8A-B9C7-D9D2F46F3CB1','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('86E75631-BB9B-432E-BE5C-0F8C7C58BDE3','生成试卷','OnlineCheck/BuildTest.aspx',20,'D1A8637F-D2D2-40D9-89A6-10C428D0C90E')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('58CA97A8-EE73-4514-B38C-90A5D03DFE2C','86E75631-BB9B-432E-BE5C-0F8C7C58BDE3','保存',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1DA64DAB-0E80-4450-B255-5FC751096E54','86E75631-BB9B-432E-BE5C-0F8C7C58BDE3','生成',2)--新加
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4E840224-3DAE-474A-9BCB-BE1FF06728D6','86E75631-BB9B-432E-BE5C-0F8C7C58BDE3','删除',3)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('F62D1C56-8FB0-480D-9702-84B168D0A89F','查看试卷','OnlineCheck/SeeTest.aspx',30,'D1A8637F-D2D2-40D9-89A6-10C428D0C90E')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CDD69197-5597-40DB-85F1-84A9E1774D68','F62D1C56-8FB0-480D-9702-84B168D0A89F','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('8787A0B6-9F9B-40A6-B122-E8A8287A84B9','考生信息设置及查询','OnlineCheck/Examinee.aspx',40,'D1A8637F-D2D2-40D9-89A6-10C428D0C90E')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('52418FE4-E5F8-4A75-8257-70F2DBEFEA86','8787A0B6-9F9B-40A6-B122-E8A8287A84B9','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('3AE8D77D-38C6-4DD5-892F-EF15F8D2E6EA','8787A0B6-9F9B-40A6-B122-E8A8287A84B9','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('75BED9B6-7FC0-4621-85DD-1EDD9E8AA242','8787A0B6-9F9B-40A6-B122-E8A8287A84B9','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C78BC726-0349-4542-AD8F-888150541B1A','8787A0B6-9F9B-40A6-B122-E8A8287A84B9','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('C91CD0C5-6609-40BD-B5E6-C2DF148B198B','考试系统','OnlineCheck/TestSystem.aspx',50,'D1A8637F-D2D2-40D9-89A6-10C428D0C90E')
GO
--6.安全技术
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('F3B157B7-9BEE-4150-80CB-087828F1C51D','安全技术','',40,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('66A76F90-96A7-4C1F-B8D9-125DDEACEF52','危险源清单','Technique/HazardList.aspx',10,'F3B157B7-9BEE-4150-80CB-087828F1C51D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D6918A64-BEEB-4748-9742-A1A9C0247131','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7C052092-64B4-44EF-B989-EA6DAE0FE304','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('75A17A4F-1077-48E0-9B5D-7E074FD9889E','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('58459B97-2412-4CBB-A573-1B7B4BF2B577','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('31C8B71D-61B4-4619-8A34-FC0BDA550937','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1EA4AA17-D529-4070-B417-EEB96B362DBA','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('AFC0CED0-120C-443C-877B-65C915808600','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A450346A-D131-4BC3-9AA2-E859B4D0AE89','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('88CDDC68-54DE-4E24-9524-A33B80EC0E12','安全隐患','Technique/Rectify.aspx',20,'F3B157B7-9BEE-4150-80CB-087828F1C51D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('88CDDC68-54DE-4E24-9524-A33B80EC0E12','88CDDC68-54DE-4E24-9524-A33B80EC0E12','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0DF5880A-D520-4C3D-B2AC-4065866A31CB','88CDDC68-54DE-4E24-9524-A33B80EC0E12','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B1DDA059-6EEF-4C64-991A-50AA90DCE7E7','88CDDC68-54DE-4E24-9524-A33B80EC0E12','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('377DE1CE-EACE-410D-8F57-062785D87BBD','88CDDC68-54DE-4E24-9524-A33B80EC0E12','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2652CD41-F74E-402B-B81E-90FAE8517E6B','88CDDC68-54DE-4E24-9524-A33B80EC0E12','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('772A2D34-1547-4926-9FA7-CA68DB5794B9','88CDDC68-54DE-4E24-9524-A33B80EC0E12','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4FDF346F-0F35-45BE-A055-03343670CFF7','88CDDC68-54DE-4E24-9524-A33B80EC0E12','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0B58F41A-D81A-4F32-8714-E8507CA10CF2','88CDDC68-54DE-4E24-9524-A33B80EC0E12','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('41C22E63-36B7-4C44-89EC-F765BFBB7C55','HAZOP管理','Technique/HAZOP.aspx',30,'F3B157B7-9BEE-4150-80CB-087828F1C51D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7F25E0C2-7F37-4358-AFED-C78F1C0109DC','41C22E63-36B7-4C44-89EC-F765BFBB7C55','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B3B0AD56-BBD7-4E06-A3A5-4FCA3D3470BF','41C22E63-36B7-4C44-89EC-F765BFBB7C55','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CAB1DC01-346A-4674-8FED-83129AA600A6','41C22E63-36B7-4C44-89EC-F765BFBB7C55','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4A53B753-5FBF-4943-B74E-72840E3E24A5','41C22E63-36B7-4C44-89EC-F765BFBB7C55','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0EE214B5-645D-4212-BFBC-BC2E1E63F405','41C22E63-36B7-4C44-89EC-F765BFBB7C55','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('214CEB1A-192F-4484-AB1F-5C08639EBE0F','41C22E63-36B7-4C44-89EC-F765BFBB7C55','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0E59EDAE-0BEF-4E2D-8618-6675D71B5C76','41C22E63-36B7-4C44-89EC-F765BFBB7C55','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('97F1D6BF-7F80-4E46-80FD-02C84117BE33','41C22E63-36B7-4C44-89EC-F765BFBB7C55','导出',8)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('0ADD01FB-8088-4595-BB40-6A73F332A229','安全评价','Technique/Appraise.aspx',40,'F3B157B7-9BEE-4150-80CB-087828F1C51D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('F458B50F-7923-4DED-BAAA-328C755F9CFF','0ADD01FB-8088-4595-BB40-6A73F332A229','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('756A5147-B861-4C90-99A6-AE01E12572FE','0ADD01FB-8088-4595-BB40-6A73F332A229','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('36232942-6D57-4A92-AC67-86F8A34E10CC','0ADD01FB-8088-4595-BB40-6A73F332A229','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E0EFBAC8-94E3-42B4-ADD2-B7F48D47E74C','0ADD01FB-8088-4595-BB40-6A73F332A229','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DAA6AC3E-9F9B-479F-9B60-E2F67896FAA1','0ADD01FB-8088-4595-BB40-6A73F332A229','保存并上报',5)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('05495F29-B583-43D9-89D3-3384D6783A3F','安全专家','Technique/Expert.aspx',50,'F3B157B7-9BEE-4150-80CB-087828F1C51D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('832B0976-C17A-493A-9E84-25615B2EE008','05495F29-B583-43D9-89D3-3384D6783A3F','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A4A6610B-C9DB-451A-9B31-F95D5DA2CEB7','05495F29-B583-43D9-89D3-3384D6783A3F','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('21F5CBD0-B55C-4B79-89E9-90CF84B0E8C2','05495F29-B583-43D9-89D3-3384D6783A3F','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1B65B7FB-5FA1-4891-9B94-9E7D0CC964AF','05495F29-B583-43D9-89D3-3384D6783A3F','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5D3BD0DA-EFF0-42B3-9B91-ADCEC6E927E8','05495F29-B583-43D9-89D3-3384D6783A3F','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8122ABE1-0835-4797-8583-A2E9CE18344C','05495F29-B583-43D9-89D3-3384D6783A3F','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9F975337-A6D2-47E6-B72E-93ED565409A3','05495F29-B583-43D9-89D3-3384D6783A3F','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('93AD2E2F-B94E-4F69-8E96-5C46BF858654','05495F29-B583-43D9-89D3-3384D6783A3F','导出',8)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('575C5154-A135-4737-8682-A129EA717660','应急预案','Technique/Emergency.aspx',60,'F3B157B7-9BEE-4150-80CB-087828F1C51D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DE6D2AD7-146A-408B-9D8C-42FFC4D993FA','575C5154-A135-4737-8682-A129EA717660','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1E416B6D-F69D-4668-9A7F-59D080A9982C','575C5154-A135-4737-8682-A129EA717660','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('12F3B6DB-1806-42FB-9682-103CF70F5AF9','575C5154-A135-4737-8682-A129EA717660','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('595A0962-CB1D-4C41-81B0-46CEFE575556','575C5154-A135-4737-8682-A129EA717660','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('78607DB7-5C87-4729-888B-C3A0ED9051E7','575C5154-A135-4737-8682-A129EA717660','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C69A1015-B4F0-44A7-A2B1-F2CDFD2B2387','575C5154-A135-4737-8682-A129EA717660','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A7FD759C-FA97-4A9B-ACE5-A2688A87CC11','575C5154-A135-4737-8682-A129EA717660','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('03519B1C-AEB5-4191-8DB9-A19A37A5C813','575C5154-A135-4737-8682-A129EA717660','导出',8)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('3E2F2FFD-ED2E-4914-8370-D97A68398814','施工方案','Technique/SpecialScheme.aspx',70,'F3B157B7-9BEE-4150-80CB-087828F1C51D')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2A46E6E9-159D-4CED-B05D-F85180D513D8','3E2F2FFD-ED2E-4914-8370-D97A68398814','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E94AE1AC-BEB5-4579-9DE4-88EB6F1970EA','3E2F2FFD-ED2E-4914-8370-D97A68398814','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8EF6C9C3-DA8D-442E-9A68-156414980DE3','3E2F2FFD-ED2E-4914-8370-D97A68398814','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BAF726AC-EB4D-4EDC-A8A8-90D78E6416CB','3E2F2FFD-ED2E-4914-8370-D97A68398814','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('564304AA-3CBE-4A4E-BE52-97FE83DE1B5E','3E2F2FFD-ED2E-4914-8370-D97A68398814','保存并上报',5)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BADA0C61-E40D-4284-BFA0-399AFE7C35F4','3E2F2FFD-ED2E-4914-8370-D97A68398814','上传资源',6)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D0F0FB64-3B45-4945-AB0B-33CCC1AE73A2','3E2F2FFD-ED2E-4914-8370-D97A68398814','审核',7)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B1DFDF65-7C9B-454E-934F-E383438D1FD1','3E2F2FFD-ED2E-4914-8370-D97A68398814','导出',8)
--7.安全监督
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('A24B7926-EF69-456E-8A24-936D30384680','安全监督','',50,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','安全监督检查报告','Supervise/SuperviseCheckReport.aspx',10,'A24B7926-EF69-456E-8A24-936D30384680')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BA4D569B-72C6-4CDF-804A-E4EC0876FBEA','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9366B357-1653-4291-B633-7E17A0C94C8A','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('277FB77A-F77C-40E8-924E-C2EA5EF97472','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('EAC337F8-DEEC-42F0-8534-53B3E78A15AA','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('55976B16-2C33-406E-B514-2FE42D031071','安全监督检查整改','Supervise/SuperviseCheckRectify.aspx',20,'A24B7926-EF69-456E-8A24-936D30384680')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('6C1BE2E8-CD60-413F-94DD-A9FC69B2E21A','55976B16-2C33-406E-B514-2FE42D031071','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D3855716-E792-4009-81C9-802BF8DA70EC','55976B16-2C33-406E-B514-2FE42D031071','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('789372B4-0590-499A-9E1D-368348AB6EBB','55976B16-2C33-406E-B514-2FE42D031071','保存',4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A8C027B4-B0E8-4D97-A8CD-584987224D06','55976B16-2C33-406E-B514-2FE42D031071','保存并上报',5)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('B9950CB5-C47A-4C0A-A6CC-C7DDBBDE7D1E','企业上报监督检查报告','Supervise/UpCheckReport.aspx',25,'A24B7926-EF69-456E-8A24-936D30384680')
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)
VALUES('4A87774E-FEA5-479A-97A3-9BBA09E4862E','集团下发监督检查整改','Check/CheckRectify.aspx',30,'A24B7926-EF69-456E-8A24-936D30384680')
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)
VALUES('091D7D24-E706-465A-95FD-8EF359CB8667','集团下发监督检查报告','Check/CheckInfoReport.aspx',35,'A24B7926-EF69-456E-8A24-936D30384680')
GO
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
--VALUES('24941EDC-CED6-4176-8CCD-EB5F08156D08','安全监督检查分析','Supervise/SuperviseCheckAnalyse.aspx',30,'A24B7926-EF69-456E-8A24-936D30384680')
--GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('3D1CFA31-96A9-496E-9A94-318670C9D658','子公司安全上报','Supervise/SubUnitReport.aspx',40,'A24B7926-EF69-456E-8A24-936D30384680')
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
--8.安全信息
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D','安全信息','',60,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu) --Information/InformationUpFile.aspx
VALUES('ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','安全信息上报','',10,'4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D')
GO
--/*安全信息报表*/
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
--VALUES ('997BFCDB-3B70-4930-A0E2-86C0C886A514','安全生产快报','Information/SafeProductionExpress.aspx',10,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001')
--GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('3156A9F0-276D-4AD4-BF84-45CF6DFC215C','百万工时安全统计月报','Information/MillionsMonthlyReport.aspx',10,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001')
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)
VALUES ('4BC71D2E-7D94-48C1-A61A-139637825AA5','职工伤亡事故原因分析报','Information/AccidentCauseReport.aspx',20,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001')
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)
VALUES ('A3894BAD-3F4A-4BB4-98CF-A76C588AE53F','安全生产数据季报','Information/SafetyQuarterlyReport.aspx',30,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001')
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)
VALUES ('7985C759-8EB9-4B7D-AC65-00541280B46C','应急演练开展情况季报','Information/DrillConductedQuarterlyReport.aspx',40,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001')
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)
VALUES ('70DEB27A-D6FF-4D57-879B-0270F2967FA0','应急演练工作计划半年报','Information/DrillPlanHalfYearReport.aspx',50,'ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001')
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) --Information/InformationAnalyse.aspx
VALUES('C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA','安全信息分析','',20,'4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('598568A0-A338-499F-888C-1B73665837F9','人工时费用分析','Information/AnalyseWorkTimeCost.aspx',10,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8A76D0BB-417C-44C4-B042-5AA74E60738B','598568A0-A338-499F-888C-1B73665837F9','统计',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('8396C9E2-3376-4144-978A-CC6041EC6C6A','安全事故分析','Information/AnalyseSafeAccident.aspx',20,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CC64B935-25EB-41D0-9D8E-D6D97151D2C5','8396C9E2-3376-4144-978A-CC6041EC6C6A','统计',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('5B645281-A055-4AA1-9245-DACBD984C76F','安全隐患分析','Information/AnalyseHiddenDanger.aspx',30,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('ACF63F9B-692D-4610-A8F9-5FDBFEAA2551','5B645281-A055-4AA1-9245-DACBD984C76F','统计',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('195D508D-E929-4B91-891E-307DC4E4338F','资源来源统计','Information/AnalyseResource.aspx',100,'C0F4A4A5-D5D3-4952-9A90-9B27F5FA9DFA')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('3B462DFF-C9BB-4646-92B0-7E8AB52FBC1E','195D508D-E929-4B91-891E-307DC4E4338F','统计',1)
--9.安全交流
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('3EF14145-E349-48B9-BB25-6CA209B485BB','安全交流','',70,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('8FA7237E-DB0C-436C-9BC6-8C3A560EE688','注册管理','Exchange/Register.aspx',10,'3EF14145-E349-48B9-BB25-6CA209B485BB')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('7CCD36CB-6BFE-4FD7-8497-4DACB565298E','内容管理','Exchange/Content.aspx',20,'3EF14145-E349-48B9-BB25-6CA209B485BB')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8C9C4A2C-FEE0-4AD3-92E6-5A5345EC11E8','7CCD36CB-6BFE-4FD7-8497-4DACB565298E','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8AF21B1A-7766-49C9-B24C-CE84BB1F297F','7CCD36CB-6BFE-4FD7-8497-4DACB565298E','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E47B35E8-E753-4D82-85D2-3B04AA4D3C41','7CCD36CB-6BFE-4FD7-8497-4DACB565298E','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('14B4CE5B-B8B2-4880-A850-27CA8AFDF428','7CCD36CB-6BFE-4FD7-8497-4DACB565298E','保存',4)
GO
--10.职业健康管理
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('4105B536-E0E9-4CD3-B0C4-27BB147603FA','职业健康','',80,'0') --HealthManage/HealthManageMain.aspx
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('B255A0C2-3D63-4A25-92F4-FA8F37F22361','危害检测','',10,'4105B536-E0E9-4CD3-B0C4-27BB147603FA') --HealthManage/HealthHarmCheck.aspx
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('28EA8CEC-3D63-4FEB-97C7-F33FBC269ABE','体检管理','',20,'4105B536-E0E9-4CD3-B0C4-27BB147603FA') --HealthManage/MedicalTest.aspx
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('7308FFE7-1C6F-4023-AA8C-0B9F103E289D','职业病事故','',30,'4105B536-E0E9-4CD3-B0C4-27BB147603FA') --HealthManage/OccupationalAccident.aspx
GO
--11.HSSE管理工作报告
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('C2F6D1E1-EC08-4312-87B7-AAA1F2AD8EE5','环境保护','',90,'0') --Environment/EnvironmentMain.aspx
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('15939349-9754-4DCD-8189-30CADFCFB456','环境监测数据','',10,'C2F6D1E1-EC08-4312-87B7-AAA1F2AD8EE5') --Environment/EnvironmentMonitor.aspx
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('9592307F-3DBA-4727-B3E8-FB21F3FC63D6','突发环境事件','',20,'C2F6D1E1-EC08-4312-87B7-AAA1F2AD8EE5') --Environment/EnvironmentEvent.aspx
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('E25E2116-C127-46B4-968E-5580E8F6CCE7','环境事件应急预案','',30,'C2F6D1E1-EC08-4312-87B7-AAA1F2AD8EE5') --Environment/EnvironmentEmergency.aspx
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('9E82AF0F-C64B-4FDA-A5E1-C08057C8D1C1','环评报告','',40,'C2F6D1E1-EC08-4312-87B7-AAA1F2AD8EE5') --Environment/EnvironmentReport.aspx
GO
--12.子公司 专有菜单 --
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('C13F6AB0-6071-4750-AB5E-CBD5FC58F24A','项目督查','',100,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('BC10F225-154D-4A25-86DD-43F781D83859','在线督查','ProjectSupervision/OnLineSupervision.aspx',10,'C13F6AB0-6071-4750-AB5E-CBD5FC58F24A')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('6AB828AE-98B6-4ECF-8794-4BE24DCA3C56','BC10F225-154D-4A25-86DD-43F781D83859','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4CDAADEC-1919-445B-BC8B-0616188FFD5C','BC10F225-154D-4A25-86DD-43F781D83859','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('90A60A04-10AF-4096-9467-6BA7AB2A5D7C','BC10F225-154D-4A25-86DD-43F781D83859','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BDC47E5C-3E27-4725-A7A7-18FC09C017A5','BC10F225-154D-4A25-86DD-43F781D83859','保存',4)
/*绩效评价*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('ACF13D4F-53CC-4F3A-A76D-0B7FB97554A9','绩效评价','',110,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('DEE90726-E00D-462B-A4BF-7E36180DD5B8','绩效评价','ProjectEvaluation/ProjectEvaluation.aspx',10,'ACF13D4F-53CC-4F3A-A76D-0B7FB97554A9')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BD80E37E-C93B-4237-A5C8-01856625638F','DEE90726-E00D-462B-A4BF-7E36180DD5B8','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('FDC3F84E-AA3D-47BD-97FE-6A6D1EE9EBFA','DEE90726-E00D-462B-A4BF-7E36180DD5B8','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('6E1FC020-19F5-461F-B12F-72057671273C','DEE90726-E00D-462B-A4BF-7E36180DD5B8','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('04AB7BF7-C527-45D4-B98D-082F10D25CA0','DEE90726-E00D-462B-A4BF-7E36180DD5B8','保存',4)
/*安全生产事故*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('192147D8-FFD1-44BD-8BC4-9DCA3E73D708','安全事故','',120,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('DC871FCA-FBA8-4533-B5D6-DF64BCE40287','事故快报','ProjectAccident/AccidentReport.aspx',10,'192147D8-FFD1-44BD-8BC4-9DCA3E73D708')
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)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('BE2F6161-7C17-41FF-A314-8C0AE323D5A4','事故处理','ProjectAccident/AccidentStatistics.aspx',20,'192147D8-FFD1-44BD-8BC4-9DCA3E73D708')
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)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('71A5556F-1590-4D4C-9A31-703DCD5C2910','事故统计','ProjectAccident/AccidentAnalysis.aspx',30,'192147D8-FFD1-44BD-8BC4-9DCA3E73D708')
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)
--1.系统设置
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('D1A0F410-09B1-4607-BC6D-865CE48F080F','系统设置','',130,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0002','单位设置','SysManage/Unit.aspx',10,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('31451999-CA49-469D-8E92-508FA7BC2A7E','8IDKGJE2-09B1-4607-BC6D-865CE48F0002','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('854573A7-18BE-41CB-BFBD-16952826EF14','8IDKGJE2-09B1-4607-BC6D-865CE48F0002','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('039D73FD-9BFD-49E3-AB36-1D635FD70AFD','8IDKGJE2-09B1-4607-BC6D-865CE48F0002','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E940FAB0-FA0C-447A-9C83-9F6082074274','8IDKGJE2-09B1-4607-BC6D-865CE48F0002','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','角色管理','SysManage/RoleList.aspx',20,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('70F31237-279D-4C39-A448-285F0B0E0C1C','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('32D49C37-5A14-4B4B-8F3F-BF7CBE0122D5','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9D9B3B9A-4CE4-44B6-92F1-AFBD777B642D','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('ED564170-0875-4F2E-B23D-7B04B2C3A3C4','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','用户信息','SysManage/UserList.aspx',30,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8E95FDBC-1936-4BD6-B442-AADE27F6C1DE','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DB2139E6-7D81-467F-A3E8-A461A4F6F674','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('79702203-7596-4AB8-BD76-5964393813AB','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C744FB32-3437-4C53-90E0-F0AFA20542B0','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('BAB254FA-C879-4463-B9DE-387C241A8623','修改密码','SysManage/UpdatePassword.aspx',40,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('00BCD912-6275-40A2-8CB1-591389118DA9','BAB254FA-C879-4463-B9DE-387C241A8623','编辑',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1F9897F0-0D3A-441A-B62B-7CC4852807C1','BAB254FA-C879-4463-B9DE-387C241A8623','重置',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5554D845-879C-47B7-AD8D-DF0B23D749CC','BAB254FA-C879-4463-B9DE-387C241A8623','保存',3)
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
--VALUES('A20C110D-29ED-488B-9676-06ABDF653AEE','菜单按钮','SysManage/ButtonToMenu.aspx',50,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
--GO
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('0CBCA2B8-04C7-4CC5-B181-59C3C30EA938','A20C110D-29ED-488B-9676-06ABDF653AEE','保存',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('2231022B-3519-42FC-A2E6-1DB9A98039DD','角色授权','SysManage/RolePower.aspx',60,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2F8858BE-1EA0-40AC-ACE1-739D1872FC89','2231022B-3519-42FC-A2E6-1DB9A98039DD','保存',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','系统环境设置','SysManage/SysConstSet.aspx',70,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('E2D59A77-5E9A-4340-8B94-86D04738F907','E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','保存',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('3E208088-31E7-4849-A9A1-FCA64B288EF3','日志管理','SysManage/LogList.aspx',80,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES ('6EDFBE24-9419-4E73-AC2E-CAD30A754A73','数据同步','SysManage/Synchronization.aspx',90,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_Menu (MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('0C67F4A8-1BE7-40BE-9621-B02A28FD13ED','报表设计','ReportPrint/PrintDesigner.aspx',100,'D1A0F410-09B1-4607-BC6D-865CE48F080F')
GO
--2.基础信息
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F080F','基础信息','',140,'0')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('D9F1F0BD-D48F-4C5B-AF26-7F4C561D1352','部门信息','BaseInfo/Depart.aspx',10,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('02709B20-E27A-4737-AB72-C81EB7B8BD7F','D9F1F0BD-D48F-4C5B-AF26-7F4C561D1352','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A27D7ECF-B009-472B-9C84-0E546A30A0D2','D9F1F0BD-D48F-4C5B-AF26-7F4C561D1352','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('14E8F40F-EE65-4A56-843A-C6E01DB4FFA4','D9F1F0BD-D48F-4C5B-AF26-7F4C561D1352','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0AAD0700-4F6D-4E1F-BF49-0F21C83E7CA2','D9F1F0BD-D48F-4C5B-AF26-7F4C561D1352','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('B830399C-CA36-4C23-A170-21E556D052DD','项目信息','BaseInfo/Project.aspx',20,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5133D10A-D667-4FFC-B2D5-83200770F573','B830399C-CA36-4C23-A170-21E556D052DD','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('146A757C-94C1-4EB5-B46C-A59CB431578A','B830399C-CA36-4C23-A170-21E556D052DD','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('F0D8E2D1-0C53-4BDE-A6CB-29BD83B326F3','B830399C-CA36-4C23-A170-21E556D052DD','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('23BDF245-F51F-41DF-8E99-FD55971AD759','B830399C-CA36-4C23-A170-21E556D052DD','保存',4)
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
--VALUES('F0B4F9FE-3F2E-4341-AC8D-06D49B6D4207','单位项目','BaseInfo/UnitProject.aspx',30,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F')
--GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('D4FC3583-31A7-49B3-8F32-007E9756D678','岗位信息','BaseInfo/WorkPost.aspx',30,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('726F714E-46BE-41BB-AC21-0E3970DEFB54','D4FC3583-31A7-49B3-8F32-007E9756D678','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('57BAAC99-FDEA-42E0-B75D-31125FF17D7D','D4FC3583-31A7-49B3-8F32-007E9756D678','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('68EBC18A-D036-4274-96D7-6746833A0ED8','D4FC3583-31A7-49B3-8F32-007E9756D678','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('908C9722-C392-49CE-AC03-754DE53E913C','D4FC3583-31A7-49B3-8F32-007E9756D678','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('84BCDBE8-47D9-40AD-AD42-3256B088FB46','基础类型','',40,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F')
GO
/*基础类型*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('685F1E0D-987E-491C-9DC7-014098DEE0C3','单位类别','BaseInfo/UnitType.aspx',10,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CE9BC17B-C3DD-4C82-80C2-E64D7FCFF242','685F1E0D-987E-491C-9DC7-014098DEE0C3','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('989B8714-BB8D-48F2-9169-D6FC95E57D70','685F1E0D-987E-491C-9DC7-014098DEE0C3','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8398FF6B-A611-4927-8EA0-4E6CEB66A575','685F1E0D-987E-491C-9DC7-014098DEE0C3','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5775A4D5-0A46-4569-A4C3-E829E413E198','685F1E0D-987E-491C-9DC7-014098DEE0C3','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('871A4DA2-2CE0-4049-8255-3759A269110E','法律法规类型','BaseInfo/LawsRegulationsType.aspx',10,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8EDEF2E0-D369-42D8-AF9E-3A375CF56E1D','871A4DA2-2CE0-4049-8255-3759A269110E','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0896D3C9-E8E1-4130-BE77-2489D288D691','871A4DA2-2CE0-4049-8255-3759A269110E','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('FAD519E9-1285-402C-8F49-920060C68E13','871A4DA2-2CE0-4049-8255-3759A269110E','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CDFBF7A0-7D26-4F28-B0B3-3E536679C8B0','871A4DA2-2CE0-4049-8255-3759A269110E','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('ACA1906A-4A68-4632-A13A-342DECE32D3E','标准规范类型','BaseInfo/HSSEStandardListType.aspx',20,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4C990D25-A411-4C9A-81EE-DC708D04450F','ACA1906A-4A68-4632-A13A-342DECE32D3E','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('39F7C571-49AD-45A7-AC46-C8E2B5509BD7','ACA1906A-4A68-4632-A13A-342DECE32D3E','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D8B7F14A-A4A8-4B52-BFB5-BB8625171773','ACA1906A-4A68-4632-A13A-342DECE32D3E','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('32AA943D-FD44-47D4-BAC3-6A62C0E37F7C','ACA1906A-4A68-4632-A13A-342DECE32D3E','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('5DAADE2B-C2D2-4765-A47A-A1C3139775DC','管理规定分类','BaseInfo/ManageRuleType.aspx',30,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('47129639-FE34-4903-9719-3FE3E299B318','5DAADE2B-C2D2-4765-A47A-A1C3139775DC','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A002A18F-E01A-4F69-AED8-B139990D77E1','5DAADE2B-C2D2-4765-A47A-A1C3139775DC','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('089CE746-8A68-4118-B0C2-3AD80BD99BB3','5DAADE2B-C2D2-4765-A47A-A1C3139775DC','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D1DEB4DF-6066-44F1-89E1-B06D03212CBF','5DAADE2B-C2D2-4765-A47A-A1C3139775DC','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('F7B600D2-999C-4C60-96D4-B7CB7129C0B5','政府部门安全规章类别','BaseInfo/RulesRegulationsType.aspx',40,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4EA243B4-8A73-4113-9993-A984F4747EB1','F7B600D2-999C-4C60-96D4-B7CB7129C0B5','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D73D5352-E91A-4169-99A1-81A4E997BDCB','F7B600D2-999C-4C60-96D4-B7CB7129C0B5','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2CB9A84F-B6AA-4B8C-B73F-CC91DB033651','F7B600D2-999C-4C60-96D4-B7CB7129C0B5','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D9E5436A-DB32-4336-AB77-439BC49AE898','F7B600D2-999C-4C60-96D4-B7CB7129C0B5','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('45EBF358-F03D-4A85-848C-0C59766D3CC8','专家类别','BaseInfo/ExpertType.aspx',50,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('52215998-9158-4E35-97B4-8CF7E19D94FC','45EBF358-F03D-4A85-848C-0C59766D3CC8','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('3603D6AC-DAD7-4055-8C11-8018DFADD773','45EBF358-F03D-4A85-848C-0C59766D3CC8','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('EFCEB86C-D233-4FEB-A98A-DD12AA1EE2FC','45EBF358-F03D-4A85-848C-0C59766D3CC8','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('889557B4-D2EA-4821-B199-19AF9AC44AB2','45EBF358-F03D-4A85-848C-0C59766D3CC8','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('724E082C-EDDA-40FF-B396-F5441C5F6B15','专家专业','BaseInfo/PersonSpecialty.aspx',60,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('EFA5F2E3-D732-4B28-B1C3-0B9CBE7B6EA7','724E082C-EDDA-40FF-B396-F5441C5F6B15','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D6EABDB0-E1A1-40E2-BEA1-A1B44CB437F2','724E082C-EDDA-40FF-B396-F5441C5F6B15','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2FE1F68A-C91F-4009-B318-C37FDD252C37','724E082C-EDDA-40FF-B396-F5441C5F6B15','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('09026419-AD72-4498-A0D1-2E6C7FB42C24','724E082C-EDDA-40FF-B396-F5441C5F6B15','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('2E424093-81B8-421A-963F-D85D17B1E82A','专家职称','BaseInfo/PostTitle.aspx',70,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('88AC5029-B6F5-446F-BEA1-DC29C8C0841D','2E424093-81B8-421A-963F-D85D17B1E82A','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4224FE3C-ADF9-4BFA-850B-86FAF4D475BA','2E424093-81B8-421A-963F-D85D17B1E82A','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B3D458A1-A138-43F7-A0E6-B73D892294DD','2E424093-81B8-421A-963F-D85D17B1E82A','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('19B9E8D2-CCDE-4CBE-BCA1-4AE9208FF72F','2E424093-81B8-421A-963F-D85D17B1E82A','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('CD5D9B58-4313-4463-BAE6-481A0D3775D9','应急预案类型','BaseInfo/EmergencyType.aspx',80,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2A56BBD5-74C9-4BB2-88A3-6B144CA5A7A6','CD5D9B58-4313-4463-BAE6-481A0D3775D9','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C1334A3E-D3F5-446E-BE3D-412F7FB3DCC5','CD5D9B58-4313-4463-BAE6-481A0D3775D9','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('98A3B3C4-1B3A-4552-BD83-B3CB44F78C48','CD5D9B58-4313-4463-BAE6-481A0D3775D9','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2CE3D33A-3EF4-4C50-B57F-D86C15479E5B','CD5D9B58-4313-4463-BAE6-481A0D3775D9','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('2181FB42-22F2-4342-B604-96F5770FE892','专项方案类别','BaseInfo/SpecialSchemeType.aspx',90,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('F1A1DD29-4C7A-4056-BA7A-342D504465DD','2181FB42-22F2-4342-B604-96F5770FE892','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0C870FD7-C0F3-4F1B-A55A-B22579920549','2181FB42-22F2-4342-B604-96F5770FE892','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0ACBAC8E-60B4-4DAF-8E43-2A3D39B13DEB','2181FB42-22F2-4342-B604-96F5770FE892','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5559ACDA-5E69-48DA-B351-FE915DB948DE','2181FB42-22F2-4342-B604-96F5770FE892','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu)
VALUES('F416839E-A37B-4DA0-AA50-8B06EBEF3139','交流话题类型','BaseInfo/ContentType.aspx',100,'84BCDBE8-47D9-40AD-AD42-3256B088FB46')
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7D1940D5-1716-4792-ADEE-702F6144D31F','F416839E-A37B-4DA0-AA50-8B06EBEF3139','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('52298C1C-29C3-495E-9E49-CC1F5AF1CA6E','F416839E-A37B-4DA0-AA50-8B06EBEF3139','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2DA5F5A1-3FAB-4588-959B-4CF7C5175C3F','F416839E-A37B-4DA0-AA50-8B06EBEF3139','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('AC671822-BF16-4704-A542-FA81683C6DFA','F416839E-A37B-4DA0-AA50-8B06EBEF3139','保存',4)
Reference in New Issue View Git Blame Copy Permalink