private void button2_Click(object sender, EventArgs e)//查詢
{
//選擇日期的公里相加/公升相加
DateTime start = new DateTime(dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, dateTimePicker1.Value.Day);
DateTime end = new DateTime(dateTimePicker2.Value.Year, dateTimePicker2.Value.Month, dateTimePicker2.Value.Day);
var day = end.AddDays(1);
var total = new OilModel2();
var distar = total.RefuelTable.Where((x) => x.RefuelingDate >= start).Where((y) => y.RefuelingDate <= day).ToList();
dataGridView1.DataSource = distar;
float k = 0, l1 = 0, l2 = 0, count = 0;
l1 = (float)distar[0].Liter;
l2 = (float)distar[distar.Count - 1].Liter;
k = (float)distar[distar.Count - 1].Kilometer;
count = k / (l1 - l2);
label4.Text = count.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
RefuelTable data = new RefuelTable()
{
RefuelingDate = dateTimePicker1.Value,
Liter = (float)(numericUpDown1.Value),
Kilometer = (float)(numericUpDown2.Value)
};
try
{
OilModel2 oiltext = new OilModel2();
oiltext.RefuelTable.Add(data);
oiltext.SaveChanges();
MessageBox.Show("完成輸入");
}
catch
{
MessageBox.Show("輸入錯誤！");
}
}
