private void btnDownload_Click(object sender, EventArgs e)
{
if (TemperatureRecords == null)
{
MessageBox.Show("Please Open the database first !");
}
else
{
using (var sfd = new SaveFileDialog())
{
if (sfd.ShowDialog() == DialogResult.OK)
{
CsvHelper.Export(sfd.FileName, TemperatureRecords);
}
}
MessageBox.Show("Download Complete");
}
}
private void btnCsv_Click(object sender, EventArgs e)
{
TemperatureRecords?.Clear();
try
{
using (var ofd = new OpenFileDialog()
{
Filter = "CSV|*.csv", ValidateNames = true, Multiselect = false
})
{
if (ofd.ShowDialog() == DialogResult.OK)
{
var temp = CsvHelper.Import(ofd.FileName);
TemperatureRecords = new List <TemperatureRecord>();
foreach (var item in temp)
{
var key = Guid.NewGuid().ToString();
//MessageBox.Show(key);
TemperatureRecords.Add(new TemperatureRecord()
{
ID = key,
時間 = Convert.ToDateTime(item.時間),
第1段溫度顯示值 = Convert.ToDouble(item.第1段溫度顯示值),
第2段溫度顯示值 = Convert.ToDouble(item.第2段溫度顯示值),
第3段溫度顯示值 = Convert.ToDouble(item.第3段溫度顯示值),
第4段溫度顯示值 = Convert.ToDouble(item.第4段溫度顯示值),
第5段溫度顯示值 = Convert.ToDouble(item.第5段溫度顯示值),
第6段溫度顯示值 = Convert.ToDouble(item.第6段溫度顯示值)
});
}
dataGridView1.DataSource = TemperatureRecords;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["ID"].Visible = false;
FileName = ofd.FileName;
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
