public IActionResult NLogData(NLogSearchArg arg) { var parameters = Request.QueryString.ToTableParms(); var pageList = _sysNLogService.AdminSearch(arg, parameters); return(Json(pageList.ToAjax())); }
/// <summary> /// 查询列表 /// </summary> /// <param name="arg"></param> /// <param name="parameters"></param> /// <returns></returns> public IPagedList <Sys_NLogMapping> AdminSearch(NLogSearchArg arg, DataTablesParameters parameters) { var query = _dbContext.Sys_NLog.AsQueryable(); #region 排序 if (!String.IsNullOrEmpty(parameters.OrderName)) { switch (parameters.OrderName) { case "Level": if (parameters.OrderDir.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { query = query.OrderByDescending(o => o.Level); } else { query = query.OrderBy(o => o.Level); } break; case "LoggedFormat": if (parameters.OrderDir.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { query = query.OrderByDescending(o => o.Logged); } else { query = query.OrderBy(o => o.Logged); } break; default: query = query.OrderBy(o => o.Id); break; } } else { query = query.OrderByDescending(o => o.Id); } #endregion var data = query.Select(item => new Sys_NLogMapping() { Id = item.Id, Logged = item.Logged, Level = item.Level, Message = item.Message }); return(PagedList <Sys_NLogMapping> .Create(data, parameters.PageIndex, parameters.Length)); }