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
}
