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