gaofei
/
HJGL_DS
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
HJGL_DS/DataBase/InitData.sql

1127 lines
90 KiB
Transact-SQL
Raw Permalink Blame History

--初始化系统管理员账户
INSERT INTO dbo.Sys_User(UserId,Account,[Password],UserName,IsPost,IsHeadMan,AllowLoginSystem)
VALUES ('AF17168B-87BD-466E-1111-F0A0A1158F9B','gly','EDE6B81F7043D328B1F1661FA011BCAB',
'管理员',1,1,'1|2|3|4|5')
GO
--菜单设置
-----------------------------------------综合菜单---------------------------------------------------
--基础信息
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('B71A4EB0-5882-46F5-2222-FAEFF383414A','基础设置','Common/BaseInfo/BaseInfoMain.aspx',20,'0','1')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('F4B314DA-1F95-4B82-2222-3A20ED04FA17','项目信息','Common/BaseInfo/Project.aspx',10,'B71A4EB0-5882-46F5-2222-FAEFF383414A','1')
GO
/*项目信息*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('434946F1-3048-4E73-BA3B-BA0628829FC0','F4B314DA-1F95-4B82-2222-3A20ED04FA17','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8A0181D1-D2D3-4DA8-ADFF-BCF105BB032F','F4B314DA-1F95-4B82-2222-3A20ED04FA17','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C9FE268F-E367-4AA3-A721-2E17D0BA77CF','F4B314DA-1F95-4B82-2222-3A20ED04FA17','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B65CA98E-C7A7-45EB-8425-C712D600AEBB','F4B314DA-1F95-4B82-2222-3A20ED04FA17','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C0AEA6BF-F73C-42DC-902F-46B3F0B4B45F','F4B314DA-1F95-4B82-2222-3A20ED04FA17','编辑检测工程编号',5)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('728BB530-B833-46FE-8A36-6628DEB7550C','F4B314DA-1F95-4B82-2222-3A20ED04FA17','计划编制',6)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('D5783F6B-CDEF-4893-2222-265C36B17167','单位信息','Common/BaseInfo/Unit.aspx',40,'B71A4EB0-5882-46F5-2222-FAEFF383414A','1')
GO
/*单位信息*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('51438E86-0E8C-4149-1111-A47DDBCF2029','D5783F6B-CDEF-4893-2222-265C36B17167','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('775FB5D5-0E95-4790-1111-6DAEE7706B94','D5783F6B-CDEF-4893-2222-265C36B17167','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C604FDC0-1BF3-45F3-1111-1B3E7765D7FD','D5783F6B-CDEF-4893-2222-265C36B17167','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AD834200-ACD4-4666-1111-8345E377B670','D5783F6B-CDEF-4893-2222-265C36B17167','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','焊工管理','Common/WelderManage/WelderManage.aspx',50,'B71A4EB0-5882-46F5-2222-FAEFF383414A','1')
GO
/*焊工管理*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('32EEB794-2F64-4300-AC4C-963D4A74E48C','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('22288619-7DA1-431C-AED2-2D439B296C8F','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('199ABD70-7844-4558-BF1D-43D5A76B6595','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5B8017C2-5848-47FF-852B-C630AED27AEB','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('07341D61-A34D-41AB-B26B-37C1FB433665','审批流程自定义','Common/BaseInfo/AudiFlowSet.aspx',60,'B71A4EB0-5882-46F5-2222-FAEFF383414A','1')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('173F1365-F060-4170-8DEA-CC62A4FFDB75','07341D61-A34D-41AB-B26B-37C1FB433665','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8F224F95-4244-4706-A5F2-29063F25E657','07341D61-A34D-41AB-B26B-37C1FB433665','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B5BBDED2-4426-402C-80B5-B3656C87F885','07341D61-A34D-41AB-B26B-37C1FB433665','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A4A975CD-6F18-4A63-92A5-F87CF736B06D','07341D61-A34D-41AB-B26B-37C1FB433665','保存',4)
GO
--首页导航定制
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('BD42A57E-1783-4FFB-A150-B2CE136AE48E','首页导航定制','Common/BaseInfo/SgglNavSetList.aspx',70,'B71A4EB0-5882-46F5-2222-FAEFF383414A','1')
GO
/*首页导航定制*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DA4D443B-7C58-4619-B650-FC5A8A6A6C0B','BD42A57E-1783-4FFB-A150-B2CE136AE48E','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DEB8FADA-8FA1-4B01-9275-509609FC7227','BD42A57E-1783-4FFB-A150-B2CE136AE48E','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D75E9512-9599-473F-B318-788CD59DE5F2','BD42A57E-1783-4FFB-A150-B2CE136AE48E','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BF57E047-C235-436B-AED3-3F7367366E9E','BD42A57E-1783-4FFB-A150-B2CE136AE48E','保存',4)
GO
--1.系统设置
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('D1A0F410-09B1-4607-2222-865CE48F080F','系统设置','Common/SysManage/SysMain.aspx',20,'0','1')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('EBAD373C-8EB4-49A1-2222-6794FFCAF9B6','角色管理','Common/SysManage/RoleList.aspx',10,'D1A0F410-09B1-4607-2222-865CE48F080F','1')
GO
/*角色*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0AF58F1B-FA3B-450E-B889-6A29713666B6','EBAD373C-8EB4-49A1-2222-6794FFCAF9B6','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('199E14E1-F883-4292-BBD5-D6350687A37F','EBAD373C-8EB4-49A1-2222-6794FFCAF9B6','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FD6DD649-03D7-447E-A6A7-2F986B8E3C97','EBAD373C-8EB4-49A1-2222-6794FFCAF9B6','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('73121F82-E7FD-4E9F-828A-F8059E8D65EC','EBAD373C-8EB4-49A1-2222-6794FFCAF9B6','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('E6F0167E-B0FD-4A32-2222-25FB9E0FDC4E','用户','Common/SysManage/UserList.aspx',20,'D1A0F410-09B1-4607-2222-865CE48F080F','1')
GO
/*用户*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('25D91766-21DB-4BBE-9748-49554B6ABA37','E6F0167E-B0FD-4A32-2222-25FB9E0FDC4E','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('757A8D8D-BF93-49D8-A528-AC38CE06F76D','E6F0167E-B0FD-4A32-2222-25FB9E0FDC4E','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C554B35C-2954-48EC-B62E-902036773232','E6F0167E-B0FD-4A32-2222-25FB9E0FDC4E','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('94C05CC4-1231-4348-864A-4BDDDECF2771','E6F0167E-B0FD-4A32-2222-25FB9E0FDC4E','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('BAB254FA-C879-4463-2222-387C241A8623','修改密码','Common/SysManage/UpdatePassword.aspx',30,'D1A0F410-09B1-4607-2222-865CE48F080F','1')
GO
/*修改密码*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AA2A93A7-7530-417B-8739-F90AC49B34A1','BAB254FA-C879-4463-2222-387C241A8623','保存',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('2231022B-3519-42FC-2222-1DB9A98039DD','角色授权','Common/SysManage/RolePower.aspx',40,'D1A0F410-09B1-4607-2222-865CE48F080F','1')
GO
/*角色授权*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('05AE37FA-98D4-452B-A5D3-1462937FA109','2231022B-3519-42FC-2222-1DB9A98039DD','保存',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('9F3A6DDF-C2EA-4AE6-2222-96B7E819A00E','数据库备份','Common/SysManage/DataBak.aspx',50,'D1A0F410-09B1-4607-2222-865CE48F080F','1')
GO
/*数据库备份*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('97A7E1B3-C90E-4E1B-A3A2-2D0E492711CD','9F3A6DDF-C2EA-4AE6-2222-96B7E819A00E','数据库备份',1)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('3E208088-31E7-4849-2222-FCA64B288EF3','日志管理','Common/SysManage/LogList.aspx',60,'D1A0F410-09B1-4607-2222-865CE48F080F','1')
GO
--项目设置
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','项目设置','Common/ProjectSet/ProjectSetMain.aspx',30,'0','1')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('0E017438-A342-47A9-84FB-38BFB70BE561','参与单位','Common/ProjectSet/ProjectUnit.aspx',10,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
GO
/*参与单位*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2FD20479-6C47-4721-8BA1-64E23E2592C5','0E017438-A342-47A9-84FB-38BFB70BE561','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A6A9F3D0-0368-4A5C-AA6E-F56F1C0BE8CD','0E017438-A342-47A9-84FB-38BFB70BE561','删除',2)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('BF1EC3DB-9278-4FE9-BE09-B364FD13AF97','参与用户','Common/ProjectSet/ProjectUser.aspx',20,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A039937F-89B0-4785-B7E3-23FF51F532A4','BF1EC3DB-9278-4FE9-BE09-B364FD13AF97','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DF77E9F4-85F2-4AF9-8B6B-830F5165A2A2','BF1EC3DB-9278-4FE9-BE09-B364FD13AF97','删除',2)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('10ADC484-14DC-4235-3333-1763E52EE4E7','项目焊工','Common/ProjectSet/ProjectWelder.aspx',30,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
GO
/*项目焊工*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F9405F4F-A08B-409C-A6AB-25F23BAF845B','10ADC484-14DC-4235-3333-1763E52EE4E7','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C9BAC56F-E3EC-4504-8D8F-6AC111389A55','10ADC484-14DC-4235-3333-1763E52EE4E7','删除',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2FED1E11-965C-4449-B4DC-4F0F6AB5FBCD','10ADC484-14DC-4235-3333-1763E52EE4E7','选用人编辑',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5B272E8D-401E-41B7-87C7-011E5CD0B760','10ADC484-14DC-4235-3333-1763E52EE4E7','审核人编辑',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('A4308F9A-0280-49C5-BEE4-FA858FE1CE24','项目装置','Common/ProjectSet/Installation.aspx',40,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
GO
/*装置*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D9F56A7D-03C2-4BC5-8317-E1E5CBB2B30B','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5D25C24E-38CE-45F5-857E-F051C1B5068E','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C8A2CAB9-705C-472B-825D-7C76A8404569','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9F1DEE68-7D91-4DE9-B935-FE10FA9E7E8F','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','保存',4)
GO
--/*项目角色授权*/
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
--VALUES ('27643029-2227-4BDC-BB41-648DDD1DAADD','项目角色授权','Common/ProjectSet/ProjectRolePower.aspx',50,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
--GO
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BA8B30C6-2812-44A2-B0DB-D4EDA19FFDA5','27643029-2227-4BDC-BB41-648DDD1DAADD','保存',1)
--GO
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
--VALUES ('E473554C-C788-4798-B8E5-2AD8A0A1C1CE','项目用户授权','Common/ProjectSet/ProjectUserPower.aspx',60,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
--GO
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6C830386-E689-40C7-A510-351DBB9702D5','E473554C-C788-4798-B8E5-2AD8A0A1C1CE','保存',1)
--GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','项目环境设置','Common/ProjectSet/ProjectSysSet.aspx',70,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C6512BF1-5DC2-4737-9399-281A99255097','E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','保存',1)
GO
/*报表设计*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('8FA7237E-DB0C-436C-6666-8C3A560EE688','报表设计','Common/ReportPrint/PrintDesigner.aspx',80,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B0728CC5-11E7-4E37-8BED-F29EF92CF805','8FA7237E-DB0C-436C-6666-8C3A560EE688','保存',1)
GO
--管理通知
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('A273E955-7C84-48C2-A715-CBBBA1952921','管理通知','Common/Notice/NoticeMain.aspx',40,'0','1')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('7A07FD8A-18FC-44D4-ACDC-E4F80C6122B5','通知信息','Common/Notice/Notice.aspx',10,'A273E955-7C84-48C2-A715-CBBBA1952921','1')
GO
/*通知信息*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5AB4B812-1819-447F-ADCC-3CBEC8F420DF','7A07FD8A-18FC-44D4-ACDC-E4F80C6122B5','编制',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('19AE8C73-7EDB-4861-8A93-B9AF50E3965B','7A07FD8A-18FC-44D4-ACDC-E4F80C6122B5','审核',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A2103B12-5636-4F60-8F79-F7C8A94E3113','7A07FD8A-18FC-44D4-ACDC-E4F80C6122B5','发布',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B331B2F0-BD38-4CD5-8FA4-6DB0E9806C9A','7A07FD8A-18FC-44D4-ACDC-E4F80C6122B5','删除',4)
GO
--------------------------------------本部管道焊接管理菜单---------------------------------------------------------
--1.基础信息
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','基础信息','HJGLServer/BaseInfo/BaseInfoMain.aspx',30,'0','2')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0004','焊接耗材','HJGLServer/BaseInfo/Consumables.aspx',10,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/*焊接耗材*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1E193A67-E2D5-400F-98BE-2B3A05335546','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('032C8DB7-2C1F-4291-8244-306FA16B94BE','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2703783E-24AB-42FD-8790-0C3BD35B3552','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1808F8E6-6262-4F87-A412-73EBB60892E4','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0005','管道等级','HJGLServer/BaseInfo/PipingClass.aspx',20,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 管道等级*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E00BCE41-533C-4BCA-B084-80007043EA54','8IDKGJE2-09B1-4607-BC6D-865CE48F0005','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B0343477-CC63-4ED4-B40B-717ACBCEC5AC','8IDKGJE2-09B1-4607-BC6D-865CE48F0005','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B632B014-AC4C-4075-8868-C81ABED701A3','8IDKGJE2-09B1-4607-BC6D-865CE48F0005','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A372B682-D0B6-4E6A-ADB5-5EA5B4FD6D25','8IDKGJE2-09B1-4607-BC6D-865CE48F0005','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0006','探伤类型','HJGLServer/BaseInfo/Testing.aspx',30,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 探伤类型*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E5E8A2EB-3A80-4EE9-B52B-C26D00BB9E6C','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CF424331-437A-4370-AE8C-535F056F844A','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F8AB6EAC-0876-49AB-8DC0-5FC8F00C84DE','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('269B46E5-E19D-4674-8D74-23E0781448A2','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0007','探伤比例','HJGLServer/BaseInfo/Detection.aspx',40,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 探伤比例*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A413D13B-6676-42FE-854A-380C55B56088','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8C33319D-CE20-4A00-9B5C-F780FF2E1FFB','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AFB1B9E7-1A8F-4487-A9D3-40CB34482104','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6203310C-DF6A-4312-B919-9DDFF960355D','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0008','焊缝类型','HJGLServer/BaseInfo/Weld.aspx',50,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 焊缝类型*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('38E40FB4-E78E-42EA-BE7B-5729BCE72AB7','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B1781247-9041-439E-8C5B-EF27A5669C2C','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9E833270-5999-4123-A6BA-29065EF3C06F','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5F5A2871-817E-4680-BA11-61881FF35808','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0009','安装组件','HJGLServer/BaseInfo/Components.aspx',60,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 安装组件*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1800E4FC-660B-4652-B7C3-EE9908BA027F','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('384B6FC5-774C-4973-847F-7D6415CDBD93','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F6A26432-4784-4C42-B74E-3357A0296C6A','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4216FE64-F958-4C22-A5C4-FB57BE014CFB','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0010','焊接方法','HJGLServer/BaseInfo/WeldingMethod.aspx',70,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 焊接方法*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('04065212-71EC-483B-AA3D-F769DE121482','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('61364200-F089-4FDD-BAA5-E287931B0FB3','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('00CE2BA6-3A63-4128-8F8D-37513D02B24D','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('987E6311-125B-45EA-8DD3-A123DBF46CA8','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0012','坡口类型','HJGLServer/BaseInfo/Groove.aspx',80,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 坡口类型*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('42A1802E-6737-4F8F-A3C0-EC175D0592F1','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('383C86B7-4FE5-4B04-ABE7-67BB2973BEDC','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CE4E21E0-078C-4191-A82F-97A386321C76','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3AB4E1A9-8ED2-412A-B881-8036C4AE368B','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0013','材质定义','HJGLServer/BaseInfo/Material.aspx',90,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 材质定义*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A1B90885-A8B5-4FAF-9853-506343DEAD73','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FF2641B8-9BAB-4FC2-B23E-1AE864A81B74','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D2BAEB0D-B750-40A3-8513-D93E29A8EB42','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D252408C-1E93-4C55-8C5B-950FB4D6DA34','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0014','介质定义','HJGLServer/BaseInfo/Medium.aspx',100,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 介质定义*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FC72F514-770E-4505-84FE-1C2AC2863841','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('704693F6-451E-4E31-A5DF-903EFF869198','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9C169401-2881-4017-88FF-10B61A3EE215','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BAC48F7B-F46D-4DEC-A2DE-24017345ECC7','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('868609F8-9C01-4982-85D1-D6B4862A8A78','材质标准','HJGLServer/BaseInfo/MaterialStandard.aspx',110,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/*材质标准*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('970B1E39-5249-44E3-AFAA-474681627CD0','868609F8-9C01-4982-85D1-D6B4862A8A78','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('53566F36-455B-44FC-BCB0-010ECE2AE888','868609F8-9C01-4982-85D1-D6B4862A8A78','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DA07B8ED-3385-41A0-A06D-3A5F11F09F26','868609F8-9C01-4982-85D1-D6B4862A8A78','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E0FFE3F0-FFB7-4CF5-A227-1A36C930997A','868609F8-9C01-4982-85D1-D6B4862A8A78','保存',4)
GO
/* 执行标准*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('7494F93E-9FC0-4C90-B0CA-79C1C04C53B9','执行标准','HJGLServer/BaseInfo/ExecStandard.aspx',120,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E5733D46-97B2-408F-9669-D04B207447FD','7494F93E-9FC0-4C90-B0CA-79C1C04C53B9','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D962C5FB-1F18-4530-9247-399A81677919','7494F93E-9FC0-4C90-B0CA-79C1C04C53B9','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DB6C8235-7C97-45E4-884D-EDB691843ABF','7494F93E-9FC0-4C90-B0CA-79C1C04C53B9','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FB02624A-7E06-430F-B2F1-A0DD58263792','7494F93E-9FC0-4C90-B0CA-79C1C04C53B9','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0015','试压类型','HJGLServer/BaseInfo/Pressure.aspx',130,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 试压类型*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2126E363-A52D-4273-880F-94B3630EBBAF','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A81AADEA-C323-4490-9CF4-62B692E50660','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FDCF4E29-13CA-4530-919B-D05C74661318','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('956A46CB-E71D-4A48-935B-81B04021F0E8','8IDKGJE2-09B1-4607-BC6D-865CE48F0015','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0011','直径寸径对照','HJGLServer/BaseInfo/Control.aspx',140,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 直径寸径对照*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3E07B93B-EEE8-4C10-9958-0DE783C85E3E','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E70CC7E6-FC94-4DD6-8139-59B6E44A2E20','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1A33107D-DFFF-47B5-85EB-50A50EE614D1','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8F491AB1-D386-4AAE-AE71-8762DCC8C8CF','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('671B079F-5576-42D7-BEDE-16C6E496BA67','材质焊材对照','HJGLServer/BaseInfo/MaterialCompare.aspx',150,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('56583D24-13A2-4624-AFA3-F6950AB405ED','671B079F-5576-42D7-BEDE-16C6E496BA67','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A1F7891D-B5AE-44A7-AF1D-D23D685B6D1A','671B079F-5576-42D7-BEDE-16C6E496BA67','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0694E454-EFA2-4420-B92D-4859FDAE327C','671B079F-5576-42D7-BEDE-16C6E496BA67','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7803340C-7DC3-406E-8FB7-4DBC4CB1B2B4','671B079F-5576-42D7-BEDE-16C6E496BA67','保存',4)
GO
/* 检测类型/组批条件*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('7BF4C0C9-C7B9-4925-9C9B-D6AACB067AC9','焊缝检测比例对照表','HJGLServer/BaseInfo/WeldControl.aspx',160,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('94900012-C791-49DC-93FC-4F149E9777C2','7BF4C0C9-C7B9-4925-9C9B-D6AACB067AC9','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('972CFA6D-328D-4FE7-A930-9339300B519E','7BF4C0C9-C7B9-4925-9C9B-D6AACB067AC9','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('88EFEDA2-0529-4971-ACD4-A8F210361935','7BF4C0C9-C7B9-4925-9C9B-D6AACB067AC9','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C2478EAD-0B87-4423-9136-CAB2ACF65BD6','7BF4C0C9-C7B9-4925-9C9B-D6AACB067AC9','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('D097AB27-F2EE-4184-9191-1BDB21C7CFA2','设备','HJGLServer/BaseInfo/Equipment.aspx',170,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/*设备管理*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('574D554C-C49E-4FAF-BAD0-9CDE114A6DB2','D097AB27-F2EE-4184-9191-1BDB21C7CFA2','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('96071CE1-A17E-4703-A91F-43874CFCD848','D097AB27-F2EE-4184-9191-1BDB21C7CFA2','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('69FEEF41-6D9E-4F89-B8D3-B8CF68C810AC','D097AB27-F2EE-4184-9191-1BDB21C7CFA2','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B62E4444-6833-46D3-8566-64DFD6CA3702','D097AB27-F2EE-4184-9191-1BDB21C7CFA2','保存',4)
GO
/*焊评材质类别*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('ED7F4339-6598-40FE-86D4-AD4C8F06F045','焊评材质类别','HJGLServer/BaseInfo/MaterialClass.aspx',180,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 焊评材质类别*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2F95B8CC-42CF-4FC2-978C-36E771027931','ED7F4339-6598-40FE-86D4-AD4C8F06F045','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A1192E3D-6CAF-459A-AA93-E1930E520202','ED7F4339-6598-40FE-86D4-AD4C8F06F045','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('229D75F1-2F8B-45BD-A5CB-6F9EAA0D8726','ED7F4339-6598-40FE-86D4-AD4C8F06F045','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('81D2EB6D-8074-4C75-9E9B-F1CF850DF73C','ED7F4339-6598-40FE-86D4-AD4C8F06F045','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('41E514DA-8991-43B6-A62D-E24F6C6825E8','焊评材质组别','HJGLServer/BaseInfo/MaterialGroup.aspx',190,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 焊评材质组别*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BF73E4AD-68C8-466D-ACF5-4F36F4F6441B','41E514DA-8991-43B6-A62D-E24F6C6825E8','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7ED4C0CF-FD89-4090-B943-D1DB8EA3EF53','41E514DA-8991-43B6-A62D-E24F6C6825E8','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2FBB35B0-54C6-40D2-A57C-30D67E5869D7','41E514DA-8991-43B6-A62D-E24F6C6825E8','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6F0270DA-35E9-4443-BE3C-DDC7CA135DA2','41E514DA-8991-43B6-A62D-E24F6C6825E8','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('30616AA4-73BA-4869-B78E-60C8D264F918','焊评标准','HJGLServer/BaseInfo/Standard.aspx',200,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/* 焊评标准*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9F71E6B5-5484-4D11-80A8-99EC08AFA288','30616AA4-73BA-4869-B78E-60C8D264F918','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F60279E6-45C0-421D-A135-B952C623ED0F','30616AA4-73BA-4869-B78E-60C8D264F918','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8E6F7C6B-6DE2-46CE-A2D4-9415ACBD671F','30616AA4-73BA-4869-B78E-60C8D264F918','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AE227BE3-28CD-47F9-8BE4-7F394F4DE82D','30616AA4-73BA-4869-B78E-60C8D264F918','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('D43D24E2-2A7F-4DB2-8725-FB4317A98A13','焊接接头简图','HJGLServer/BaseInfo/JointImage.aspx',210,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/*焊接接头简图*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4AF0C876-2B93-4FFB-9636-F20AEB377A6E','D43D24E2-2A7F-4DB2-8725-FB4317A98A13','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0F3B2AE0-9DCD-44D7-8684-DD23386B673C','D43D24E2-2A7F-4DB2-8725-FB4317A98A13','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AF8024E7-5438-42BA-AD02-67371A910FC4','D43D24E2-2A7F-4DB2-8725-FB4317A98A13','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('58FC87A5-6E1B-4603-BDA1-F24C64D22F2B','D43D24E2-2A7F-4DB2-8725-FB4317A98A13','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('A210A562-FD47-4A2E-BCA3-25DD5DB1BB3C','热处理工艺卡目录','HJGLServer/BaseInfo/HotProcessCard.aspx',220,'2D39CA91-94B2-48F2-ACBA-D5DBC294F75D','2')
GO
/*焊接接头简图*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('742BD44F-0917-4EED-B990-010C8A26117A','A210A562-FD47-4A2E-BCA3-25DD5DB1BB3C','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('952B445E-8784-4D91-B934-3E888A1D7403','A210A562-FD47-4A2E-BCA3-25DD5DB1BB3C','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('442123CA-5EC0-4215-9D0F-E534D298A74F','A210A562-FD47-4A2E-BCA3-25DD5DB1BB3C','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8DF03F16-CAF0-4CF3-8BB5-4890C433736E','A210A562-FD47-4A2E-BCA3-25DD5DB1BB3C','保存',4)
GO
--2.工艺评定
--本部
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('1D009522-D2C6-4256-B4FB-3E5E061A23D7','工艺评定','',40,'0','2')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','焊接工艺评定台账','HJGLServer/WeldingManage/WeldingProcedure.aspx',10,'1D009522-D2C6-4256-B4FB-3E5E061A23D7','2')
GO
/*焊接工艺评定台账*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8329629E-4643-4198-80E6-484D1C6EDEED','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F722D1DE-20A1-4583-A5FF-C1C4382224FE','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A42C1619-A6AE-44BB-B8A6-DAD4ED8A8EA5','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FFAB108F-2424-40A8-85AE-729378681A9D','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('46FE8A9E-4739-4758-9D16-FF82904789F6','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','导入',5)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('274C462B-3E47-4970-8492-51C2F3603BF5','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','导出',6)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,Url, SortIndex, SuperMenu,MenuModule)
VALUES('C3D3402A-B7B2-4887-97B0-6211D21469DC','检测工艺参数','HJGLServer/WeldingManage/TestingParameters.aspx',20,'1D009522-D2C6-4256-B4FB-3E5E061A23D7','2')
GO
/*检测工艺参数*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9DBCB005-849A-404B-A108-5735AD09AB97','C3D3402A-B7B2-4887-97B0-6211D21469DC','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('78752E2C-83AF-405C-A3E9-B79870419DBD','C3D3402A-B7B2-4887-97B0-6211D21469DC','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8071886C-5C55-4562-AE9F-4859D9672E8E','C3D3402A-B7B2-4887-97B0-6211D21469DC','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('54A06D12-8065-4E85-9E3C-09CEF02FEE3D','C3D3402A-B7B2-4887-97B0-6211D21469DC','保存',4)
GO
--5.文件控制 本部
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','文件控制','',50,'0','2')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('E968A3B0-8BEF-4584-9589-4DF32F46A757','国内法律法规相关条款','HJGLServer/FileControl/DomesticLawsRegulations.aspx',10,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('409F8953-FCA2-4F5D-B954-89D56CA97CAA','E968A3B0-8BEF-4584-9589-4DF32F46A757','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('358DAC0D-2A60-4DE4-A482-4CE0E1EC5516','E968A3B0-8BEF-4584-9589-4DF32F46A757','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('40406101-A91C-432C-92CF-0A0188BA8771','E968A3B0-8BEF-4584-9589-4DF32F46A757','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('3BB329CD-6673-4650-A6A9-9D48B33F1FE6','E968A3B0-8BEF-4584-9589-4DF32F46A757','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('44141764-C129-4E0B-A548-BB30748FB28A','国内现行相关标准规范','HJGLServer/FileControl/DomesticStandards.aspx',20,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B562C642-EFB7-44F5-B8D0-3E8C78708FAE','44141764-C129-4E0B-A548-BB30748FB28A','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A8A25829-F500-4E0D-99E7-EFBC71C530F5','44141764-C129-4E0B-A548-BB30748FB28A','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D43342FA-DA11-45D7-8B16-80D18ACB1993','44141764-C129-4E0B-A548-BB30748FB28A','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('28E65E43-B60C-4F03-A09E-36CE6B4CC48B','44141764-C129-4E0B-A548-BB30748FB28A','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('49F3E237-B051-41A3-8842-7309F11E4BF8','国外现行相关标准规范','HJGLServer/FileControl/ForeignStandards.aspx',30,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('541D1948-3C53-4CAF-91F1-3DC80373A1E9','49F3E237-B051-41A3-8842-7309F11E4BF8','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8BE81113-77D3-44E2-AA64-1A0142F55868','49F3E237-B051-41A3-8842-7309F11E4BF8','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8826FB28-2253-444B-B332-C602A53585E8','49F3E237-B051-41A3-8842-7309F11E4BF8','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8432498B-F9EA-406D-B7F4-6C1A47F5318A','49F3E237-B051-41A3-8842-7309F11E4BF8','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','公司相关规章制度标准','HJGLServer/FileControl/CompanyStandards.aspx',40,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('04F97EA7-BFB5-4337-AC28-1BC6B53C8CE2','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('4FFB1B3C-C276-4328-9AE1-3F6C0B505528','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('CA2EC179-FBC0-44CD-A0C2-7F6660D45CA4','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('FBD32CBA-6634-4130-B22B-1892E43A6E3D','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','保存',4)
GO
--------------------------------------现场管道焊接管理菜单---------------------------------------------------------
--1.焊接管理
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-4607-6666-DCC3O48F080F','施工管理','HJGL/WeldingManage/WeldingManageMain.aspx',10,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('8IDKGJE2-09B1-6UIO-6666-5TGED48F0001','工艺管线参数设置','HJGL/WeldingManage/PipelineManage.aspx',10,'8IDKGJE2-09B1-4607-6666-DCC3O48F080F','3')
GO
/*管线管理*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0BBB44E1-254E-4420-9531-A627A7D5258B','8IDKGJE2-09B1-6UIO-6666-5TGED48F0001','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A4D55469-B958-473E-8D29-D80A6E81E93F','8IDKGJE2-09B1-6UIO-6666-5TGED48F0001','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CEDF64ED-B32A-4EEB-B014-5D5BC1925EF0','8IDKGJE2-09B1-6UIO-6666-5TGED48F0001','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('20F05C73-5EE0-4714-BD42-3F6743ED6A19','8IDKGJE2-09B1-6UIO-6666-5TGED48F0001','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('32F5CC8C-E0F4-456C-6666-77E36269FA50','焊口信息设置','HJGL/WeldingManage/JointInfo.aspx',20,'8IDKGJE2-09B1-4607-6666-DCC3O48F080F','3')
GO
/*焊口信息管理*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('94111C7E-7505-42F0-8999-259D98DCC62C','32F5CC8C-E0F4-456C-6666-77E36269FA50','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('59E26E2F-5D07-4F48-B45A-D779288DE252','32F5CC8C-E0F4-456C-6666-77E36269FA50','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('535E1C03-4614-460E-86C7-B05C32DA69BC','32F5CC8C-E0F4-456C-6666-77E36269FA50','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5D975555-11DD-455D-AAF6-B4817C5E77BF','32F5CC8C-E0F4-456C-6666-77E36269FA50','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('990A5B54-EFCB-43D1-ACA6-578C79BA0225','32F5CC8C-E0F4-456C-6666-77E36269FA50','打印',5)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3E8144C8-CFC9-4218-9130-838001820B61','32F5CC8C-E0F4-456C-6666-77E36269FA50','导出',6)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CC5CDF54-FBC6-429C-8FC1-127855486F20','32F5CC8C-E0F4-456C-6666-77E36269FA50','批量增加',7)
go
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
VALUES('AC69CD82-74FC-4561-8BC4-58A920348765','焊接记录预提交','HJGL/WeldingManage/PreWeldReportMain.aspx','25','8IDKGJE2-09B1-4607-6666-DCC3O48F080F','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('098E2B04-9629-46C8-A820-3219B757228B','AC69CD82-74FC-4561-8BC4-58A920348765','审核',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('5TYHMD2F-2582-4DEB-6666-6E9DCFEFBGHO','焊接记录上交','HJGL/WeldingManage/WeldReport.aspx',30,'8IDKGJE2-09B1-4607-6666-DCC3O48F080F','3')
GO
/*焊接日报*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F92EF3A9-813D-424A-90F6-AB9A4C769B14','5TYHMD2F-2582-4DEB-6666-6E9DCFEFBGHO','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DAC01EFD-815A-4B8F-BE97-807A2A711B89','5TYHMD2F-2582-4DEB-6666-6E9DCFEFBGHO','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7542BB0D-B30D-4E32-8521-F8784D89CA95','5TYHMD2F-2582-4DEB-6666-6E9DCFEFBGHO','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D56DBB51-00A4-40DF-B168-D6436863B856','5TYHMD2F-2582-4DEB-6666-6E9DCFEFBGHO','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1524C376-20F5-4073-BE49-F4E6F849C865','5TYHMD2F-2582-4DEB-6666-6E9DCFEFBGHO','打印',5)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2EB02766-4D89-4852-8267-C0EDECB0AAE0','5TYHMD2F-2582-4DEB-6666-6E9DCFEFBGHO','导出',6)
go
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu, MenuModule)
--VALUES('FFAAA6B0-9BB1-4872-B95D-CE9E56F7C2C5','单线图焊缝信息查看','HJGL/WeldingManage/IsoInfoFrame.aspx',40,'8IDKGJE2-09B1-4607-6666-DCC3O48F080F','3')
--GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu, MenuModule)
VALUES('6FC1CFE0-6BF4-4E92-998E-D15408D8E1F2','检测报告编制提示','HJGL/WeldingManage/TestingReportPrompt.aspx',50,'8IDKGJE2-09B1-4607-6666-DCC3O48F080F','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B52D0323-4845-4DA9-A7F7-2C00FD76D0AC','6FC1CFE0-6BF4-4E92-998E-D15408D8E1F2','编辑完成报告反馈',1)
go
--2.无损委托
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('4F07D4BF-5971-4D3C-6666-B2ACA8CD82FF','检验委托管理','HJGL/TrustManage/TrustManageMain.aspx',20,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','检验批委托','HJGL/WeldingManage/PointManage.aspx',10,'4F07D4BF-5971-4D3C-6666-B2ACA8CD82FF','3')
GO
/*点口管理*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B81B3DEC-22F8-4805-A31B-AE752AA7BA38','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','批打开',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('22443307-40BC-4CDF-9C1B-68866A1C8C13','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','批关闭',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8E69A9C8-09AA-455E-8921-48CDBFED8073','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','点口确认',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('59ED44C1-C094-4976-A67B-A8ED66302264','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','生成委托单',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A2311E00-996B-4AD6-A812-68FA4A2B3C39','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','打印',5)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5922FD52-2601-47C2-8DF4-DA4669756989','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','外观检验确认',6)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('57B10BA0-1F92-44F6-9AC1-C80060B856AE','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','取消委托确认',7)
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3225E61C-8781-4F32-B614-943121D4B46C','3ACE25CE-C5CE-4CEC-6666-0D5CF1DF2F01','删除',8)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('93BBEACB-90BE-45B2-BA38-3250EA52A40E','检验批查询','HJGL/WeldingManage/PointManageMove.aspx',15,'4F07D4BF-5971-4D3C-6666-B2ACA8CD82FF','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('10123AB9-2CC1-494A-6666-FEAB50FCACBE','检测委托单信息及打印','HJGL/TrustManage/TrustManageEdit.aspx',20,'4F07D4BF-5971-4D3C-6666-B2ACA8CD82FF','3')
GO
/*无损委托单录入*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('44970368-CA80-425C-A832-5012A633CD21','10123AB9-2CC1-494A-6666-FEAB50FCACBE','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0DA6CF78-D623-4016-8AE1-2B8F12835D01','10123AB9-2CC1-494A-6666-FEAB50FCACBE','删除',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('36D91461-EED0-4124-988B-00A878FCFF3C','10123AB9-2CC1-494A-6666-FEAB50FCACBE','打印',3)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('58676138-53A1-4CB7-A0D3-87EE24243E96','返修焊缝委托','HJGL/WeldingManage/RepairItemRecordTrust.aspx',23,'4F07D4BF-5971-4D3C-6666-B2ACA8CD82FF','3')
GO
/*返修焊缝委托*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('27297E8A-CA8C-45B9-AE82-BCCE55B99B69','58676138-53A1-4CB7-A0D3-87EE24243E96','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2C7EC206-9B56-4E41-83A6-9FC910F065EE','58676138-53A1-4CB7-A0D3-87EE24243E96','扩拍',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('78B684AC-8E89-47F3-8903-E259EE794369','58676138-53A1-4CB7-A0D3-87EE24243E96','取消委托确认',3)
go
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
--VALUES('DDAB7C10-91C3-4DE0-6666-4F055A95235F','无损委托单审核','HJGL/TrustManage/TrustManageAudit.aspx',20,'4F07D4BF-5971-4D3C-6666-B2ACA8CD82FF','3')
--GO
--/*无损委托单审核*/
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('71861DE4-0412-4BAC-BBF1-C776331F9CDB','DDAB7C10-91C3-4DE0-6666-4F055A95235F','审核',1)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A4DC4A5C-6BF2-4FD3-93FA-F51063E44EF5','DDAB7C10-91C3-4DE0-6666-4F055A95235F','打印',2)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('16BCC62B-5E6C-4452-B6C4-B83D67136E6F','DDAB7C10-91C3-4DE0-6666-4F055A95235F','保存',3)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('04CED345-AA5E-4277-B8BA-1A47FEDEE3FD','DDAB7C10-91C3-4DE0-6666-4F055A95235F','提交',4)
--go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('352C276B-0E56-4DB5-6666-2385AD1E51B1','返修焊缝委托单信息及打印','HJGL/RepairManage/RepairManageEdit.aspx',30,'4F07D4BF-5971-4D3C-6666-B2ACA8CD82FF','3')
GO
/*返修委托单录入*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F4C2F6F4-6EE6-45E3-AB62-319EAC339785','352C276B-0E56-4DB5-6666-2385AD1E51B1','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EE28F050-0CD5-4904-8100-0130854DA8C8','352C276B-0E56-4DB5-6666-2385AD1E51B1','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3734237E-42ED-4944-A237-F3206A015E1D','352C276B-0E56-4DB5-6666-2385AD1E51B1','打印',4)
go
--3.检测管理
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('29D556E6-9131-4437-6666-63F5902FDBCE','检测数据管理','HJGL/CheckManage/CheckManageMain.aspx',30,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('CDECC461-1897-4D88-6666-0824E540F565','检测结果录入','HJGL/CheckManage/CheckManage.aspx',10,'29D556E6-9131-4437-6666-63F5902FDBCE','3')
GO
/*检测单录入*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('16D464E3-F010-452D-8A58-6FC35A94AE7D','CDECC461-1897-4D88-6666-0824E540F565','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CF996CDD-14C2-4D1E-B809-E9A785928376','CDECC461-1897-4D88-6666-0824E540F565','编辑质量等级评定',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7D6F0130-8367-4602-B88E-1985D0D00349','CDECC461-1897-4D88-6666-0824E540F565','生成返修委托单',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('592A225E-B29D-4501-9015-E81C6AB54A44','CDECC461-1897-4D88-6666-0824E540F565','打印',4)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('F4A17CDA-5210-4980-BC5B-96C78281D460','RT质量等级评定','HJGL/CheckManage/RTQualityRating.aspx',12,'29D556E6-9131-4437-6666-63F5902FDBCE','3')
GO
/*RT质量等级评定*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('995787AA-C7F9-424F-ABC6-933C45B59EBA','F4A17CDA-5210-4980-BC5B-96C78281D460','编辑质量等级评定',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('040EFCDD-9670-431D-9C91-4006A686E76C','F4A17CDA-5210-4980-BC5B-96C78281D460','生成返修委托单',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1DD8E604-0635-447D-B3BC-1DFA106B4042','F4A17CDA-5210-4980-BC5B-96C78281D460','打印',3)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('EA83EFF2-3223-4E65-AB50-C51BA0B5C353','MT,PT,UT质量等级评定','HJGL/CheckManage/NonRTQualityRating.aspx',14,'29D556E6-9131-4437-6666-63F5902FDBCE','3')
GO
/*MT,PT,UT质量等级评定*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A6AA0B17-C22B-43FE-AF1C-8F9E70387FB1','EA83EFF2-3223-4E65-AB50-C51BA0B5C353','编辑质量等级评定',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BE7A7B0B-82AA-499D-870B-7B6096F88C25','EA83EFF2-3223-4E65-AB50-C51BA0B5C353','生成返修委托单',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('54FCE446-04CB-4D88-980F-36EF11B16D96','EA83EFF2-3223-4E65-AB50-C51BA0B5C353','打印',3)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('3FB934E7-BEFF-48BA-6666-268780FA1CE2','返修检测结果录入','HJGL/RepairManage/RepairResultManage.aspx',20,'29D556E6-9131-4437-6666-63F5902FDBCE','3')
GO
/*返修检测结果录入及查询*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B528A641-E79B-4DA4-A220-C4D8E192CA89','3FB934E7-BEFF-48BA-6666-268780FA1CE2','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5F0BBEB7-DBE8-4822-AA13-E3A68CC79FF6','3FB934E7-BEFF-48BA-6666-268780FA1CE2','编辑质量等级评定',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B11ED000-2077-4310-A1BA-B4F1AB77ACE6','3FB934E7-BEFF-48BA-6666-268780FA1CE2','生成返修委托单',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E94492AE-80C7-4732-A0B5-E32DE3F49C76','3FB934E7-BEFF-48BA-6666-268780FA1CE2','打印',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('04848983-735D-4BC3-B215-0EB6F48C6822','检测记录打印','HJGL/CheckManage/CheckRecordPrint.aspx',30,'29D556E6-9131-4437-6666-63F5902FDBCE','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('3122F36F-6142-47DE-8ADF-0083BBBCA7C1','检测报表打印','HJGL/CheckManage/TestingReportPrint.aspx',40,'29D556E6-9131-4437-6666-63F5902FDBCE','3')
GO
--4.热处理/硬度管理
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('7FE911EF-616A-4F04-6666-E53E633A9E86','热处理管理','HJGL/HotHardManage/HotHardManageMain.aspx',40,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('C13DBFD6-FC8C-4E20-83D6-B9882AD76BB2','热处理委托及打印','HJGL/HotProessManage/HotProessTrust.aspx',10,'7FE911EF-616A-4F04-6666-E53E633A9E86','3')
GO
/*热处理管理*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('74979E64-8FB3-4FC7-BA68-0F3D7F0187BF','C13DBFD6-FC8C-4E20-83D6-B9882AD76BB2','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('15BC4DD7-87DD-44D8-A7D2-ED09FBC9012C','C13DBFD6-FC8C-4E20-83D6-B9882AD76BB2','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0276B159-EFEE-4945-8E49-1DBDBAEBBA83','C13DBFD6-FC8C-4E20-83D6-B9882AD76BB2','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AC522070-705D-4030-8ADD-FDB0AA52F782','C13DBFD6-FC8C-4E20-83D6-B9882AD76BB2','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('27F246B0-9A33-4FE3-BCF1-8D44224EA59C','C13DBFD6-FC8C-4E20-83D6-B9882AD76BB2','打印',5)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EEF8CC11-C2AF-4F16-A9D7-9D3C6DD68D25','C13DBFD6-FC8C-4E20-83D6-B9882AD76BB2','是否打印控制',6)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('90579BE7-E38C-4CD2-6666-755169FF3BB2','热处理数据录入','HJGL/HotProessManage/HotProessManageEdit.aspx',20,'7FE911EF-616A-4F04-6666-E53E633A9E86','3')
GO
/*热处理管理*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D69D4C93-82C7-4E1D-B65C-430C827BF0F2','90579BE7-E38C-4CD2-6666-755169FF3BB2','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('003C0736-152A-44B8-9D36-A455494BF4C0','90579BE7-E38C-4CD2-6666-755169FF3BB2','打印',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('3D0522B2-9136-4DE2-9CCC-BDEAB3EF1749','热处理反馈及硬度委托','HJGL/HotProessManage/HotProessResult.aspx',30,'7FE911EF-616A-4F04-6666-E53E633A9E86','3')
GO
/*热处理结果反馈*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1F480478-12E8-4B8C-9B10-45B684C24C61','3D0522B2-9136-4DE2-9CCC-BDEAB3EF1749','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('1AB18551-CD96-4241-818F-515FE4D4DF20','热处理及硬度数据查询','HJGL/HotProessManage/HotProessHardSelect.aspx',40,'7FE911EF-616A-4F04-6666-E53E633A9E86','3')
GO
/*热处理及硬度数据查询*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2D3A22B0-9E6D-4602-8FB3-C8DADEF4E48A','1AB18551-CD96-4241-818F-515FE4D4DF20','导出',1)
GO
--4.热处理/硬度管理
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('AEF69BC0-6AE6-4C02-B456-97E4ED8BE3D3','理化管理','HJGL/HotHardManage/HotHardManageMain.aspx',50,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('72B3E508-1315-4CC3-6666-E840FA701A0E','硬度委托及打印','HJGL/HotHardManage/HotHardManageEdit.aspx',10,'AEF69BC0-6AE6-4C02-B456-97E4ED8BE3D3','3')
GO
/*硬度委托录入*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0374A8DD-7861-4C76-8EE4-A004125E2D43','72B3E508-1315-4CC3-6666-E840FA701A0E','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BEDE8BB0-DA9F-40ED-B401-811819AF224E','72B3E508-1315-4CC3-6666-E840FA701A0E','打印',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('DE6F5EC4-28DA-4603-ADC4-ED7BCEAFDEB2','硬度检验报告','HJGL/HotHardManage/HardTestReport.aspx',20,'AEF69BC0-6AE6-4C02-B456-97E4ED8BE3D3','3')
GO
/*硬度检验报告*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CDF6BB31-797C-4538-BB83-B0D7CD9CF960','DE6F5EC4-28DA-4603-ADC4-ED7BCEAFDEB2','保存',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5FAA68CC-35FF-4FB9-B90F-DBFA9F8D9037','DE6F5EC4-28DA-4603-ADC4-ED7BCEAFDEB2','打印',2)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('359320A4-D9F7-4462-B8D3-64FECFA5261C','硬度检验结果反馈','HJGL/HotHardManage/HardTestResult.aspx',30,'AEF69BC0-6AE6-4C02-B456-97E4ED8BE3D3','3')
GO
/*硬度检验结果反馈*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('623F47B4-4725-4362-BA58-D2EACFD8AB62','359320A4-D9F7-4462-B8D3-64FECFA5261C','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('027BE96F-4C76-41FE-852D-2DC37BBA2D4C','硬度检验报告查询','HJGL/WeldingReport/HardTestReportRecord.aspx',130,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
--VALUES('D8084A7D-6240-4145-6666-4ADA33E7687B','返修委托单审核','HJGL/RepairManage/RepairManageAudit.aspx',20,'3B318A38-052E-4682-6666-52618A8E9840','3')
--GO
--/*返修委托单审核*/
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('54DFBA29-439E-41F9-BC45-6A7C77E9BD21','D8084A7D-6240-4145-6666-4ADA33E7687B','审核',1)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A2C5DA63-CB2B-41FD-A545-E12735E5EFC1','D8084A7D-6240-4145-6666-4ADA33E7687B','打印',2)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('983CA74B-D648-43D6-9DD4-5DDB9AA8F5DD','D8084A7D-6240-4145-6666-4ADA33E7687B','保存',3)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('40BB3DF4-F2C8-4C2D-8761-9F89A48FB8BE','D8084A7D-6240-4145-6666-4ADA33E7687B','提交',4)
--go
--6.试压管理
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('A24B7926-EF69-456E-6666-936D30384680','试压管理','HJGL/TestPackageManage/TestPackageManageMain.aspx',70,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('1C6F9CA9-FDAC-4CE5-6666-5536538851E1','试压包信息反馈','HJGL/TestPackageManage/TestPackageManage.aspx',10,'A24B7926-EF69-456E-6666-936D30384680','3')
GO
/*试压包录入*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3436F897-B8A6-4E8E-8F9C-355BCA7288DE','1C6F9CA9-FDAC-4CE5-6666-5536538851E1','编辑要求完成日期',1)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('55976B16-2C33-406E-6666-2FE42D031071','试压包记录编辑','HJGL/TestPackageManage/TestPackageManageAudit.aspx',20,'A24B7926-EF69-456E-6666-936D30384680','3')
GO
/*试压包审核*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('68FE879D-2AE6-4341-943C-B320AF56412E','55976B16-2C33-406E-6666-2FE42D031071','审核',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0F37F068-B2CF-4168-B23C-859ED0F669DB','55976B16-2C33-406E-6666-2FE42D031071','打印',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BE346D75-1EDE-422C-BD58-D6EF00F9CFC7','55976B16-2C33-406E-6666-2FE42D031071','保存',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6FDB62DF-BFA3-42A2-ABAF-5205E9B68774','55976B16-2C33-406E-6666-2FE42D031071','提交',4)
go
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
--VALUES('24941EDC-CED6-4176-6666-EB5F08156D08','A项尾工录入','HJGL/TestPackageManage/AItemEndCheck.aspx',30,'A24B7926-EF69-456E-6666-936D30384680','3')
--GO
--/*A项尾工录入*/
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B8F9EF46-DAAB-47D6-A53B-B93C69B86464','24941EDC-CED6-4176-6666-EB5F08156D08','增加',1)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C65DB885-AFAA-4502-8E09-8EA8F17722D4','24941EDC-CED6-4176-6666-EB5F08156D08','修改',2)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('58DB0A99-F610-4BF9-B8E2-58D715130FC2','24941EDC-CED6-4176-6666-EB5F08156D08','删除',3)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B08B00E1-E9C4-407B-A579-41838DDCA878','24941EDC-CED6-4176-6666-EB5F08156D08','保存',4)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E1049225-0934-404E-8289-BAFB72B508AC','24941EDC-CED6-4176-6666-EB5F08156D08','打印',5)
--go
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
--VALUES('B7EF02DC-45AB-4CFB-6666-8340D85D57AD','B项尾工录入','HJGL/TestPackageManage/BItemEndCheck.aspx',40,'A24B7926-EF69-456E-6666-936D30384680','3')
--GO
--/*B项尾工录入*/
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('57C09648-FBE0-4E25-87F3-A318A974CB57','B7EF02DC-45AB-4CFB-6666-8340D85D57AD','增加',1)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3A5E6CE7-6F06-4C51-B6C5-2BF8A73F3101','B7EF02DC-45AB-4CFB-6666-8340D85D57AD','修改',2)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('55DE9CC1-7EAF-4B85-A5C1-F4858F787874','B7EF02DC-45AB-4CFB-6666-8340D85D57AD','删除',3)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F2970212-DC6D-4D1B-A13B-B8B6FD24F589','B7EF02DC-45AB-4CFB-6666-8340D85D57AD','保存',4)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F4CA35E9-40BA-46C5-9E2B-DD9C088412C8','B7EF02DC-45AB-4CFB-6666-8340D85D57AD','打印',5)
--go
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
--VALUES('82951D78-9029-4F69-6666-00C47551B3E6','试压包完成','HJGL/TestPackageManage/TestPackageManageView.aspx',50,'A24B7926-EF69-456E-6666-936D30384680','3')
--GO
--/*试压包完成*/
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B0D0D3A0-57C6-40F9-AD77-585E6F6068E5','82951D78-9029-4F69-6666-00C47551B3E6','审核',1)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5D5A2C99-061B-4EC5-B9FF-D7101E8D822C','82951D78-9029-4F69-6666-00C47551B3E6','打印',2)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8B5E66C7-0245-4353-9318-5C6164D0E1AF','82951D78-9029-4F69-6666-00C47551B3E6','保存',3)
--INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EF09FC23-894E-4F6D-A9AD-3CB0512653D8','82951D78-9029-4F69-6666-00C47551B3E6','提交',4)
--go
--7.焊接报表
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('F3B157B7-9BEE-4150-6666-087828F1C51D','焊接报表','HJGL/WeldingReport/WeldingReportMain.aspx',80,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('66A76F90-96A7-4C1F-6666-125DDEACEF52','单位工区进度分析','HJGL/WeldingReport/UnitWorkareaAnalyze.aspx',10,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
/*单位工区进度分析*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8F41CA4A-EAB4-4FEF-B2AC-63F7A1F7F5C7','66A76F90-96A7-4C1F-6666-125DDEACEF52','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('10057A9D-59AD-44EE-B33A-F8D7C4C76083','66A76F90-96A7-4C1F-6666-125DDEACEF52','导出',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('88CDDC68-54DE-4E24-6666-A33B80EC0E12','单位工区质量分析','HJGL/WeldingReport/UnitWorkAreaQuality.aspx',20,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
/*单位工区质量分析*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C5B87480-1E34-4C89-80B8-E1D3FA58A4F9','88CDDC68-54DE-4E24-6666-A33B80EC0E12','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AA330467-C0B3-4327-97A4-5E3E42004124','88CDDC68-54DE-4E24-6666-A33B80EC0E12','导出',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('41C22E63-36B7-4C44-6666-F765BFBB7C55','焊工业绩分析','HJGL/WeldingReport/WelderPerformance.aspx',30,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
/*焊工业绩分析*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A9CAF508-0C04-4007-B2B8-DF40A8BF043F','41C22E63-36B7-4C44-6666-F765BFBB7C55','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1935EDC9-C6B7-4912-9B22-1EB15FB03339','41C22E63-36B7-4C44-6666-F765BFBB7C55','导出',2)
go
/*管线综合分析*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('0ADD01FB-8088-4595-6666-6A73F332A229','项目工作量统计','HJGL/WeldingReport/IsoCmprehensive.aspx',40,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
/*管线综合分析*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5812B919-98CE-4503-A41D-3CC244AFE88C','0ADD01FB-8088-4595-6666-6A73F332A229','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9B5AC37F-FB75-41CF-AC29-7A26A21FDF9F','0ADD01FB-8088-4595-6666-6A73F332A229','导出',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('4DF486B0-7315-4CCE-A913-E8B1049E8DE3','焊接接头报检检查记录','HJGL/WeldingReport/WeldInspectionCheckRecord.aspx',100,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('05495F29-B583-43D9-6666-3384D6783A3F','预制安装进度','HJGL/WeldingReport/PrefabricatedInstall.aspx',50,'F3B157B7-9BEE-6666-80CB-087828F1C51D','3')
GO
/*预制安装进度*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('313136D7-31EB-4847-935C-7EEBDD2034B1','05495F29-B583-43D9-6666-3384D6783A3F','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('31EFACDC-2BB2-4786-91D2-B0CC179C9FA8','05495F29-B583-43D9-6666-3384D6783A3F','导出',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('575C5154-A135-4737-6666-A129EA717660','介质综合分析','HJGL/WeldingReport/MediaComprehensive.aspx',60,'F3B157B7-9BEE-6666-80CB-087828F1C51D','3')
GO
/*介质综合分析*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('11A51FB3-0279-42E9-A490-354EE9CC5D9D','575C5154-A135-4737-6666-A129EA717660','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2D9287CE-BF87-49B5-8EBA-E16DB7E63624','575C5154-A135-4737-6666-A129EA717660','导出',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('3E2F2FFD-ED2E-4914-6666-D97A68398814','探伤综合报告','HJGL/WeldingReport/DetectionAnalyze.aspx',70,'F3B157B7-9BEE-6666-80CB-087828F1C51D','3')
GO
/*探伤综合报告*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3CEDE82A-73EE-4210-A3FA-E7CB2906D08A','3E2F2FFD-ED2E-4914-6666-D97A68398814','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('57EEBF24-61F1-46A3-BA0D-A255CC87E1DA','3E2F2FFD-ED2E-4914-6666-D97A68398814','导出',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('0DC90447-F99B-4002-6666-7981A7837A1F','焊口综合信息','HJGL/WeldingReport/JointComprehensive.aspx',80,'F3B157B7-9BEE-6666-80CB-087828F1C51D','3')
GO
/*焊口综合信息*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0C633955-FE33-4ED9-90B7-0190F3DB4688','0DC90447-F99B-4002-6666-7981A7837A1F','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7463BA7A-E983-4269-AAEF-A28C31819187','0DC90447-F99B-4002-6666-7981A7837A1F','导出',2)
go
/*管线综合信息*/
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('CF3CB43C-4031-4CFD-6666-154DC1CB881E','项目管线参数查询','HJGL/WeldingReport/IsoCompreInfo.aspx',90,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
/*管线综合信息*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A07E0075-6589-4E4B-B506-5D56AB6B2E17','CF3CB43C-4031-4CFD-6666-154DC1CB881E','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BDBF2989-53B5-44E4-921C-C2F9A9551AD2','CF3CB43C-4031-4CFD-6666-154DC1CB881E','导出',2)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('50FCA1D5-2508-4B27-B509-61E347F2A052','检验批次检测比例确认表查询及打印','HJGL/WeldingReport/InspectionBatch.aspx',110,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('38995982-6BCB-4BBA-A5F7-1306C5D4473C','焊工焊接检测统计表','HJGL/WeldingReport/WelderCheckStatistic.aspx',31,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
/*焊工业绩分析*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7E1F0AF5-549E-47EE-AA4B-4805154699E4','38995982-6BCB-4BBA-A5F7-1306C5D4473C','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4DD6D459-EC45-4835-9DA8-5477B50B0D16','38995982-6BCB-4BBA-A5F7-1306C5D4473C','导出',2)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('0F927D41-7F2B-4642-9D9C-6EBB95448D24','管线焊接检测统计表','HJGL/WeldingReport/IsoCheckStatistics.aspx',41,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
/*管线焊接检测统计表*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9F9D5B9D-3021-4EB3-B3E8-0B516EEED5FA','0F927D41-7F2B-4642-9D9C-6EBB95448D24','统计',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DDDA6B43-447E-4C42-9D8F-0CA8D5F39D5A','0F927D41-7F2B-4642-9D9C-6EBB95448D24','导出',2)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('8350CF87-E36E-4F73-AFB3-1F3BF6D2B8C9','射线检测结果确认表','HJGL/WeldingReport/RTTestingResult.aspx',120,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
insert into dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
values('53BA71AC-2AFF-4277-9E54-AB814BFCAF84','硬度报告焊口统计表','HJGL/WeldingReport/HardTestReportRecordStatistics.aspx',132,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('CDBAD816-2591-4FDC-BFA2-3D076F47E17B','综合数据查询','HJGL/WeldingReport/StatisticsSampleTable.aspx',170,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
INSERT dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
VALUES ('96BEABE7-EF0A-400B-8839-5539A41A3594','管道无损检测数量统计表','HJGL/CheckManage/CheckQuantityStatistics.aspx',180,'F3B157B7-9BEE-4150-6666-087828F1C51D','3')
GO
--8.通用导入
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('4RGASWE2-09B1-4607-6666-WDFCVG693G6D','通用导入','HJGL/DataIn/DataInMain.aspx',90,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('ERDXV53M-09B1-6UIO-6666-5DVZDF329001','数据导入','HJGL/DataIn/DataIn.aspx',10,'4RGASWE2-09B1-4607-6666-WDFCVG693G6D','3')
GO
/*数据导入*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A58C9BA7-3F6F-425C-84EE-D3335227E2B3','ERDXV53M-09B1-6UIO-6666-5DVZDF329001','审核',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('98398BD5-731A-4DCF-B90D-6C9B6B955D99','ERDXV53M-09B1-6UIO-6666-5DVZDF329001','导入',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4A02CC87-9CF4-4DD3-831A-A5C9005D69DC','ERDXV53M-09B1-6UIO-6666-5DVZDF329001','保存',3)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('EFDASF56-6UIO-3EFM-6666-DMGJZXD6307P','更新导入','HJGL/DataIn/DataUpdate.aspx',20,'4RGASWE2-09B1-4607-6666-WDFCVG693G6D','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BC9D4F63-537C-4AA8-9AE3-C80C76A9623D','EFDASF56-6UIO-3EFM-6666-DMGJZXD6307P','审核',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A619F091-9E6C-407E-8C6F-F31707EA385E','EFDASF56-6UIO-3EFM-6666-DMGJZXD6307P','导入',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E4BD496E-1CC2-4A48-85AB-825A0B0E7E8D','EFDASF56-6UIO-3EFM-6666-DMGJZXD6307P','保存',3)
go
--9.焊材管理
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('4105B536-E0E9-4CD3-6666-27BB147603FA','焊材管理','HJGL/MaterialManage/MaterialMain.aspx',100,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('B255A0C2-3D63-4A25-6666-FA8F37F22361','焊条烘烤记录','HJGL/MaterialManage/ElectrodeBakeRecord.aspx',10,'4105B536-E0E9-4CD3-6666-27BB147603FA','3')
GO
/*焊条烘烤记录*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('17D0FCD4-6322-4F54-81CF-0BC9E0762867','B255A0C2-3D63-4A25-6666-FA8F37F22361','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6F326332-97AC-4F5F-8F48-F9EE1CA68F1B','B255A0C2-3D63-4A25-6666-FA8F37F22361','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8700A107-AA8F-4A0A-AF02-29BF0AA9ED3C','B255A0C2-3D63-4A25-6666-FA8F37F22361','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('39CD5646-F48E-494E-8407-B0FC0360E5DD','B255A0C2-3D63-4A25-6666-FA8F37F22361','保存',4)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('28EA8CEC-3D63-4FEB-6666-F33FBC269ABE','焊条发放回收记录','HJGL/MaterialManage/ElectrodeRecovery.aspx',20,'4105B536-E0E9-4CD3-6666-27BB147603FA','3')
GO
/*焊条发放回收记录*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('01626078-FCD4-4A0E-98E9-ABFA60149F4A','28EA8CEC-3D63-4FEB-6666-F33FBC269ABE','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('00ED6E3F-F9F0-46A1-A6CF-7DD668F2716C','28EA8CEC-3D63-4FEB-6666-F33FBC269ABE','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8314BB35-05B6-497B-B11C-5FBFF9C2D664','28EA8CEC-3D63-4FEB-6666-F33FBC269ABE','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3264784D-A765-4ECE-A52E-E0874BEA7B66','28EA8CEC-3D63-4FEB-6666-F33FBC269ABE','保存',4)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('7308FFE7-1C6F-4023-6666-0B9F103E289D','材料到货登记及验收记录','HJGL/MaterialManage/EMaterialRegist.aspx',30,'4105B536-E0E9-4CD3-6666-27BB147603FA','3')
GO
/*材料到货登记及验收记录*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('172B766F-3F12-4755-B412-50E6B0CFDDDF','7308FFE7-1C6F-4023-6666-0B9F103E289D','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('152F0644-F07C-4F0C-ADC4-B4BEEF059BF6','7308FFE7-1C6F-4023-6666-0B9F103E289D','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7690ADC6-4D6A-4EFA-9A8C-F576E0F92F2A','7308FFE7-1C6F-4023-6666-0B9F103E289D','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('47915C15-DB56-4C84-A030-5DFF5C9EBA23','7308FFE7-1C6F-4023-6666-0B9F103E289D','保存',4)
go
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('5BADA90D-EB19-47DE-6666-CA22517AF415','焊材库温湿度记录表','HJGL/MaterialManage/EWeldRHRecord.aspx',40,'4105B536-E0E9-4CD3-6666-27BB147603FA','3')
GO
/*焊材库温湿度记录表*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7CE2AA3E-80C1-4C4D-B0EB-234FCDC1E0E7','5BADA90D-EB19-47DE-6666-CA22517AF415','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('870FA22C-F23B-4500-A384-8B7F15A226BE','5BADA90D-EB19-47DE-6666-CA22517AF415','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0F3781D5-C07B-49FC-809C-32CDE0A5F0DC','5BADA90D-EB19-47DE-6666-CA22517AF415','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('290F8355-0EE5-4EF4-A85A-5D7944385546','5BADA90D-EB19-47DE-6666-CA22517AF415','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('643DD9A7-DC4C-4AE3-9C5A-85E8F229794D','5BADA90D-EB19-47DE-6666-CA22517AF415','打印',5)
go
--10.焊接工艺评定
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','焊接工艺评定','HJGL/WeldingManage/WeldingProcedureMain.aspx',110,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('F4B02718-0616-4623-6666-885698DDBEB1','工艺评定图片','HJGL/WeldingManage/ProcedureImageList.aspx',10,'FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','3')
GO
/*工艺评定图片*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('97895D8A-E9C5-400C-8F4D-3EECB0EFB906','F4B02718-0616-4623-6666-885698DDBEB1','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FC49A7BF-A5EE-4FB7-B4F8-0897E8FA043F','F4B02718-0616-4623-6666-885698DDBEB1','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('21B4CF0E-5A2F-4E33-A0ED-0AEA21ECEFE0','F4B02718-0616-4623-6666-885698DDBEB1','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('936073D2-BEE5-4657-986C-BC794B9CFCF9','F4B02718-0616-4623-6666-885698DDBEB1','保存',4)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('EFDSFVDE-RTHN-7UMG-6666-5TGED48F8IOL','焊接工艺评定查询','HJGL/WeldingManage/WeldingProcedureSearch.aspx',20,'FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','3')
GO
/*焊接工艺评定*/
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('44RRGGBB-2F64-4300-AC4C-963D4A74E48C','EFDSFVDE-RTHN-7UMG-6666-5TGED48F8IOL','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('55TTHHMM-7DA1-431C-AED2-2D439B296C8F','EFDSFVDE-RTHN-7UMG-6666-5TGED48F8IOL','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DAFDASVD-7844-4558-BF1D-43D5A76B6595','EFDSFVDE-RTHN-7UMG-6666-5TGED48F8IOL','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('GSRGTERD-5848-47FF-852B-C630AED27AEB','EFDSFVDE-RTHN-7UMG-6666-5TGED48F8IOL','保存',4)
GO
--现场焊接工艺评定台账
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('1D8517D6-9EB3-44C8-A416-78099AE0C138','焊接工艺评定台账','HJGL/WeldingManage/WeldingProcedure.aspx',110,'FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7E0DC014-56FD-4625-A361-3663DAE5DC15','1D8517D6-9EB3-44C8-A416-78099AE0C138','修改',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AB40F0C7-ED19-4CED-B3D6-48E904669EC0','1D8517D6-9EB3-44C8-A416-78099AE0C138','删除',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9663B8FC-8AC0-40B6-AC29-6CA448867900','1D8517D6-9EB3-44C8-A416-78099AE0C138','保存',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('535D0E87-4703-44B1-9186-7B66E0183574','1D8517D6-9EB3-44C8-A416-78099AE0C138','导出',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('B69007E6-A111-4A74-AC8C-80A9A726C730','材料匹配工艺评定','HJGL/WeldingManage/MatchedProcedureMaterial.aspx',40,'FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4DDFFF6C-A20D-4831-91A8-1534E197409E','B69007E6-A111-4A74-AC8C-80A9A726C730','删除',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule,IsAudiFlow)
VALUES('F9F110BD-C417-4B4C-B61B-14046644521F','焊接工艺卡','HJGL/WeldingManage/WeldingProcessCard.aspx',50,'FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','3',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('552FBD3C-E0FF-458A-BD94-34492504E9FA','热处理工艺卡','HJGL/WeldingManage/WeldHotProcessCard.aspx',60,'FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('1A466D4D-EF2A-45F0-8926-8A185EBC6DFF','返修工艺卡','HJGL/WeldingManage/WeldRepairCard.aspx',70,'FDVXFGDS-5THM-CCDE-6666-TGHNO48F7UKM','3')
GO
--11.管线材料匹配
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('C9FDE144-BD47-4D30-A140-81C927909B20','管线材料匹配','',120,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('EC70A4C1-4662-49CF-B249-33401D0E4B4E','管道组成件信息','HJGL/Match/MaterialSet.aspx',10,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AAC1332F-E26F-4748-B280-0750A98E5C04','EC70A4C1-4662-49CF-B249-33401D0E4B4E','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('05EB62B2-4C18-4E32-B7DC-88052F9AF85A','EC70A4C1-4662-49CF-B249-33401D0E4B4E','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F08A939B-39DC-4E03-BF62-C01FEAD7AACD','EC70A4C1-4662-49CF-B249-33401D0E4B4E','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EF54C33F-44B6-4710-9037-3C2BA0C84DB3','EC70A4C1-4662-49CF-B249-33401D0E4B4E','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6F427A61-FF5F-4B77-B62B-F8B7BBCDDBF6','EC70A4C1-4662-49CF-B249-33401D0E4B4E','导入',5)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('07E087F7-7AFC-4555-A573-1DC2DD9CC50E','EC70A4C1-4662-49CF-B249-33401D0E4B4E','导出',6)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('62DAFBF7-809D-403B-A72B-08189E6E15F2','管线材料对应表','HJGL/Match/PipeMaterial.aspx',20,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('33060AD5-5661-4DC8-968A-E80C6E491932','62DAFBF7-809D-403B-A72B-08189E6E15F2','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DE6FAE85-1113-4057-93F8-3171642288C8','62DAFBF7-809D-403B-A72B-08189E6E15F2','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9F28D23B-8B93-49BF-A452-3EC9A4E88711','62DAFBF7-809D-403B-A72B-08189E6E15F2','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0E895CBE-DA97-47F7-B3F1-BFBC6AD68EC4','62DAFBF7-809D-403B-A72B-08189E6E15F2','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('95BE0202-37C7-4EF5-9850-B136DE9B7BB4','62DAFBF7-809D-403B-A72B-08189E6E15F2','导入',5)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('A7EEF633-E9D4-4331-8E06-BB212A95F199','进料单','HJGL/Match/InStorage.aspx',30,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7117EFFA-D153-41F7-B760-BAF1B7ABDA01','A7EEF633-E9D4-4331-8E06-BB212A95F199','增加',1)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1FFBE1ED-565D-4D6C-9C98-83F3C6FA3EAA','A7EEF633-E9D4-4331-8E06-BB212A95F199','修改',2)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('137AA306-7C8C-4995-B4DD-AC7D9FECE068','A7EEF633-E9D4-4331-8E06-BB212A95F199','删除',3)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3AD57F35-095B-40FE-A57C-135EEADEF7A3','A7EEF633-E9D4-4331-8E06-BB212A95F199','保存',4)
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D013FF62-0117-47D0-B9AA-F0D7E66F2F88','A7EEF633-E9D4-4331-8E06-BB212A95F199','导入',5)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('31894A72-6F04-4233-A017-0ECB924AF408','材料匹配','HJGL/Match/MatchSet.aspx',40,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4A7A7F70-E77A-4E31-B827-DCDEF659F9DB','31894A72-6F04-4233-A017-0ECB924AF408','生成',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('31E31DF7-BFA6-4A0F-B639-AE68AD341017','出料单','HJGL/Match/OutStorage.aspx',50,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('827C5778-269D-40A2-BA86-27A8613B3DC8','库存','HJGL/Match/Storage.aspx',60,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('06447E20-7C1E-42F9-9739-72F3B3FC5589','符合焊接条件管线查询','HJGL/Match/PipelineConditionsQuery.aspx',70,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('06583A06-306E-4735-BCA9-9D5D7256B573','管线材料分配情况分析','HJGL/Match/PipelineMaterialsDistribution.aspx',80,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES('76485D8F-52BA-4FA4-84B9-86302C54191A','所需材料及分配情况分析','HJGL/Match/PipelineRrequiredMaterials.aspx',90,'C9FDE144-BD47-4D30-A140-81C927909B20','3')
GO
--12.文件控制 (现场)
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('E082B8AC-84EA-497C-90D1-93DC7ABB6E8A','文件控制','HJGL/FileControl/FileControlMain.aspx',130,'0','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('F54634C1-9F0E-4256-A028-8C1BAE0F9419','国内法律法规相关条款','HJGL/FileControl/DomesticLawsRegulationsView.aspx',10,'E082B8AC-84EA-497C-90D1-93DC7ABB6E8A','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('2DE0F31A-2B39-4F8E-99C3-9D81F165AB2C','国内现行相关标准规范','HJGL/FileControl/DomesticStandardsView.aspx',20,'E082B8AC-84EA-497C-90D1-93DC7ABB6E8A','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('2F410802-E1EE-49AD-9C2A-908FBD4C41B2','国外现行相关标准规范','HJGL/FileControl/ForeignStandardsView.aspx',30,'E082B8AC-84EA-497C-90D1-93DC7ABB6E8A','3')
GO
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, Url, SortIndex, SuperMenu,MenuModule)
VALUES ('DE13A2E3-4E58-46CA-BE94-724C17FBAD9C','公司相关规章制度标准','HJGL/FileControl/CompanyStandardsView.aspx',40,'E082B8AC-84EA-497C-90D1-93DC7ABB6E8A','3')
GO
Reference in New Issue View Git Blame Copy Permalink