private void Button1_Click(object sender, RoutedEventArgs e)//tianjia
{
if (Brushes.Red == TextBox_Id.Foreground || Brushes.Red == TextBox_Count.Foreground)
{
MessageBox.Show("商品ID不存在或库存不足，添加失败。", "操作失败", 0, MessageBoxImage.Error);
return;
}
string sql1 = String.Format("select * from Commondity where Id='{0}'", TextBox_Id.Text);
try
{
List <string> ids = SqlManager.ReadColumn(sql1, "Id");
List <string> names = SqlManager.ReadColumn(sql1, "Name");
List <string> counts = SqlManager.ReadColumn(sql1, "Count");
List <string> prices = SqlManager.ReadColumn(sql1, "Price");
for (int i = 0; i < ids.Count; i++)
{
ItemList.Items.Add(new PaymentItemInfo {
Id = ids[i].Trim(), Count = TextBox_Count.Text.Trim(), SinglePrice = prices[i].Trim(), Name = names[i].Trim(), SumPrice = (int.Parse(TextBox_Count.Text.Trim()) * float.Parse(prices[i].Trim())).ToString()
});
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "查询失败", 0, MessageBoxImage.Error); }
TextBox_Count.Text = "";
TextBox_Id.Focus();
TextBox_Id.SelectAll();
}
public UpdateWindow()
{
InitializeComponent();
TextBox_Id.Focus();
}
public MainFrm()
{
InitializeComponent();
TextBox_Id.Focus();
}
