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
}
