private void timer_check_Tick(object state, EventArgs sender) { if (vlc.IsPlaying()) { this.LB_ServerState.Text = "正常"; this.LB_ServerState.ForeColor = Color.White; } else { this.LB_ServerState.Text = "异常"; vlc.release(); string str = string.Format("SELECT Url FROM tb_param WHERE CamID={0};", this.CBO_CamID.Text); try { string url = mysql.ExecuteDataTable(str).Rows[0]["Url"].ToString(); vlc.playUrl(url, this.Pic_Monitor.Handle); } catch (Exception ex) { Console.WriteLine(ex.Message); } this.LB_ServerState.ForeColor = Color.Red; } }
/// <summary> /// 读取日数据 /// </summary> public void ReadDayData(int CamID, HistoryData HD, DateTime date) { string str = string.Format("select * from pflow_tb_data_hor where CamID={0} and Detecttime like '{1}%';", CamID, date.ToString("yyyy-MM-dd")); try { DataTable dt = mysql.ExecuteDataTable(str); if (dt.Rows.Count > 0) { ChangeType(dt, HD); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
/// <summary> /// 读取摄像头参数 /// </summary> public void ReadCameraParam(DataGridView dgv) { IsCamFlag = true; dgv.AllowUserToAddRows = false; addFlag = false; deleteFlag = false; index_list.Clear(); string str = string.Format("SELECT * FROM TB_PARAM"); try { dt = mysql.ExecuteDataTable(str); dgv.DataSource = dt; } catch (Exception ex) { Console.WriteLine(ex.Message); } dgv.Columns[0].Visible = false; }
private void CBO_CamID_Click(object sender, EventArgs e) { CBO_CamID.Items.Clear(); try { DataTable dt = mysql.ExecuteDataTable("SELECT CamID FROM tb_param"); for (int i = 0; i < dt.Rows.Count; i++) { CBO_CamID.Items.Add(dt.Rows[i]["CamID"]); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
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); } }
public static void readWeatherDetail() { string sqlString = string.Format("SELECT * FROM tb_weather WHERE uuid=(SELECT MAX(uuid) FROM tb_weather);"); WeatherDetail detail = new WeatherDetail(); detail.weather = new Weather(); detail.wind = new Wind(); try { DataTable dt = mysql.ExecuteDataTable(sqlString); detail.publish_time = dt.Rows[0]["time"].ToString(); detail.weather.info = dt.Rows[0]["weather"].ToString(); detail.wind.power = dt.Rows[0]["wind"].ToString(); detail.weather.temperature = float.Parse(dt.Rows[0]["temperature"].ToString()); update(detail); } catch (Exception ex) { Console.WriteLine(ex); } }
private void MultiScreen_VisibleChanged(object sender, EventArgs e) { if (this.Visible == true) { this.treeView1.ImageList = this.imageList1; for (int i = 0; i < vlc.Count(); i++) { if (vlc[i] == null) { vlc[i] = new Client.VLCPlayer(); } } this.treeView1.Nodes[0].Nodes.Clear(); try { dt = mysql.ExecuteDataTable("Select * from tb_param"); for (int i = 0; i < dt.Rows.Count; i++) { this.treeView1.Nodes[0].Nodes.Add(dt.Rows[i]["CamID"].ToString()); if (!dic.Keys.Contains(dt.Rows[i]["CamID"].ToString())) { dic.Add(dt.Rows[i]["CamID"].ToString(), dt.Rows[i]["url"].ToString()); } } } catch (Exception ex) { Console.WriteLine(ex.Message); MessageBox.Show("读取参数错误"); } } if (this.Visible == false) { realseSource(); } }