public Response <DataTable> GetPodTrackReportExport(GetPodTrackReportExportRequest request) { Response <DataTable> response = new Response <DataTable>(); if (request == null) { ArgumentNullException ex = new ArgumentNullException("GetPodTrackReportExport request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { HiltiAccessor accessor = new HiltiAccessor(); response.Result = accessor.GetPodTrackReportExport(request.SqlWhere, request.ReportName); response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Exception = ex; } return(response); }
public Response <GetPodTrackReportExportRequest> GetPodTrackReport(GetPodTrackReportExportRequest request) { Response <GetPodTrackReportExportRequest> response = new Response <GetPodTrackReportExportRequest>() { Result = new GetPodTrackReportExportRequest() }; if (request == null) { ArgumentNullException ex = new ArgumentNullException("GetPodTrackReportExport request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { HiltiAccessor accessor = new HiltiAccessor(); int Rowcount; double SumGrossWeight; double SumNetWeight; response.Result.XLDTrackReport = accessor.GetPodTrackReport(request.SqlWhere, request.PageIndex, request.PageSize, request.ReportName, out Rowcount, out SumGrossWeight, out SumNetWeight); response.Result.PageIndex = request.PageIndex; response.Result.PageCount = Rowcount % request.PageSize == 0 ? Rowcount / request.PageSize : Rowcount / request.PageSize + 1; response.Result.SumPoll = Rowcount; response.Result.SumGrossWeight = SumGrossWeight; response.Result.SumNetWeight = SumNetWeight; response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; response.Exception = ex; } return(response); }