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