CNCEC_SUBQHSE_WUHUAN/DataBase/菜单初始化脚本/1-4进度管理(Menu_JDGL).sql

251 lines
17 KiB
Transact-SQL

delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_JDGL')
go
delete from Sys_Menu where MenuType='Menu_JDGL'
go
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('B707B4E0-EF73-4010-A13B-59263A5029C7','单位、分部、分项工程设置','',10,'0','Menu_JDGL',0,0,1)
--GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('858E83E9-ADE5-452E-BD65-82D8DFF872C0','分部、工作项及费用清单裁剪','JDGL/WBS/WBSSetAudit.aspx',10,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('004CD808-1E02-4AD8-8C4B-7F805C12CCDC','858E83E9-ADE5-452E-BD65-82D8DFF872C0','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B7FBE5AB-C02A-4FE7-9D6D-D8C4B5EAE146','858E83E9-ADE5-452E-BD65-82D8DFF872C0','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('04075797-5B97-41D0-B596-B8CF18B27A35','858E83E9-ADE5-452E-BD65-82D8DFF872C0','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('6E53397A-00FB-425B-B884-7AC9710D0924','858E83E9-ADE5-452E-BD65-82D8DFF872C0','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('82E1EB3B-3589-4C32-9C20-40125CE6EAB4','设备材料分类','',15,'0','Menu_JDGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('F2BC1293-8639-4BD6-8759-648BCF6346E9','设备材料大类','JDGL/WBS/EquipmentMaterialBigType.aspx',4,'82E1EB3B-3589-4C32-9C20-40125CE6EAB4','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A6A7CDD7-B223-4A80-9A0E-8E0F4B4E422A','F2BC1293-8639-4BD6-8759-648BCF6346E9','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('0D343597-D1FD-4CD5-9F23-43E6A68FE26B','F2BC1293-8639-4BD6-8759-648BCF6346E9','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D003035F-CE86-4A71-AD3A-33CD4E260A00','F2BC1293-8639-4BD6-8759-648BCF6346E9','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('6210DDB2-9196-4315-9308-009BD3A85E78','F2BC1293-8639-4BD6-8759-648BCF6346E9','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('D00B3C53-2972-4D24-B88F-B38880D4A24F','设备材料分类','JDGL/WBS/EquipmentMaterialType.aspx',5,'82E1EB3B-3589-4C32-9C20-40125CE6EAB4','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('3B588E9C-B89C-466B-B1A6-A8986F04EBA6','D00B3C53-2972-4D24-B88F-B38880D4A24F','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9522CCE6-9F26-4C4B-84AC-708E7FC7F39D','D00B3C53-2972-4D24-B88F-B38880D4A24F','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('D2F495A5-33D0-49B2-BEF5-BA96C9283D71','D00B3C53-2972-4D24-B88F-B38880D4A24F','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2AE8CA32-9218-41A1-AEFF-33B5EB416B08','D00B3C53-2972-4D24-B88F-B38880D4A24F','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('E3905BF1-289B-4500-BD34-36F97D649AFC','工作量录入','JDGL/WBS/WorkloadInput.aspx',20,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('7C48BC93-7923-47F0-AE83-D93FAC8369CE','E3905BF1-289B-4500-BD34-36F97D649AFC','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('2A3F8526-95C7-4D30-B2DD-DD26696BE150','工作量统计','JDGL/WBS/WorkloadStatistics.aspx',30,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C3694283-495F-4AA3-9287-1F40D96230A6','2A3F8526-95C7-4D30-B2DD-DD26696BE150','查询',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('59AAE0F0-2DB6-4065-B304-7E2C56EC3E5D','赢得值曲线','JDGL/CostAnalysis/EarnedValueCurve.aspx',40,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DA8CC928-675F-4BF4-B684-87387629B339','59AAE0F0-2DB6-4065-B304-7E2C56EC3E5D','查询',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('D1FC6ACA-C789-401C-B9FB-3A96FFE4C8AC','进度报表','JDGL/CostAnalysis/JDReport.aspx',45,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('43C643F5-93E4-40E3-A66B-C34D26CF454E','D1FC6ACA-C789-401C-B9FB-3A96FFE4C8AC','查询',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('9CAF311E-C234-4DA4-B235-D4E478FBD80E','里程碑','JDGL/WBS/MilePost.aspx',50,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A1FAC2ED-A671-4656-AA6F-A2807A130D50','9CAF311E-C234-4DA4-B235-D4E478FBD80E','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BC0F5AF3-F9E9-4058-903E-3DD4A3C77158','9CAF311E-C234-4DA4-B235-D4E478FBD80E','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('37319E6D-23C9-4CF0-B917-31AE86FD01F7','9CAF311E-C234-4DA4-B235-D4E478FBD80E','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('60462BF3-3F78-4E17-8E15-451A108D5475','9CAF311E-C234-4DA4-B235-D4E478FBD80E','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('94287B92-7E96-4B90-BC6F-DAF30AE3B314','月度计划情况','JDGL/Check/MonthPlan.aspx',51,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8672C3E5-C819-4906-BB7D-50A5319F7B79','94287B92-7E96-4B90-BC6F-DAF30AE3B314','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('C75747BA-F48D-4A2F-8DD1-D2DABEEE125F','94287B92-7E96-4B90-BC6F-DAF30AE3B314','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('11049A9C-C66C-44E2-B9E8-FEC69D498CBD','94287B92-7E96-4B90-BC6F-DAF30AE3B314','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('F136D1B4-A988-42E7-AD7C-4A246B440D03','94287B92-7E96-4B90-BC6F-DAF30AE3B314','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('56A54B4B-BBA3-4249-9FFC-3A60DAC79059','周进度计划','JDGL/Check/WeekPlan.aspx',52,'0','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9371CFCF-E162-49FD-BC48-CE178E153F51','56A54B4B-BBA3-4249-9FFC-3A60DAC79059','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('DC978D83-FC78-4A7E-888A-581082F0F70D','56A54B4B-BBA3-4249-9FFC-3A60DAC79059','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BE4B07C7-EFE7-47F1-BBF9-A60930F70BDD','56A54B4B-BBA3-4249-9FFC-3A60DAC79059','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('A8102F40-6E06-49EB-9471-3FF4DC745226','56A54B4B-BBA3-4249-9FFC-3A60DAC79059','保存',4)
GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('27C1D718-2DC0-42A5-96C0-F7A2D0DBC5F6','进度测量标志(权重)设置','',20,'0','Menu_JDGL',0,0,1)
--GO
-- INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
-- VALUES('6844F671-8545-4DD9-B9A0-AA36CB5F1D6F','进度测量标志(权重)设置','JDGL/WBSWeights/WeightsAudit.aspx',10,'27C1D718-2DC0-42A5-96C0-F7A2D0DBC5F6','Menu_JDGL',0,1,1)
-- GO
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('DCC4B8BA-9B20-47B8-9067-DD1DC3D55415','6844F671-8545-4DD9-B9A0-AA36CB5F1D6F','保存',1)
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('170A1EB4-5102-4A86-B57E-5F61B13A3236','6844F671-8545-4DD9-B9A0-AA36CB5F1D6F','审核',2)
-- GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('BE150D8E-9BAB-4207-9CDD-5B05E847D906','进度计划及计划值设置','',30,'0','Menu_JDGL',0,0,1)
--GO
-- INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
-- VALUES('9FEB264F-4124-48E8-A43C-5663BBFB55F0','进度计划及计划值设置','JDGL/WBSPlan/WBSPlanAudit.aspx',10,'BE150D8E-9BAB-4207-9CDD-5B05E847D906','Menu_JDGL',0,1,1)
-- GO
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('0B90094F-1428-47F9-8939-F997B0E50AC7','9FEB264F-4124-48E8-A43C-5663BBFB55F0','保存',1)
-- GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('0B9BFD3F-AD3A-41D0-9144-9BABCB8E8422','实际进度(完成值/实耗值)测量','',40,'0','Menu_JDGL',0,0,1)
--GO
-- INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
-- VALUES('6CFA0EE1-F075-417E-9D96-05B31122BB95','实际进度(完成值/实耗值)测量录入','JDGL/WBSCompleteAndReal/WBSCompleteAudit.aspx',10,'0B9BFD3F-AD3A-41D0-9144-9BABCB8E8422','Menu_JDGL',0,1,1)
-- GO
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('C9801907-F716-47CF-ACDA-CCE884123AE9','6CFA0EE1-F075-417E-9D96-05B31122BB95','保存',1)
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('F3FFB663-83F8-463D-9643-99D564B79BDF','6CFA0EE1-F075-417E-9D96-05B31122BB95','提交',2)
-- GO
-- INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
-- VALUES('4FB962B3-905B-4560-9957-46A11392BB0B','进度(完成值)测量报告','JDGL/WBSCompleteAndReal/WBSReport.aspx',20,'0B9BFD3F-AD3A-41D0-9144-9BABCB8E8422','Menu_JDGL',0,1,1)
-- GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('3478449A-681A-4DB1-8E79-598BB24DD0C4','进度/费用偏差分析与纠偏','',50,'0','Menu_JDGL',0,0,1)
--GO
-- INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
-- VALUES('64197BF4-2622-4588-B49B-815188184CE2','赢得值曲线','JDGL/CostAnalysis/EarnedValueCurve.aspx',10,'3478449A-681A-4DB1-8E79-598BB24DD0C4','Menu_JDGL',0,1,1)
-- GO
-- INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
-- VALUES('AA5C8AB2-CE89-41BC-B7B5-C689ED368B98','计划调整及纠偏措施设置','JDGL/CostAnalysis/PlanAdjust.aspx',20,'3478449A-681A-4DB1-8E79-598BB24DD0C4','Menu_JDGL',0,1,1)
-- GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('2344465A-F43E-495E-98E7-9AC1C6484F5C','工程量清单设置','JDGL/Check/QuantityList.aspx',60,'0','Menu_JDGL',0,1,1)
--GO
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('35BBBD54-29F1-4D46-9745-3500B6B00267','2344465A-F43E-495E-98E7-9AC1C6484F5C','增加',1)
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('52B28F04-AECA-4FDD-B5FA-45EC22CAC50B','2344465A-F43E-495E-98E7-9AC1C6484F5C','修改',2)
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('FC4DAA4C-7E3A-4627-A2A8-1286018C4B30','2344465A-F43E-495E-98E7-9AC1C6484F5C','删除',3)
-- INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
-- VALUES('4705582D-0389-4226-9D44-D906691F3310','2344465A-F43E-495E-98E7-9AC1C6484F5C','保存',4)
-- GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('92CBD072-20F8-45B1-9D17-6F7494DD2020','数据导入','',60,'0','Menu_JDGL',0,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('F3AA42B3-5776-4992-A625-1216C579FEDE','项目进度情况','JDGL/Check/ProgressCompletion.aspx',60,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('8232DE3C-307C-49ED-9A37-6C29A94AABDF','F3AA42B3-5776-4992-A625-1216C579FEDE','增加',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BFF4796D-734B-49C3-BAEA-D15437D72BA4','F3AA42B3-5776-4992-A625-1216C579FEDE','修改',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9884E883-9C71-4F76-A7E0-BBC030911548','F3AA42B3-5776-4992-A625-1216C579FEDE','删除',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('08C87DB8-494D-47F3-B271-7548CCE72E7A','F3AA42B3-5776-4992-A625-1216C579FEDE','保存',4)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('2AE9D982-A499-497F-8F54-ADDA5856887E','工程量完成情况','JDGL/Check/QuantityCompletion.aspx',70,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BDBABEE5-DE52-47BA-9799-ACB7EE76F3FA','2AE9D982-A499-497F-8F54-ADDA5856887E','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('82E513B9-1A6F-495A-A633-EBC89CE5273A','低温储罐完成情况','JDGL/Check/LowTankCompletion.aspx',80,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B09CE48A-C905-49A9-AFF1-AE15B5B71422','82E513B9-1A6F-495A-A633-EBC89CE5273A','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('4ACA0647-4D44-462E-8277-1EF9F100566A','钢结构完成情况','JDGL/Check/SteelStructureCompletion.aspx',90,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('9EACCE68-163F-4E47-B1AF-179E813B3A12','4ACA0647-4D44-462E-8277-1EF9F100566A','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('92FD1845-F56C-4111-8BA0-91838A18B750','设备完成情况','JDGL/Check/EquipmentCompletion.aspx',100,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B69B59B4-E58D-40F6-8097-D6782FE3ED68','92FD1845-F56C-4111-8BA0-91838A18B750','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('9AE07A76-3A54-4414-BC8C-C86A18C737BA','管道完成情况','JDGL/Check/PipelineCompletion.aspx',110,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('EB18C5C6-3303-410B-ACA9-A82B3239CDA4','9AE07A76-3A54-4414-BC8C-C86A18C737BA','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('8A8A1050-F227-42ED-9456-8CB5ECA36512','电气完成情况','JDGL/Check/ElectricalCompletion.aspx',120,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('5EDC2141-3218-4C80-9A69-AD1FBD5BCEF5','8A8A1050-F227-42ED-9456-8CB5ECA36512','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('7EC1FBAF-BEC9-46CD-9E3B-0D0093B4E1C2','仪表完成情况','JDGL/Check/MeterCompletion.aspx',130,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('10527FF2-975E-49DA-B4C7-3FE69FCBA7B3','7EC1FBAF-BEC9-46CD-9E3B-0D0093B4E1C2','保存',1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('C7037A5D-D8A6-4C1C-A5B8-2083C31C0A7B','全厂地下管网完成情况','JDGL/Check/UndergroundPipeCompletion.aspx',140,'92CBD072-20F8-45B1-9D17-6F7494DD2020','Menu_JDGL',0,1,1)
GO
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('BECB2F6E-90D5-432C-A56C-9F8AAF62C511','C7037A5D-D8A6-4C1C-A5B8-2083C31C0A7B','保存',1)
GO