public void readThresholdFromDB(int camid, Threshold threshold) { Client.MySqlHelper mysql = new Client.MySqlHelper(); string sqlString = string.Format("SELECT DensityThreshold, SpeedThresshold FROM tb_param WHERE CamID={0};", camid); try { DataTable dt = mysql.ExecuteDataTable(sqlString); double.TryParse(dt.Rows[0]["DensityThreshold"].ToString(), out threshold.DensityThreshold); double.TryParse(dt.Rows[0]["SpeedThresshold"].ToString(), out threshold.SpeedThresshold); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
private void Btn_Confirm_Click(object sender, EventArgs e) { if (this.dateTime.Value != null && this.cbo_weather.Text != null && this.tbo_temperature.Text != null && this.tbo_wind.Text != null) { float temperature; if (float.TryParse(this.tbo_temperature.Text, out temperature)) { DateTime dt = this.dateTime.Value; string weather = this.cbo_weather.Text.ToString(); string wind = this.tbo_wind.Text; Client.MySqlHelper mysql = new Client.MySqlHelper(); string sqlString = string.Format("INSERT INTO tb_weather SET time='{0}',weather='{1}',temperature={2},wind='{3}';", dt, weather, temperature, wind); try { mysql.ExecuteNonQuery(sqlString); WeatherDetail detail = new WeatherDetail(); detail.weather = new Weather(); detail.wind = new Wind(); detail.publish_time = dt.ToString(); detail.weather.temperature = temperature; detail.wind.power = wind; detail.weather.info = weather; WeatherUpdate.update(detail); this.tbo_temperature.Text = ""; this.tbo_wind.Text = ""; this.cbo_weather.Text = ""; } catch (Exception ex) { Console.WriteLine(ex.Message); MessageBox.Show("写入数据库失败"); } } else { MessageBox.Show("请输入正确温度"); } } else { MessageBox.Show("请输入全部信息"); } }