22 lines
947 B
Transact-SQL
22 lines
947 B
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_PZHGL')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_PZHGL'
|
|
--go
|
|
/****综合管理******/
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('46DAFA3B-36E2-417B-85EE-E338958A9BC3','施工日志','',10,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('935199C0-1E35-461B-882D-DF7506ACFEE7','周报','',20,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('33102EAD-9E19-4F07-B236-C79DAE7ADA21','月报','',30,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('FDBBB584-78DE-4A25-925B-9082653C22EC','项目绩效','',40,'0','Menu_PZHGL',0,1,1)
|
|
GO
|
|
|