private void DisplayVideoForm_Load(object sender, EventArgs e) { #region 从数据库里读取控件信息 string videoConnStr = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; MySqlConnection videoConn = DBOperateClass.Open_Conn(videoConnStr); MySqlDataAdapter videoadapter = new MySqlDataAdapter("select * from video_design_info",videoConn); DataTable videodt = new DataTable(); videoadapter.Fill(videodt); for (int i = 0; i < videodt.Rows.Count; i++) { if (videodt.Rows[i]["Control_Type"].ToString() == "video") { videoPropertiesClass[i] = new VideoPropertiesClass(); videoPictureBox[i] = new PictureBox(); videoPropertiesClass[i].X = videodt.Rows[i]["Control_X"].ToString(); videoPropertiesClass[i].Y = videodt.Rows[i]["Control_Y"].ToString(); videoPropertiesClass[i].Width = videodt.Rows[i]["Control_Width"].ToString(); videoPropertiesClass[i].Height = videodt.Rows[i]["Control_Height"].ToString(); videoPictureBox[i].Name = videodt.Rows[i]["Control_Name"].ToString(); videoPictureBox[i].Image = global::DisplayWindows.Properties.Resources.webcam;//控件图片的资源 videoPictureBox[i].SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 videoPictureBox[i].Size = new System.Drawing.Size(int.Parse(videodt.Rows[i]["Control_Width"].ToString()), int.Parse(videodt.Rows[i]["Control_Height"].ToString())); //控件大小 videoPictureBox[i].Location = new Point(int.Parse(videoPropertiesClass[i].X)-190, int.Parse(videoPropertiesClass[i].Y)); //控件位置 this.Controls.Add(videoPictureBox[i]); //在面板上增加一个控件 } } for (int i = 0; i < videodt.Rows.Count; i++) { if (videodt.Rows[i]["Control_Type"].ToString() == "drop") { dropPropertiesClass[i] = new DropPropertiesClass(); dropPictureBox[i] = new PictureBox(); dropPropertiesClass[i].X = videodt.Rows[i]["Control_X"].ToString(); dropPropertiesClass[i].Y = videodt.Rows[i]["Control_Y"].ToString(); dropPropertiesClass[i].Width = videodt.Rows[i]["Control_Width"].ToString(); dropPropertiesClass[i].Height = videodt.Rows[i]["Control_Height"].ToString(); dropPictureBox[i].Name = videodt.Rows[i]["Control_Name"].ToString(); dropPictureBox[i].Image = global::DisplayWindows.Properties.Resources.drop128;//控件图片的资源 dropPictureBox[i].SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 dropPictureBox[i].Size = new System.Drawing.Size(int.Parse(videodt.Rows[i]["Control_Width"].ToString()), int.Parse(videodt.Rows[i]["Control_Height"].ToString())); //控件大小 dropPictureBox[i].Location = new Point(int.Parse(dropPropertiesClass[i].X)-190, int.Parse(dropPropertiesClass[i].Y)); //控件位置 this.Controls.Add(dropPictureBox[i]); //在面板上增加一个控件 } } DBOperateClass.Close_Conn(videoConn); #endregion }
private void dockPanel_MouseDown(object sender, MouseEventArgs e) { if (toolForm.ToolControlsName != null) { switch (toolForm.ToolControlsName) { #region Video case "Video": #region 控件名称为数据库里已有的名称则videoCount++ string VideoConnStr = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; MySqlConnection VideoConn = DBOperateClass.Open_Conn(VideoConnStr); MySqlDataAdapter Videoadapter = new MySqlDataAdapter("select * from video_design_info", VideoConn); DataTable Videodt = new DataTable(); Videoadapter.Fill(Videodt); for (int i = 0; i < Videodt.Rows.Count; i++) { if (Videodt.Rows[i]["Control_Name"].ToString() == "摄像头" + videoAddCount) { videoAddCount++; } } DBOperateClass.Close_Conn(VideoConn); #endregion #region 添加一个摄像头控件 videoPropertiesClass[videoCount] = new VideoPropertiesClass(); videoPictureBox[videoCount] = new PictureBox(); videoPictureBox[videoCount].Name = "摄像头" + videoAddCount; videoPictureBox[videoCount].Image = global::DisplayWindows.Properties.Resources.webcam;//控件图片的资源 videoPictureBox[videoCount].SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 videoPictureBox[videoCount].Size = new System.Drawing.Size(55, 50); //控件大小 videoPictureBox[videoCount].Location = new Point(e.X - 28, e.Y - 25); //把鼠标点减去控件宽和高的一半 videoPictureBox[videoCount].MouseDown += new System.Windows.Forms.MouseEventHandler(MyMouseDown); videoPictureBox[videoCount].MouseLeave += new System.EventHandler(MyMouseLeave); videoPictureBox[videoCount].MouseMove += new System.Windows.Forms.MouseEventHandler(MyMouseMove); videoPictureBox[videoCount].ContextMenuStrip = this.videoContextMenuStrip_video; //增加鼠标右键菜单 this.dockPanel.Controls.Add(videoPictureBox[videoCount]); //在面板上增加一个控件 #endregion #region 在数据库里增加一条记录 string Videoconn = "server=localhost;uid=root;Password=password;database=mg;charset=utf8"; DBOperateClass.Run_SQL("insert into video_info(VideoDev_Name,VideoDev_Manu,VideoDev_User,VideoDev_Password,VideoDev_IP,VideoDev_Port,VideoDev_Prot,VideoDev_Stream,VideoDev_Channel,VideoDev_Remark) value ('" + videoPropertiesClass[videoCount].Name + "','" + videoPropertiesClass[videoCount].Manufacturer + "','" + videoPropertiesClass[videoCount].User + "','" + videoPropertiesClass[videoCount].Password + "','" + videoPropertiesClass[videoCount].IP + "','" + videoPropertiesClass[videoCount].Port + "','" + videoPropertiesClass[videoCount].Protocol + "','" + videoPropertiesClass[videoCount].Stream + "','" + videoPropertiesClass[videoCount].Channel + "','" + videoPropertiesClass[videoCount].Remark + "')", Videoconn); #endregion #region 在本地数据库里增加一条记录 string Videolocalconn = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; DBOperateClass.Run_SQL("insert into video_design_info(Control_Name,Control_Type,Control_X,Control_Y,Control_Width,Control_Height,Control_Save,Control_Delete,Control_Update) value ('" + videoPictureBox[videoCount].Name + "','" + videoPropertiesClass[videoCount].Type + "','" + videoPictureBox[videoCount].Location.X.ToString() + "','" + videoPictureBox[videoCount].Location.Y.ToString() + "','" + videoPictureBox[videoCount].Size.Width.ToString() + "','" + videoPictureBox[videoCount].Size.Height.ToString() + "','" + videoPropertiesClass[videoCount].Save.ToString() + "','" + videoPropertiesClass[videoCount].Delete.ToString() + "','" + videoPropertiesClass[videoCount].Update.ToString() + "')", Videolocalconn); #endregion toolForm.ToolControlsName = null; //增加控件后将控件名称置空,一次增加一个控件 videoAddCount++; //添加完摄像头控件后videoAddCount++ videoCount++; //添加完摄像头控件后videoCount++ controlCount++; //添加完控件后controlCount++ need_Save = true; //将需要保存标识置为true break; #endregion #region Drop case "Drop": #region 控件名称为数据库里已有的名称则DropCount++ string DropConnStr = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; MySqlConnection DropConn = DBOperateClass.Open_Conn(DropConnStr); MySqlDataAdapter Dropadapter = new MySqlDataAdapter("select * from video_design_info", DropConn); DataTable Dropdt = new DataTable(); Dropadapter.Fill(Dropdt); for (int i = 0; i < Dropdt.Rows.Count; i++) { if (Dropdt.Rows[i]["Control_Name"].ToString() == "水浸" + dropAddCount) { dropAddCount++; } } DBOperateClass.Close_Conn(DropConn); #endregion #region 添加一个水浸控件 dropPropertiesClass[dropCount] = new DropPropertiesClass(); dropPictureBox[dropCount] = new PictureBox(); dropPictureBox[dropCount].Name = "水浸" + dropAddCount; dropPictureBox[dropCount].Image = global::DisplayWindows.Properties.Resources.drop128;//控件图片的资源 dropPictureBox[dropCount].SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 dropPictureBox[dropCount].Size = new System.Drawing.Size(55, 50); //控件大小 dropPictureBox[dropCount].Location = new Point(e.X - 28, e.Y - 25); //把鼠标点减去控件宽和高的一半 dropPictureBox[dropCount].MouseDown += new System.Windows.Forms.MouseEventHandler(MyMouseDown); dropPictureBox[dropCount].MouseLeave += new System.EventHandler(MyMouseLeave); dropPictureBox[dropCount].MouseMove += new System.Windows.Forms.MouseEventHandler(MyMouseMove); dropPictureBox[dropCount].ContextMenuStrip = this.videoContextMenuStrip_video; //增加鼠标右键菜单 this.dockPanel.Controls.Add(dropPictureBox[dropCount]); //在面板上增加一个控件 #endregion //#region 在数据库里增加一条记录 //string Dropconn = "server=localhost;uid=root;Password=password;database=mg;charset=utf8"; //DBOperateClass.Run_SQL("insert into video_info(VideoDev_Name,VideoDev_Manu,VideoDev_User,VideoDev_Password,VideoDev_IP,VideoDev_Port,VideoDev_Prot,VideoDev_Stream,VideoDev_Channel,VideoDev_Remark) value ('" + videoPropertiesClass[dropCount].Name + "','" + videoPropertiesClass[dropCount].Manufacturer + "','" + videoPropertiesClass[dropCount].User + "','" + videoPropertiesClass[dropCount].Password + "','" + videoPropertiesClass[dropCount].IP + "','" + videoPropertiesClass[dropCount].Port + "','" + videoPropertiesClass[dropCount].Protocol + "','" + videoPropertiesClass[dropCount].Stream + "','" + videoPropertiesClass[dropCount].Channel + "','" + videoPropertiesClass[dropCount].Remark + "')", Dropconn); //#endregion #region 在本地数据库里增加一条记录 string Droplocalconn = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; DBOperateClass.Run_SQL("insert into video_design_info(Control_Name,Control_Type,Control_X,Control_Y,Control_Width,Control_Height,Control_Save,Control_Delete,Control_Update) value ('" + dropPictureBox[dropCount].Name + "','" + dropPropertiesClass[dropCount].Type + "','" + dropPictureBox[dropCount].Location.X.ToString() + "','" + dropPictureBox[dropCount].Location.Y.ToString() + "','" + dropPictureBox[dropCount].Size.Width.ToString() + "','" + dropPictureBox[dropCount].Size.Height.ToString() + "','" + dropPropertiesClass[dropCount].Save.ToString() + "','" + dropPropertiesClass[dropCount].Delete.ToString() + "','" + dropPropertiesClass[dropCount].Update.ToString() + "')", Droplocalconn); #endregion // // MessageBox.Show(dropPictureBox[dropCount].Name); toolForm.ToolControlsName = null; //增加控件后将控件名称置空,一次增加一个控件 dropAddCount++; //添加完水浸控件后dropAddCount++ dropCount++; //添加完水浸控件后dropCount++ controlCount++; //添加完控件后controlCount++ need_Save = true; //将需要保存标识置为true break; #endregion #region Temp case "Temp": PictureBox tempPictureBox = new PictureBox(); tempPictureBox.Image = global::DisplayWindows.Properties.Resources.thermometer128; //控件图片的资源 tempPictureBox.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 tempPictureBox.Size = new System.Drawing.Size(55, 50); //控件大小 tempPictureBox.Location = new Point(e.X - 28, e.Y - 25); //把鼠标点减去控件宽和高的一半 tempPictureBox.MouseDown += new System.Windows.Forms.MouseEventHandler(MyMouseDown); tempPictureBox.MouseLeave += new System.EventHandler(MyMouseLeave); tempPictureBox.MouseMove += new System.Windows.Forms.MouseEventHandler(MyMouseMove); tempPictureBox.ContextMenuStrip = this.videoContextMenuStrip_video; //增加鼠标右键菜单 this.dockPanel.Controls.Add(tempPictureBox); //在面板上增加一个控件 tempPictureBox.Name = "温湿度" + tempCount; tempCount++; toolForm.ToolControlsName = null; need_Save = true; //将需要保存标识置为true break; #endregion #region default default: need_Save = false; break; #endregion } } }
private void DesignTempForm_Load(object sender, EventArgs e) { initProperty(); #region 从数据库video_desgin_info表里里读取控件信息 string videoConnStr = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; MySqlConnection videoConn = DBOperateClass.Open_Conn(videoConnStr); MySqlDataAdapter videoadapter = new MySqlDataAdapter("select * from video_design_info", videoConn); DataTable videodt = new DataTable(); videoadapter.Fill(videodt); for (int i = 0; i < videodt.Rows.Count; i++) { if (videodt.Rows[i]["Control_Type"].ToString() == "video") { videoPropertiesClass[videoCount] = new VideoPropertiesClass(); videoPictureBox[videoCount] = new PictureBox(); videoPropertiesClass[videoCount].X = videodt.Rows[i]["Control_X"].ToString(); videoPropertiesClass[videoCount].Y = videodt.Rows[i]["Control_Y"].ToString(); videoPropertiesClass[videoCount].Width = videodt.Rows[i]["Control_Width"].ToString(); videoPropertiesClass[videoCount].Height = videodt.Rows[i]["Control_Height"].ToString(); videoPictureBox[videoCount].Name = videodt.Rows[i]["Control_Name"].ToString(); videoPictureBox[videoCount].Image = global::DisplayWindows.Properties.Resources.webcam;//控件图片的资源 videoPictureBox[videoCount].SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 videoPictureBox[videoCount].Size = new System.Drawing.Size(int.Parse(videodt.Rows[i]["Control_Width"].ToString()), int.Parse(videodt.Rows[i]["Control_Height"].ToString())); //控件大小 videoPictureBox[videoCount].Location = new Point(int.Parse(videoPropertiesClass[videoCount].X), int.Parse(videoPropertiesClass[videoCount].Y)); //把鼠标点减去控件宽和高的一半 videoPictureBox[videoCount].MouseDown += new System.Windows.Forms.MouseEventHandler(MyMouseDown); videoPictureBox[videoCount].MouseLeave += new System.EventHandler(MyMouseLeave); videoPictureBox[videoCount].MouseMove += new System.Windows.Forms.MouseEventHandler(MyMouseMove); videoPictureBox[videoCount].ContextMenuStrip = this.videoContextMenuStrip_video; //增加鼠标右键菜单 this.dockPanel.Controls.Add(videoPictureBox[videoCount]); //在面板上增加一个控件 videoCount++; //添加完摄像头控件后videoCount++ controlCount++; //添加完控件后controlCount++ } } for (int i = 0; i < videodt.Rows.Count; i++) { if (videodt.Rows[i]["Control_Type"].ToString() == "drop") { dropPropertiesClass[dropCount] = new DropPropertiesClass(); dropPictureBox[dropCount] = new PictureBox(); dropPropertiesClass[dropCount].X = videodt.Rows[i]["Control_X"].ToString(); dropPropertiesClass[dropCount].Y = videodt.Rows[i]["Control_Y"].ToString(); dropPropertiesClass[dropCount].Width = videodt.Rows[i]["Control_Width"].ToString(); dropPropertiesClass[dropCount].Height = videodt.Rows[i]["Control_Height"].ToString(); dropPictureBox[dropCount].Name = videodt.Rows[i]["Control_Name"].ToString(); dropPictureBox[dropCount].Image = global::DisplayWindows.Properties.Resources.drop128;//控件图片的资源 dropPictureBox[dropCount].SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 dropPictureBox[dropCount].Size = new System.Drawing.Size(int.Parse(videodt.Rows[i]["Control_Width"].ToString()), int.Parse(videodt.Rows[i]["Control_Height"].ToString())); //控件大小 dropPictureBox[dropCount].Location = new Point(int.Parse(dropPropertiesClass[dropCount].X), int.Parse(dropPropertiesClass[dropCount].Y)); //把鼠标点减去控件宽和高的一半 dropPictureBox[dropCount].MouseDown += new System.Windows.Forms.MouseEventHandler(MyMouseDown); dropPictureBox[dropCount].MouseLeave += new System.EventHandler(MyMouseLeave); dropPictureBox[dropCount].MouseMove += new System.Windows.Forms.MouseEventHandler(MyMouseMove); dropPictureBox[dropCount].ContextMenuStrip = this.dropContextMenuStrip_video; //增加鼠标右键菜单 this.dockPanel.Controls.Add(dropPictureBox[dropCount]); //在面板上增加一个控件 dropCount++; //添加完摄像头控件后dropCount++ controlCount++; //添加完控件后controlCount++ } } DBOperateClass.Close_Conn(videoConn); #endregion }