public ActionResult GetPagingBlackList(GetPagingDebugLogBlackListRequest request, int page, int rows)
{
var result = string.Empty;
if (request == null)
{
request = new GetPagingDebugLogBlackListRequest();
}
request.PageIndex = page;
request.PageSize = rows;
var rs = _debugLogBlackListService.GetPagingBlackList(request);
if (rs.ReturnCode == ReturnCodeType.Success)
{
result = "{\"total\": " + rs.Content.TotalCount + ",\"rows\":" + rs.Content.Entities.ToJson(dateTimeFormat: DateTimeTypeConst.DATETIME) + "}";
}
return(Content(result));
}
/// <summary>
/// 获取黑名单列表(分页)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public PagingResult <GetPagingDebugLogBlackListResponse> GetPagingBlackList(GetPagingDebugLogBlackListRequest request)
{
PagingResult <GetPagingDebugLogBlackListResponse> result = null;
var totalCount = 0;
var startIndex = (request.PageIndex - 1) * request.PageSize + 1;
var endIndex = request.PageIndex * request.PageSize;
using (var conn = DapperHelper.CreateConnection())
{
var multi = conn.QueryMultiple(@"--获取所有(分页)
SELECT rs.*
FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY debugLogBlackList.id DESC ) AS RowNum ,
debugLogBlackList.system_code AS SystemCode ,
debugLogBlackList.machine_name AS MachineName ,
debugLogBlackList.ip_address AS IpAddress ,
debugLogBlackList.client_ip AS ClientIp ,
debugLogBlackList.appdomain_name AS AppdomainName ,
debugLogBlackList.is_regex AS IsRegex ,
debugLogBlackList.created_time AS CreatedTime ,
debugLogBlackList.last_updated_time AS LastUpdatedTime ,
*
FROM dbo.t_logs_debug_log_black_list (NOLOCK) AS debugLogBlackList
) AS rs
WHERE rs.RowNum BETWEEN @Start AND @End;
--获取所有total
SELECT COUNT(debugLogBlackList.id)
FROM dbo.t_logs_debug_log_black_list (NOLOCK) AS debugLogBlackList;", new { @Start = startIndex, @End = endIndex });
var query1 = multi.Read <GetPagingDebugLogBlackListResponse>();
var query2 = multi.Read <int>();
totalCount = query2.First();
result = new PagingResult <GetPagingDebugLogBlackListResponse>(totalCount, request.PageIndex, request.PageSize, query1);
}
return(result);
}
/// <summary>
/// 获取黑名单列表(分页)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ServiceResult <PagingResult <GetPagingDebugLogBlackListResponse> > GetPagingBlackList(GetPagingDebugLogBlackListRequest request)
{
var result = new ServiceResult <PagingResult <GetPagingDebugLogBlackListResponse> >
{
ReturnCode = ReturnCodeType.Error,
Content = new PagingResult <GetPagingDebugLogBlackListResponse>()
};
var rs = _debugLogBlackListDao.GetPagingBlackList(request);
result.ReturnCode = ReturnCodeType.Success;
result.Content = rs;
return(result);
}
