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)); }