public JsonResult FindAllSaleOrderSearch(AllSaleOrderSearch allSaleOrderSearch)
{
PagedList <ResponseConsoSaleOrder> pageList = null;
CommunicateManager.Invoke <IConsoOrderService>(p => pageList = p.FindConsoAllSaleOrder(allSaleOrderSearch));
return(Json(new { total = pageList.Total, rows = pageList.Rows }, JsonRequestBehavior.DenyGet));
}
public PagedList <ResponseConsoSaleOrder> FindConsoAllSaleOrder(AllSaleOrderSearch allSaleOrderSearch)
{
string code = AuthManager.GetCurrentUser().Code;
var query = this.afterSaleOrderRepository.FindAllNoTracking(p => p.Order.CarrierCode.Equals(code) || p.Order.Policy.CarrierCode.Equals(code) || p.Order.Policy.Code.Equals(code));
if (!string.IsNullOrWhiteSpace(allSaleOrderSearch.OrderID))
{
query = query.Where(p => p.OrderID.Equals(allSaleOrderSearch.OrderID.Trim()));
}
if (!string.IsNullOrWhiteSpace(allSaleOrderSearch.PNR))
{
query = query.Where(p => p.Order.PnrCode.Equals(allSaleOrderSearch.PNR.Trim()));
}
if (!string.IsNullOrWhiteSpace(allSaleOrderSearch.BusinessmanCode))
{
query = query.Where(p => p.Order.BusinessmanCode.Equals(allSaleOrderSearch.BusinessmanCode.Trim()));
}
if (!string.IsNullOrWhiteSpace(allSaleOrderSearch.PaySerialNumber))
{
query = query.Where(p => p.Order.OrderPay.PaySerialNumber.Equals(allSaleOrderSearch.PaySerialNumber.Trim()));
}
if (allSaleOrderSearch.ProcessStatus.HasValue)
{
query = query.Where(p => p.ProcessStatus == allSaleOrderSearch.ProcessStatus.Value);
}
if (!string.IsNullOrWhiteSpace(allSaleOrderSearch.PassengerName))
{
query = query.Where(p => p.Passenger.Any(x => x.Passenger.PassengerName.Equals(allSaleOrderSearch.PassengerName.Trim())));
}
List <AfterSaleOrder> afterSaleOrderList = query.OrderByDescending(p => p.CreateTime).Skip((allSaleOrderSearch.Page - 1) * allSaleOrderSearch.Rows).Take(allSaleOrderSearch.Rows).ToList();
return(new PagedList <ResponseConsoSaleOrder>()
{
Total = query.Count(),
Rows = AutoMapper.Mapper.Map <List <AfterSaleOrder>, List <ResponseConsoSaleOrder> >(afterSaleOrderList)
});
}
