--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