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