122 lines
8.0 KiB
Transact-SQL
122 lines
8.0 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_Person')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_Person'
|
|
--go
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('20AB6116-A8D3-4D72-8800-79F80AE66D85','员工信息','Person/PersonSet.aspx',10,'0','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('301bf07e-c5fe-4658-9759-6e709730b5aa','20AB6116-A8D3-4D72-8800-79F80AE66D85','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('65a99b31-fcfc-4071-8591-9704867e473a','20AB6116-A8D3-4D72-8800-79F80AE66D85','修改',2)
|
|
--INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
--VALUES('87CBED4A-BCFF-4E95-BFE9-B654C07E574A','20AB6116-A8D3-4D72-8800-79F80AE66D85','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('ADE212A1-E5AA-49BB-820B-9CFB589DC84F','20AB6116-A8D3-4D72-8800-79F80AE66D85','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('3BF62723-9448-4A29-A239-0A17566F50E8','员工总结','Person/PersonTotal.aspx',20,'0','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('B726D24F-7E7D-4D87-B077-FDCEE6E8D109','3BF62723-9448-4A29-A239-0A17566F50E8','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E5383EA8-9141-4E27-82EA-24515771F4EB','3BF62723-9448-4A29-A239-0A17566F50E8','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('55E15D60-7F15-412D-9EFE-638114BA3DDD','3BF62723-9448-4A29-A239-0A17566F50E8','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('DF6DE32E-8069-4312-BDE2-47570F0C04E4','3BF62723-9448-4A29-A239-0A17566F50E8','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1D8B35D2-5C8F-4FF4-96E4-8EB61BDBAE51','员工培训','Person/PersonTraining.aspx',30,'0','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('830eebb4-dbc5-41ed-b838-d21e172049e3','1D8B35D2-5C8F-4FF4-96E4-8EB61BDBAE51','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('717275e8-0f09-4ce4-8259-ba59c92640fe','1D8B35D2-5C8F-4FF4-96E4-8EB61BDBAE51','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('47121a2f-95cc-454f-b80a-72ee054cdd4a','1D8B35D2-5C8F-4FF4-96E4-8EB61BDBAE51','保存',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('cb40ef74-3e12-4e56-a30f-9b236306b82a','1D8B35D2-5C8F-4FF4-96E4-8EB61BDBAE51','删除',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('A913653D-1EBB-4F55-97C9-81CC5B5913C4','员工责任书','Person/PersonDuty.aspx',40,'0','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('ccd07444-ffdb-40ec-bf93-ada8a43c3fd8','A913653D-1EBB-4F55-97C9-81CC5B5913C4','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2ceedb4b-1602-401d-b4c1-9e6cd45cc4a5','A913653D-1EBB-4F55-97C9-81CC5B5913C4','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('29a0bdef-f6b5-426e-9003-91dcb4b717f9','A913653D-1EBB-4F55-97C9-81CC5B5913C4','保存',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2989c8a9-1e9b-4cbe-907a-36684a077fa7','A913653D-1EBB-4F55-97C9-81CC5B5913C4','删除',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DD111492-E5F1-4E6F-BCAD-BA26EA184761','员工考核','Person/PersonCheck.aspx',50,'0','Menu_Person',1,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DC31E45E-0EE9-4601-825D-8F388B6D9B71','分流管理','Person/Shunt.aspx',60,'0','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('A56DD84C-F5FF-4E84-99EF-5F95826288B6','DC31E45E-0EE9-4601-825D-8F388B6D9B71','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('2A087BA8-5DBE-4F1C-92B1-9ADE89369E16','DC31E45E-0EE9-4601-825D-8F388B6D9B71','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('E34451E7-C84B-4D7B-A58E-22541652FF62','DC31E45E-0EE9-4601-825D-8F388B6D9B71','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('D100D727-E5AB-40CD-810B-1C6C32E6AF36','DC31E45E-0EE9-4601-825D-8F388B6D9B71','保存',4)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6D944EF4-6C05-4EBF-B2ED-4309B6E34169','DC31E45E-0EE9-4601-825D-8F388B6D9B71','提交',5)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('F9E911AB-2B5A-489D-B9AF-3EA97C2826A2','知识竞赛','',70,'0','Menu_Person',1,0,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('A048350B-25E6-4DE1-A701-73638656D15F','制定计划','PersonManage/Test/TestPlan.aspx',10,'F9E911AB-2B5A-489D-B9AF-3EA97C2826A2','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('FB9D383C-B7AF-46F9-AF53-0B9F30C8F696','A048350B-25E6-4DE1-A701-73638656D15F','增加',1)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('6F9D316F-60A7-428E-821A-33DFBA556FD8','A048350B-25E6-4DE1-A701-73638656D15F','修改',2)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1ECFC9D3-8337-4668-A41C-2BFAB0F319FD','A048350B-25E6-4DE1-A701-73638656D15F','删除',3)
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('827A2357-2688-4D2B-A443-D1887F7F10E5','A048350B-25E6-4DE1-A701-73638656D15F','保存',4)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('64CFD530-A4F9-4857-BE3C-D243B4333ECA','答题记录','PersonManage/Test/TestRecord.aspx',20,'F9E911AB-2B5A-489D-B9AF-3EA97C2826A2','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('1A5E01E7-2E55-4ECE-9130-D6CD5CFA599D','64CFD530-A4F9-4857-BE3C-D243B4333ECA','删除',1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('19FB0C6D-E2CA-4352-B635-060347D45C4A','成绩排名','PersonManage/Test/TestRanking.aspx',30,'F9E911AB-2B5A-489D-B9AF-3EA97C2826A2','Menu_Person',1,1,1)
|
|
GO
|
|
|
|
--员工管理
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('0E46F8F2-69DB-4F54-BCA0-1F3CBE57DA10','人员初步规划','Person/PersonPlan.aspx',80,'0','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('34D71F63-D749-4307-9268-8348F3F81ACB','0E46F8F2-69DB-4F54-BCA0-1F3CBE57DA10','导入',1)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('44D71A21-49BB-4D71-98CD-97909AB21918','0E46F8F2-69DB-4F54-BCA0-1F3CBE57DA10','修改',2)
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('61ADEE69-5B20-4E5B-991B-25AF31C76E3C','0E46F8F2-69DB-4F54-BCA0-1F3CBE57DA10','删除',3)
|
|
GO
|
|
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1E490AB0-B211-4F17-8B2A-C7A840DD9D72','人员初步规划图形分析','Person/PersonPlanChart.aspx',90,'0','Menu_Person',1,1,1)
|
|
GO
|
|
INSERT INTO Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
VALUES('F134A25C-999F-4924-9750-386616AEF285','1E490AB0-B211-4F17-8B2A-C7A840DD9D72','查询',1)
|
|
GO |