public void OrderNumColumnHead() { OrderIDList.Columns.Add(OrderID.Text); OrderIDList.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); OrderIDList.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); OrderIDList.Columns[0].Width = OrderIDList.Size.Width - 8; }
private void refreshBookOverview() { BooksOnOrderLabel.Text = "Books On Order #: "; PaymentTermsTextBox.Text = ""; StoresDropDown.Items.Clear(); fillComboBox(); BooksOnOrderList.Clear(); OrderIDList.Clear(); OrderNumColumnHead(); BooksOnOrderColumnHead(); }
private void StoresDropDown_SelectedIndexChanged(object sender, EventArgs e) { try { OrderIDList.Clear(); BooksOnOrderList.Clear(); BooksOnOrderLabel.Text = "Books On Order #: "; string selected = null; //sets up string to be used in try catch string prev = null; if (StoresDropDown.SelectedItem is storeViewModel st) { selected = st.StoreID; } else { return; } List <salesViewModel> sales = bookService.getAllSales(); foreach (salesViewModel salesView in sales) { if (salesView.OrderNum == prev) { //nothing Happens } else if (salesView.StoreID == selected) { OrderIDList.Items.Add(salesView.OrderNum); } //filters out duplicates prev = salesView.OrderNum; } OrderNumColumnHead(); BooksOnOrderColumnHead(); } catch { return; } }
public static void Save_Mall_OrderTradeNo(string TradeNo, List <int> OrderIDList = null) { var condtions = new List <string>(); if (OrderIDList != null && OrderIDList.Count > 0) { condtions.Add("[OrderID] in (" + string.Join(",", OrderIDList.ToArray()) + ")"); } else { condtions.Add("TradeNo=@TradeNo"); } string cmdtext = "select * from [Mall_OrderTradeNo] where " + string.Join(" and ", condtions.ToArray()); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@TradeNo", TradeNo)); var orderTradeList = GetList <Mall_OrderTradeNo>(cmdtext, parameters); if (OrderIDList == null) { OrderIDList = orderTradeList.Select(p => p.OrderID).ToList(); } using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); if (OrderIDList == null || OrderIDList.Count == 0) { OrderIDList = new List <int>(); } if (OrderIDList.Count == 0) { var payment = Payment.GetPaymentByTradeNo(TradeNo, helper); if (payment != null) { OrderIDList.Add(payment.OrderID); } } foreach (var OrderID in OrderIDList) { var data = orderTradeList.FirstOrDefault(p => p.TradeNo.Equals(TradeNo) && p.OrderID == OrderID); if (data == null) { data = new Mall_OrderTradeNo(); data.OrderID = OrderID; data.TradeNo = TradeNo; data.AddTime = DateTime.Now; data.Save(helper); } } cmdtext = "update [Mall_Order] set TradeNo=@TradeNo where [ID] in (" + string.Join(",", OrderIDList.ToArray()) + ")"; parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@TradeNo", TradeNo)); helper.Execute(cmdtext, CommandType.Text, parameters); helper.Commit(); } catch (Exception ex) { Utility.LogHelper.WriteError("Mall_OrderTradeNo", "Save_Mall_OrderTradeNo", ex); } } }