public Response <IEnumerable <long> > GetAbnormalPODTrackSearchToExcel(GetAbnormalPODSearchRequest request)
{
Response <IEnumerable <long> > response = new Response <IEnumerable <long> >()
{
Result = Enumerable.Empty <long>()
};
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("GetAbnormalPODTrackSearchToExcel request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
AKZOAccessor accessor = new AKZOAccessor();
response.Result = accessor.GetAbnormalPODTrackSearchToExcel(request.SqlWhere);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
}
return(response);
}
public Response <GetAbnormalPODSearchRequest> GetAbnormalPODSearch(GetAbnormalPODSearchRequest request)
{
Response <GetAbnormalPODSearchRequest> response = new Response <GetAbnormalPODSearchRequest>()
{
Result = new GetAbnormalPODSearchRequest()
};
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("GetAbnormalPODSearch request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
AKZOAccessor accessor = new AKZOAccessor();
int Rowcount;
response.Result.AbnormalTable = accessor.GetAbnormalPODSearch(request.SqlWhere, 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.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
}
return(response);
}
