/// <summary>
/// get user permission list
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <UserPermissionEntity> GetUserPermissionList(int userID)
{
try
{
var param = new DynamicParameters();
param.Add("@userID", userID);
return(QuickRepository.ExecProcQuery <UserPermissionEntity>("dbo.pr_sys_UserResourceListGet", param)
.ToList <UserPermissionEntity>());
}
catch (System.Exception ex)
{
throw;
}
}
/// <summary>
/// get user resource permission allowed
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <RoleResourcePermissionView> GetResourcePermissionAllowed(int userID)
{
try
{
var param = new DynamicParameters();
param.Add("@userID", userID);
var list = QuickRepository.ExecProcQuery <RoleResourcePermissionView>("pr_sys_ResourceListAllowedGetByUserOrRole",
param).ToList <RoleResourcePermissionView>();
return(list);
}
catch (System.Exception ex)
{
//NLogWriter.Error("获取用户资源权限列表(用于用户管理，显示有效权限)失败!", ex);
throw;
}
}
/// <summary>
/// get resource by user id
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <ResourceEntity> GetResourceByUserID(int userID)
{
try
{
var param = new DynamicParameters();
param.Add("@userID", userID);
var list = QuickRepository.ExecProcQuery <ResourceEntity>("pr_sys_ResourceListGetByUserID",
param).ToList <ResourceEntity>();
return(list);
}
catch (System.Exception ex)
{
//NLogWriter.Error("根据UserID获取资源列表(用于用户登录,保存可操作资源)失败!", ex);
throw;
}
}
///// <summary>
///// 根据资源ID，从临时列表获取资源
///// </summary>
///// <param name="resourceID"></param>
///// <param name="list"></param>
///// <returns></returns>
//private ResourceNode GetResourceByID(int resourceID, List<ResourceNode> list)
//{
// var node = (from a in list
// where a.ID == resourceID
// select a).FirstOrDefault<ResourceNode>();
// return node;
//}
/// <summary>
/// 获取用户资源权限列表(用于用户分配资源权限)
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <RoleResourcePermissionView> GetResourcePermission(RoleUserQuery query)
{
try
{
var param = new DynamicParameters();
param.Add("@userID", query.UserID);
param.Add("@roleID", query.RoleID);
var list = QuickRepository.ExecProcQuery <RoleResourcePermissionView>("pr_sys_ResourcePermissionGetListByUserRole",
param).ToList <RoleResourcePermissionView>();
return(list);
}
catch (System.Exception ex)
{
//NLogWriter.Error("获取用户资源权限列表(用于用户分配资源权限)失败!", ex);
throw;
}
}
///// <summary>
///// 获取左侧导航菜单
///// </summary>
///// <returns></returns>
//public ResourceNode GetLeftMenu(int userID)
//{
// var list = GetLeftMenuList(userID);
// var bv = new ResourceNode
// {
// ID = 0,
// ResourceCode = "LEFT_MENU_ROOT",
// ResourceName = "左侧导航树"
// };
// bv.children = GetChildren(0, list);
// return bv;
//}
/// <summary>
/// 查询左侧导航树数据
/// </summary>
/// <returns></returns>
public List <ResourceEntity> GetLeftMenuList(int userID)
{
List <ResourceEntity> list = null;
try
{
var param = new DynamicParameters();
param.Add("@userID", userID);
list = QuickRepository.ExecProcQuery <ResourceEntity>("pr_sys_ResourceLeftMenuGetByUser", param)
.ToList <ResourceEntity>();
return(list);
}
catch (System.Exception ex)
{
//NLogWriter.Error("查询左侧导航树数据失败!", ex);
throw;
}
}
/// <summary>
/// retrieve user resource data for treeview display
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <UserResourcePermissionView> RetrieveUserResourceList(int userID)
{
List <UserResourcePermissionView> list = null;
try
{
var param = new DynamicParameters();
param.Add("@userID", userID);
list = QuickRepository.ExecProcQuery <UserResourcePermissionView>("pr_sys_UserResourceListRetrieveByUser",
param).ToList <UserResourcePermissionView>();
return(list);
}
catch (System.Exception ex)
{
//NLogWriter.Error("根据角色获取资源许可失败!", ex);
throw;
}
}
/// <summary>
/// get role resource data by roleid
/// </summary>
/// <param name="roleID"></param>
/// <returns></returns>
public List <RoleResourcePermissionView> GetRoleResourceList(int roleID)
{
List <RoleResourcePermissionView> list = null;
try
{
var param = new DynamicParameters();
param.Add("@roleID", roleID);
list = QuickRepository.ExecProcQuery <RoleResourcePermissionView>("pr_sys_RoleResourceListGetByRole",
param).ToList <RoleResourcePermissionView>();
return(list);
}
catch (System.Exception ex)
{
//NLogWriter.Error("根据角色获取资源许可失败!", ex);
throw;
}
}
/// <summary>
/// 根据角色或用户获取资源列表
/// </summary>
/// <param name="roleID"></param>
/// <param name="userID"></param>
/// <returns></returns>
public List <ResourceEntity> GetResourceListByUserRole(int roleID, int userID)
{
List <ResourceEntity> list = null;
try
{
var param = new DynamicParameters();
param.Add("@roleID", roleID);
param.Add("@userID", userID);
list = QuickRepository.ExecProcQuery <ResourceEntity>("pr_sys_ResourceListAllowedGetByUserOrRole",
param).ToList <ResourceEntity>();
return(list);
}
catch (System.Exception ex)
{
//NLogWriter.Error("根据角色获取资源失败!", ex);
throw;
}
}
