private void QueryApplyForm(Pagination pagination) { try { IEnumerable <OrderListView> orderInfos = OrderQueryService.QueryOrders(getCondition(), pagination); dataList.DataSource = Enumerable.Select(orderInfos, order => { return(new { order.OrderId, PNR = order.ETDZPNR == null ? string.Empty : order.ETDZPNR.ToListString(), AirportPair = order.Flights.Join("<br />", f => string.Format( "{0}-{1}", f.DepartureCity, f.ArrivalCity)), FlightInfo = order.Flights.Join("<br />", f => string.Format( "{0}{1}<br />{2} / {3}", f.Carrier, f.FlightNo, string.IsNullOrEmpty(f.Bunk) ? "-" : f.Bunk, getDiscountText(f.Discount))), TakeoffTime = order.Flights.Join("<br />", f => f.TakeoffTime.ToString("yyyy-MM-dd<br />HH:mm")), Passengers = string.Join("<br />", order.Passengers), ProducedTime = order.ProducedTime.ToString("yyyy-MM-dd HH:mm"), order.ProducedAccount, order.PurchaserName, allTakeOff = order.Flights.All(item => item.TakeoffTime < DateTime.Now) }); }); dataList.DataBind(); if (orderInfos.Any()) { pager.Visible = true; if (pagination.GetRowCount) { pager.RowCount = pagination.RowCount; } } else { pager.Visible = false; } } catch (Exception ex) { ShowExceptionMessage(ex, "查询"); } }
void queryOrders(Pagination pagination) { try { var isAdmin = CurrentUser.IsAdministrator; IEnumerable <OrderListView> orderListViews = OrderQueryService.QueryOrders(getCondition(), pagination).ToList(); var lockInfos = LockService.Query(orderListViews.Select(form => form.OrderId.ToString())).ToList(); var orders = from item in orderListViews let IsShowPNR = item.Source == OrderSource.CodeImport || item.Source == OrderSource.ContentImport || item.Source == OrderSource.InterfaceOrder || (item.Status > OrderStatus.PaidForSupply && item.Status != OrderStatus.Canceled) let lockInfo = lockInfos.FirstOrDefault(l => l.Key == item.OrderId.ToString()) select new { OrderId = item.OrderId, PNR = item.ETDZPNR != null?item.ETDZPNR.ToListString() : item.ReservationPNR == null || !IsShowPNR ? string.Empty : item.ReservationPNR.ToListString(), Product = item.ProductType.GetDescription(), AirportPair = item.Flights.Join("<br />", f => string.Format("{0}-{1}", f.DepartureCity, f.ArrivalCity)), FlightInfo = item.Flights.Join("<br />", f => string.Format("{0}{1}<br />{2}/{3}", f.Carrier, f.FlightNo, string.IsNullOrEmpty(f.Bunk) ? "-" : f.Bunk, getDiscountText(f.Discount))), TakeoffTime = item.Flights.Join("<br />", f => f.TakeoffTime.ToString("yyyy-MM-dd<br />HH:mm")), Passenger = item.Passengers.Join("<br />"), Fare = item.Flights.Sum(f => f.Fare).TrimInvaidZero(), AirportFee = item.Flights.Sum(f => f.AirportFee).TrimInvaidZero(), BAF = item.Flights.Sum(f => f.BAF).TrimInvaidZero(), SettleAmount = item.SettlementForPurchaser.Amount.TrimInvaidZero(), RebateAndCommission = item.ProductType == ProductType.Special ? string.Empty : string.Format("{0}%/{1}", (item.SettlementForPurchaser.Rebate * 100).TrimInvaidZero(), item.SettlementForPurchaser.Commission.TrimInvaidZero()), item.ProducedAccount, ProducedTime = item.ProducedTime.ToString("yyyy-MM-dd<br />HH:mm:ss"), item.ProducedAccountName, UnLockEnable = isAdmin && lockInfo != null && lockInfo.Account != CurrentUser.UserName }; this.dataList.DataSource = orders; this.dataList.DataBind(); if (orders.Any()) { this.pager.Visible = true; if (pagination.GetRowCount) { this.pager.RowCount = pagination.RowCount; } } else { this.pager.Visible = false; } } catch (Exception ex) { ShowExceptionMessage(ex, "查询"); } }
void queryOrders(Pagination pagination) { try { var orderListViews = OrderQueryService.QueryOrders(getCondition(), pagination).ToList(); var lockInfos = LockService.Query(orderListViews.Select(form => form.OrderId.ToString())).ToList(); var orders = from item in orderListViews let lockInfo = lockInfos.FirstOrDefault(l => l.Key == item.OrderId.ToString()) select new { OrderId = item.OrderId, AirportPair = item.Flights.Join("<br />", f => string.Format("{0}-{1}", f.DepartureCity, f.ArrivalCity)), FlightInfo = item.Flights.Join("<br />", f => f.Carrier + f.FlightNo), TakeoffTime = item.Flights.Join("<br />", f => f.TakeoffTime.ToString("yyyy-MM-dd<br />HH:mm")), Passenger = item.Passengers.Join("<br />"), Fare = item.Flights.Sum(f => f.Fare).TrimInvaidZero(), AirportFee = item.Flights.Sum(f => f.AirportFee).TrimInvaidZero(), BAF = item.Flights.Sum(f => f.BAF).TrimInvaidZero(), Status = Service.Order.StatusService.GetOrderStatus(item.Status, m_IsSupplier ? OrderRole.Supplier : OrderRole.Provider), ProducedTime = item.ProducedTime.ToString("yyyy-MM-dd<br />HH:mm:ss"), LockInfo = lockInfo == null ? string.Empty : lockInfo.Name + "<br />", RemindContent = item.RemindTime.HasValue ? item.RemindContent : string.Empty, RemindIsShow = item.IsNeedReminded }; this.dataList.DataSource = orders; this.dataList.DataBind(); if (orders.Any()) { this.pager.Visible = true; if (pagination.GetRowCount) { this.pager.RowCount = pagination.RowCount; } } else { this.pager.Visible = false; } } catch (Exception ex) { ShowExceptionMessage(ex, "查询"); } }
private void queryOrders(Pagination pagination) { try { List <OrderListView> orders = OrderQueryService.QueryOrders(GetCondition(), pagination).ToList(); List <OrderListView> SortedOrders = orders.Where(o => o.Flights.Min(f => f.TakeoffTime.Date) == DateTime.Today).ToList(); SortedOrders.AddRange(orders.Where(o => o.Flights.Min(f => f.TakeoffTime.Date) != DateTime.Today).OrderByDescending(o => o.IsEmergentOrder).ThenBy(o => o.PayTime)); var lockInfos = LockService.Query(orders.Select(form => form.OrderId.ToString())).ToList(); dataList.DataSource = SortedOrders.Select(item => { LockInfo lockInfo = lockInfos.FirstOrDefault(l => l.Key == item.OrderId.ToString()); DateTime?startStatTime = null; if (CurrentCompany.CompanyType == CompanyType.Supplier) { } else if (item.IsSpecial && item.Supplier.HasValue) { if (item.SupplyTime.HasValue && item.PayTime.HasValue) { startStatTime = item.SupplyTime.Value > item.PayTime.Value ? item.SupplyTime.Value : item.PayTime.Value; } } else { startStatTime = item.PayTime; } bool isRelation = item.PurcharseProviderRelation == null || item.PurcharseProviderRelation == RelationType.Brother; return(new { item.OrderId, Product = item.ProductType.GetDescription(), PNR = item.ETDZPNR != null ? item.ETDZPNR.ToListString() : item.ReservationPNR == null ? string.Empty : item.ReservationPNR.ToListString(), AirportPair = item.Flights.Join("<br />", f => string.Format( "{0}{1} {2} {3}-{4}<br />{5:yyyy-MM-dd HH:mm}", f.Carrier, f.FlightNo, string.IsNullOrEmpty(f.Bunk) ? "-" : f.Bunk, f.DepartureCity, f.ArrivalCity, f.TakeoffTime)), Passenger = item.Passengers.Join("<br />"), Fare = item.Flights.Sum(f => f.Fare).TrimInvaidZero(), AirportFee = item.Flights.Sum(f => f.AirportFee).TrimInvaidZero(), BAF = item.Flights.Sum(f => f.BAF).TrimInvaidZero(), SettleAmount = item.SettlementForProvider.Amount.TrimInvaidZero(), Rebate = (item.SettlementForProvider.Rebate * 100).TrimInvaidZero() + "%", Commission = item.SettlementForProvider.Commission.TrimInvaidZero(), Status = StatusService.GetOrderStatus(item.Status, OrderRole.Provider), EmergentOrderContnt = item.IsEmergentOrder ? string.Format("<a href='javascript:void(0);' id='{0}' class='tips_btn urgent'>紧急</a>", item.OrderId) : string.Empty, // EmergentOrderContnt = isEmergentOrder ? string.Format("<a href='javascript:void(0);' class='tips_btn urgent'>紧急</a><div class='tips_box hidden'><div class='tips_bd'><p>{0}</p></div></div>", emergentOrderContnt) : string.Empty, ProducedTime = item.ProducedTime.ToString("yyyy-MM-dd<br />HH:mm:ss"), ProductType = item.ProviderProductType.GetDescription(), LockInfo = lockInfo == null? string.Empty:lockInfo.Name + "<br />", OfficeNum = item.OfficeNo, PurchaseIsBother = isRelation, Relation = isRelation ? "平台" : item.PurcharseProviderRelation == RelationType.Interior?"内部":"下级", TodaysFlight = item.Flights.Any(f => f.TakeoffTime.Date == DateTime.Today), PassengerType = item.PassengerType.GetDescription(), IsChildTicket = item.PassengerType == PassengerType.Child, ETDZTime = (startStatTime.HasValue && item.RefuseETDZTime.HasValue) ? Math.Round((item.RefuseETDZTime.Value - startStatTime.Value).TotalMinutes).ToString() : (startStatTime.HasValue) ? Math.Round(((item.ETDZTime ?? DateTime.Now) - startStatTime.Value).TotalMinutes).ToString() :string.Empty, TicketType = item.IsSpecial ? string.Empty : string.Format("({0})", item.TicketType.ToString()), RemindContent = item.RemindTime.HasValue ? item.RemindContent : string.Empty, RemindIsShow = item.IsNeedReminded }); }); dataList.DataBind(); if (orders.Any()) { pager.Visible = true; if (pagination.GetRowCount) { pager.RowCount = pagination.RowCount; } } else { pager.Visible = false; } } catch (Exception ex) { ShowExceptionMessage(ex, "查询"); } }