private void DisplayTempForm_Load(object sender, EventArgs e) { #region 从数据库里读取控件信息 string ConnStr = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; MySqlConnection Conn = DBOperateClass.Open_Conn(ConnStr); MySqlDataAdapter adapter = new MySqlDataAdapter("select * from video_design_info", Conn); DataTable dt = new DataTable(); adapter.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { videoPropertiesClass[i] = new VideoPropertiesClass(); videoPictureBox[i] = new PictureBox(); videoPropertiesClass[i].X = dt.Rows[i]["Control_X"].ToString(); videoPropertiesClass[i].Y = dt.Rows[i]["Control_Y"].ToString(); videoPropertiesClass[i].Width = dt.Rows[i]["Control_Width"].ToString(); videoPropertiesClass[i].Height = dt.Rows[i]["Control_Height"].ToString(); videoPictureBox[i].Name = dt.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(dt.Rows[i]["Control_Width"].ToString()), int.Parse(dt.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]); //在面板上增加一个控件 } DBOperateClass.Close_Conn(Conn); #endregion }
private void dockPanel_MouseDown(object sender, MouseEventArgs e) { if (toolForm.ToolControlsName != null) { switch (toolForm.ToolControlsName) { #region Video case "Video": #region 控件名称为数据库里已有的名称则videoCount++ string ConnStr = "server=localhost;uid=root;Password=password;database=local;charset=utf8"; MySqlConnection Conn = DBOperateClass.Open_Conn(ConnStr); MySqlDataAdapter adapter = new MySqlDataAdapter("select * from video_design_info", Conn); DataTable dt = new DataTable(); adapter.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Control_Name"].ToString() == "摄像头" + videoAddCount) { videoAddCount++; } } DBOperateClass.Close_Conn(Conn); #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; //增加鼠标右键菜单 this.dockPanel.Controls.Add(videoPictureBox[videoCount]); //在面板上增加一个控件 #endregion #region 在数据库里增加一条记录 string conn = "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 + "')", conn); #endregion #region 在本地数据库里增加一条记录 string localconn = "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() + "')", localconn); #endregion toolForm.ToolControlsName = null; //增加控件后将控件名称置空,一次增加一个控件 videoAddCount++; //添加完摄像头控件后videoAddCount++ videoCount++; //添加完摄像头控件后videoCount++ break; #endregion #region Drop case "Drop": PictureBox dropPictureBox = new PictureBox(); dropPictureBox.Image = global::DisplayWindows.Properties.Resources.drop128; //控件图片的资源 dropPictureBox.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; //控件图片的布局方式 dropPictureBox.Size = new System.Drawing.Size(55, 50); //控件大小 dropPictureBox.Location = new Point(e.X - 28, e.Y - 25); //把鼠标点减去控件宽和高的一半 dropPictureBox.MouseDown += new System.Windows.Forms.MouseEventHandler(MyMouseDown); dropPictureBox.MouseLeave += new System.EventHandler(MyMouseLeave); dropPictureBox.MouseMove += new System.Windows.Forms.MouseEventHandler(MyMouseMove); dropPictureBox.ContextMenuStrip = this.dropContextMenuStrip; //增加鼠标右键菜单 this.dockPanel.Controls.Add(dropPictureBox); //在面板上增加一个控件 dropPictureBox.Name = "滴水" + dropCount; dropCount++; toolForm.ToolControlsName = null; 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; //增加鼠标右键菜单 this.dockPanel.Controls.Add(tempPictureBox); //在面板上增加一个控件 tempPictureBox.Name = "温湿度" + tempCount; tempCount++; toolForm.ToolControlsName = null; 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 }