35 lines
1.1 KiB
SQL
35 lines
1.1 KiB
SQL
/* 修改人:Ld 修改时间:2026-08-06 16:15:15; 精确修正角色2新一级菜单下误迁的占位授权记录 */
|
|
SET XACT_ABORT ON;
|
|
BEGIN TRAN;
|
|
|
|
UPDATE dbo.基础表_角色模块信息
|
|
SET pid = 161,
|
|
是否启用 = 1,
|
|
角色模块顺序 = CASE IDD
|
|
WHEN 1184 THEN 1
|
|
WHEN 1181 THEN 3
|
|
WHEN 1183 THEN 10
|
|
WHEN 1185 THEN 11
|
|
WHEN 1187 THEN 12
|
|
WHEN 1182 THEN 7
|
|
WHEN 1186 THEN 13
|
|
ELSE 角色模块顺序
|
|
END
|
|
WHERE 角色编号 = 2
|
|
AND IDD IN (1184, 1181, 1183, 1185, 1187, 1182, 1186);
|
|
|
|
UPDATE dbo.基础表_角色模块信息
|
|
SET 是否启用 = 0
|
|
WHERE 角色编号 = 2
|
|
AND IDD = 1177;
|
|
|
|
SELECT p.title AS 一级菜单, c.id AS 二级ID, c.title AS 二级菜单, r.IDD, r.是否启用, r.角色模块顺序
|
|
FROM dbo.基础表_角色模块信息 r
|
|
INNER JOIN dbo.基础表_模块信息 c ON c.id = r.id
|
|
LEFT JOIN dbo.基础表_模块信息 p ON p.id = r.pid
|
|
WHERE r.角色编号 = 2
|
|
AND r.IDD IN (1184, 1181, 1183, 1185, 1187, 1182, 1186, 1177)
|
|
ORDER BY r.是否启用 DESC, p.id, r.角色模块顺序, c.id;
|
|
|
|
COMMIT TRAN;
|