47 lines
2.5 KiB
Transact-SQL
47 lines
2.5 KiB
Transact-SQL
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('168A94C7-E37D-4B9C-8684-51DF4F8C5134','关键事项（内部）','',10,'0','Menu_PGJSX',0,0,1)
|
||
go
|
||
|
||
update sys_menu set IsUsed='0' where menuid='5F3B18D6-9FBA-4EF5-A7E4-DC9F6A4EA680';
|
||
update sys_menu set IsUsed='0' where menuid='CAA875A7-089B-4B79-87CE-742FDFD9DE43';
|
||
|
||
--0 我创建的，1待我处理，2我已处理、3我参与的
|
||
--关键事项改成 我创建的
|
||
update sys_menu set SuperMenu='3517DBE2-9728-4BA0-9EA5-AE2147DB883B',MenuName='我创建的',url='PZHGL/GJSX/GJSXList.aspx?classify=0'
|
||
where menuid='0BEA2126-7A48-40EB-8E21-99148E91A22B';
|
||
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('4A9E60ED-24FF-4410-B3B7-2A5079615A78','待我处理','PZHGL/GJSX/GJSXList.aspx?classify=1',20,'168A94C7-E37D-4B9C-8684-51DF4F8C5134','Menu_PGJSX',0,1,1)
|
||
go
|
||
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('BEF7850D-1BA5-45F9-BD40-E52F6D813E7C','我已处理','PZHGL/GJSX/GJSXList.aspx?classify=2',30,'168A94C7-E37D-4B9C-8684-51DF4F8C5134','Menu_PGJSX',0,1,1)
|
||
go
|
||
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('3C129205-F6A9-480D-B36C-E35DED5D7CEC','我参与的','PZHGL/GJSX/GJSXList.aspx?classify=3',40,'168A94C7-E37D-4B9C-8684-51DF4F8C5134','Menu_PGJSX',0,1,1)
|
||
go
|
||
|
||
--协调沟通
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('42791ACB-7C72-481F-B1ED-158C7141522C','协调沟通（外部）','',20,'0','Menu_PGJSX',0,0,1)
|
||
go
|
||
|
||
update sys_menu set SuperMenu='42791ACB-7C72-481F-B1ED-158C7141522C',MenuName='我创建的',url='DocManage/DocManage.aspx?classify=0',MenuType='Menu_PGJSX'
|
||
where menuid='609F0D64-ABB8-4F5C-9646-FC1DFC8BAB85';
|
||
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('2FEF98BD-DBBD-4ADA-B600-18D3C113B22A','待我处理','DocManage/DocManage.aspx?classify=1',20,'42791ACB-7C72-481F-B1ED-158C7141522C','Menu_PGJSX',0,1,1)
|
||
go
|
||
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('5BDEEA43-FFD7-4AEB-B760-24E70009EA0C','我已处理','DocManage/DocManage.aspx?classify=2',30,'42791ACB-7C72-481F-B1ED-158C7141522C','Menu_PGJSX',0,1,1)
|
||
go
|
||
|
||
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
values('58B45CA6-AFFB-4624-80C6-F70C1A54FBE2','我参与的','DocManage/DocManage.aspx?classify=3',40,'42791ACB-7C72-481F-B1ED-158C7141522C','Menu_PGJSX',0,1,1)
|
||
go
|
||
|
||
|
||
|