/// <summary> /// 获取Nike导出报表 /// </summary> /// <param name="request"></param> /// <returns></returns> public Response <DataTable> GetNikeReportExprot(GetNikeReportExportRequest request) { Response <DataTable> response = new Response <DataTable>() { Result = new GetNikeReportExportRequest().NikeReport }; if (request == null) { ArgumentNullException ex = new ArgumentNullException("GetNikeReportExport request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { NikeAccessor Accessor = new NikeAccessor(); response.Result = Accessor.GetNikeReportExprot(request.SqlWhere, request.ReportName); response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.Exception = ex; response.ErrorCode = ErrorCode.Technical; } return(response); }
public Response <GetNikeReportExportRequest> GetNikeReportQutry(GetNikeReportExportRequest request) { Response <GetNikeReportExportRequest> response = new Response <GetNikeReportExportRequest>() { Result = new GetNikeReportExportRequest() }; if (request == null) { ArgumentNullException ex = new ArgumentNullException("GetNikeReportQutry request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { NikeAccessor accessor = new NikeAccessor(); int Rowcount; response.Result.NikeReport = accessor.GetNikeReportQuery(request.SqlWhere, request.ReportName, request.PageIndex, request.PageSize, out Rowcount); response.Result.PageIndex = request.PageIndex; response.Result.PageCount = Rowcount % request.PageSize == 0 ? Rowcount / request.PageSize : Rowcount / request.PageSize + 1; response.Result.RowCount = Rowcount; response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Exception = ex; } return(response); }