public List <RequestInfo> GetRequestList(GetRequestListRequest request, out int totalCount)
{
string where = " where 1=1 ";
if (!request.Node.IsEmpty())
{
string nodes = string.Join(",", request.Node.Split(",").ToList().Select(x => "'" + x + "'"));
where = where + $" AND Node IN ({nodes})";
}
if (!request.Start.IsEmpty())
{
where = where + $" AND CreateTime >= '{request.Start}' ";
}
if (!request.End.IsEmpty())
{
where = where + $" AND CreateTime < '{request.End}' ";
}
if (!request.IP.IsEmpty())
{
where = where + $" AND IP = '{request.IP}' ";
}
if (!request.Url.IsEmpty())
{
where = where + $" AND Url like '%{request.Url}%' ";
}
string sql = "Select * From RequestInfo " + where;
return(conn.GetListBySql <RequestInfo>(sql, "id desc", request.pageSize, request.pageNumber, out totalCount, request));
}
public async Task <IActionResult> GetRequestList(GetRequestListRequest request)
{
if (request.Start.IsEmpty() && request.End.IsEmpty())
{
request.Start = DateTime.Now.ToString("yyyy-MM-dd");
request.End = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
}
var result = await _storage.SearchRequestInfoAsync(new RequestInfoSearchFilterOption()
{
Nodes = request.Node.IsEmpty() ? null : request.Node.Split(','),
IP = request.IP,
Url = request.Url,
StartTime = request.Start.ToDateTime(),
EndTime = request.End.TryToDateTime(),
Page = request.pageNumber,
PageSize = request.pageSize,
IsOrderByField = true,
Field = RequestInfoFields.CreateTime,
IsAscend = true,
}).ConfigureAwait(false);
return(Json(new { total = result.AllItemCount, rows = result.List }));
}
public IActionResult GetRequestList(GetRequestListRequest request)
{
int totalCount = 0;
var list = _dataService.GetRequestList(request, out totalCount);
return(Json(new { total = totalCount, rows = list }));
}
public IActionResult GetRequestList(GetRequestListRequest request)
{
int totalCount = 0;
if (request.Start.IsEmpty() && request.End.IsEmpty())
{
request.Start = DateTime.Now.ToString("yyyy-MM-dd");
request.End = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
}
var list = _dataService.GetRequestList(request, out totalCount);
return(Json(new { total = totalCount, rows = list }));
}
public async Task <string> GetRequestList(GetRequestListRequest request)
{
#region BuildService
if (request.Service.IsEmpty() || request.Service == "ALL")
{
request.Service = "";
}
if (request.Instance.IsEmpty() || request.Instance == "ALL")
{
request.LocalIP = "";
request.LocalPort = 0;
}
else
{
request.LocalIP = request.Instance.Substring(0, request.Instance.LastIndexOf(':'));
request.LocalPort = request.Instance.Substring(request.Instance.LastIndexOf(':') + 1).ToInt();
}
#endregion
var result = await _storage.SearchRequestInfoAsync(new RequestInfoSearchFilterOption()
{
TraceId = request.TraceId,
StatusCodes = request.StatusCode.IsEmpty() ? null : request.StatusCode.Split(',').Select(x => x.ToInt()).ToArray(),
Service = request.Service,
LocalIP = request.LocalIP,
LocalPort = request.LocalPort,
IP = request.IP,
Url = request.Url,
StartTime = request.Start.ToDateTime(),
EndTime = request.End.TryToDateTime(),
Page = request.pageNumber,
PageSize = request.pageSize,
IsOrderByField = true,
Field = RequestInfoFields.CreateTime,
IsAscend = false,
StartTimeFormat = "yyyy-MM-dd HH:mm:ss",
EndTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(Json(new { total = result.AllItemCount, rows = result.List }));
}
public async Task <IActionResult> GetRequestList([FromBody] GetRequestListRequest request)
{
var result = await _storage.SearchRequestInfoAsync(new RequestInfoSearchFilterOption()
{
TraceId = request.TraceId,
StatusCodes = request.StatusCode.IsEmpty() ? null : request.StatusCode.Split(',').Select(x => x.ToInt()).ToArray(),
Nodes = request.Node.IsEmpty() ? null : request.Node.Split(','),
IP = request.IP,
Url = request.Url,
StartTime = request.Start.ToDateTime(),
EndTime = request.End.TryToDateTime(),
Page = request.pageNumber,
PageSize = request.pageSize,
IsOrderByField = true,
Field = RequestInfoFields.CreateTime,
IsAscend = false,
StartTimeFormat = "yyyy-MM-dd HH:mm:ss",
EndTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(Json(new { total = result.AllItemCount, rows = result.List }));
}
public List <RequestInfo> GetRequestList(GetRequestListRequest request, out int totalCount)
{
string where = " where 1=1 ";
if (!request.Node.IsEmpty())
{
string nodes = string.Join(",", request.Node.Split(",").ToList().Select(x => "'" + x + "'"));
where = where + $" AND Node IN ({nodes})";
}
if (!request.Start.IsEmpty())
{
where = where + $" AND CreateTime >= '{request.Start}' ";
}
if (!request.End.IsEmpty())
{
where = where + $" AND CreateTime < '{request.End}' ";
}
if (!request.IP.IsEmpty())
{
where = where + $" AND IP = '{request.IP}' ";
}
if (!request.Url.IsEmpty())
{
where = where + $" AND Url like '%{request.Url}%' ";
}
string sql = $"Select * From RequestInfo {where} limit {(request.pageNumber - 1) * request.pageSize},{request.pageSize} ";
totalCount = conn.QueryFirstOrDefault <int>(" Select count(1) From RequestInfo " + where);
return(conn.Query <RequestInfo>(sql).ToList());
}
public List <RequestInfo> GetRequestList(GetRequestListRequest request, out int totalCount) => _accessor.GetRequestList(request, out totalCount);
