private void button1_Click(object sender, EventArgs e)
{
var cartext = new CartotalModel();
var list = cartext.CarTable.ToList();
double test = 0;
foreach (var item in list)
{
if (item.RefuelingDate > dateTimePicker1.Value && item.RefuelingDate < dateTimePicker2.Value)
{
dataGridView1.DataSource = list;
if (item.Liter != 0)
{
test += item.Kilometer / item.Liter;
}
else
{
test += 0;
}
double listliter = list.Max((x) => x.Liter) - list.Min((x) => x.Liter);
double listkilometer = list.Max((x) => x.Kilometer) - list.Min((x) => x.Kilometer);
label3.Text = Convert.ToString(listkilometer / listliter);
//for (int x = 0; x < item.Id; x++)
//var All += list[x].Liter / list[x].Kilometer;// item.Liter[x] / item.Kilometer[x];
//label3.Text = Alltotal.ToString();
}
else
{
dataGridView1.DataSource = null;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
CarTable cardata = new CarTable()
{
RefuelingDate = dateTimePicker1.Value,
Liter = Convert.ToInt32(numericUpDown1.Value),
Kilometer = Convert.ToInt32(numericUpDown2.Value)
};
try
{
CartotalModel cartotal = new CartotalModel();
cartotal.CarTable.Add(cardata);
cartotal.SaveChanges();
MessageBox.Show("存檔完成");
}
catch (Exception ex)
{
MessageBox.Show($"發生錯誤{ex.ToString()}");
}
}
