17 lines
857 B
Transact-SQL
17 lines
857 B
Transact-SQL
--公司级看板数据
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('087F4FAF-3B00-462A-9040-4CB3556F8177','看板数据维护','HSSE/BoardData.aspx',240,'0','Menu_HSSE',1,1,1)
|
|
go
|
|
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values(NEWID(),'087F4FAF-3B00-462A-9040-4CB3556F8177','增加',1)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values(NEWID(),'087F4FAF-3B00-462A-9040-4CB3556F8177','修改',2)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values(NEWID(),'087F4FAF-3B00-462A-9040-4CB3556F8177','删除',3)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values(NEWID(),'087F4FAF-3B00-462A-9040-4CB3556F8177','保存',4)
|
|
go
|
|
|
|
|
|
update sys_menu set IsUsed=0 where menuid='B06DD352-61C6-453C-A9C7-9CF10918AF08' |