public JsonResult FindAllOrderSearch(AllOrderSearch allOrderSearch, int Page, int Rows)
{
PagedList <ResponseConsoOrder> pageList = null;
CommunicateManager.Invoke <IConsoOrderService>(p => pageList = p.FindConsoAllOrder(allOrderSearch, Page, Rows));
return(Json(new { total = pageList.Total, rows = pageList.Rows }, JsonRequestBehavior.DenyGet));
}
public PagedList <ResponseConsoOrder> FindConsoAllOrder(AllOrderSearch allOrderSearch, int Page, int Rows)
{
string code = AuthManager.GetCurrentUser().Code;
var query = this.orderRepository.FindAllNoTracking(p => (p.CarrierCode.Equals(code) || p.Policy.CarrierCode.Equals(code) || p.Policy.Code.Equals(code)));// && p.OrderStatus != EnumOrderStatus.WaitChoosePolicy && p.OrderStatus != EnumOrderStatus.Invalid && p.OrderStatus != EnumOrderStatus.OrderCanceled
if (!string.IsNullOrWhiteSpace(allOrderSearch.OrderID))
{
query = query.Where(p => p.OrderId.Equals(allOrderSearch.OrderID.Trim()));
}
if (!string.IsNullOrWhiteSpace(allOrderSearch.PNR))
{
query = query.Where(p => p.PnrCode.Equals(allOrderSearch.PNR.Trim()));
}
if (!string.IsNullOrWhiteSpace(allOrderSearch.PassengerName))
{
query = query.Where(p => p.Passengers.Any(x => x.PassengerName.Equals(allOrderSearch.PassengerName.Trim())));
}
if (!string.IsNullOrWhiteSpace(allOrderSearch.TicketNum))
{
query = query.Where(p => p.Passengers.Any(x => x.TicketNumber.Equals(allOrderSearch.TicketNum.Trim())));
}
if (!string.IsNullOrWhiteSpace(allOrderSearch.BusinessmanCode))
{
query = query.Where(p => p.BusinessmanCode.Equals(allOrderSearch.BusinessmanCode.Trim()));
}
if (!string.IsNullOrWhiteSpace(allOrderSearch.PaySerialNumber))
{
query = query.Where(p => p.OrderPay.PaySerialNumber.Equals(allOrderSearch.PaySerialNumber.Trim()));
}
if (!string.IsNullOrWhiteSpace(allOrderSearch.CarrayCode))
{
query = query.Where(p => p.SkyWays.Any(x => x.CarrayCode.Equals(allOrderSearch.CarrayCode.Trim())));
}
if (allOrderSearch.OrderStatus.HasValue)
{
query = query.Where(p => p.OrderStatus == allOrderSearch.OrderStatus.Value);
}
if (!string.IsNullOrEmpty(allOrderSearch.PolicyType))
{
query = query.Where(p => p.Policy.PolicyType == allOrderSearch.PolicyType);
}
if (allOrderSearch.PolicysSourceType.HasValue)
{
query = query.Where(p => p.Policy.PolicySourceType == allOrderSearch.PolicysSourceType.Value);
}
List <Order> orderList = query.OrderByDescending(p => p.CreateTime).Skip((Page - 1) * Rows).Take(Rows).ToList();
return(new PagedList <ResponseConsoOrder>()
{
Total = query.Count(),
Rows = AutoMapper.Mapper.Map <List <Order>, List <ResponseConsoOrder> >(orderList)
});
}
