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));
}
