/// <summary>
/// 根据角色Id,岗位Id,组Id,人员Id获取具有的菜单信息
/// </summary>
/// <param name="input">输入参数</param>
/// <returns>树形菜单信息</returns>
/// GetMenuPermissionByPrivilegeMasterValue
public Task <IEnumerable <JsTreeEntity> > GetMenuHavePermissionByPrivilegeMasterValue(SystemPermissiontMenuHaveByPrivilegeMasterValueInput input)
{
var sql =
new StringBuilder("SELECT MenuId id,ParentId parent,name text,icon FROM System_Menu menu WHERE MenuId IN( SELECT PrivilegeAccessValue FROM System_Permission WHERE PrivilegeAccess=@privilegeAccess AND ");
sql.Append(
input.PrivilegeMaster == EnumPrivilegeMaster.人员
? " PrivilegeMasterValue IN (SELECT PrivilegeMasterValue FROM System_PermissionUser WHERE PrivilegeMasterUserId=@privilegeMasterValue) "
: " PrivilegeMasterValue=@privilegeMasterValue ");
sql.Append(" GROUP BY PrivilegeAccessValue) AND menu.IsFreeze=@isFreeze");
if (input.PrivilegeAccess != null)
{
switch (input.PrivilegeAccess)
{
case EnumPrivilegeAccess.菜单按钮:
sql.Append(" AND menu.HaveFunctionPermission='true'");
break;
case EnumPrivilegeAccess.数据权限:
sql.Append(" AND menu.HaveDataPermission='true'");
break;
case EnumPrivilegeAccess.字段:
sql.Append(" AND menu.HaveFieldPermission='true'");
break;
case EnumPrivilegeAccess.菜单:
sql.Append(" AND menu.HaveMenuPermission='true'");
break;
}
}
sql.Append(" ORDER BY OrderNo");
return(SqlMapperUtil.SqlWithParams <JsTreeEntity>(sql.ToString(),
new
{
privilegeAccess = EnumPrivilegeAccess.菜单,
privilegeMasterValue = input.PrivilegeMasterValue,
isFreeze = false
}));
}
public async Task <JsonResult> GetMenuHavePermissionByPrivilegeMasterValue(SystemPermissiontMenuHaveByPrivilegeMasterValueInput input)
{
return(JsonForJsTree((await _permissionLogic.GetMenuHavePermissionByPrivilegeMasterValue(input)).ToList()));
}
/// <summary>
/// 根据角色Id,岗位Id,组Id,人员Id获取具有的菜单信息
/// </summary>
/// <param name="input">输入参数</param>
/// <returns>树形菜单信息</returns>
public async Task <IEnumerable <JsTreeEntity> > GetMenuHavePermissionByPrivilegeMasterValue(SystemPermissiontMenuHaveByPrivilegeMasterValueInput input)
{
return((await _permissionRepository.GetMenuHavePermissionByPrivilegeMasterValue(input)).ToList());
}
