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