public int Save() { int i = 0; if (!HaveImported) { int payStatus = 1; if (OrderType.Trim().Equals("现货未付")) { payStatus = 0; } string[,] insertParam = { { "flow_number", "varchar", flowNumber.Trim() }, { "type", "varchar", OrderType.Trim() }, { "open_id", "varchar", "" }, { "member_name", "varchar", MemberName.Trim() }, { "cell_number", "varchar", CellNumber.Trim() }, { "price", "float", OrderPrice.ToString() }, { "dragon_ball_used", "int", UsedDragonBallCount.ToString() }, { "ticket_used_amount", "float", UsedTicketAmount.ToString().Trim() }, { "real_paid_summary", "float", RealPaidAmount.ToString() }, { "dragon_ball_rate", "float", DragonBallRate.ToString().Trim() }, { "dragon_ball_generated", "int", GenerateDraonBallCount.ToString() }, { "pay_status", "int", payStatus.ToString() }, { "order_date", "datetime", Date.ToShortDateString() } }; i = DBHelper.InsertData("orders", insertParam); if (i > 0) { foreach (OrderDetail dtl in orderDetails) { dtl.Save(); } } } return(i); }
public override string ToString() { return("Order number: " + OrderNumber.ToString() + Environment.NewLine + "" + DatabaseMethods.SelectOffers().Where(x => x.OfferNumber == TravelOfferNumber).First().ToString() + Environment.NewLine + "Client: " + DatabaseMethods.SelectClients().Where(x => x.ClientNumber == OrderClientNumber).First().Name + " " + DatabaseMethods.SelectClients().Where(x => x.ClientNumber == OrderClientNumber).First().LastName + Environment.NewLine + "Worker: " + ServiceWorker.Name + " " + ServiceWorker.LastName + Environment.NewLine + "Order price: €" + OrderPrice.ToString() + Environment.NewLine + "Travelers amount: " + OrderClientsAmount.ToString() + Environment.NewLine + "Travel start date: " + TravelStartDate.ToShortDateString() + Environment.NewLine + "Order registered on: " + OrderRegisterDate.ToShortDateString()); }
/// <summary> /// Возвращает строку запроса типа ?min_lat=55.30077916694387&min_lng=36.974153699712836&max_lat=56.200586833056136&max_lng=38.26083830028717 /// </summary> /// <returns></returns> public string ToUrlQuery() { var list = new List <string>(15); if (!string.IsNullOrWhiteSpace(Id)) { list.Add($"id={Id}"); } if (WeightGramms > 0) { list.Add($"weight={WeightGramms.ToString()}"); } if (OrderPrice > 0) { list.Add($"order_price={OrderPrice.ToString()}"); } if (!string.IsNullOrWhiteSpace(City)) { list.Add($"city={City}"); } if (!string.IsNullOrWhiteSpace(Region)) { list.Add($"region={Region}"); } if (!string.IsNullOrWhiteSpace(CountryCode)) { list.Add($"country={CountryCode}"); } if (!string.IsNullOrWhiteSpace(Type)) { list.Add($"type={Type}"); } if (!string.IsNullOrWhiteSpace(Partner)) { list.Add($"partner={Partner}"); } if (MinLng.HasValue && MaxLng.HasValue && MinLat.HasValue && MaxLat.HasValue) { list.Add($"min_lng={MinLng.ToString().Replace(",", ".")}"); list.Add($"max_lng={MaxLng.ToString().Replace(",", ".")}"); list.Add($"min_lat={MinLat.ToString().Replace(",", ".")}"); list.Add($"max_lat={MaxLat.ToString().Replace(",", ".")}"); } if (RegionCities.HasValue) { list.Add($"region_cities={(RegionCities.Value ? "Y" : "N")}"); } if (!string.IsNullOrWhiteSpace(InSales)) { list.Add($"insales={InSales}"); } return("?" + string.Join("&", list)); }
/// <summary> /// Handles CreateOrder button event and open PurchaseView in wizard /// </summary> private void OnCreateOrder() { Logger.Default.Append("OnCreateOrder Begin"); InitCustomer(); _worker = new BackgroundWorker(); _worker.DoWork += delegate { WizardProgressVisibility = Visibility.Visible; Customer.Order = Access.CreateOrder(Customer); if (Customer.Order != null) { PersistSelectedSpots(Customer.Order.Seats); OrderPrice = SelectedSpots.Where(x => x.Result == Core.OperationResult.Success).Sum(x => x.Price); StatusText = OperationResult = String.Format("Заказ № {0} создан. Сумма заказа: {1}", Customer.Order.Id, OrderPrice.ToString("C")); if (_wizardWindow != null) { WizardTitle = "Оплата заказа"; ContentWindow = new PurchaseViewModel(Instance); } _wisardStep = WisardStep.OrderCreated; } else { StatusText = OperationResult = "Произошла ошибка. Места не зарезервированы"; } }; _worker.RunWorkerCompleted += delegate { WizardProgressVisibility = Visibility.Collapsed; }; _worker.RunWorkerAsync(); Logger.Default.Append("OnCreateOrder End"); }
/// <summary> /// Handles PayOrder button event and open PrintView in wizard /// </summary> private void OnPayOrder() { BlankStatus = String.Empty; // if View called from orders if (Customer.Order.Seats == null) { Customer.Order.Seats = new List <Seat>(); foreach (Ticket t in Tickets) { Seat seat = new Seat() { Id = t.Id }; Customer.Order.Seats.Add(seat); } } Customer.Order.PaymentType = (PaymentType)Enum.Parse(typeof(PaymentType), SelectedPaymentType.Key.ToString(), true); _worker = new BackgroundWorker(); _worker.DoWork += delegate { WizardProgressVisibility = Visibility.Visible; Customer.Order = Access.ConfirmPayment(Customer.Order); if (Customer.Order != null && Customer.Order.Status == ItemStatus.Sold) { Blank[] blanks = Access.GetBlanks(0, Customer.Order.ItemsCount, ItemStatus.OnSale); if (blanks != null) { if (blanks.Length != Customer.Order.ItemsCount) { BlankStatus = "Количество бланков недостаточно для печати заказа"; } } else { BlankStatus = "У вас отсутствуют бланки"; } for (int i = 0; i < Customer.Order.Seats.Count; i++) { Seat seat = Customer.Order.Seats[i]; Spot spot = SelectedSpots.FirstOrDefault(x => x.Id == seat.Id); if (spot != null) { spot.Status = seat.Status; //spot.Result = seat.Result; spot.ReserveDate = seat.ReserveDate; if (blanks != null && blanks.Length > i) { spot.Blank = blanks[i]; } } } //PersistSelectedSpots(Customer.Order.Seats); StatusText = OperationResult = String.Format("Заказ № {0} оплачен. Сумма заказа: {1}", Customer.Order.Id, OrderPrice.ToString("C")); if (_wizardWindow != null) { WizardTitle = "Печать заказа"; ContentWindow = new PrintViewModel(Instance); } _wisardStep = WisardStep.OrderPaid; DisplayTickets(); } else { Customer.Order = new Order(); // Just not to be null StatusText = OperationResult = String.Format("Произошла ошибка. Заказ № {0} не оплачен", Customer.Order.Id); } }; _worker.RunWorkerCompleted += delegate { WizardProgressVisibility = Visibility.Collapsed; }; _worker.RunWorkerAsync(); }
public int Place(string openId) { if (_fields == null) { MiniUsers user = new MiniUsers(openId.Trim()); if (user != null) { string name = "小程序用户"; try { MiniUsers miniUser = new MiniUsers(openId.Trim()); if (!miniUser._fields["nick"].ToString().Trim().Equals("")) { name = miniUser._fields["nick"].ToString().Trim(); } if (!miniUser._fields["real_name"].ToString().Trim().Equals("")) { name = miniUser._fields["real_name"].ToString().Trim(); } } catch { } string[,] insertParam = { { "type", "varchar", Type.Trim() }, { "open_id", "varchar", openId.Trim() }, { "cell_number", "varchar", user._fields["cell_number"].ToString().Trim() }, { "name", "varchar", name.Trim() }, { "pay_method", "varchar", PayMethod.Trim() }, { "order_price", "float", OrderPrice.ToString() }, { "order_real_pay_price", "float", OrderPrice.ToString() }, { "shop", "varchar", shop.Trim() }, { "memo", "varchar", memo.Trim() } }; int i = DBHelper.InsertData("order_online", insertParam); if (i == 1) { int totalScore = 0; DataTable dt = DBHelper.GetDataTable(" select top 1 * from order_online order by [id] desc"); int maxId = int.Parse(dt.Rows[0][0].ToString()); _fields = dt.Rows[0]; foreach (OnlineOrderDetail detail in orderDetails) { detail.AddNew(maxId); if (detail.productId > 0) { Product p = new Product(detail.productId); totalScore = totalScore + int.Parse(p._fields["award_score"].ToString().Trim()); } } DBHelper.UpdateData("order_online", new string[, ] { { "generate_score", "int", totalScore.ToString() } }, new string[, ] { { "id", "int", maxId.ToString() } }, Util.conStr.Trim()); return(maxId); } } } return(0); }