49 lines
3.1 KiB
Transact-SQL
49 lines
3.1 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_Server')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_Server'
|
|
--go
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C502FC6D-DE43-4646-AE28-168D8C7BF4C0','检查通知单','OfficeCheck/Check/CheckNotice.aspx',5,'0','Menu_Server',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('27DFFD9F-2EA1-4C6A-8E7F-90E521858D71','C502FC6D-DE43-4646-AE28-168D8C7BF4C0','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EB9BD937-E01B-4A0A-9CBA-4BD7E04CEEF2','C502FC6D-DE43-4646-AE28-168D8C7BF4C0','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('77CCFDD7-52D3-4C92-98A4-EC2F8CAB058C','C502FC6D-DE43-4646-AE28-168D8C7BF4C0','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D12487AE-9DB9-40CB-81BB-F85B5A119A76','C502FC6D-DE43-4646-AE28-168D8C7BF4C0','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('6090DD54-FE59-4011-92EE-9906C9BC69B6','发起检查','OfficeCheck/Check/CheckInfo.aspx ',10,'0','Menu_Server',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B9D4DF05-C44F-4F3D-B032-C6790D80BC95','6090DD54-FE59-4011-92EE-9906C9BC69B6','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('95D6D61B-61DD-49C2-8F7D-91F4152AC08F','6090DD54-FE59-4011-92EE-9906C9BC69B6','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6E4F7A16-524A-4598-AD4D-D0FBA9BCE6AA','6090DD54-FE59-4011-92EE-9906C9BC69B6','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('4C4A5211-A1D4-4582-829D-58BD79D2E055','6090DD54-FE59-4011-92EE-9906C9BC69B6','保存',4)
|
|
GO
|
|
|
|
|
|
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
--VALUES('C619988F-307B-4A39-B518-7F45CA7326F5','检查记录','',20,'0','Menu_Server',1,1,1)
|
|
--GO
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DEE90726-E00D-462B-A4BF-7E36180DD5B8','项目绩效评价','OfficeCheck/ProjectEvaluation/ProjectEvaluation.aspx',30,'0','Menu_Server',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('BD80E37E-C93B-4237-A5C8-01856625638F','DEE90726-E00D-462B-A4BF-7E36180DD5B8','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FDC3F84E-AA3D-47BD-97FE-6A6D1EE9EBFA','DEE90726-E00D-462B-A4BF-7E36180DD5B8','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6E1FC020-19F5-461F-B12F-72057671273C','DEE90726-E00D-462B-A4BF-7E36180DD5B8','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('04AB7BF7-C527-45D4-B98D-082F10D25CA0','DEE90726-E00D-462B-A4BF-7E36180DD5B8','保存',4)
|
|
GO
|