private void BindData() { var context = new RefuleModel(); var list = context.RefuleTable.ToList(); dataGridView1.DataSource = list; }
private void button1_Click(object sender, EventArgs e) { var Startdate = dateTimePicker1.Value; var Enddate = dateTimePicker2.Value; RefuleModel a = new RefuleModel(); var middate1 = a.RefuleTable.Where((x) => x.RefuelingDate >= Startdate); var middate2 = middate1.Where((x) => x.RefuelingDate <= Enddate); var list1 = middate2.ToList(); dataGridView1.DataSource = list1; var TotalLiter = a.RefuleTable.Sum(x => x.Liter); var TotalKilometer = a.RefuleTable.Sum(x => x.Kilometer); var TotalAverage = TotalKilometer / TotalLiter; label4.Text = TotalAverage.ToString(); }
private void button1_Click(object sender, EventArgs e) { RefuleTable data = new RefuleTable() { RefuelingDate = dateTimePicker1.Value, Liter = (double)numericUpDown1.Value, Kilometer = (double)numericUpDown2.Value }; try { RefuleModel context = new RefuleModel(); context.RefuleTable.Add(data); context.SaveChanges(); MessageBox.Show("存檔完成"); } catch (Exception ex) { MessageBox.Show($"發生錯誤{ex.ToString()}"); } }