private void Button_Del_Click(object sender, RoutedEventArgs e)
{
Bread bread = listView.SelectedItem as Bread;
if (bread == null)
{
return;
}
var result = MessageBox.Show("确认删除面包？", "确认删除", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
if (store.Remove(bread))
{
RefreshData();
}
}
}
public static bool InsertBread(Bread bread)
{
string insertStr = string.Format(
"INSERT INTO {0}" +
"(type, name, price, manufactureDate, expirationDate) " +
"VALUES({1}, \"{2}\", {3}, \"{4}\",\"{5}\")",
breadTblName, bread.Type, bread.Name, bread.Price,
bread.ManufactureDate, bread.ExpirationDate);
MySqlCommand cmd = new MySqlCommand(insertStr, conn);
try {
cmd.ExecuteNonQuery();
return(true);
} catch (MySqlException ex) {
MessageBox.Show("Failed to insert bread:" + ex.Message);
return(false);
}
}
public bool Add(Bread bread)
{
if (inventory + 1 > capacity)
{
return(false);
}
if (DataBaseWrapper.InsertBread(bread))
{
breads.Add(bread);
inventory++;
RefreshData();
return(true);
}
else
{
RefreshData();
return(false);
}
}
private void Button_Change_Click(object sender, RoutedEventArgs e)
{
Bread bread = listView.SelectedItem as Bread;
if (bread == null)
{
return;
}
var result = MessageBox.Show("确认修改数据？", "确认修改", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
try {
store.UpdateBread(bread.Id, tName.Text, float.Parse(tPrice.Text.Substring(1))
, DateTime.Parse(tDt1.Text), DateTime.Parse(tDt2.Text));
RefreshData();
} catch (Exception ex) {
MessageBox.Show("输入数据有误：" + ex.Message);
}
}
}
