本文共 355 字，大约阅读时间需要 1 分钟。
SELECT sp.st_id AS StId, sp.rl_id AS RlId, rl.rl_name AS RoleName FROM act_staffpermission sp INNER JOIN act_role rl ON sp.rl_id = rl.rl_id WHERE 1=1 AND sp.st_id = #UserId# AND rl.warehouse_id IN #WarehouseIds[]#
转载于:https://www.cnblogs.com/xakml/p/10874745.html