lpf
/
xinjiang
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
xinjiang/DataBase/菜单初始化脚本/1-5焊接管理（Menu_HJGL）.sql

372 lines
32 KiB
Transact-SQL
Raw Permalink Blame History

--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_HJGL')
--delete from Sys_Menu where MenuType='Menu_HJGL'
--------------------------------------------现场焊接--------------------------------------------------------
-- 2.焊工管理
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('3EFCE9C3-1983-4AEC-8FA1-D7A90F08CBCB','焊工管理','',20,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','焊工管理','HJGL/PersonManage/WelderManage.aspx',10,'3EFCE9C3-1983-4AEC-8FA1-D7A90F08CBCB','Menu_HJGL',0,1,1)
GO
/*焊工管理*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3804552E-E893-45F1-B949-161941311363','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('22288619-7DA1-431C-AED2-2D439B296C8F','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5B8017C2-5848-47FF-852B-C630AED27AEB','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','保存',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('03F9F8C8-A110-4715-9C34-B1F040E830BD','1908E4C9-4A63-4A6C-6666-DA4910C2A8C7','查看',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('13F11D51-1B54-400F-BDBB-36685BC94819','无损检测工管理','HJGL/PersonManage/CheckerManage.aspx',20,'3EFCE9C3-1983-4AEC-8FA1-D7A90F08CBCB','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('eab01c05-d6ae-4c3f-9367-e95a6aedaf1a','13F11D51-1B54-400F-BDBB-36685BC94819','修改',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6341239e-6a24-465a-867f-60d60f724f6d','13F11D51-1B54-400F-BDBB-36685BC94819','保存',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4c356a22-1a10-4e8c-b402-85190bd966e9','13F11D51-1B54-400F-BDBB-36685BC94819','查看',3)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('1D009522-D2C6-4256-B4FB-3E5E061A23D7','焊接工艺评定','',30,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','焊接工艺规程编制','HJGL/WPQ/WPQList.aspx',20,'1D009522-D2C6-4256-B4FB-3E5E061A23D7','Menu_HJGL',0,1,1)
GO
/*焊接工艺评定*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8329629E-4643-4198-80E6-484D1C6EDEED','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F722D1DE-20A1-4583-A5FF-C1C4382224FE','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A42C1619-A6AE-44BB-B8A6-DAD4ED8A8EA5','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FFAB108F-2424-40A8-85AE-729378681A9D','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','保存',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('46FE8A9E-4739-4758-9D16-FF82904789F6','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','导入',5)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('274C462B-3E47-4970-8492-51C2F3603BF5','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','导出',6)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4D3D3E46-0FBA-4F2E-AA4E-0D8EDDC5D845','63CD1C52-1A87-4946-9CA7-8C3C2CB0CA2E','查看',7)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','焊口基础信息','',40,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','管线信息','HJGL/WeldingManage/PipelineList.aspx',10,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','Menu_HJGL',0,1,1)
GO
/*管线管理*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0D805149-7D81-44E4-A94C-0B409D33AF9C','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('14C05A28-353E-4AF5-B060-150743BF491A','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('559EE5FF-4CFE-4751-8B92-70967074F300','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('78541946-2B46-46B7-A6E8-224F96DFCDB9','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','保存',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D6A20878-6A61-4693-9E3A-575DD2143617','8IDKGJE2-09B1-6UIO-3EFM-5TGED48F0001','查看',5)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('32F5CC8C-E0F4-456C-AB88-77E36269FA50','焊口基础信息','HJGL/WeldingManage/WeldJointList.aspx',20,'8IDKGJE2-09B1-4607-DCS2-DCC3O48F080F','Menu_HJGL',0,1,1)
GO
/*焊口基础信息*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A011071D-AD84-40AB-A47F-F3B5C1AA830B','32F5CC8C-E0F4-456C-AB88-77E36269FA50','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1674F54E-7928-4A30-8806-334F3C7A7093','32F5CC8C-E0F4-456C-AB88-77E36269FA50','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EAFB612A-5209-46C6-A653-05CB31D4F971','32F5CC8C-E0F4-456C-AB88-77E36269FA50','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('E92BBD02-304A-46B6-9B23-D7491F3F8994','32F5CC8C-E0F4-456C-AB88-77E36269FA50','保存',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3B71DE7A-6508-4522-AD5B-96E0FBDF5D77','32F5CC8C-E0F4-456C-AB88-77E36269FA50','查看',5)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('4D36E99E-B3D8-4C61-826A-CBD98EC51515','焊接日报','',50,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('6ce0b6bc-aa4d-4f0d-9f1f-75a553810793','焊接任务单','HJGL/WeldingManage/WeldTask.aspx',10,'4D36E99E-B3D8-4C61-826A-CBD98EC51515','Menu_HJGL',0,1,1)
GO
/*焊接任务单*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('46a7d961-6d25-4c7f-af06-3c613fc6fd74','6ce0b6bc-aa4d-4f0d-9f1f-75a553810793','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('671b16af-1e5d-482c-a51b-ae01b50dd8e9','6ce0b6bc-aa4d-4f0d-9f1f-75a553810793','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('15450068-414a-4dde-a175-3b5a34df85d6','6ce0b6bc-aa4d-4f0d-9f1f-75a553810793','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('21743940-338a-4adc-8753-64bb90c16dd8','6ce0b6bc-aa4d-4f0d-9f1f-75a553810793','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('294A4F70-B19E-4D84-A09D-484128D9CC19','预提交日报审核','HJGL/WeldingManage/PreWeldReportAudit.aspx',40,'4D36E99E-B3D8-4C61-826A-CBD98EC51515','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('BED081DC-44FC-40E0-8D15-AC57738CE9D1','294A4F70-B19E-4D84-A09D-484128D9CC19','审核',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','焊接日报','HJGL/WeldingManage/WeldReport.aspx',50,'4D36E99E-B3D8-4C61-826A-CBD98EC51515','Menu_HJGL',0,1,1)
GO
/*焊接日报*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('997FDAE7-C4E8-44DE-9AA7-D5003F6D6BEC','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('93B807D4-2723-468A-96BA-F4D7C8A9CADA','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2A70F46A-8E58-4803-9ED6-C0F5F2952CB4','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('03FE46CE-F8BA-44AD-9482-4C7644A26E86','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','保存',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DF712F86-FAC7-4966-8BB7-C976DF1885F5','5TYHMD2F-2582-4DEB-905E-6E9DCFEFBGHO','查看',5)
GO
--6.热处理/硬度管理
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('7FE911EF-616A-4F04-AACD-E53E633A9E86','热处理/硬度管理','',60,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('90579BE7-E38C-4CD2-A3BC-755169FF3BB2','热处理委托','HJGL/HotProcessHard/HotProessTrust.aspx',10,'7FE911EF-616A-4F04-AACD-E53E633A9E86','Menu_HJGL',0,1,1)
GO
/*热处理委托及数据录入*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5C7CC252-2686-49C3-83B1-7494CA011662','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C5F195E3-696C-47D2-9102-FE5744B88A87','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8BFC9AEC-931C-4197-9795-4DF4E976B325','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('89A481B0-708E-45A2-A1ED-7BEABE53EB79','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','保存',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B8C7E5BC-A341-418D-921F-FC317F0DE1A2','90579BE7-E38C-4CD2-A3BC-755169FF3BB2','查看',5)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('71a7de4f-5216-41cb-bcc9-8a5e43d5d168','热处理报告','HJGL/HotProcessHard/HotProessReport.aspx',20,'7FE911EF-616A-4F04-AACD-E53E633A9E86','Menu_HJGL',0,1,1)
GO
/*热处理报告及数据录入*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('479ceaf7-39dd-473b-ab78-59bb14ebde64','71a7de4f-5216-41cb-bcc9-8a5e43d5d168','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7bdcc0f8-8c81-4d6f-94da-7e95fb0795a1','71a7de4f-5216-41cb-bcc9-8a5e43d5d168','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('a8197327-5004-4a97-8338-c2065ee65145','71a7de4f-5216-41cb-bcc9-8a5e43d5d168','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8cb65fe6-6976-488c-8071-cbf7565d9679','71a7de4f-5216-41cb-bcc9-8a5e43d5d168','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('72B3E508-1315-4CC3-939F-E840FA701A0E','硬度检测委托','HJGL/HotProcessHard/HardTrust.aspx',60,'7FE911EF-616A-4F04-AACD-E53E633A9E86','Menu_HJGL',0,1,1)
GO
/*硬度委托及数据录入*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('F0A352F0-6514-46A4-A41B-722091453078','72B3E508-1315-4CC3-939F-E840FA701A0E','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9466A139-55F5-427C-8276-BD0883D12FE3','72B3E508-1315-4CC3-939F-E840FA701A0E','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('CFDC9109-8EE8-474B-A670-5919E3EA3D39','72B3E508-1315-4CC3-939F-E840FA701A0E','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8F12D774-2407-4C5D-AA13-BAA6E8DC0337','72B3E508-1315-4CC3-939F-E840FA701A0E','保存',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DEE3BE44-C58B-4465-88FD-89510F0D1016','72B3E508-1315-4CC3-939F-E840FA701A0E','查看',5)
GO
--硬度检测报告
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('c5ba5ef6-2112-4fe2-9ada-b8762cb629f6','硬度检测报告','HJGL/HotProcessHard/HardReport.aspx',65,'7FE911EF-616A-4F04-AACD-E53E633A9E86','Menu_HJGL',0,1,1)
GO
/*硬度检测报告及数据录入*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9caf15f8-048d-4522-909b-34f4af38b7ae','c5ba5ef6-2112-4fe2-9ada-b8762cb629f6','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5f84ded3-c23b-4d1e-b50a-936b34dac03b','c5ba5ef6-2112-4fe2-9ada-b8762cb629f6','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5948fe09-6326-463e-87ee-e01dc02808bb','c5ba5ef6-2112-4fe2-9ada-b8762cb629f6','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4f32b10e-7ba3-436e-a3e4-172b46026f4b','c5ba5ef6-2112-4fe2-9ada-b8762cb629f6','保存',4)
GO
--7.点口管理
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('4F07D4BF-5971-4D3C-A0DE-B2ACA8CD82FF','点口管理','',70,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','点口管理','HJGL/PointTrust/PointBatch.aspx',10,'4F07D4BF-5971-4D3C-A0DE-B2ACA8CD82FF','Menu_HJGL',0,1,1)
GO
/*点口管理*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B926906A-DB1A-4C88-9132-99E87DC76536','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','自动点口关闭',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DEA70C82-BACF-4241-ADAB-0988C6F552EC','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','打开重新点口',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('226279B8-039A-4C88-8127-11C2F77EF0CA','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','点口审核',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('25120D60-56DD-4A8F-ADDD-4D704D7C1416','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','取消审核',5)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('FA69A222-DF16-44CF-AA29-558B18972B32','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','生成委托单',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('477D2645-257D-4928-9FE5-3A54241ADF16','3ACE25CE-C5CE-4CEC-AD27-0D5CF1DF2F01','查看',5)
GO
--8.无损检测委托
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('3363C60A-E1ED-445B-BC93-DF2BE04D9759','无损检测委托','',80,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('0CA58EC2-7934-49B3-A2C3-327FAD27C541','无损检测委托单','HJGL/PointTrust/TrustBatch.aspx',10,'3363C60A-E1ED-445B-BC93-DF2BE04D9759','Menu_HJGL',0,1,1)
GO
/*无损委托单*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('94F17203-0D8D-483B-91F4-3C7192629E34','0CA58EC2-7934-49B3-A2C3-327FAD27C541','审核',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('462773FD-CB49-46D5-BA4D-5D82468EBF14','0CA58EC2-7934-49B3-A2C3-327FAD27C541','打印',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('462882FG-CB49-46D5-BA4D-5D82468EBF14','0CA58EC2-7934-49B3-A2C3-327FAD27C541','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('06BCEA33-980E-443E-B23A-1F77DA296314','0CA58EC2-7934-49B3-A2C3-327FAD27C541','查看',4)
GO
--9.无损检测
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('DFDD9655-0284-499C-8842-A238CA97418C','无损检测','',90,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('CDECC461-1897-4D88-BD13-0824E540F565','检测单录入','HJGL/NDT/NDTBatch.aspx',10,'DFDD9655-0284-499C-8842-A238CA97418C','Menu_HJGL',0,1,1)
GO
/*检测单录入*/
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('33586177-63CB-47D5-9669-5AFD79112B24','CDECC461-1897-4D88-BD13-0824E540F565','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('84FDB796-696E-4B66-A78F-3A07046B053D','CDECC461-1897-4D88-BD13-0824E540F565','保存',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D7487947-BBFF-44E7-A071-E9E9C825F4E2','CDECC461-1897-4D88-BD13-0824E540F565','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('18A85977-EC3C-4BC6-9F5D-4232EFB043D6','CDECC461-1897-4D88-BD13-0824E540F565','审核',4)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('154D9616-2ECC-4589-AC5B-31E0CB4DE8F6','CDECC461-1897-4D88-BD13-0824E540F565','取消审核',5)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D32CCB3F-D17B-4252-AE6C-C56E8A008409','CDECC461-1897-4D88-BD13-0824E540F565','生成返修通知单',6)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AFD236D2-403A-42B4-B0C0-0B6F28F6C703','CDECC461-1897-4D88-BD13-0824E540F565','查看',7)
GO
--10.返修检测委托
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('E7533566-73A9-4507-8FCB-1FE713819A24','返修检测委托','',100,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('6D215BF6-7002-46B3-B2EA-A57CD849F0F1','返修/扩透','HJGL/RepairAndExpand/RepairAndExpand.aspx',10,'E7533566-73A9-4507-8FCB-1FE713819A24','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('050820DE-6B81-4BE7-A19D-29EC9F087BEC','6D215BF6-7002-46B3-B2EA-A57CD849F0F1','保存',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('DA002E4A-3EDE-4060-9BB8-18B8F122D6D2','6D215BF6-7002-46B3-B2EA-A57CD849F0F1','审核',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A87470B4-2594-4C06-A4E1-98A971041499','6D215BF6-7002-46B3-B2EA-A57CD849F0F1','取消审核',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('2B1B88D3-6641-4B5F-AAF1-D6CFC02AD27F','6D215BF6-7002-46B3-B2EA-A57CD849F0F1','查看',4)
GO
--11.试压管理
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('A24B7926-EF69-456E-8A24-936D30384680','试压管理','',110,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','试压包划分','HJGL/TestPackage/TestPackageEdit.aspx',10,'A24B7926-EF69-456E-8A24-936D30384680','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D4A245E0-E89D-40A9-983C-2B3FF3F14331','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('43D348E8-52F5-4F5C-8264-8B1EC8E41C7F','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('66F6BF4D-1B12-45A7-827A-9167A4B5AC6B','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A88FD1A9-B3B6-4E3C-81F3-57CDB3D984FA','1C6F9CA9-FDAC-4CE5-A19C-5536538851E1','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('55976B16-2C33-406E-B514-2FE42D031071','试压前条件确认','HJGL/TestPackage/TestPackageAudit.aspx',20,'A24B7926-EF69-456E-8A24-936D30384680','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B29CC5BA-A54E-4B88-AC20-B9193BFDD9A3','55976B16-2C33-406E-B514-2FE42D031071','审核',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A50474FB-78B5-4DAD-B5B0-1DCBAD738E98','55976B16-2C33-406E-B514-2FE42D031071','取消审核',2)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('24941EDC-CED6-4176-8CCD-EB5F08156D08','尾项检查及消项','HJGL/TestPackage/ItemEndCheck.aspx',30,'A24B7926-EF69-456E-8A24-936D30384680','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D0725173-165E-406C-AEDC-D80C42B6DD28','24941EDC-CED6-4176-8CCD-EB5F08156D08','修改',0)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('03348952-1EB1-455E-851C-59A98715C8EA','24941EDC-CED6-4176-8CCD-EB5F08156D08','保存',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('495A7D66-D911-4722-BBE3-39ABA0FA4D84','24941EDC-CED6-4176-8CCD-EB5F08156D08','删除',2)
GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('B7EF02DC-45AB-4CFB-ADC8-8340D85D57AD','试压后尾项B检查','HJGL/TestPackage/BItemEndCheck.aspx',40,'A24B7926-EF69-456E-8A24-936D30384680','Menu_HJGL',0,1,1)
--GO
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AB0B02FA-7E03-411C-92CD-3AD3F77408BC','B7EF02DC-45AB-4CFB-ADC8-8340D85D57AD','保存',1)
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EBC430E7-0944-4868-85D8-DF83A2182B65','B7EF02DC-45AB-4CFB-ADC8-8340D85D57AD','删除',2)
--GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('82951D78-9029-4F69-A032-00C47551B3E6','压力试验','HJGL/TestPackage/TestPackageComplete.aspx',50,'A24B7926-EF69-456E-8A24-936D30384680','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('58443F60-212D-4890-AB2B-56C38BA91D2F','82951D78-9029-4F69-A032-00C47551B3E6','试压包完成',1)
GO
--12.焊接报表
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('F3B157B7-9BEE-4150-80CB-087828F1C51D','焊接数据分析','',120,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('075232DC-7C0B-4A5D-B9E4-6B37CB1A9C69','焊接一次合格率','HJGL/WeldingReport/FirstPassRate.aspx',10,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7D735BE5-49F7-4A08-B95F-1262CA542C59','075232DC-7C0B-4A5D-B9E4-6B37CB1A9C69','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('66A76F90-96A7-4C1F-B8D9-125DDEACEF52','单位工程进度分析','HJGL/WeldingReport/UnitWorkareaAnalyze.aspx',20,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('76A14B06-16EE-4292-A103-3E96D6BA617E','66A76F90-96A7-4C1F-B8D9-125DDEACEF52','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('88CDDC68-54DE-4E24-9524-A33B80EC0E12','单位工程质量分析','HJGL/WeldingReport/UnitWorkAreaQuality.aspx',30,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7928E47B-81D3-4661-8ED7-8F346AAC3082','88CDDC68-54DE-4E24-9524-A33B80EC0E12','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('41C22E63-36B7-4C44-89EC-F765BFBB7C55','焊工业绩分析','HJGL/WeldingReport/WelderPerformance.aspx',40,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('24353DB7-56D4-4227-B491-BE0608E0C13C','41C22E63-36B7-4C44-89EC-F765BFBB7C55','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('464DBFBC-94E8-48A1-AF67-28AACF872470','焊工平均业绩','HJGL/WeldingReport/WelderAvgPerformance.aspx',50,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('309C1841-A539-4AA4-8332-8B58E8111EA8','464DBFBC-94E8-48A1-AF67-28AACF872470','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('0ADD01FB-8088-4595-BB40-6A73F332A229','管线综合分析','HJGL/WeldingReport/IsoCmprehensive.aspx',60,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A1431A25-88FB-477F-9AB2-E854FD4D77C9','0ADD01FB-8088-4595-BB40-6A73F332A229','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('5F0969E3-2A0A-473E-92BE-4DD390602556','焊接缺陷统计','HJGL/WeldingReport/DefectStatistics.aspx',70,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('04E2E628-11D3-41D7-B763-39911716B91C','5F0969E3-2A0A-473E-92BE-4DD390602556','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('CF3CB43C-4031-4CFD-905F-154DC1CB881E','管线综合信息','HJGL/WeldingReport/IsoCompreInfo.aspx',80,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('476B1955-1AC8-47CE-A5BE-A4F672A8F35F','CF3CB43C-4031-4CFD-905F-154DC1CB881E','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('E96D5600-0B06-4817-BE80-BAA9B99E6F4A','无损检测周报','HJGL/WeldingReport/NDTWeeklyReport.aspx',90,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('51FC6D1B-203E-4359-91BD-A628A71CDFFA','E96D5600-0B06-4817-BE80-BAA9B99E6F4A','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('6324E66A-4760-4D10-9EA6-88B792EEAEAF','无损检测月报','HJGL/WeldingReport/NDTMonthlyReport.aspx',100,'F3B157B7-9BEE-4150-80CB-087828F1C51D','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A1BF9B3A-A9FB-4442-A68C-489C48139EC7','6324E66A-4760-4D10-9EA6-88B792EEAEAF','查看',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('96e7b541-7364-4075-a2b2-d6e0024f1781','泄露性/真空管理','',115,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('4b1c7e7d-dc3e-46f6-b1e9-fab4457e7684','泄露性/真空试验录入','HJGL/LeakVacuum/LeakVacuumEdit.aspx',10,'96e7b541-7364-4075-a2b2-d6e0024f1781','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('a6117ff6-0c6e-406c-bca2-eaefc286fa73','4b1c7e7d-dc3e-46f6-b1e9-fab4457e7684','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('07cf29be-e032-4232-8321-3c1c7151e4cf','4b1c7e7d-dc3e-46f6-b1e9-fab4457e7684','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3c6190c5-3fe6-4f26-b661-8c23d9c35107','4b1c7e7d-dc3e-46f6-b1e9-fab4457e7684','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7895baa3-7712-4c1d-ba8d-2f2e175ea9a5','4b1c7e7d-dc3e-46f6-b1e9-fab4457e7684','保存',4)
GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('578bff7d-c944-48df-8dfa-dd5526337a81','泄漏性／真空尾项检查','HJGL/LeakVacuum/LV_ItemEndCheck.aspx',20,'96e7b541-7364-4075-a2b2-d6e0024f1781','Menu_HJGL',0,1,1)
--GO
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('ed04541d-1509-40eb-86c5-0004aad04fad','578bff7d-c944-48df-8dfa-dd5526337a81','保存',1)
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('fa441e33-b91e-46d3-acf5-d52b62d04098','578bff7d-c944-48df-8dfa-dd5526337a81','删除',2)
--GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('9f5136ec-fc9a-47b0-b085-41a1a46b77d6','泄漏性／真空试验审核','HJGL/LeakVacuum/LeakVacuumAudit.aspx',30,'96e7b541-7364-4075-a2b2-d6e0024f1781','Menu_HJGL',0,1,1)
--GO
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('3b365be5-639e-4528-b789-6cc03d83154a','9f5136ec-fc9a-47b0-b085-41a1a46b77d6','审核',1)
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5dced5a2-bdfd-4333-8b7c-31a0401ed6aa','9f5136ec-fc9a-47b0-b085-41a1a46b77d6','取消审核',2)
--GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('4c980bd6-b57d-4a28-b337-83603e81e116','泄漏性／真空试验完成','HJGL/LeakVacuum/LeakVacuumComplete.aspx',50,'96e7b541-7364-4075-a2b2-d6e0024f1781','Menu_HJGL',0,1,1)
--GO
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('19eeca10-c8aa-4973-8667-f777d6bf0854','4c980bd6-b57d-4a28-b337-83603e81e116','试压包完成',1)
--GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('3fa44880-96d1-46ab-84b2-1f975dbcf193','吹扫/清洗管理','',120,'0','Menu_HJGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('e6da5ef9-aa42-49dd-b6a6-b54a3b922d68','吹扫/清洗试验录入','HJGL/PurgingCleaning/PurgingCleaningEdit.aspx',10,'3fa44880-96d1-46ab-84b2-1f975dbcf193','Menu_HJGL',0,1,1)
GO
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('540530b3-b28b-4fae-9a0d-caa8ba9b055e','e6da5ef9-aa42-49dd-b6a6-b54a3b922d68','增加',1)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('48beb1b1-3abe-495f-b9d8-d5142763969a','e6da5ef9-aa42-49dd-b6a6-b54a3b922d68','修改',2)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('9072845e-9884-441c-8ad7-2faa06e6827a','e6da5ef9-aa42-49dd-b6a6-b54a3b922d68','删除',3)
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('30f2584f-57b8-478a-8803-edda26bd050f','e6da5ef9-aa42-49dd-b6a6-b54a3b922d68','保存',4)
GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('af47c6ea-755e-409e-ae69-04479952755a','吹扫/清洗尾项检查','HJGL/PurgingCleaning/PC_ItemEndCheck.aspx',20,'3fa44880-96d1-46ab-84b2-1f975dbcf193','Menu_HJGL',0,1,1)
--GO
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('5489962e-b9b8-4fce-a950-ffb63433a792','af47c6ea-755e-409e-ae69-04479952755a','保存',1)
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('226b8ee9-c6a0-4a55-b44f-fea1ea268dca','af47c6ea-755e-409e-ae69-04479952755a','删除',2)
--GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('67f3aee2-2a02-4b02-aaef-a9d8fbfd2f01','吹扫/清洗试验审核','HJGL/PurgingCleaning/PurgingCleaningAudit.aspx',30,'3fa44880-96d1-46ab-84b2-1f975dbcf193','Menu_HJGL',0,1,1)
--GO
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('6ba8d609-ba12-4fe2-b005-decb80ee675b','67f3aee2-2a02-4b02-aaef-a9d8fbfd2f01','审核',1)
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('40668bd5-e4d9-4a76-9a02-883fc2284ce0','67f3aee2-2a02-4b02-aaef-a9d8fbfd2f01','取消审核',2)
--GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('5f343a44-15ae-4c6a-9cbe-e8322a548ce5','吹扫/清洗试验完成','HJGL/PurgingCleaning/PurgingCleaningComplete.aspx',50,'3fa44880-96d1-46ab-84b2-1f975dbcf193','Menu_HJGL',0,1,1)
--GO
--INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('39c4abb1-daca-4162-8bb9-80c752f011da','5f343a44-15ae-4c6a-9cbe-e8322a548ce5','试压包完成',1)
--GO
Reference in New Issue View Git Blame Copy Permalink