653 lines
52 KiB
Transact-SQL
653 lines
52 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_SysSet')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_SysSet'
|
|
--go
|
|
/****系统设置******/
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C2297533-B7C0-441E-B29F-ADE87C6F8978','系统设置','',10,'0','Menu_SysSet',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0002','单位管理','SysManage/Unit.aspx',10,'C2297533-B7C0-441E-B29F-ADE87C6F8978','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','角色设置','SysManage/RoleList.aspx',30,'C2297533-B7C0-441E-B29F-ADE87C6F8978','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('2231022B-3519-42FC-A2E6-1DB9A98039DD','角色授权','SysManage/RolePower.aspx',40,'C2297533-B7C0-441E-B29F-ADE87C6F8978','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2F8858BE-1EA0-40AC-ACE1-739D1872FC89','2231022B-3519-42FC-A2E6-1DB9A98039DD','保存',1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','用户信息','SysManage/UserList.aspx',50,'C2297533-B7C0-441E-B29F-ADE87C6F8978','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','环境设置','SysManage/SysConstSet.aspx',60,'C2297533-B7C0-441E-B29F-ADE87C6F8978','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E2D59A77-5E9A-4340-8B94-86D04738F907','E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','保存',1)
|
|
GO
|
|
|
|
|
|
/****基础设置******/
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D363BD9D-4DEC-45D8-89C8-B0E49DEF61B4','基础设置','',20,'0','Menu_SysSet',1,0,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','公共设置','',10,'D363BD9D-4DEC-45D8-89C8-B0E49DEF61B4','Menu_SysSet',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('AEB427BD-AE1A-47CC-9337-368BB06B37F7','项目类型定义','BaseInfo/ProjectType.aspx',10,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('29435573-3312-463e-94ba-cd24da8dbbb8','AEB427BD-AE1A-47CC-9337-368BB06B37F7','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('e0136bdc-769d-4726-bd27-51c440bb0b7f','AEB427BD-AE1A-47CC-9337-368BB06B37F7','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('b53b2254-e229-4839-95da-1f7192424c62','AEB427BD-AE1A-47CC-9337-368BB06B37F7','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('aed806b0-4ee8-4f36-9874-d9ab919ad4b8','AEB427BD-AE1A-47CC-9337-368BB06B37F7','保存',4)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('685F1E0D-987E-491C-9DC7-014098DEE0C3','单位类型定义','BaseInfo/UnitType.aspx',20,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D9F1F0BD-D48F-4C5B-AF26-7F4C561D1352','公司部门定义','SysManage/Depart.aspx',30,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
--VALUES('C14DE553-6304-441D-9D70-4B0CEADF0080','施工班组定义','',40,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
--GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4AEA28ED-327C-4A8F-977D-BB56F423CEA4','作业人员角色定义','',50,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('145523FE-B49A-4420-9DFB-565A79F4AF36','管理人员角色定义','',60,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('2E424093-81B8-421A-963F-D85D17B1E82A','职称定义','BaseInfo/PostTitle.aspx',70,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1390195D8-874B-4E7B-8DBF-D81A5984E973','执业资格证书定义','BaseInfo/PracticeCertificate.aspx',80,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('94c05f8b-5daa-4ff9-b6e8-68fbeae3e869','1390195D8-874B-4E7B-8DBF-D81A5984E973','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('43f86173-f796-4c3d-8b9d-7da06fbc5f68','1390195D8-874B-4E7B-8DBF-D81A5984E973','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7fdf928e-b01f-409d-996d-35d568c44b95','1390195D8-874B-4E7B-8DBF-D81A5984E973','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('71a266df-27fa-4a31-b2a8-57aa67bd7800','1390195D8-874B-4E7B-8DBF-D81A5984E973','保存',4)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('871A4DA2-2CE0-4049-8255-3759A269110E','法律法规类型定义','BaseInfo/LawsRegulationsType.aspx',90,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('ACA1906A-4A68-4632-A13A-342DECE32D3E','标准规范类型定义','BaseInfo/HSSEStandardListType.aspx',100,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('5DAADE2B-C2D2-4765-A47A-A1C3139775DC','管理规定类型定义','BaseInfo/ManageRuleType.aspx',110,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F7B600D2-999C-4C60-96D4-B7CB7129C0B5','规章制度类型定义','BaseInfo/RulesRegulationsType.aspx',120,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('179F286B-6DF8-414E-947F-82267076D4C8','施工方案类型','BaseInfo/SolutionTempleteType.aspx',130,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('BE742EF1-6E96-44E4-ACB1-D964D6572B3D','179F286B-6DF8-414E-947F-82267076D4C8','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('52793AC6-30FF-41AA-BF79-28EFB059459F','179F286B-6DF8-414E-947F-82267076D4C8','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7E604782-870D-4C48-A8DE-F072F54CAF2B','179F286B-6DF8-414E-947F-82267076D4C8','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('98B1B662-629F-4702-BAAC-F6E8C75DC641','179F286B-6DF8-414E-947F-82267076D4C8','保存',4)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('2181FB42-22F2-4342-B604-96F5770FE892','分部分项工程定义','BaseInfo/SpecialSchemeType.aspx',140,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D95CA72C-182C-4718-92A4-3F665E0FB660','项目亮点类型定义','BaseInfo/PictureType.aspx',150,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('0957C59D-E9E0-40E5-A422-3A596C3BFB0B','D95CA72C-182C-4718-92A4-3F665E0FB660','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EA5F5B14-4D9D-4BBC-83F3-330985CCE771','D95CA72C-182C-4718-92A4-3F665E0FB660','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('21C14F40-BCC1-4D69-B6C7-5DC296EA97E6','D95CA72C-182C-4718-92A4-3F665E0FB660','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B0D1F559-A842-46AD-B836-32FD325B9ABB','D95CA72C-182C-4718-92A4-3F665E0FB660','保存',4)
|
|
GO
|
|
|
|
|
|
insert into Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('3044D68E-5018-4B57-BFC4-FBE4BCCA8B8B','问题类别定义','BaseInfo/QuestionType.aspx',160,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('27D8CEC6-5D58-4B06-BF3F-C62E1D361074','3044D68E-5018-4B57-BFC4-FBE4BCCA8B8B','增加',1)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('7EB2E0FA-0DEE-45D2-81BA-A49F9F8D556E','3044D68E-5018-4B57-BFC4-FBE4BCCA8B8B','修改',2)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('CBEF171A-1E96-4523-9CD5-5040D2C42DC6','3044D68E-5018-4B57-BFC4-FBE4BCCA8B8B','删除',3)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('124B7659-5F18-49F3-8D30-BF8680830827','3044D68E-5018-4B57-BFC4-FBE4BCCA8B8B','保存',4)
|
|
GO
|
|
|
|
insert into Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('F0DF2F2B-7C12-4A0F-B7D4-0B00BADE1D64','文档类别定义','BaseInfo/DocType.aspx',170,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('27D8CEC6-5D58-4B06-BF3F-C62E1D361074','F0DF2F2B-7C12-4A0F-B7D4-0B00BADE1D64','增加',1)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('7EB2E0FA-0DEE-45D2-81BA-A49F9F8D556E','F0DF2F2B-7C12-4A0F-B7D4-0B00BADE1D64','修改',2)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('CBEF171A-1E96-4523-9CD5-5040D2C42DC6','F0DF2F2B-7C12-4A0F-B7D4-0B00BADE1D64','删除',3)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('124B7659-5F18-49F3-8D30-BF8680830827','F0DF2F2B-7C12-4A0F-B7D4-0B00BADE1D64','保存',4)
|
|
GO
|
|
|
|
insert into Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('D0850615-BF32-4CFA-84CA-EEA261676EA8','移交专业设置','BaseInfo/TransferMajor.aspx',180,'5196A6FD-4BF1-46B3-8D24-9A3CE5BB4760','Menu_SysSet',1,1,1)
|
|
GO
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('0465EA2B-2F37-4103-A717-4033894108E0','D0850615-BF32-4CFA-84CA-EEA261676EA8','增加',1)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('EF58BDF7-F303-4633-8B83-DB4B151F8EAF','D0850615-BF32-4CFA-84CA-EEA261676EA8','修改',2)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('FC1373E2-D942-4D0E-822F-CE2F16C5D42D','D0850615-BF32-4CFA-84CA-EEA261676EA8','删除',3)
|
|
insert into Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) values('65427D56-5490-42D7-8F00-EB3A59FAA6B0','D0850615-BF32-4CFA-84CA-EEA261676EA8','保存',4)
|
|
GO
|
|
|
|
/****质量基础设置******/
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('A93BA810-3511-4BB2-9C10-9663351DF79F','质量设置','',20,'D363BD9D-4DEC-45D8-89C8-B0E49DEF61B4','Menu_SysSet',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('24F9A1ED-0F4C-407C-8EB3-2A8711BB6ECC','质量问题类别定义','BaseInfo/QualityQuestionType.aspx',10,'A93BA810-3511-4BB2-9C10-9663351DF79F','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B6860AAE-5149-4416-9E83-829DF743D77E','24F9A1ED-0F4C-407C-8EB3-2A8711BB6ECC','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('499EB09B-C0AB-43B8-BAF2-FB03C055C9FF','24F9A1ED-0F4C-407C-8EB3-2A8711BB6ECC','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1E979268-6848-48DB-AE25-86F4A0F30472','24F9A1ED-0F4C-407C-8EB3-2A8711BB6ECC','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D165EE90-3889-488F-ADE8-3DF7ED2CCA69','24F9A1ED-0F4C-407C-8EB3-2A8711BB6ECC','保存',4)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D00A978A-DDEE-4BFF-8872-FFF65A7BC0BC','施工专业定义','BaseInfo/CNProfessional.aspx',20,'A93BA810-3511-4BB2-9C10-9663351DF79F','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('277B0B0B-9E10-4C03-B1D2-D11ADF4E3CB5','D00A978A-DDEE-4BFF-8872-FFF65A7BC0BC','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E7ADA328-CB20-4A42-882C-E9D0D186A2EC','D00A978A-DDEE-4BFF-8872-FFF65A7BC0BC','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('26C7A0AA-11F6-4C3D-A6A6-525C3ADA32DC','D00A978A-DDEE-4BFF-8872-FFF65A7BC0BC','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('756E3AC5-7DCE-41DB-9129-B24D36015D26','D00A978A-DDEE-4BFF-8872-FFF65A7BC0BC','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('BADDFC6A-F0E2-4443-A98D-12439C4A2F16','设计专业定义','BaseInfo/DesignProfessional.aspx',30,'A93BA810-3511-4BB2-9C10-9663351DF79F','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('61CC0574-C488-4103-AFD5-81A6689F1939','BADDFC6A-F0E2-4443-A98D-12439C4A2F16','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7798C3C2-2B51-4EF2-B2BE-8CC33548DC2F','BADDFC6A-F0E2-4443-A98D-12439C4A2F16','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F0D33EC5-06EA-4837-98B9-20910CA6548E','BADDFC6A-F0E2-4443-A98D-12439C4A2F16','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('ECF2004E-5063-4EBF-ABBD-89A08B5D3E98','BADDFC6A-F0E2-4443-A98D-12439C4A2F16','保存',4)
|
|
GO
|
|
|
|
|
|
|
|
/****安全基础设置******/
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','安全设置','',30,'D363BD9D-4DEC-45D8-89C8-B0E49DEF61B4','Menu_SysSet',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D4FC3583-31A7-49B3-8F32-007E9756D678','岗位信息','BaseInfo/WorkPost.aspx',10,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3A40AF0B-C9B8-4AF9-A683-FEADD8CC3A1C','特岗证书定义','BaseInfo/Certificate.aspx',20,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('29EC9A5A-B1E3-4906-A17F-2E266B0B7CBD','3A40AF0B-C9B8-4AF9-A683-FEADD8CC3A1C','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('60D3B100-C470-4E82-A30A-78D8E5A1AECF','3A40AF0B-C9B8-4AF9-A683-FEADD8CC3A1C','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FBA2E268-77B8-467D-9FF7-BDB569B68B77','3A40AF0B-C9B8-4AF9-A683-FEADD8CC3A1C','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('19E7715D-5DC0-46E9-9227-D731ADBA8175','3A40AF0B-C9B8-4AF9-A683-FEADD8CC3A1C','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B7926494-8CCD-40BD-1111-6BD10176DA0D','机具设备定义','BaseInfo/SpecialEquipment.aspx',30,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E0853FCF-A9EB-4006-8F0A-25E52C307B80','B7926494-8CCD-40BD-1111-6BD10176DA0D','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('862C0C1D-AE0F-466E-A514-0CD52E9B2C6B','B7926494-8CCD-40BD-1111-6BD10176DA0D','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('49848FFA-E9FF-4C77-B441-DFF5BBC29539','B7926494-8CCD-40BD-1111-6BD10176DA0D','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2E0AE5AF-4BC7-4E33-A791-D04A321B5EF9','B7926494-8CCD-40BD-1111-6BD10176DA0D','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('000F8328-AB84-4235-95F8-E826DB292D83','费用类型定义','BaseInfo/CostType.aspx',40,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('20A9DAA5-58B8-4D66-ACA1-C4ECC760D7B6','000F8328-AB84-4235-95F8-E826DB292D83','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B2CAB772-2AE0-4FC0-9E61-F354D0C36842','000F8328-AB84-4235-95F8-E826DB292D83','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D2E8A6F3-1895-4402-9EBB-F7D4479BD7E3','000F8328-AB84-4235-95F8-E826DB292D83','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2ACF3E89-FCAC-4E52-A288-C1270C225B33','000F8328-AB84-4235-95F8-E826DB292D83','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F6C0E3DE-84CB-45CE-A46A-84DD51B8FBCB','事故类型定义','BaseInfo/AccidentType.aspx',50,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('62B536D8-FEDB-4106-81E7-EBCFB34596B6','F6C0E3DE-84CB-45CE-A46A-84DD51B8FBCB','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('751CB238-AA4B-4A6B-ABB8-024282B263E1','F6C0E3DE-84CB-45CE-A46A-84DD51B8FBCB','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DF16EC25-A30F-4D70-80DB-52AE76B74556','F6C0E3DE-84CB-45CE-A46A-84DD51B8FBCB','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E7E18784-77CE-48CB-88FE-3D6321D9DE96','F6C0E3DE-84CB-45CE-A46A-84DD51B8FBCB','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4C86AEA0-5D8A-4677-8F53-D1C757141CD3','许可证类型定义','BaseInfo/LicenseType.aspx',60,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EDE81A14-66EE-4F80-A09A-08B0ABFB2F16','4C86AEA0-5D8A-4677-8F53-D1C757141CD3','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('098D2C8F-A2FE-4536-B04B-56E6739398CF','4C86AEA0-5D8A-4677-8F53-D1C757141CD3','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('13094377-32C5-424F-AA94-9E609AAF030F','4C86AEA0-5D8A-4677-8F53-D1C757141CD3','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('8FC42B99-81C9-4B6D-911A-6D7D30BB4F89','4C86AEA0-5D8A-4677-8F53-D1C757141CD3','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('CD5D9B58-4313-4463-BAE6-481A0D3775D9','应急预案类型定义','BaseInfo/EmergencyType.aspx',70,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('091322A8-4FFB-472C-91EB-ABB3E491262A','培训类型定义','BaseInfo/TrainType.aspx',80,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E1193037-221A-4011-B045-DD1704CCDE62','091322A8-4FFB-472C-91EB-ABB3E491262A','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CABC7646-2E57-4CCD-8469-D66670477EDE','091322A8-4FFB-472C-91EB-ABB3E491262A','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('00ADAD93-8D34-4B7B-ABD8-E2B401E671C2','091322A8-4FFB-472C-91EB-ABB3E491262A','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CD2D597A-691C-4B50-851B-CBEB34DEEB84','091322A8-4FFB-472C-91EB-ABB3E491262A','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B27A0196-06A0-412D-B734-FB348AA6E312','培训级别定义','BaseInfo/TrainLevel.aspx',90,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B88D5325-D989-470B-ADB6-0EB601F99252','B27A0196-06A0-412D-B734-FB348AA6E312','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F18677DB-AE2E-4063-BB8A-5AFD3029D7B3','B27A0196-06A0-412D-B734-FB348AA6E312','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7437E844-A370-484A-BA6F-222BD18E8E44','B27A0196-06A0-412D-B734-FB348AA6E312','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2A98879F-48A5-49C5-8C58-DD8EA01B8339','B27A0196-06A0-412D-B734-FB348AA6E312','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('38143A01-D17C-4234-A1A1-D90A3F887438','工作阶段定义','BaseInfo/WorkStage.aspx',100,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('39FC7E71-7021-4B74-9B03-A12C074F30F2','38143A01-D17C-4234-A1A1-D90A3F887438','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FEAA4962-43AB-41AE-976B-499BEE1123D3','38143A01-D17C-4234-A1A1-D90A3F887438','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E90B5930-232B-46AD-97E5-0144E53CADBC','38143A01-D17C-4234-A1A1-D90A3F887438','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EAB7496C-AC99-42D5-A609-5867E68E2691','38143A01-D17C-4234-A1A1-D90A3F887438','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4BB6AC40-D4D5-439B-85CC-100E431CF3F1','安全措施类型定义','BaseInfo/SafetyMeasures.aspx',110,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DBE4768A-0962-44E5-A603-605A5BA88E9B','4BB6AC40-D4D5-439B-85CC-100E431CF3F1','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DECFFC95-DC39-4BBF-9657-6F7A585F0DE4','4BB6AC40-D4D5-439B-85CC-100E431CF3F1','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('304A3AFE-0769-4D50-8F80-4C3FD94E5DB1','4BB6AC40-D4D5-439B-85CC-100E431CF3F1','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2D84061B-11BA-4D3B-9A27-E13B934D0165','4BB6AC40-D4D5-439B-85CC-100E431CF3F1','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3EC2676A-70EB-400E-BE17-EEBBA0B7E9D7','安全巡检类型定义','BaseInfo/HazardRegisterTypes.aspx',120,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9DC6A654-B014-48DA-9A33-972FC782D2B3','3EC2676A-70EB-400E-BE17-EEBBA0B7E9D7','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AB4EFF59-5CEA-41CA-AA62-58EA1A4CEF39','3EC2676A-70EB-400E-BE17-EEBBA0B7E9D7','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D9CCA30D-CEAA-4D67-A252-508479C474D5','3EC2676A-70EB-400E-BE17-EEBBA0B7E9D7','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7F9EAADC-69F4-4D97-8E0B-B6DB4919225E','3EC2676A-70EB-400E-BE17-EEBBA0B7E9D7','保存',4)
|
|
GO
|
|
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('CCF9E615-78C9-4085-BCFE-0F9907D3FA0A','物资类别','BaseInfo/GoodsCategory.aspx',130,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('121E4E38-D5A6-44CB-9479-1F63FA4DA73F','CCF9E615-78C9-4085-BCFE-0F9907D3FA0A','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('0DB09DFF-22D6-489E-B8B6-12C8850F0540','CCF9E615-78C9-4085-BCFE-0F9907D3FA0A','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('280BF20F-8008-45CF-97DC-59E09E21EB40','CCF9E615-78C9-4085-BCFE-0F9907D3FA0A','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('211F29C6-BA48-4D9A-B119-70E5E21C868C','CCF9E615-78C9-4085-BCFE-0F9907D3FA0A','保存',4)
|
|
GO
|
|
------------------------------------------------本部焊接基础信息--------------------------------------------
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('85DFE1D3-9E68-46B5-87E5-A525698F2F5F','焊接设置','',40,'D363BD9D-4DEC-45D8-89C8-B0E49DEF61B4','Menu_SysSet',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0013','管道材质定义','HJGL/BaseInfo/Material.aspx',10,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*材质定义*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5C13752C-8927-4585-A600-AEE62B5B704D','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0F5E5CC0-7E7A-489C-A549-979395C21FCC','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('648CF364-DD3C-4153-BB8E-90207535ED86','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('396C1679-A303-43AB-A5CB-9C41B905416B','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1C210C6A-9A9D-493D-B899-E676B725579F','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','查看',5)
|
|
GO
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0011','管道规格定义','HJGL/BaseInfo/Control.aspx',20,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*直径寸径对照*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CCB0797A-BEF9-493D-9D73-2716977FDA11','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('ADA012CA-32E5-48FB-88D2-7C4DE9914E00','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('83234A4B-6608-4FFF-B9D1-1EE40CEF1171','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A845E8D1-AA04-43F8-873A-1741F0866CF9','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2A02CE68-C5DA-4F94-B806-796A1F757E59','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0010','焊接方法定义','HJGL/BaseInfo/WeldingMethod.aspx',30,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*焊接方法*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4AC2A90B-3A98-4F1E-82C4-61CB310B893B','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BE3D4228-3064-45B6-BF49-2CA0277B5B05','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('156D4431-0685-4583-9AED-00DD6182CA40','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('584A1FAC-AC6E-427B-80BE-4995851D93DD','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('528240A9-0285-47C7-95CC-D9EEA5AFB0ED','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0004','焊接耗材定义','HJGL/BaseInfo/Consumables.aspx',40,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*焊接耗材*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1E193A67-E2D5-400F-98BE-2B3A05335546','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('032C8DB7-2C1F-4291-8244-306FA16B94BE','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2703783E-24AB-42FD-8790-0C3BD35B3552','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1808F8E6-6262-4F87-A412-73EBB60892E4','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('32468500-9EAC-4588-A0F5-BB271EA4987C','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0008','焊缝类型定义','HJGL/BaseInfo/Weld.aspx',50,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*焊缝类型*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1D3CEB1A-B4B9-40B8-B859-C7EBB18BAD67','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7ACE3181-0CB5-47B7-9662-6751EFFB0329','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BC593263-3CF6-4A54-B109-9F129F9F044F','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D907991C-4E7E-42F3-AE63-7D9F489C6967','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E9EBAA48-5F38-4BB3-BF94-6075809E6B80','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0012','坡口类型定义','HJGL/BaseInfo/Groove.aspx',60,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*坡口类型*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('39465F91-1F7F-41FD-8E55-D8A2A492173A','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F68FF943-6865-4C64-8568-D9A8E2644865','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('81250B08-C9B2-40C1-B545-8886AF370C89','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3DE94701-1B3C-495D-982E-E5A90945C829','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A5D8B2BA-3759-4435-B50C-DCEE3E63E80B','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0003','焊接位置定义','HJGL/BaseInfo/WeldingLocation.aspx',70,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*焊接位置*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('07A8F4C1-89D2-464B-9B14-05CB899654DD','8IDKGJE2-09B1-4607-BC6D-865CE48F0003','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B9A8737D-EC58-444F-848D-6DA119371330','8IDKGJE2-09B1-4607-BC6D-865CE48F0003','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F3B42490-F98F-4883-A1F3-4C50C2EF5108','8IDKGJE2-09B1-4607-BC6D-865CE48F0003','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('16521D71-6566-4FC2-8F69-68ABBD9ED13A','8IDKGJE2-09B1-4607-BC6D-865CE48F0003','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B3280BA5-C326-4926-95F1-6AFE1C4B4B4B','8IDKGJE2-09B1-4607-BC6D-865CE48F0003','查看',5)
|
|
GO
|
|
--SELECT NEWID()
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D68AE881-7472-4C48-953D-E13C46D6E2A4','焊接缺陷定义','HJGL/BaseInfo/Defect.aspx',80,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*缺陷性质*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0E7251BD-A650-4A37-90C6-1F32C5CC70AC','D68AE881-7472-4C48-953D-E13C46D6E2A4','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A366D1BB-6F51-4C6A-BC54-853C965120A6','D68AE881-7472-4C48-953D-E13C46D6E2A4','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B1DCB5C8-E052-4320-BED0-57D664E4679A','D68AE881-7472-4C48-953D-E13C46D6E2A4','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9244C7EA-6426-4FFF-8864-1E46834EB2E1','D68AE881-7472-4C48-953D-E13C46D6E2A4','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BA7ADEB4-302D-42B2-98E1-1A7F70ED8C3B','D68AE881-7472-4C48-953D-E13C46D6E2A4','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0006','探伤类型定义','HJGL/BaseInfo/Testing.aspx',90,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*探伤类型*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6852BC76-6B23-4166-A35A-41DB422ADF3B','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('26667D2C-6617-4CA2-A328-9C7E11E98F80','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DE5A7100-1798-4D5E-A3B9-17D7E5ED2B98','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D25FACD7-35C2-4C58-B564-C53D7C79EF1D','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('01EE5373-AC82-42AA-A161-E193A4731BA7','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0007','探伤比例定义','HJGL/BaseInfo/Detection.aspx',100,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*探伤比例*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6969BCFB-CE11-4B1E-835E-B045644994EA','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('785995D4-7368-4FCA-9F97-CDADADFABA3D','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('68873C19-8410-4F3C-ACD0-F757BB2C137C','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B8885C9C-704D-4686-B4A3-B5923BC8DF6B','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AEBF2820-F7DE-456C-B733-B45968418C82','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0015','试压类型定义','HJGL/BaseInfo/Pressure.aspx',110,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E5010508-5096-4162-8103-2E00261ADC94','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A797EBD4-5CB3-47BE-A66E-AA8836256C21','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0426A353-6A81-4C63-B0AC-7183C52C1D15','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E7F5CD40-0B3B-4599-9A01-F4A5A11A42C4','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C95D6EE1-F6B5-4DBA-96E4-977C129235CD','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F480545B-371A-4949-85F8-92B2CA75A044','试验介质','HJGL/BaseInfo/TestMedium.aspx',115,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*试验定义*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1691F358-CB9B-4F03-A9C9-E94A54117E01','F480545B-371A-4949-85F8-92B2CA75A044','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F16DDC3A-C461-4C57-99EC-29E0C6E5C85B','F480545B-371A-4949-85F8-92B2CA75A044','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7072C193-5209-4511-AAB2-75B7379ACBAF','F480545B-371A-4949-85F8-92B2CA75A044','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8E2C3C0F-2EE2-439B-9D47-0231749CD2A1','F480545B-371A-4949-85F8-92B2CA75A044','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F7B0562E-956C-46F7-91F1-03D5752E2A90','F480545B-371A-4949-85F8-92B2CA75A044','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('49852102-F148-44FB-95F6-EFBE32708276','管道吹洗方法定义','HJGL/BaseInfo/PurgeMethod.aspx',120,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*管道吹洗方法*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('782DC80C-FB15-47F2-B106-B0237F660EDC','49852102-F148-44FB-95F6-EFBE32708276','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EF1B8C03-5D1D-4C98-9989-03EE1777C1D6','49852102-F148-44FB-95F6-EFBE32708276','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E8D5BF88-8028-4D62-B65A-E976409F6B71','49852102-F148-44FB-95F6-EFBE32708276','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('309C0946-0BF8-4F22-804F-BE4E2F1258B4','49852102-F148-44FB-95F6-EFBE32708276','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E10129A3-DA72-41CF-8139-21BBE7EBEC1E','49852102-F148-44FB-95F6-EFBE32708276','查看',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C587E930-4FBC-48CE-8BF9-7CB8164C207C','压力管道级别定义','HJGL/BaseInfo/PressurePipingClass.aspx',130,'85DFE1D3-9E68-46B5-87E5-A525698F2F5F','Menu_SysSet',1,1,1)
|
|
GO
|
|
/*压力管道级别*/
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AC3D7141-3B5E-4177-B148-41647220E171','C587E930-4FBC-48CE-8BF9-7CB8164C207C','增加',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B8D90010-5ECB-42B4-9F50-4869BC1334FD','C587E930-4FBC-48CE-8BF9-7CB8164C207C','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8BCCBE7A-93B5-4CAD-B979-9E7847D76E22','C587E930-4FBC-48CE-8BF9-7CB8164C207C','删除',3)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3C69A157-C5F6-4A80-8BEB-543A2F661E66','C587E930-4FBC-48CE-8BF9-7CB8164C207C','保存',4)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4C2ACBEB-C80A-423B-822D-5CA8DF3FEA33','C587E930-4FBC-48CE-8BF9-7CB8164C207C','查看',5)
|
|
GO
|
|
------------------------------------------------本部焊接基础信息--------------------------------------------
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('24A40837-0756-49B0-8B3C-EFB8A9879336','合同设置','',50,'D363BD9D-4DEC-45D8-89C8-B0E49DEF61B4','Menu_SysSet',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('E40C8FCE-3530-47D6-85EB-5C7E7E0A89FC','施工分包方式定义','',10,'24A40837-0756-49B0-8B3C-EFB8A9879336','Menu_SysSet',1,1,1)
|
|
GO
|
|
/****项目设置******/
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('75AA6177-8AAD-4AA4-BC4E-3883FB095A65','项目设置','',30,'0','Menu_SysSet',1,0,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B830399C-CA36-4C23-A170-21E556D052DD','项目成立','ProjectData/ProjectSet.aspx',10,'75AA6177-8AAD-4AA4-BC4E-3883FB095A65','Menu_SysSet',1,1,1)
|
|
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)
|
|
GO
|