36 lines
1.4 KiB
Transact-SQL
36 lines
1.4 KiB
Transact-SQL
|
|
|
|
--集团督查检查
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|