172 lines
12 KiB
Transact-SQL
172 lines
12 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_PZHGL')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_PZHGL'
|
|
--go
|
|
/****综合管理******/
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1DFB41AB-526C-4246-B2A7-A201AB334C17','总承包商施工计划','',10,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('0DAFF358-EA16-44B2-8E4B-E15E40EFAAD0','总承包商施工报告','',20,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4CB03F8B-C967-4082-ADF1-08776FE40E21','施工日志','',30,'0','Menu_PZHGL',0,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('0383A4A1-1565-4F11-BAF3-2B84CB621796','个人施工日志','PZHGL/InformationProject/ConstructionLog.aspx',10,'4CB03F8B-C967-4082-ADF1-08776FE40E21','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D853D4D4-4D31-45D2-ADF4-F8799EC68B02','0383A4A1-1565-4F11-BAF3-2B84CB621796','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3A559270-B5F8-4FD3-B6DA-37D5D5C7CAFB','0383A4A1-1565-4F11-BAF3-2B84CB621796','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('86812B35-34D8-42DE-B989-BC1DDA6B7CD3','0383A4A1-1565-4F11-BAF3-2B84CB621796','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C179D43F-10C7-48F1-A06D-D09A9C0433D2','0383A4A1-1565-4F11-BAF3-2B84CB621796','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D3F67A7B-2FC4-468A-98BB-5F3DF2F193C4','项目施工日志','PZHGL/InformationProject/ProjectConstructionLog.aspx',20,'4CB03F8B-C967-4082-ADF1-08776FE40E21','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D7CE42E6-2641-453B-9AE5-11F0570E00F8','D3F67A7B-2FC4-468A-98BB-5F3DF2F193C4','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2B47E22C-6A37-4E16-A6A1-70386DDC5F81','D3F67A7B-2FC4-468A-98BB-5F3DF2F193C4','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('817A0F17-C2F9-4EF7-9889-844064933757','D3F67A7B-2FC4-468A-98BB-5F3DF2F193C4','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('7CA03E95-00EA-4118-A8EA-F27CE48ACBA7','D3F67A7B-2FC4-468A-98BB-5F3DF2F193C4','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1C190A15-CC04-441C-AEF3-C945A53A81A6','日志文件柜','PZHGL/InformationProject/ConstructionLogFileCabinet.aspx',30,'4CB03F8B-C967-4082-ADF1-08776FE40E21','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('CD88CE2A-A8E2-4F07-9A90-9161BD1C345C','工作交接','',40,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('4F5C00F3-DA7D-4B2D-B1EF-310DFFCA77DD','来往文件管理','PZHGL/InformationProject/ReceiveFileManager.aspx',50,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D6386C75-FAB4-4188-B5F8-9D10041C811A','4F5C00F3-DA7D-4B2D-B1EF-310DFFCA77DD','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('740D8F89-98A1-4DE2-A818-54024092F441','4F5C00F3-DA7D-4B2D-B1EF-310DFFCA77DD','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D034F64F-0BD3-4C34-91FD-ADDBD7AD09AE','4F5C00F3-DA7D-4B2D-B1EF-310DFFCA77DD','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3E9B53A3-ACC6-4BE2-A02D-948CED42B358','4F5C00F3-DA7D-4B2D-B1EF-310DFFCA77DD','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('BBABC8E0-FBD0-41C5-8DB9-951CB5C0AC35','4F5C00F3-DA7D-4B2D-B1EF-310DFFCA77DD','提交',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('44140854-701D-4D67-AD8E-AA8DD48B6D6A','移动端首页数据','PZHGL/ProjectData/ProjectPageData.aspx',60,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C65C5FFF-4EA7-4A5C-9AFA-44B27ED7C5C5','44140854-701D-4D67-AD8E-AA8DD48B6D6A','保存',1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F266456A-991F-45A3-BCD6-CF2515D71E39','项目施工平面布置图','PZHGL/ProjectData/ProjectMap.aspx',70,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DF9EDDB2-F76D-4CAD-8EBB-4D7D574A82F9','F266456A-991F-45A3-BCD6-CF2515D71E39','保存',1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('B58179BE-FE6E-4E91-84FC-D211E4692354','项目亮点','PZHGL/InformationProject/Picture.aspx',80,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2B7C6B79-6BE6-4032-BAAD-61998B60FD18','B58179BE-FE6E-4E91-84FC-D211E4692354','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DA4020F0-BFC6-4BD3-886F-BC40FE0FF6CB','B58179BE-FE6E-4E91-84FC-D211E4692354','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('030CF6D1-7D6A-49A9-AA1A-C514A455AD85','B58179BE-FE6E-4E91-84FC-D211E4692354','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('826A3F40-797E-48C6-96E0-E2B7CE88C948','B58179BE-FE6E-4E91-84FC-D211E4692354','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E4662F45-D430-4294-BC14-4D1027CC7F7A','B58179BE-FE6E-4E91-84FC-D211E4692354','提交',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('43E96F2A-9497-4C37-998F-0EB324000609','工作联系单','CQMS/Unqualified/ContactList.aspx',90,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3E8A8D04-93BC-4B9A-A59E-596570539088','43E96F2A-9497-4C37-998F-0EB324000609','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('0B9EC330-EDBD-4EC3-AFAD-C4B84AAA8A09','43E96F2A-9497-4C37-998F-0EB324000609','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3321089A-8232-4404-82F0-7DC08792662A','43E96F2A-9497-4C37-998F-0EB324000609','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F626FAC0-A2CF-4591-BA10-13E1301357ED','43E96F2A-9497-4C37-998F-0EB324000609','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6C1CB28E-DE08-44F2-AD72-3311FEE23DCF','43E96F2A-9497-4C37-998F-0EB324000609','提交',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('87867EA8-576A-4166-AE7A-7416115DF30B','工程联络单','CQMS/Check/TechnicalContactList.aspx',91,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('4038F770-94C7-4908-A418-5C08BDD23F27','87867EA8-576A-4166-AE7A-7416115DF30B','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('68F179A9-3D35-4E60-A7CB-21A5002B2CCA','87867EA8-576A-4166-AE7A-7416115DF30B','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('30153752-DA3B-4875-8618-14C08D557497','87867EA8-576A-4166-AE7A-7416115DF30B','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AB47219C-C026-4A7B-B8AC-7AAE2EBA2922','87867EA8-576A-4166-AE7A-7416115DF30B','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1BE5F5C6-1829-4975-A484-3720B2CED804','87867EA8-576A-4166-AE7A-7416115DF30B','提交',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('38F11FC6-E9F0-4ABD-BD78-BB1807EA3CE3','设计变更','CQMS/Check/Design.aspx',92,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1CE1CBE5-E38E-4AEC-BBC3-63FA10C50FF6','38F11FC6-E9F0-4ABD-BD78-BB1807EA3CE3','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('470A66ED-CFF9-427E-B7A6-DD963E4D4D1E','38F11FC6-E9F0-4ABD-BD78-BB1807EA3CE3','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2340876B-469F-4BD1-B5CE-D96416A9E9B9','38F11FC6-E9F0-4ABD-BD78-BB1807EA3CE3','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C2623574-A8C9-4183-BF89-D02257FDB64C','38F11FC6-E9F0-4ABD-BD78-BB1807EA3CE3','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('3FBB9592-A383-4163-B1B8-06C9FBC7F49C','38F11FC6-E9F0-4ABD-BD78-BB1807EA3CE3','提交',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3A9039B2-20DC-47FA-A943-E3604FBBF699','施工图纸','CQMS/Check/Draw.aspx',93,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1881CDE5-B4A1-4BC3-8CA7-DE966F5C6FC8','3A9039B2-20DC-47FA-A943-E3604FBBF699','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('5FE886C2-A9C6-45D3-B312-A79116DAB62D','3A9039B2-20DC-47FA-A943-E3604FBBF699','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D9007864-4DD2-42F2-82BF-728D015E2274','3A9039B2-20DC-47FA-A943-E3604FBBF699','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EB1E4B30-66E6-45E2-B8D8-8D8382E97E15','3A9039B2-20DC-47FA-A943-E3604FBBF699','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F50EDEF0-FCDE-4B84-8D30-1F16E03FE26F','施工月报','PZHGL/InformationProject/ConstructionMonthReport.aspx',95,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('AFEBD968-295E-4E43-8D86-508B1E0B784B','F50EDEF0-FCDE-4B84-8D30-1F16E03FE26F','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('C6A2DA3D-163C-4FA5-8EF1-67F07CB72429','F50EDEF0-FCDE-4B84-8D30-1F16E03FE26F','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('143704FE-D865-42A4-ABA6-EAB87466AA51','F50EDEF0-FCDE-4B84-8D30-1F16E03FE26F','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('833F9250-7646-4C1B-97AA-70511DD04C31','F50EDEF0-FCDE-4B84-8D30-1F16E03FE26F','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('25AC041E-0B27-4D7C-860B-1A06518B6673','文件柜','',100,'0','Menu_PZHGL',0,0,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F274F84A-B648-4ABA-99D4-993AA6D1143A','工作联系单','CQMS/Check/WorkContactFile.aspx',10,'25AC041E-0B27-4D7C-860B-1A06518B6673','Menu_PZHGL',0,1,1)
|
|
GO |