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