98 lines
6.4 KiB
Transact-SQL
98 lines
6.4 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,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 Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('53F0B89E-A69F-4E7A-BE1C-0ADAC7F504DE','关键事项','',110,0,'Menu_PZHGL',0,0,1)
|
|
|
|
insert into Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('0BEA2126-7A48-40EB-8E21-99148E91A22B','关键事项','PZHGL/GJSX/GJSXList.aspx',10,'53F0B89E-A69F-4E7A-BE1C-0ADAC7F504DE','Menu_PZHGL',0,1,1)
|
|
insert into Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('5F3B18D6-9FBA-4EF5-A7E4-DC9F6A4EA680','关键事项查询','PZHGL/GJSX/GJSXFind.aspx',20,'53F0B89E-A69F-4E7A-BE1C-0ADAC7F504DE','Menu_PZHGL',0,1,1)
|
|
insert into Sys_Menu( MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType ,IsOffice,IsEnd,IsUsed )
|
|
values('CAA875A7-089B-4B79-87CE-742FDFD9DE43','关键事项统计','PZHGL/GJSX/GJSXInfoCount.aspx',30,'53F0B89E-A69F-4E7A-BE1C-0ADAC7F504DE','Menu_PZHGL',0,1,1)
|
|
|
|
|
|
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 |