/// <summary>
/// 获取所有功能项,若input有值则排除该功能项
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public Task <IEnumerable <SystemMenuButtonFunctionOutput> > GetAllFunctions(SystemMenuButtonGetFunctionsInput input)
{
StringBuilder sql =
new StringBuilder(@"SELECT func.* AppCode FROM dbo.System_Function func ");
if (!input.Id.IsNullOrEmptyGuid())
{
sql.Append(
" WHERE 1=1 AND func.FunctionId NOT IN (SELECT FunctionId FROM System_MenuButtonFunction WHERE MenuButtonId=@menuButtonId)");
}
if (input.IsPage)
{
sql.Append(string.Format(" AND func.IsPage='{0}'", input.IsPage));
}
sql.Append(" ORDER BY Area,Controller,IsPage DESC");
return(SqlMapperUtil.SqlWithParams <SystemMenuButtonFunctionOutput>(sql.ToString(), new { menuButtonId = input.Id }));
}
/// <summary>
/// 获取所有功能项,若input有值则排除该功能项
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <IEnumerable <SystemMenuButtonFunctionOutput> > GetAllFunctions(SystemMenuButtonGetFunctionsInput input)
{
return((await _menuButtonFunctionRepository.GetAllFunctions(input)).ToList());
}
public async Task <JsonResult> GetAllFunctions(SystemMenuButtonGetFunctionsInput input)
{
input.IsPage = true;
return(Json(await _menuButtonFunctionLogic.GetAllFunctions(input)));
}
