private void Button_Click(object sender, RoutedEventArgs e) //更改商品价格
{
string sql = String.Format("update Commondity set Price='{0}',Count='{1}',Name='{2}' where Id='{3}'", TextBox_SinglePrice.Text, TextBox_Count.Text, TextBox_Name.Text, TextBox_Id.Text);
try
{
if (SqlManager.ExecuteCommand(sql) > 0)
{
MessageBox.Show("修改成功！", "修改成功", 0, MessageBoxImage.Information);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "修改失败", 0, MessageBoxImage.Error); }
}
private void Button2_Click(object sender, RoutedEventArgs e) //结算
{
if (0 == ItemList.Items.Count)
{
MessageBox.Show("结算列表为空", "未执行结算", 0, MessageBoxImage.Exclamation);
return;
}
List <PaymentItemInfo> successedList = new List <PaymentItemInfo>();
List <PaymentItemInfo> failedList = new List <PaymentItemInfo>();
try
{
foreach (PaymentItemInfo info in ItemList.Items)
{
string sql = String.Format("INSERT INTO Sale(Id, Count, Price) VALUES('{0}','{1}','{2}')", info.Id, info.Count, info.SinglePrice);
try
{
SqlManager.ExecuteCommand(String.Format("update Commondity set Count={0} where Id={1}", int.Parse(SqlManager.ReadColumn(String.Format("select * from Commondity where Id='{0}'", info.Id), "Count")[0]) - int.Parse(info.Count), info.Id));
SqlManager.ExecuteCommand(sql);
} catch (Exception) { failedList.Add(info); continue; }
successedList.Add(info);
}
if (ItemList.Items.Count - failedList.Count > 0)
{
TextBox_Id.Text = TextBox_Count.Text = "";
foreach (PaymentItemInfo pi in successedList)
{
ItemList.Items.Remove(pi);
}
if (0 == failedList.Count)
{
MessageBox.Show("结算成功！", "结算成功", 0, MessageBoxImage.Information);
}
else
{
string failedString = "";
foreach (PaymentItemInfo pi in failedList)
{
failedString += pi.Id + " " + pi.Name + Environment.NewLine;
}
MessageBox.Show(successedList.Count + "样商品结算成功，以下是结算失败的商品：" + Environment.NewLine + failedString);
}
}
else
{
MessageBox.Show("结算失败！", "结算失败", 0, MessageBoxImage.Error);
}
}
catch (Exception ex) { Console.WriteLine(ex.Message); }
}
private void ButtonSubmit_Click(object sender, RoutedEventArgs e)
{
string sql = String.Format("INSERT INTO Commondity(Id, Name, Count, Price) VALUES('{0}','{1}','{2}','{3}')", ItemId.Text, ItemName.Text, ItemCount.Text, ItemPrice.Text); //SQL语句
try
{
if (SqlManager.ExecuteCommand(sql) > 0)
{
MessageBox.Show("添加商品信息成功", "添加成功", 0, MessageBoxImage.Information);
}
else
{
MessageBox.Show("添加商品信息失败", "添加失败", 0, MessageBoxImage.Information);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "添加失败！", 0, MessageBoxImage.Error); }
}