/// <summary>
/// 根据权限归属Id查询菜单权限信息
/// </summary>
/// <param name="input">权限类型:菜单、功能项、数据、字段、文件</param>
/// <returns></returns>
public Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue(
SystemPermissionByPrivilegeMasterValueInput input)
{
var sql =
new StringBuilder(
"SELECT PrivilegeAccessValue FROM System_Permission WHERE PrivilegeAccess=@privilegeAccess");
sql.Append(
input.PrivilegeMaster == EnumPrivilegeMaster.人员
? " AND PrivilegeMasterValue IN (SELECT PrivilegeMasterValue FROM System_PermissionUser WHERE PrivilegeMasterUserId=@privilegeMasterValue)"
: " AND PrivilegeMasterValue=@privilegeMasterValue");
if (!input.PrivilegeMenuId.IsNullOrEmptyGuid())
{
sql.Append(" AND PrivilegeMenuId=@privilegeMenuId");
}
sql.Append(" GROUP BY PrivilegeAccessValue");
return(SqlMapperUtil.SqlWithParams <SystemPermission>(sql.ToString(),
new
{
privilegeAccess = (byte)input.PrivilegeAccess,
privilegeMasterValue = input.PrivilegeMasterValue,
privilegeMenuId = input.PrivilegeMenuId
}));
}
public async Task <JsonResult> GetPermissionByPrivilegeMasterValue(SystemPermissionByPrivilegeMasterValueInput input)
{
return(Json(await _permissionLogic.GetPermissionByPrivilegeMasterValue(input)));
}
/// <summary>
/// 根据状态为True的菜单信息
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue(SystemPermissionByPrivilegeMasterValueInput input)
{
return((await _permissionRepository.GetPermissionByPrivilegeMasterValue(input)).ToList());
}
