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