38 lines
1.5 KiB
Transact-SQL
38 lines
1.5 KiB
Transact-SQL
|
||
|
||
--注意！！！执行之前看下客户有没有数据上报菜单（Menu_ZHGL），如果没有MenuType改为：Menu_ZHGL
|
||
|
||
--集团督查检查
|
||
IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = '8B9C0F42-D36F-4798-94AB-F56723E8B714')
|
||
BEGIN
|
||
--集团督查检查
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('8B9C0F42-D36F-4798-94AB-F56723E8B714','集团督查检查',null,60,'0','Menu_ZHGL',1,0,1)
|
||
|
||
--督查检查通知单
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('15443DE9-4AC2-43F9-A622-9F9253ECB157','督查检查通知单','DCGL/ServerCheck/CheckNotice.aspx',10,'8B9C0F42-D36F-4798-94AB-F56723E8B714','Menu_ZHGL',1,1,1)
|
||
|
||
--集团下发督查检查整改
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('2E4A3E58-44B7-41B0-BFE3-634DF29AAE27','集团下发督查检查整改','DCGL/ServerCheck/CheckRectify.aspx',20,'8B9C0F42-D36F-4798-94AB-F56723E8B714','Menu_ZHGL',1,1,1)
|
||
END
|
||
GO
|
||
|
||
|
||
--集团下发督查检查整改按钮
|
||
IF NOT EXISTS (SELECT * FROM Sys_ButtonToMenu WHERE MenuId = '2E4A3E58-44B7-41B0-BFE3-634DF29AAE27')
|
||
BEGIN
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('002D5E43-8A3B-4B48-8058-5175347224BD','2E4A3E58-44B7-41B0-BFE3-634DF29AAE27','修改',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('D8548A9A-5522-4DBC-BF17-31EE21AA97E9','2E4A3E58-44B7-41B0-BFE3-634DF29AAE27','保存',2)
|
||
END
|
||
GO
|
||
|
||
|
||
|
||
|
||
|
||
|