public static void Update(TemperatureRecord record)
{
using (var cn = new SQLiteConnection($"Data Source = {DatabasePath}"))
{
cn.Open();
try
{
var query = "UPDATE temperature SET 時間 =" +
" @時間,第1段溫度顯示值 = @第1段溫度顯示值," +
"第2段溫度顯示值 = @第2段溫度顯示值," +
"第3段溫度顯示值 = @第3段溫度顯示值," +
"第4段溫度顯示值 = @第4段溫度顯示值," +
"第5段溫度顯示值 = @第5段溫度顯示值," +
"第6段溫度顯示值 = @第6段溫度顯示值 " +
"WHERE ID = @ID ";
var results = cn.Execute(query, record);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
private static double GetValue(TemperatureRecord record, string propertyName)
{
return((double)record.GetType().GetProperty(propertyName).GetValue(record));
}
