84 lines
5.4 KiB
Transact-SQL
84 lines
5.4 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_Personal')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_Personal'
|
|
--go
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C48343FA-ADC6-4551-86AD-7B68C27A6170','个人信息','Personal/PersonalInfo.aspx',10,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('BAB254FA-C879-4463-B9DE-387C241A8623','密码修改','SysManage/UpdatePassword.aspx',20,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('00BCD912-6275-40A2-8CB1-591389118DA9','BAB254FA-C879-4463-B9DE-387C241A8623','编辑',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1F9897F0-0D3A-441A-B62B-7CC4852807C1','BAB254FA-C879-4463-B9DE-387C241A8623','重置',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('5554D845-879C-47B7-AD8D-DF0B23D749CC','BAB254FA-C879-4463-B9DE-387C241A8623','保存',3)
|
|
GO
|
|
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('C6EF06E5-9019-4583-8122-EA94FCC545C6','员工总结','',30,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('71feb79b-fe0c-4a5f-acd1-a396017b95ec','C6EF06E5-9019-4583-8122-EA94FCC545C6','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('d37f33b8-ab50-4c92-8f8f-fda22a78c388','C6EF06E5-9019-4583-8122-EA94FCC545C6','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('056628a8-466c-4cab-9d28-e67584197f02','C6EF06E5-9019-4583-8122-EA94FCC545C6','保存',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('16820e01-fc96-422d-8c6c-a7b8a31c1564','C6EF06E5-9019-4583-8122-EA94FCC545C6','删除',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('AAF841AA-2EE8-4FEC-B1FB-B978736C6E1F','员工责任书','Personal/PersonDuty.aspx',40,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('CB373458-30B0-4850-ABFF-B38D40A04D43','员工绩效考核结果','Personal/PersonCheckInfo.aspx',50,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('6549EF60-1DED-4912-8D2D-7B32A80A2DEC','视频会议','Personal/PersonMeeting.aspx',60,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('522EAECC-3D40-4804-A066-A43BA8F6BFC1','员工出差记录','Personal/BusinessTrip.aspx',70,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('8B969A75-E5CC-424F-A3FA-4AABAFD83776','522EAECC-3D40-4804-A066-A43BA8F6BFC1','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('577F9981-3EA0-4EFA-A37F-D34313FA75A0','522EAECC-3D40-4804-A066-A43BA8F6BFC1','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F6CCDCAF-D922-4463-A446-21F5202F88E3','522EAECC-3D40-4804-A066-A43BA8F6BFC1','保存',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('CA9037CE-F174-4664-9566-86313C4B8B70','522EAECC-3D40-4804-A066-A43BA8F6BFC1','删除',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('16229932-671B-4E04-BB61-A5C7DE4CE47F','员工开车绩效记录','Personal/TestRunPerformance.aspx',80,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('85D7D848-2848-4DA8-817B-45854F823ACF','16229932-671B-4E04-BB61-A5C7DE4CE47F','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('5C7EED44-CA88-48DC-8F45-816CCFDD27BB','16229932-671B-4E04-BB61-A5C7DE4CE47F','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('08C5FB21-7B0B-4A6B-B7B6-EB9DA928ECE3','16229932-671B-4E04-BB61-A5C7DE4CE47F','保存',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('64D20EC1-23E3-4163-9FD5-BD75DA0BB270','16229932-671B-4E04-BB61-A5C7DE4CE47F','删除',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F0792B77-AEE4-4834-82C2-E5B75D0B0AB7','开车月技术总结','Personal/TestRunMonthSummary.aspx',90,'0','Menu_Personal',0,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('ACEEE043-26ED-4C5E-B0AC-BDF511D67919','F0792B77-AEE4-4834-82C2-E5B75D0B0AB7','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('EDC39144-E757-4DA7-99B4-06E67A4829C4','F0792B77-AEE4-4834-82C2-E5B75D0B0AB7','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('9043447A-07F3-497D-810E-03A24A2FAC38','F0792B77-AEE4-4834-82C2-E5B75D0B0AB7','保存',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('88F477AB-BA4B-4157-9728-F8B6B593296E','F0792B77-AEE4-4834-82C2-E5B75D0B0AB7','删除',4)
|
|
GO |