982 lines
80 KiB
Transact-SQL
982 lines
80 KiB
Transact-SQL
--初始化系统管理员账户
|
||
INSERT INTO dbo.Sys_User(UserId,Account,[Password],UserName,IsPost,AllowLoginSystem)
|
||
VALUES ('AF17168B-87BD-4GLY-1111-F0A0A1158F9B','gly',
|
||
'EDE6B81F7043D328B1F1661FA011BCAB','管理员',1,'1|2|3')
|
||
GO
|
||
|
||
-----------------------------------------综合菜单---------------------------------------------------
|
||
|
||
--基础信息
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('B71A4EB0-5882-46F5-2222-FAEFF383414A','基础设置','Basic Information','',10,'0','1')
|
||
GO
|
||
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('F4B314DA-1F95-4B82-2222-3A20ED04FA17','项目信息','Project Information','Common/BaseInfo/Project.aspx',10,'B71A4EB0-5882-46F5-2222-FAEFF383414A','1')
|
||
GO
|
||
/*项目信息*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('434946F1-3048-4E73-BA3B-BA0628829FC0','F4B314DA-1F95-4B82-2222-3A20ED04FA17','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('8A0181D1-D2D3-4DA8-ADFF-BCF105BB032F','F4B314DA-1F95-4B82-2222-3A20ED04FA17','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C9FE268F-E367-4AA3-A721-2E17D0BA77CF','F4B314DA-1F95-4B82-2222-3A20ED04FA17','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B65CA98E-C7A7-45EB-8425-C712D600AEBB','F4B314DA-1F95-4B82-2222-3A20ED04FA17','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('52B4B295-99CE-4153-BAB6-1F2C2F4072A8','F4B314DA-1F95-4B82-2222-3A20ED04FA17','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('D5783F6B-CDEF-4893-2222-265C36B17167','单位信息','Company Information','Common/BaseInfo/Unit.aspx',40,'B71A4EB0-5882-46F5-2222-FAEFF383414A','1')
|
||
GO
|
||
/*单位信息*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('51438E86-0E8C-4149-1111-A47DDBCF2029','D5783F6B-CDEF-4893-2222-265C36B17167','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('775FB5D5-0E95-4790-1111-6DAEE7706B94','D5783F6B-CDEF-4893-2222-265C36B17167','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C604FDC0-1BF3-45F3-1111-1B3E7765D7FD','D5783F6B-CDEF-4893-2222-265C36B17167','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('AD834200-ACD4-4666-1111-8345E377B670','D5783F6B-CDEF-4893-2222-265C36B17167','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('70006E42-9EB9-4065-B700-513F1ABFBDD7','D5783F6B-CDEF-4893-2222-265C36B17167','查看','See',5)
|
||
GO
|
||
|
||
-----------------------------------------------------------------------------------------------------
|
||
--1.系统设置
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('D1A0F410-09B1-4607-BC6D-865CE48F080F','系统设置','System Setup','',20,'0','1')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','角色管理','Role Management','Common/SysManage/RoleList.aspx',10,'D1A0F410-09B1-4607-BC6D-865CE48F080F','1')
|
||
GO
|
||
/*角色*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('73F31C92-0C13-42F4-B3F3-425BA8C1E540','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('22BEA782-6641-4C1C-945A-1691D0822911','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F4067593-8373-4DD0-A03C-ECD69B3FA3CB','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('353DF0FD-C984-4FD0-98AF-1E8BF35E6A74','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B092F6AA-9955-4E9E-B506-29485E59B3BB','EBAD373C-8EB4-49A1-91F6-6794FFCAF9B6','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','用户','User','Common/SysManage/UserList.aspx',20,'D1A0F410-09B1-4607-BC6D-865CE48F080F','1')
|
||
GO
|
||
/*用户*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5F9ACF5A-5E4E-45AB-BA0B-B71F861F69C4','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D23EFC9A-0594-4954-AFBB-9149DAFBB011','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('91259F8B-8DBA-4E21-8861-641C43780C8C','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('906845F8-A5EB-49D9-818B-19BFD390BD06','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('78982125-73B5-4BD0-B6A7-38ECF3EE6E66','E6F0167E-B0FD-4A32-9C47-25FB9E0FDC4E','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('BAB254FA-C879-4463-B9DE-387C241A8623','修改密码','Change Password','Common/SysManage/UpdatePassword.aspx',30,'D1A0F410-09B1-4607-BC6D-865CE48F080F','1')
|
||
GO
|
||
/*修改密码*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7663E788-C586-474E-95A4-DBF84D61F4B1','BAB254FA-C879-4463-B9DE-387C241A8623','保存','Save',1)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('2231022B-3519-42FC-A2E6-1DB9A98039DD','角色授权','Role Authorization','Common/SysManage/RolePower.aspx',40,'D1A0F410-09B1-4607-BC6D-865CE48F080F','1')
|
||
GO
|
||
/*角色授权*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('663521AF-93B8-43C8-B711-A56E076D1FF2','2231022B-3519-42FC-A2E6-1DB9A98039DD','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A511179B-3F92-41C3-AABE-901C1F082DE8','2231022B-3519-42FC-A2E6-1DB9A98039DD','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('3E208088-31E7-4849-A9A1-FCA64B288EF3','日志管理','Log Management','Common/SysManage/LogList.aspx',60,'D1A0F410-09B1-4607-BC6D-865CE48F080F','1')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E390911C-564D-4783-B95D-4CFDA292E980','3E208088-31E7-4849-A9A1-FCA64B288EF3','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('233873BF-F6BE-4F3A-90EC-AFFFFC504501','焊工管理','Welder Management','',25,'0','1')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','焊工基本信息','Welder BaseInfo','WelderManage/WelderManage.aspx',10,'233873BF-F6BE-4F3A-90EC-AFFFFC504501','1')
|
||
GO
|
||
/*焊工管理*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('32EEB794-2F64-4300-AC4C-963D4A74E48C','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('22288619-7DA1-431C-AED2-2D439B296C8F','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('199ABD70-7844-4558-BF1D-43D5A76B6595','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5B8017C2-5848-47FF-852B-C630AED27AEB','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('03F9F8C8-A110-4715-9C34-B1F040E830BD','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('2F21257A-8CC4-4712-A954-A7F690CC68C5','合格项目/资质分析','Welder QualifiedProject','WelderManage/QualifiedProject.aspx',20,'233873BF-F6BE-4F3A-90EC-AFFFFC504501','1')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('4326F62F-7E77-4C69-8496-99954D6AC37B','2F21257A-8CC4-4712-A954-A7F690CC68C5','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('35A13279-F6DD-439C-AF1E-D66534E27656','2F21257A-8CC4-4712-A954-A7F690CC68C5','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9C6289BB-AC10-4C03-964F-F46A0783BACF','2F21257A-8CC4-4712-A954-A7F690CC68C5','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('325C1A85-308A-4703-BFEE-F6DE1ACAEA02','2F21257A-8CC4-4712-A954-A7F690CC68C5','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('78D1CEDF-7D38-4390-84BA-76111A2C5F7B','2F21257A-8CC4-4712-A954-A7F690CC68C5','查看','See',5)
|
||
GO
|
||
|
||
|
||
----------------------------------------------------------------------------------------------
|
||
--3.项目设置
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','项目设置','Project Setup','',30,'0','1')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('0E017438-A342-47A9-84FB-38BFB70BE561','参与单位','Participating Units','Common/ProjectSet/ProjectUnit.aspx',10,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
|
||
GO
|
||
/*参与单位*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('2FD20479-6C47-4721-8BA1-64E23E2592C5','0E017438-A342-47A9-84FB-38BFB70BE561','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A6A9F3D0-0368-4A5C-AA6E-F56F1C0BE8CD','0E017438-A342-47A9-84FB-38BFB70BE561','删除','Delete',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F8FD51B1-F70C-4DFE-899B-5A5E6CC140A7','0E017438-A342-47A9-84FB-38BFB70BE561','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('BF1EC3DB-9278-4FE9-BE09-B364FD13AF97','参与用户','Participating Users ','Common/ProjectSet/ProjectUser.aspx',20,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A039937F-89B0-4785-B7E3-23FF51F532A4','BF1EC3DB-9278-4FE9-BE09-B364FD13AF97','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DF77E9F4-85F2-4AF9-8B6B-830F5165A2A2','BF1EC3DB-9278-4FE9-BE09-B364FD13AF97','删除','Delete',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B2627EE0-B919-466F-90A5-BF3B754E6760','BF1EC3DB-9278-4FE9-BE09-B364FD13AF97','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('10ADC484-14DC-4235-3333-1763E52EE4E7','项目焊工','Project Welder','Common/ProjectSet/ProjectWelder.aspx',30,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
|
||
GO
|
||
/*项目焊工*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F9405F4F-A08B-409C-A6AB-25F23BAF845B','10ADC484-14DC-4235-3333-1763E52EE4E7','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C9BAC56F-E3EC-4504-8D8F-6AC111389A55','10ADC484-14DC-4235-3333-1763E52EE4E7','删除','Delete',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B3AB2DBC-C6CB-43BB-9244-C33780B36D5B','10ADC484-14DC-4235-3333-1763E52EE4E7','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('A4308F9A-0280-49C5-BEE4-FA858FE1CE24','项目装置','Unit Information Setup','Common/ProjectSet/Installation.aspx',40,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
|
||
GO
|
||
/*装置*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D9F56A7D-03C2-4BC5-8317-E1E5CBB2B30B','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5D25C24E-38CE-45F5-857E-F051C1B5068E','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C8A2CAB9-705C-472B-825D-7C76A8404569','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9F1DEE68-7D91-4DE9-B935-FE10FA9E7E8F','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('FA70D6D5-BDAD-41CB-B360-05B613A412DB','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName,Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','项目环境设置','Project Environment Setup','Common/ProjectSet/ProjectSysSet.aspx',50,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C6512BF1-5DC2-4737-9399-281A99255097','E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('6A41D3C4-C95C-43DA-80EA-3E7439F4253B','E4BFDCFD-2B1F-49C5-B02B-1C91BFFAAC6E','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName,Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('36B10E8B-3DBA-4244-9996-746C90B4B710','项目图片','Project Picture','Common/ProjectSet/ProjectPicture.aspx',60,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
|
||
GO
|
||
/*项目图片*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B505EF96-A274-4DF2-91F3-CE078E84A181','36B10E8B-3DBA-4244-9996-746C90B4B710','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('2DA02B39-94CE-461C-BE49-E424A6C6F826','36B10E8B-3DBA-4244-9996-746C90B4B710','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('6C6FDDE9-00C2-48B8-A06F-996803870792','36B10E8B-3DBA-4244-9996-746C90B4B710','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('398ADC95-3007-4EAF-B748-3A5159A6C20D','36B10E8B-3DBA-4244-9996-746C90B4B710','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('6DA2B12B-B422-4894-83DA-313A8734AC34','36B10E8B-3DBA-4244-9996-746C90B4B710','查看','See',5)
|
||
GO
|
||
|
||
/*报表设计*/
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName,MenuEnName,Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8FA7237E-DB0C-436C-6666-8C3A560EE688','报表设计','Report Design','Common/ReportPrint/PrintDesigner.aspx',70,'7D1BF176-FA75-495B-AF7C-DCC9E8097DF3','1')
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B0728CC5-11E7-4E37-8BED-F29EF92CF805','8FA7237E-DB0C-436C-6666-8C3A560EE688','保存','Save',1)
|
||
GO
|
||
|
||
------------------------------------------公共信息--------------------------------------------------------
|
||
|
||
--2.基础信息
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F080F','基础信息','Public Information','',10,'0','2')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0004','焊接耗材','Welding Comsumable Material','PublicInfo/BaseInfo/Consumables.aspx',10,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*焊接耗材*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1E193A67-E2D5-400F-98BE-2B3A05335546','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('032C8DB7-2C1F-4291-8244-306FA16B94BE','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('2703783E-24AB-42FD-8790-0C3BD35B3552','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1808F8E6-6262-4F87-A412-73EBB60892E4','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('32468500-9EAC-4588-A0F5-BB271EA4987C','8IDKGJE2-09B1-4607-BC6D-865CE48F0004','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0006','探伤类型','NDE Type','PublicInfo/BaseInfo/Testing.aspx',20,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*探伤类型*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('6852BC76-6B23-4166-A35A-41DB422ADF3B','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('26667D2C-6617-4CA2-A328-9C7E11E98F80','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DE5A7100-1798-4D5E-A3B9-17D7E5ED2B98','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D25FACD7-35C2-4C58-B564-C53D7C79EF1D','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('01EE5373-AC82-42AA-A161-E193A4731BA7','8IDKGJE2-09B1-4607-BC6D-865CE48F0006','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0007','探伤比例','NDT Percentage','PublicInfo/BaseInfo/Detection.aspx',30,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*探伤比例*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('6969BCFB-CE11-4B1E-835E-B045644994EA','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('785995D4-7368-4FCA-9F97-CDADADFABA3D','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('68873C19-8410-4F3C-ACD0-F757BB2C137C','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B8885C9C-704D-4686-B4A3-B5923BC8DF6B','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('AEBF2820-F7DE-456C-B733-B45968418C82','8IDKGJE2-09B1-4607-BC6D-865CE48F0007','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0008','焊缝类型','Welding Joint Type','PublicInfo/BaseInfo/Weld.aspx',40,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*焊缝类型*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1D3CEB1A-B4B9-40B8-B859-C7EBB18BAD67','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7ACE3181-0CB5-47B7-9662-6751EFFB0329','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('BC593263-3CF6-4A54-B109-9F129F9F044F','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D907991C-4E7E-42F3-AE63-7D9F489C6967','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E9EBAA48-5F38-4BB3-BF94-6075809E6B80','8IDKGJE2-09B1-4607-BC6D-865CE48F0008','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-1234-VC6D-865CE48F0005','管道等级','Piping Class','PublicInfo/BaseInfo/PipingClass.aspx',50,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/* 管道等级*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E00BCE41-533C-4BCA-B084-80007043EA54','8IDKGJE2-09B1-1234-VC6D-865CE48F0005','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B0343477-CC63-4ED4-B40B-717ACBCEC5AC','8IDKGJE2-09B1-1234-VC6D-865CE48F0005','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B632B014-AC4C-4075-8868-C81ABED701A3','8IDKGJE2-09B1-1234-VC6D-865CE48F0005','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A372B682-D0B6-4E6A-ADB5-5EA5B4FD6D25','8IDKGJE2-09B1-1234-VC6D-865CE48F0005','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0FF6BA1D-B3FB-4F09-ACF9-CD6E5E46F00F','8IDKGJE2-09B1-1234-VC6D-865CE48F0005','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0009','安装组件','Assemble Component','PublicInfo/BaseInfo/Components.aspx',60,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*安装组件*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('647F4167-0DBC-4589-994C-71D3F1FBCAB1','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E67B14CE-A0FA-424A-B8B7-10E05A516E09','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5BDA2335-1B97-4FCA-855B-AA108AF13FB6','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('094166A4-7CC9-4C21-8DB1-EE02AA2B9B9A','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B1675007-EA87-4280-BAE0-DE4067CB4FDF','8IDKGJE2-09B1-4607-BC6D-865CE48F0009','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0010','焊接方法','Welding Method','PublicInfo/BaseInfo/WeldingMethod.aspx',70,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*焊接方法*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('4AC2A90B-3A98-4F1E-82C4-61CB310B893B','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('BE3D4228-3064-45B6-BF49-2CA0277B5B05','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('156D4431-0685-4583-9AED-00DD6182CA40','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('584A1FAC-AC6E-427B-80BE-4995851D93DD','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('528240A9-0285-47C7-95CC-D9EEA5AFB0ED','8IDKGJE2-09B1-4607-BC6D-865CE48F0010','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0011','直径寸径对照','Diameter/Size Reference','PublicInfo/BaseInfo/Control.aspx',80,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*直径寸径对照*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('CCB0797A-BEF9-493D-9D73-2716977FDA11','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('ADA012CA-32E5-48FB-88D2-7C4DE9914E00','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('83234A4B-6608-4FFF-B9D1-1EE40CEF1171','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A845E8D1-AA04-43F8-873A-1741F0866CF9','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('2A02CE68-C5DA-4F94-B806-796A1F757E59','8IDKGJE2-09B1-4607-BC6D-865CE48F0011','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0012','坡口类型','Bevel Type','PublicInfo/BaseInfo/Groove.aspx',90,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*坡口类型*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('39465F91-1F7F-41FD-8E55-D8A2A492173A','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F68FF943-6865-4C64-8568-D9A8E2644865','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('81250B08-C9B2-40C1-B545-8886AF370C89','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3DE94701-1B3C-495D-982E-E5A90945C829','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A5D8B2BA-3759-4435-B50C-DCEE3E63E80B','8IDKGJE2-09B1-4607-BC6D-865CE48F0012','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0013','材质定义','Material Specification Definition','PublicInfo/BaseInfo/Material.aspx',100,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*材质定义*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5C13752C-8927-4585-A600-AEE62B5B704D','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0F5E5CC0-7E7A-489C-A549-979395C21FCC','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('648CF364-DD3C-4153-BB8E-90207535ED86','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('396C1679-A303-43AB-A5CB-9C41B905416B','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1C210C6A-9A9D-493D-B899-E676B725579F','8IDKGJE2-09B1-4607-BC6D-865CE48F0013','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0014','介质定义','Medium Definition','PublicInfo/BaseInfo/Medium.aspx',110,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*介质定义*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9496C659-AC0A-485B-86A1-59E5C5DC6BAC','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DFEA5009-12B5-49D8-9953-28C16DDF89C9','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('22014672-A39E-4B07-B004-3D1D6DE6CFA4','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3F34A6BF-FFAB-42CC-B187-095B4484FAE6','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1D85B9EB-CFAF-4CF2-BA7D-A25D9E5374C2','8IDKGJE2-09B1-4607-BC6D-865CE48F0014','查看','See',5)
|
||
GO
|
||
SELECT NEWID()
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('D68AE881-7472-4C48-953D-E13C46D6E2A4','缺陷性质','Defect Property','PublicInfo/BaseInfo/Defect.aspx',130,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
/*缺陷性质*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0E7251BD-A650-4A37-90C6-1F32C5CC70AC','D68AE881-7472-4C48-953D-E13C46D6E2A4','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A366D1BB-6F51-4C6A-BC54-853C965120A6','D68AE881-7472-4C48-953D-E13C46D6E2A4','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B1DCB5C8-E052-4320-BED0-57D664E4679A','D68AE881-7472-4C48-953D-E13C46D6E2A4','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9244C7EA-6426-4FFF-8864-1E46834EB2E1','D68AE881-7472-4C48-953D-E13C46D6E2A4','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('BA7ADEB4-302D-42B2-98E1-1A7F70ED8C3B','D68AE881-7472-4C48-953D-E13C46D6E2A4','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-BC6D-865CE48F0015','试压类型','Pressure Test Type','PublicInfo/BaseInfo/Pressure.aspx',140,'8IDKGJE2-09B1-4607-BC6D-865CE48F080F','2')
|
||
GO
|
||
|
||
-----------------------------------------------------------------------------------------------
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('1D009522-D2C6-4256-B4FB-3E5E061A23D7','工艺评定','Procedure Qualification','',20,'0','2')
|
||
GO
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName,Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','焊接工艺评定','Welding Procedure Qualification','PublicInfo/WPQ/WPQList.aspx',10,'1D009522-D2C6-4256-B4FB-3E5E061A23D7','2')
|
||
GO
|
||
/*焊接工艺评定*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('8329629E-4643-4198-80E6-484D1C6EDEED','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F722D1DE-20A1-4583-A5FF-C1C4382224FE','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A42C1619-A6AE-44BB-B8A6-DAD4ED8A8EA5','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('FFAB108F-2424-40A8-85AE-729378681A9D','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('46FE8A9E-4739-4758-9D16-FF82904789F6','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','导入','Import',5)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('274C462B-3E47-4970-8492-51C2F3603BF5','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','导出','Export',6)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('4D3D3E46-0FBA-4F2E-AA4E-0D8EDDC5D845','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','查看','See',7)
|
||
GO
|
||
|
||
----------------------------------------------------------------------------------------------------
|
||
|
||
--5.文件控制
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','文件控制','File control','',50,'0','2')
|
||
GO
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('E968A3B0-8BEF-4584-9589-4DF32F46A757','国内法律法规相关条款','Domestic laws and regulations','PublicInfo/FileControl/DomesticLawsRegulations.aspx',10,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('409F8953-FCA2-4F5D-B954-89D56CA97CAA','E968A3B0-8BEF-4584-9589-4DF32F46A757','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('358DAC0D-2A60-4DE4-A482-4CE0E1EC5516','E968A3B0-8BEF-4584-9589-4DF32F46A757','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('40406101-A91C-432C-92CF-0A0188BA8771','E968A3B0-8BEF-4584-9589-4DF32F46A757','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('3BB329CD-6673-4650-A6A9-9D48B33F1FE6','E968A3B0-8BEF-4584-9589-4DF32F46A757','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('4C2763C1-3DDF-4309-A481-9CB83C2E1D1B','E968A3B0-8BEF-4584-9589-4DF32F46A757','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('44141764-C129-4E0B-A548-BB30748FB28A','国内现行相关标准规范','Domestic Standards and Specifications','PublicInfo/FileControl/DomesticStandards.aspx',20,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('B562C642-EFB7-44F5-B8D0-3E8C78708FAE','44141764-C129-4E0B-A548-BB30748FB28A','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('A8A25829-F500-4E0D-99E7-EFBC71C530F5','44141764-C129-4E0B-A548-BB30748FB28A','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('D43342FA-DA11-45D7-8B16-80D18ACB1993','44141764-C129-4E0B-A548-BB30748FB28A','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('28E65E43-B60C-4F03-A09E-36CE6B4CC48B','44141764-C129-4E0B-A548-BB30748FB28A','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('16ED68A5-D9D9-4D42-BCC8-190B02AB6889','44141764-C129-4E0B-A548-BB30748FB28A','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('49F3E237-B051-41A3-8842-7309F11E4BF8','国外现行相关标准规范','Foreign Standards and Specifications','PublicInfo/FileControl/ForeignStandards.aspx',30,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('541D1948-3C53-4CAF-91F1-3DC80373A1E9','49F3E237-B051-41A3-8842-7309F11E4BF8','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('8BE81113-77D3-44E2-AA64-1A0142F55868','49F3E237-B051-41A3-8842-7309F11E4BF8','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('8826FB28-2253-444B-B332-C602A53585E8','49F3E237-B051-41A3-8842-7309F11E4BF8','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('8432498B-F9EA-406D-B7F4-6C1A47F5318A','49F3E237-B051-41A3-8842-7309F11E4BF8','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('068C622D-E517-46D7-AC17-DCACBBFEA98C','49F3E237-B051-41A3-8842-7309F11E4BF8','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES ('6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','公司相关规章制度标准','Relevant company regulations and standards','PublicInfo/FileControl/CompanyStandards.aspx',40,'6B7D303D-0BEB-4C24-8AB8-68955CFFFAB8','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('04F97EA7-BFB5-4337-AC28-1BC6B53C8CE2','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('4FFB1B3C-C276-4328-9AE1-3F6C0B505528','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('CA2EC179-FBC0-44CD-A0C2-7F6660D45CA4','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('FBD32CBA-6634-4130-B22B-1892E43A6E3D','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('B5748A97-3DF3-4E50-BDCB-80D9B6CBAF54','6C2AB5BD-7285-4EA7-B3C3-94746E9FFDB3','查看','See',5)
|
||
GO
|
||
|
||
--6.通用导入
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('083CE783-E1E0-46F3-9DFB-54E17A16AFD3','过程控制资料','Process Control Data','',60,'0','2')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('0EBD310C-3952-4525-84E9-C28604C980A7','焊接数据统计（日、周、月）','Welding Data statistics(Day、Week、Month)','PublicInfo/ProcessControl/WeldingMonthly.aspx',20,'083CE783-E1E0-46F3-9DFB-54E17A16AFD3','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('824B562C-0423-4021-84B8-D6F9C2682FBD','0EBD310C-3952-4525-84E9-C28604C980A7','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('4FC5604D-0395-4F54-B7D4-F59237AD1400','施工单位焊接统计','Welding Statistics Of Construction Units','PublicInfo/ProcessControl/StatisticsByUnit.aspx',30,'083CE783-E1E0-46F3-9DFB-54E17A16AFD3','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('38CEC14F-2A3C-4F8D-ACB6-ABF908DD4821','4FC5604D-0395-4F54-B7D4-F59237AD1400','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('61877D2E-5D82-49D2-8228-9E7038780D5E','焊接质量月统计报表','Monthly Statistical Of Welding Quality','PublicInfo/ProcessControl/StatisticsByMonthly.aspx',40,'083CE783-E1E0-46F3-9DFB-54E17A16AFD3','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('8C7229EB-EEF6-4DAC-B37B-137EA40E3FFB','61877D2E-5D82-49D2-8228-9E7038780D5E','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('58A1B158-66A6-48F0-A384-FDAA4D5A9C09','焊工名次','Welder rank','PublicInfo/ProcessControl/WelderRank.aspx',50,'083CE783-E1E0-46F3-9DFB-54E17A16AFD3','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('55346C3D-9902-4339-B95E-431019B184B8','58A1B158-66A6-48F0-A384-FDAA4D5A9C09','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('AFE02503-95EC-498B-9799-A24A1E85B8EE','项目焊接质量状态','Welding Quality Status Of Project','PublicInfo/ProcessControl/WeldingQuelity.aspx',60,'083CE783-E1E0-46F3-9DFB-54E17A16AFD3','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('BD030328-84A9-4CC5-86B7-468153059789','AFE02503-95EC-498B-9799-A24A1E85B8EE','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO Sys_Menu(MenuId,MenuName,MenuEnName,Url,SortIndex,SuperMenu,MenuModule)
|
||
VALUES('F4EEC44E-00EA-46A8-BC19-712E828FE511','最终存档数据','Final Archived Data','PublicInfo/ProcessControl/FinalArchivedData.aspx',70,'083CE783-E1E0-46F3-9DFB-54E17A16AFD3','2')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex)
|
||
VALUES('0CED3205-2013-484B-B311-887E847DF17E','F4EEC44E-00EA-46A8-BC19-712E828FE511','查看','See',5)
|
||
GO
|
||
|
||
|
||
|
||
|
||
----------------------------------------------现场管道安装--------------------------------------------------
|
||
|
||
--4.焊接管理
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','焊接管理','Welding Management','',10,'0','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','管线管理','PipelINE Management','WeldingProcess/WeldingManage/PipelineManage.aspx',10,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','3')
|
||
GO
|
||
/*管线管理*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0D805149-7D81-44E4-A94C-0B409D33AF9C','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('14C05A28-353E-4AF5-B060-150743BF491A','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('559EE5FF-4CFE-4751-8B92-70967074F300','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('78541946-2B46-46B7-A6E8-224F96DFCDB9','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D6A20878-6A61-4693-9E3A-575DD2143617','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('32F5CC8C-E0F4-456C-AB88-77E36269FA50','焊口信息管理','Welding Joints Information','WeldingProcess/WeldingManage/JointInfo.aspx',20,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','3')
|
||
GO
|
||
/*焊口信息管理*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A011071D-AD84-40AB-A47F-F3B5C1AA830B','32F5CC8C-E0F4-456C-AB88-77E36269FA50','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('1674F54E-7928-4A30-8806-334F3C7A7093','32F5CC8C-E0F4-456C-AB88-77E36269FA50','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('EAFB612A-5209-46C6-A653-05CB31D4F971','32F5CC8C-E0F4-456C-AB88-77E36269FA50','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('E92BBD02-304A-46B6-9B23-D7491F3F8994','32F5CC8C-E0F4-456C-AB88-77E36269FA50','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3B71DE7A-6508-4522-AD5B-96E0FBDF5D77','32F5CC8C-E0F4-456C-AB88-77E36269FA50','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','焊接日报','Daily Welding Report','WeldingProcess/WeldingManage/WeldReport.aspx',30,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','3')
|
||
GO
|
||
/*焊接日报*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('997FDAE7-C4E8-44DE-9AA7-D5003F6D6BEC','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('93B807D4-2723-468A-96BA-F4D7C8A9CADA','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('2A70F46A-8E58-4803-9ED6-C0F5F2952CB4','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('03FE46CE-F8BA-44AD-9482-4C7644A26E86','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DF712F86-FAC7-4966-8BB7-C976DF1885F5','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','查看','See',5)
|
||
GO
|
||
|
||
|
||
--4.热处理/硬度管理
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('7FE911EF-616A-4F04-AACD-E53E633A9E86','热处理/硬度管理','PWHT/Hardness Management','',20,'0','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('90579BE7-E38C-4CD2-A3BC-755169FF3BB2','热处理委托及数据录入','PWHT Test Request Data Input','HotProcessHard/HotProessTrust.aspx',10,'7FE911EF-616A-4F04-AACD-E53E633A9E86','3')
|
||
GO
|
||
/*热处理委托及数据录入*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5C7CC252-2686-49C3-83B1-7494CA011662','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C5F195E3-696C-47D2-9102-FE5744B88A87','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('8BFC9AEC-931C-4197-9795-4DF4E976B325','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('89A481B0-708E-45A2-A1ED-7BEABE53EB79','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B8C7E5BC-A341-418D-921F-FC317F0DE1A2','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('DAA6042B-6E65-49E4-9337-355E4420E25D','热处理反馈及硬度委托','PWHT Feedback Request Hardness Test','HotProcessHard/HotProessFeedback.aspx',20,'7FE911EF-616A-4F04-AACD-E53E633A9E86','3')
|
||
GO
|
||
|
||
/*热处理反馈及硬度委托*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('34A22DBB-75C2-47A6-B9C1-21EA2A8288C3','DAA6042B-6E65-49E4-9337-355E4420E25D','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9BA543C3-C6A2-4B2D-9A44-2E1BE2C55436','DAA6042B-6E65-49E4-9337-355E4420E25D','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('72B3E508-1315-4CC3-939F-E840FA701A0E','硬度委托及数据录入','Hardness Test Request Data Input','HotProcessHard/HardTrust.aspx',30,'7FE911EF-616A-4F04-AACD-E53E633A9E86','3')
|
||
GO
|
||
/*硬度委托及数据录入*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F0A352F0-6514-46A4-A41B-722091453078','72B3E508-1315-4CC3-939F-E840FA701A0E','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9466A139-55F5-427C-8276-BD0883D12FE3','72B3E508-1315-4CC3-939F-E840FA701A0E','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('CFDC9109-8EE8-474B-A670-5919E3EA3D39','72B3E508-1315-4CC3-939F-E840FA701A0E','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('8F12D774-2407-4C5D-AA13-BAA6E8DC0337','72B3E508-1315-4CC3-939F-E840FA701A0E','保存','Save',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DEE3BE44-C58B-4465-88FD-89510F0D1016','72B3E508-1315-4CC3-939F-E840FA701A0E','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('B0355AED-E873-4398-963C-07243E296A1D','硬度检验结果反馈','Hardness Test Result Feedback','HotProcessHard/HardFeedback.aspx',40,'7FE911EF-616A-4F04-AACD-E53E633A9E86','3')
|
||
GO
|
||
/*硬度检验结果反馈*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('4A37050E-A895-4208-A7C7-34C0958B0C25','B0355AED-E873-4398-963C-07243E296A1D','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('9F9F98AE-F6B4-40BC-AF90-772A39933889','B0355AED-E873-4398-963C-07243E296A1D','查看','See',5)
|
||
GO
|
||
|
||
--5.无损委托
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('4F07D4BF-5971-4D3C-A0DE-B2ACA8CD82FF','NDE 管理','NDT Management','WeldingProcess/TrustManage/TrustManageMain.aspx',30,'0','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','点口管理','Joint Selection Management','WeldingProcess/TrustManage/PointManage.aspx',10,'4F07D4BF-5971-4D3C-A0DE-B2ACA8CD82FF','3')
|
||
GO
|
||
/*点口管理*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('FA69A222-DF16-44CF-AA29-558B18972B32','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','生成','Generate',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B926906A-DB1A-4C88-9132-99E87DC76536','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','手动点口关闭','PointClose',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DEA70C82-BACF-4241-ADAB-0988C6F552EC','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','打开重新点口','OpenResetPoint',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('226279B8-039A-4C88-8127-11C2F77EF0CA','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','手动结束批','ClearBatch',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('226279B8-039A-4C88-8127-22C2F77EF0CA','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','重新选择扩口','ClearBatch',5)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('477D2645-257D-4928-9FE5-3A54241ADF16','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','查看','See',6)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('0CA58EC2-7934-49B3-A2C3-327FAD27C541','无损委托单','NDT Test Request','WeldingProcess/TrustManage/TrustBatchManage.aspx',20,'4F07D4BF-5971-4D3C-A0DE-B2ACA8CD82FF','3')
|
||
GO
|
||
/*无损委托单*/
|
||
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('94F17203-0D8D-483B-91F4-3C7192629E34','0CA58EC2-7934-49B3-A2C3-327FAD27C541','保存','Save',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('462773FD-CB49-46D5-BA4D-5D82468EBF14','0CA58EC2-7934-49B3-A2C3-327FAD27C541','打印','Print',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('462882FG-CB49-46D5-BA4D-5D82468EBF14','0CA58EC2-7934-49B3-A2C3-327FAD27C541','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('06BCEA33-980E-443E-B23A-1F77DA296314','0CA58EC2-7934-49B3-A2C3-327FAD27C541','查看','See',5)
|
||
GO
|
||
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('CDECC461-1897-4D88-BD13-0824E540F565','检测单录入','NDT Test Input','WeldingProcess/CheckManage/CheckManage.aspx',30,'4F07D4BF-5971-4D3C-A0DE-B2ACA8CD82FF','3')
|
||
GO
|
||
/*检测单录入*/
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('33586177-63CB-47D5-9669-5AFD79112B24','CDECC461-1897-4D88-BD13-0824E540F565','增加','Add',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('84FDB796-696E-4B66-A78F-3A07046B053D','CDECC461-1897-4D88-BD13-0824E540F565','保存','Save',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D7487947-BBFF-44E7-A071-E9E9C825F4E2','CDECC461-1897-4D88-BD13-0824E540F565','删除','Delete',3)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('18A85977-EC3C-4BC6-9F5D-4232EFB043D6','CDECC461-1897-4D88-BD13-0824E540F565','审核','Auditing',4)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('154D9616-2ECC-4589-AC5B-31E0CB4DE8F6','CDECC461-1897-4D88-BD13-0824E540F565','取消审核','CancelAuditing',5)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('D32CCB3F-D17B-4252-AE6C-C56E8A008409','CDECC461-1897-4D88-BD13-0824E540F565','生成返修通知单','RepairNotice',6)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('AFD236D2-403A-42B4-B0C0-0B6F28F6C703','CDECC461-1897-4D88-BD13-0824E540F565','查看','See',7)
|
||
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('6D215BF6-7002-46B3-B2EA-A57CD849F0F1','返修/扩透','Repair/Expand','WeldingProcess/CheckManage/RepairAndExpand.aspx',40,'4F07D4BF-5971-4D3C-A0DE-B2ACA8CD82FF','3')
|
||
GO
|
||
|
||
|
||
--8.试压管理
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('A24B7926-EF69-456E-8A24-936D30384680','试压管理','Test Package Management','',40,'0','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','试压包录入','Test Package Input','WeldingProcess/TestPackageManage/TestPackageManageEdit.aspx',10,'A24B7926-EF69-456E-8A24-936D30384680','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('24941EDC-CED6-4176-8CCD-EB5F08156D08','试压前尾项A检查','A Punch List Check','WeldingProcess/TestPackageManage/AItemEndCheck.aspx',20,'A24B7926-EF69-456E-8A24-936D30384680','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('55976B16-2C33-406E-B514-2FE42D031071','试压包审核','Pressure Test Package Review','WeldingProcess/TestPackageManage/TestPackageManageAudit.aspx',30,'A24B7926-EF69-456E-8A24-936D30384680','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('B7EF02DC-45AB-4CFB-ADC8-8340D85D57AD','试压后尾项B检查','B Punch List Check','WeldingProcess/TestPackageManage/BItemEndCheck.aspx',40,'A24B7926-EF69-456E-8A24-936D30384680','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('82951D78-9029-4F69-A032-00C47551B3E6','试压包完成','Test Package Completion','WeldingProcess/TestPackageManage/TestPackageManageComplete.aspx',50,'A24B7926-EF69-456E-8A24-936D30384680','3')
|
||
GO
|
||
|
||
--9.焊接报表
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('F3B157B7-9BEE-4150-80CB-087828F1C51D','焊接报表','Welding Report','',50,'0','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('66A76F90-96A7-4C1F-B8D9-125DDEACEF52','单位工区进度分析','Work Area Progress Analysis','WeldingProcess/WeldingReport/UnitWorkareaAnalyze.aspx',10,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7D735BE5-49F7-4A08-B95F-1262CA542C59','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('88CDDC68-54DE-4E24-9524-A33B80EC0E12','单位工区质量分析','Work Area Quality Analysis','WeldingProcess/WeldingReport/UnitWorkAreaQuality.aspx',20,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('7928E47B-81D3-4661-8ED7-8F346AAC3082','88CDDC68-54DE-4E24-9524-A33B80EC0E12','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('41C22E63-36B7-4C44-89EC-F765BFBB7C55','焊工业绩分析','Welder Performance Analysis','WeldingProcess/WeldingReport/WelderPerformance.aspx',30,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('24353DB7-56D4-4227-B491-BE0608E0C13C','41C22E63-36B7-4C44-89EC-F765BFBB7C55','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('FFF57C8F-6683-42BC-BD2C-C3B1745842E4','焊工返修记录','Welder Repair Log','WeldingProcess/WeldingReport/WelderRepairLog.aspx',35,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3DC788AF-267E-405C-8031-B5626B673484','FFF57C8F-6683-42BC-BD2C-C3B1745842E4','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('FCF06B4F-F14E-4D4C-8BBD-D6CFAD5D904C','焊工RT统计表','NDE By Welder-RT','WeldingProcess/WeldingReport/NDTByWelder.aspx',37,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0565E28C-3790-4EDA-8F97-AB10ADA19D57','FCF06B4F-F14E-4D4C-8BBD-D6CFAD5D904C','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('0ADD01FB-8088-4595-BB40-6A73F332A229','管线综合分析','comprehensive analysis of Pipeline','WeldingProcess/WeldingReport/IsoCmprehensive.aspx',40,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('A1431A25-88FB-477F-9AB2-E854FD4D77C9','0ADD01FB-8088-4595-BB40-6A73F332A229','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('05495F29-B583-43D9-89D3-3384D6783A3F','预制安装进度','Prefabrication and Field Installation Progress','WeldingProcess/WeldingReport/PrefabricatedInstall.aspx',50,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('570BFC74-C0EE-46C9-8979-DFF36F9825FB','05495F29-B583-43D9-89D3-3384D6783A3F','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('575C5154-A135-4737-8682-A129EA717660','介质综合分析','Comprehensive analysis of medium','WeldingProcess/WeldingReport/MediaComprehensive.aspx',60,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5E6639F9-C5D2-489B-9442-7F348784E56B','575C5154-A135-4737-8682-A129EA717660','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('3E2F2FFD-ED2E-4914-8370-D97A68398814','探伤综合报告','Comprehensive analysis for NDT','WeldingProcess/WeldingReport/DetectionAnalyze.aspx',70,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('DBF1004E-2D83-467D-A858-E5341D91FDD6','3E2F2FFD-ED2E-4914-8370-D97A68398814','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('0DC90447-F99B-4002-8E5D-7981A7837A1F','焊口综合信息','Summarized Information of Welding Joints','WeldingProcess/WeldingReport/JointComprehensive.aspx',80,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('11FAF39B-BCFA-44BA-B2FD-B05D2F068572','0DC90447-F99B-4002-8E5D-7981A7837A1F','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('CF3CB43C-4031-4CFD-905F-154DC1CB881E','管线综合信息','Summarized Information of Pipeline','WeldingProcess/WeldingReport/IsoCompreInfo.aspx',90,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('476B1955-1AC8-47CE-A5BE-A4F672A8F35F','CF3CB43C-4031-4CFD-905F-154DC1CB881E','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('9EE8BFD1-857D-4D55-AB75-55F676DB2DE4','积压焊口','RT backlog','WeldingProcess/WeldingReport/RTbacklogReport.aspx',100,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('898A7628-306E-488D-9829-4216673BB97F','9EE8BFD1-857D-4D55-AB75-55F676DB2DE4','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('186E8FF3-1AE6-4801-BB3E-812CDE88A9FD','积压焊口两周滚动统计','Two-week SelectedNDE WithOut Statistics','WeldingProcess/WeldingReport/TwoWeekNDEWithOut.aspx',104,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('C811E19F-5AE1-4CA7-A910-649598EAA980','186E8FF3-1AE6-4801-BB3E-812CDE88A9FD','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('CEE70BD3-6F71-4119-8DBA-CB1BC81F5A50','NDE积压汇总表','SelectedNDE WithOut','WeldingProcess/WeldingReport/NDEWithOut.aspx',105,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('0DBDF2E2-09B8-40E0-92D4-AAE5BE53CE72','CEE70BD3-6F71-4119-8DBA-CB1BC81F5A50','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('8AF2CA92-F7A5-4A54-9453-5F71976512C9','NDE积压焊口一览表','NDT Backlog List','WeldingProcess/WeldingReport/NDTBacklogList.aspx',106,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('8996F359-53CB-48C2-905C-B07C608B3379','8AF2CA92-F7A5-4A54-9453-5F71976512C9','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('D41E37F9-A073-4D62-A09C-D73D5527EDBD','NDE检测信息','NDE Detection Information','WeldingProcess/WeldingReport/NDEDetectionInformation.aspx',107,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('B787C372-C190-47D8-A121-D9FF3332AB38','D41E37F9-A073-4D62-A09C-D73D5527EDBD','查看','See',5)
|
||
GO
|
||
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('0865BC00-12E1-4C2E-B6F7-3B8E13107F3A','周预制的焊口数','Fabricated Welds Per Week','WeldingProcess/WeldingReport/WeeklyWeldsReport.aspx',110,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('6112565A-4FC8-428F-854C-0BDED31705DC','0865BC00-12E1-4C2E-B6F7-3B8E13107F3A','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('019EA157-62AB-4A24-8024-3A0742B0093C','周RT检测返修比例','RT Rejected Rate Per Week','WeldingProcess/WeldingReport/RTRejectedRateReport.aspx',120,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('4572CDBF-3C6B-424F-923F-6A544792286F','019EA157-62AB-4A24-8024-3A0742B0093C','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('D5062590-D242-4130-A85B-1088623F102D','对接口的RT统计表','RT By Line Class-BW','WeldingProcess/WeldingReport/RTButtWelds.aspx',130,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('F9E89231-4FA9-4259-96B6-F7993CAF5F09','D5062590-D242-4130-A85B-1088623F102D','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('E335843B-9B6F-4F4F-A4CC-211D42D0873B','对接口的RT详细一览表','RT By Line Class-BW List','WeldingProcess/WeldingReport/RTButtWeldList.aspx',135,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('FC4362C6-3A29-407A-8385-8313C975D289','E335843B-9B6F-4F4F-A4CC-211D42D0873B','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('E781C1D2-9D33-48B2-A2BB-9BCB93568F03','未焊焊口清单','Outstanding Welds','WeldingProcess/WeldingReport/OutstandingWelds.aspx',140,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('3414D582-D327-41B1-8D5B-A0E8AB9D3867','E781C1D2-9D33-48B2-A2BB-9BCB93568F03','查看','See',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('F388B5F9-8A8F-4621-A3F3-B1115CE3638E','焊接信息','Weld Summary','WeldingProcess/WeldingReport/WeldSummary.aspx',150,'F3B157B7-9BEE-4150-80CB-087828F1C51D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('CC337D82-A949-49C1-8814-52240C55CFA5','F388B5F9-8A8F-4621-A3F3-B1115CE3638E','查看','See',5)
|
||
GO
|
||
|
||
|
||
--6.通用导入
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D','通用导入','General Import','',60,'0','3')
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','数据导入','Data Import','WeldingProcess/DataIn/DataIn.aspx',10,'4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('BC7B1782-B874-4BAE-B4CD-1685098D2D6F','ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','导入','Import',1)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('ED68DC0C-9185-4C61-93AC-4E3B4E55835B','ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','修改','Modify',2)
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('5685338B-7AAE-4614-9E1C-7B22A184016D','ERDXV53M-09B1-6UIO-3EFM-5DVZDF329001','删除','Delete',3)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu,MenuModule)
|
||
VALUES('EFDASF56-6UIO-3EFM-3UTM-DMGJZXD6307P','更新导入','Revise Importing','WeldingProcess/DataIn/DataUpdate.aspx',20,'4RGASWE2-09B1-4607-DCS2-WDFCVG693G6D','3')
|
||
GO
|
||
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,ButtonEnName,SortIndex) VALUES('12125BAD-A573-4A8B-89BD-0A48783F2C23','EFDASF56-6UIO-3EFM-3UTM-DMGJZXD6307P','导入','Import',1)
|
||
GO
|
||
|
||
--20.焊接报表设计
|
||
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu)
|
||
--VALUES('3EF14145-E349-48B9-BB25-6CA209B485BB','焊接报表设计','Welding Report Design','ReportPrint/ReportPrintMain.aspx',200,'0')
|
||
--GO
|
||
|
||
--INSERT INTO dbo.Sys_Menu(MenuId, MenuName, MenuEnName, Url, SortIndex, SuperMenu)
|
||
--VALUES('8FA7237E-DB0C-436C-9BC6-8C3A560EE688','报表设计','Report Design','ReportPrint/PrintDesigner.aspx',10,'3EF14145-E349-48B9-BB25-6CA209B485BB')
|
||
--GO
|
||
|
||
|
||
|
||
|
||
----------------------------------缺陷性质脚本------------------------------------------
|
||
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(1,'横裂纹','Transverse crack')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(2,'纵裂纹','Longitudinal crack')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(3,'弧坑裂纹','Crater crack')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(4,'未焊透','Incomplete Penetration')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(5,'未熔合','Lack fusion')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(6,'条渣','Linear Slag')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(7,'点渣','Point crack')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(8,'夹钨','Tungsten inclusion')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(9,'气孔','Porosity')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(10,'条孔','Linear porosity')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(11,'焊瘤','Excessive penetration')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(12,'内凹','Concavity')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(13,'根部咬边','Undercut of root')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(14,'错口','Mismatch')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(15,'表面沟槽','Surface groove')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(16,'根部氧化','Oxidation of root')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(17,'深孔','Worm Hole')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(18,'间隙超过1~3mm','Gap exceed 1~3mm')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(19,'原材料','Raw Materials')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(20,'焊缝','Weld')
|
||
INSERT INTO dbo.Base_Defect(DefectId,DefectName,DefectEngName) VALUES(21,'其它','Other')
|
||
GO
|
||
|
||
|
||
----------------------------------尺寸对照表------------------------------------------
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('B77DD3B3-3633-461D-8546-9F2C1CCFB288',NULL,'21.3','2.11',NULL,'2.41','2.77',NULL,'3.73',NULL,NULL,NULL,'4.78','2.77','3.73','7.47')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('D4CA393A-852F-405B-9305-9E5347150F0A',NULL,'26.7','2.11',NULL,'2.41','2.87',NULL,'3.91',NULL,NULL,NULL,'5.56','2.87','3.91','7.82')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('597C7BF3-646B-48BD-AC68-A04239A8D229',NULL,'33.4','2.77',NULL,'2.9','3.38',NULL,'4.55',NULL,NULL,NULL,'6.35','3.38','4.55','9.09')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('20718102-3212-4504-9D30-E84DAC1797B9',NULL,'48.3','2.77',NULL,'3.18','6.68',NULL,'5.08',NULL,NULL,NULL,'7.14','3.68','5.08','10.15')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('2B3DDE01-B892-45CB-9764-5E22CE821F6A',NULL,'60.3','2.77',NULL,'3.18','3.91',NULL,'5.54',NULL,NULL,NULL,'8.74','3.91','5.54','11.07')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('FDF41779-2BA7-4813-AC07-7FE239E08528',NULL,'88.9','3.05',NULL,'4.78','5.49',NULL,'7.62',NULL,NULL,NULL,'11.13','5.49','7.62','15.24')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('99AE61C3-B0EE-4A59-B73A-F128651B6218',NULL,'114.3','3.05',NULL,'4.78','6.02',NULL,'8.56',NULL,'11.13',NULL,'13.49','6.02','8.56','17.12')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('14FC7B21-8F2F-4449-9EB5-D08E9C34A436',NULL,'168.3','3.4',NULL,NULL,'7.11',NULL,'10.97',NULL,'14.27',NULL,'18.26','7.11','10.97','21.95')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('37FA2021-B14D-46E8-A946-C671A5CFCCAB',NULL,'219.1','3.76','6.35','7.04','8.18','10.31','12.7','15.09','18.26','20.62','23.01','8.18','12.7','22.23')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('00060231-2906-42E7-8447-64BCDD3B96C0',NULL,'273','4.19','6.35','7.8','9.27','12.7','15.09','18.26','21.44','25.4','28.58','9.27','12.7','25.4')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('3C9F0977-5753-4A9F-B478-A3E5064F2292',NULL,'323.8','4.57','6.35','8.38','10.31','14.27','17.48','21.44','25.4','28.58','33.32','9.53','12.7','25.4')
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('9726D54B-3C80-460F-9DC4-574B08F9D656',NULL,'355.6','6.35','7.92','9.53','11.13','15.09','19.05','23.83','27.79','31.75','35.71','9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('5AB191B2-2D17-43FE-852E-369065B390E2',NULL,'406.4','6.35','7.92','9.53','12.7','16.66','21.44','26.19','30.96','36.53','40.49','9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('56D5416C-26D4-436F-8009-61C721B5A606',NULL,'457','6.35','7.92','11.13','14.27','19.05','23.83','29.36','34.93','39.67','45.24','9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('8557BC21-1979-4543-A308-65A716537093',NULL,'508','6.35','9.53','12.7','15.09','20.62','26.19','32.54','38.1','44.45','50.01','9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('A7676A35-9490-4A67-8FDB-1D1414C2C609',NULL,'559','6.35','9.53','12.7',NULL,'22.23','28.58','34.93','41.28','47.63','53.98','9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('831E236C-14F2-42AB-8654-3787AC6DFC4A',NULL,'610','6.35','9.53','14.27','17.48','24.61','30.96','38.89','46.02','52.37','59.54','9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('B99375FB-A61A-48DF-97F1-5B9C7BBD8B90',NULL,'660','7.95','12.7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('737B57DB-4C8C-4BA8-8C7C-E6E070B643AF',NULL,'711','7.92','12.7','15.88',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('4EFBA021-C0B8-4176-A2BE-D01CF9677E2D',NULL,'762','7.92','12.7','15.88',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('C48CA2E9-309A-41E1-8A41-CB6B77D61C61',NULL,'813','7.92','12.7','15.88','17.48',NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('554839B5-ACE4-4A04-9A01-F53BC3D6B8B6',NULL,'864','7.92','12.7','15.88','17.48',NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('B8D114BB-A139-4D2F-818F-D2C68BDC0915',NULL,'914','7.92','12.7','15.88','17.48',NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('97531D76-7869-4237-8FE4-2640B506A846',NULL,'965',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('F321C061-B1A3-4D54-978E-5E186B102581',NULL,'1016',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('88EF6141-52C7-4BD9-B450-E73195E9CEF2',NULL,'1067',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('7C130347-ACD8-4F08-B110-E87ECA61B412',NULL,'1118',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('F29396AC-CB09-4071-A775-915C61CE7F21',NULL,'1168',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
INSERT INTO Base_DNCompare(DNCompareId,PipeSize,OutSizeDia,SCH10,SCH20,SCH30,SCH40,SCH60,SCH80,SCH100,SCH120,SCH140,SCH160,STD,XS,XXS)
|
||
VALUES('25D1AFBE-A164-4D10-9C22-7726A6B05D4C',NULL,'1219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9.53','12.7',NULL)
|
||
GO
|
||
|
||
|
||
--焊接位置
|
||
INSERT INTO Base_WeldingLocation(WeldingLocationId, WeldingLocationCode)
|
||
VALUES('144E153F-7CF4-4CDC-83C2-260D53C93753','1G')
|
||
INSERT INTO Base_WeldingLocation(WeldingLocationId, WeldingLocationCode)
|
||
VALUES('1F3FB33D-761F-44F7-85A6-2F6EFD61042B','2G')
|
||
INSERT INTO Base_WeldingLocation(WeldingLocationId, WeldingLocationCode)
|
||
VALUES('5124DA9A-E560-41A1-8479-E73C484FAA1D','3G')
|
||
INSERT INTO Base_WeldingLocation(WeldingLocationId, WeldingLocationCode)
|
||
VALUES('9548F4B7-A4BA-4823-9161-5F04533926DC','4G')
|
||
INSERT INTO Base_WeldingLocation(WeldingLocationId, WeldingLocationCode)
|
||
VALUES('4AC0BC73-FAD5-4A61-88BE-0CF5A1B80C20','5G')
|
||
INSERT INTO Base_WeldingLocation(WeldingLocationId, WeldingLocationCode)
|
||
VALUES('50C65E53-BB65-4954-8D68-E9D40001F3C2','6G')
|
||
INSERT INTO Base_WeldingLocation(WeldingLocationId, WeldingLocationCode)
|
||
VALUES('2BC3F7C3-0093-4BD9-BDF7-2EF25E862AE5','ALL')
|
||
GO
|
||
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('1','Pipe 管道')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('2','Pile head 桩基')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('3','Pipe Nozzle 管嘴')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('4','Plate 平板')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('5','Rebar 钢筋')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('6','Sphere tank 球罐')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('7','Steel structure 钢结构')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('8','Tank 储罐')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('9','Tank without Nozzle 储罐不带接管')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('10','Pipe without Nozzle 管道不带接管')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('11','Pipe & Nozzle 管道带接管 2G+5G/5FG')
|
||
INSERT INTO Base_QueProject(QueProjectId, QueProjectName)
|
||
VALUES('12','Fillets Groove 管板（FG')
|
||
GO
|
||
|
||
|
||
-----------------系统设置-----------------------------------------------------------
|
||
Insert Into dbo.Sys_Set(SetId,SetName,IsAuto) values(1,'焊接日报编号',1)
|
||
Insert Into dbo.Sys_Set(SetId,SetName,IsAuto) values(2,'点口编号',1)
|
||
Insert Into dbo.Sys_Set(SetId,SetName,IsAuto) values(3,'无损检测委托单',1)/*IsAuto=1表示第一种打印格式*/
|
||
GO
|
||
|
||
--插入报表模板
|
||
--insert into HJGL_NULL.dbo.ReportServer(ReportId,TabContent,ReportName,InitTabContent)
|
||
--select ReportId,TabContent,ReportName,InitTabContent from HJGLDB.dbo.ReportServer
|