41 lines
1.5 KiB
Transact-SQL
41 lines
1.5 KiB
Transact-SQL
-- 奖品等级设置菜单 (Admin数据库)
|
|
-- 在商品管理下添加奖品等级设置菜单
|
|
|
|
-- 查找商品管理的菜单ID
|
|
DECLARE @GoodsMenuId BIGINT;
|
|
SELECT @GoodsMenuId = Id FROM menus WHERE Name = N'商品管理' AND MenuType = 1;
|
|
|
|
-- 如果商品管理菜单存在，则添加奖品等级设置子菜单
|
|
IF @GoodsMenuId IS NOT NULL
|
|
BEGIN
|
|
-- 检查是否已存在
|
|
IF NOT EXISTS (SELECT 1 FROM menus WHERE Name = N'奖品等级设置' AND ParentId = @GoodsMenuId)
|
|
BEGIN
|
|
INSERT INTO menus (ParentId, Name, Path, Component, Permission, Icon, SortOrder, MenuType, Status, IsExternal, IsCache, CreatedAt)
|
|
VALUES (@GoodsMenuId, N'奖品等级设置', '/business/goods/prize-level', 'business/goods/prize-level', 'goods:prize-level', 'Medal', 30, 2, 1, 0, 1, GETDATE());
|
|
|
|
PRINT N'奖品等级设置菜单添加成功';
|
|
|
|
-- 获取新插入的菜单ID
|
|
DECLARE @NewMenuId BIGINT = SCOPE_IDENTITY();
|
|
|
|
-- 分配给超级管理员角色
|
|
DECLARE @SuperAdminRoleId BIGINT;
|
|
SELECT @SuperAdminRoleId = Id FROM roles WHERE Code = 'super_admin';
|
|
|
|
IF @SuperAdminRoleId IS NOT NULL
|
|
BEGIN
|
|
INSERT INTO role_menus (RoleId, MenuId) VALUES (@SuperAdminRoleId, @NewMenuId);
|
|
PRINT N'已分配给超级管理员角色';
|
|
END
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
PRINT N'奖品等级设置菜单已存在';
|
|
END
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
PRINT N'商品管理菜单不存在，请先创建商品管理菜单';
|
|
END
|