using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using FineAdmin.IRepository;
|
using FineAdmin.Model;
|
using Dapper;
|
|
namespace FineAdmin.Repository
|
{
|
public class ModuleRepository : BaseRepository<ModuleModel>, IModuleRepository
|
{
|
/// <summary>
|
/// 根据角色ID获取菜单列表
|
/// </summary>
|
/// <param name="sql"></param>
|
/// <param name="roleId"></param>
|
/// <returns></returns>
|
public IEnumerable<ModuleModel> GetModuleListByRoleId(string sql, int roleId)
|
{
|
using (var conn = OracleHelper.OracleConnection())
|
{
|
sql += @" WHERE id in(SELECT a.ModuleId FROM dbsys_roleauthorize a
|
INNER JOIN dbsys_module b ON a.ModuleId = b.Id
|
WHERE 1=1
|
and a.RoleId = :RoleId
|
GROUP BY a.ModuleId)
|
ORDER BY m.SortCode ASC";
|
return conn.Query<ModuleModel>(sql, new { RoleId = roleId });
|
}
|
}
|
}
|
}
|
