毕业设计--视频监控系统代码

附录一登录界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace MyVideo{public partial class frmLogin : Form{public frmLogin(){InitializeComponent();}private void frmLogin_Load(object sender, EventArgs e){this.timer1.Start(); //启动时间}//确定private void btQueding_Click(object sender, EventArgs e){if (tbName.Text.Trim() != "" && tbPas.Text.Trim() != "")//信息输入框都不为空{string LJ= @"Data Source=PC-20150826CYWO;Initial Catalog=MyData;Integrated Security=True";//建立连接SqlConnection conn = new SqlConnection(LJ);SqlCommand comm = conn.CreateCommand();//实例化数据库的操作命令conn.Open();if (rbStudent.Checked)//学生{string sql = "select sno,spass,sname from student where(sno='" + tbName.Text + "')";mandText = sql;SqlDataReader datar = comm.ExecuteReader();//使SqlDataReader 前进到下一条记录。

返回一个bool值，如果为真跳出循环while (datar.Read()){//读取数据库的内容，并与输入的进行比较；判断用户输入是否正确if (datar["spass"].ToString().Trim() != tbPas.Text.Trim()){MessageBox.Show("密码不正确，请重新输入！");tbPas.Focus();//焦点：使光标聚焦在文本输入框return;}else{Form1 f1 = new Form1();this.Hide();//this.Close();f1.ShowDialog();//信息正确，界面跳转}}datar.Close();}else if (rbTeacher.Checked)//老师{string sql = "select tno,tpass,tname from teacher where(tno='" + tbName.Text + "')";mandText = sql;SqlDataReader datar = comm.ExecuteReader();while (datar.Read()){//判断用户输入是否正确if (datar["tpass"].ToString().Trim() != tbPas.Text.Trim()){MessageBox.Show("用户名或密码不正确，请重新输入！");tbPas.Focus();return;}else{Form1 f1 = new Form1();this.Hide();//this.Close();f1.ShowDialog();}}datar.Close();}else if (rbAdmin.Checked)//管理员{string sql = "SELECT adminname,adminpass,adminID FROM admin WHERE(adminID='" + tbName.Text + "')";mandText = sql;SqlDataReader datar = comm.ExecuteReader();while (datar.Read()){if (datar["adminpass"].ToString().Trim() != tbPas.Text.Trim()){MessageBox.Show("密码不正确，请重新输入！");tbPas.Focus();return;}else{AdminLogin f2 = new AdminLogin();this.Hide();f2.ShowDialog();}}datar.Close();}tbName.Text = "";//用户信息错误，信息清除tbPas.Text = "";}else{MessageBox.Show("用户或密码不能为空！");tbName.Focus();return;}}//取消private void btQuxiao_Click(object sender, EventArgs e){if (MessageBox.Show("你确定退出系统吗？", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == DialogResult.OK){Application.Exit();}}//时间显示private void timer1_Tick(object sender, EventArgs e){time.Text = "当前时间为：" + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString();//字幕滚动#regionthis.time.Left -= 3;if (this.time.Left < 0){this.time.Left = this.Width-200;}#endregion}}}附录二信息维护界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace MyVideo{public partial class AdminLogin : Form{public AdminLogin(){InitializeComponent();}public static string sql = "Data Source=PC-20150826CYWO;Initial Catalog=MyData;Integrated Security=True";int tab_num = 1;//学生工号改变选择tab1private void rbxsxh_CheckedChanged(object sender, EventArgs e){this.tabControl1.SelectedIndex = 0;}//教师工号改变选择tab2private void rbjsgh_CheckedChanged(object sender, EventArgs e){this.tabControl1.SelectedIndex = 1;}private void tabControl1_SelectedIndexChanged(object sender, EventArgs e){if ( == "tabPage1"){tab_num = 1;}else if ( == "tabPage2"){tab_num = 2;}}private void AdminLogin_Load(object sender, EventArgs e){this.teacherTableAdapter.Fill(this.myDataTeacher.teacher);this.studentTableAdapter.Fill(this.myDataDataStudent.student);}//查询按钮private void bt_search_Click(object sender, EventArgs e){if (tbSearch.Text.Trim() != ""){search();}else{MessageBox.Show("查询条件不能为空");}}//查询private void search(){string sql_student = "select *from Student where 1=1";string sql_teacher = "select *from teacher where 1=1";if (rbxsxh.Checked)//学生学号{if (tbSearch.Text.Trim() != ""){sql_student += " and sno like '%" + tbSearch.Text.Trim() + "%'";}dataGridView1.DataSource =MyMeans.GetDataset(sql_student, "Student").Tables["Student"];}else if (rbjsgh.Checked)//教学工号{if (tbSearch.Text.Trim() != ""){sql_teacher += " and tno like '%" + tbSearch.Text.Trim() + "%'";}dataGridView2.DataSource =MyMeans.GetDataset(sql_teacher, "teacher").Tables["teacher"];}}//添加学生信息private void button3_Click(object sender, EventArgs e){if (textBox2.Text == "" && textBox3.Text == "" && textBox4.Text == ""){MessageBox.Show("请完善学生信息");}else{SqlConnection conn = new SqlConnection(sql);conn.Open();SqlCommand comm = new SqlCommand(sql, conn);if (tab_num == 1){string sql1 = "select sno from Student where sno='" + textBox2.Text.Trim() + "'";mandText = sql1;SqlDataReader datar = comm.ExecuteReader();if (datar.Read()){MessageBox.Show("该学生信息已经存在");}else{string sql_xuan = "Insert into Student(sno,sname,spass) values ('" +textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" +textBox4.Text.Trim() + "')";MyMeans.Sqlexcute(sql_xuan);MessageBox.Show("数据保存成功", "系统提示");relogin();}}else if (tab_num == 2){string sql2 = "select tno from teacher where tno='" + textBox2.Text.Trim() + "'";mandText = sql2;SqlDataReader datar = comm.ExecuteReader();if (datar.Read()){MessageBox.Show("该教师信息已经存在");}else{string sql_xuan = "Insert into teacher(tno,tname,tpass) values ('" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox4.Text.Trim() + "')";MyMeans.Sqlexcute(sql_xuan);MessageBox.Show("数据保存成功", "系统提示");relogin();}}textBox2.Text = "";textBox3.Text = "";textBox4.Text = "";conn.Close();}}//删除信息private void button4_Click(object sender, EventArgs e){if (textBox2.Text == ""){MessageBox.Show("请填写删除学生学号或教师工号");}else{if (tab_num == 1){string sql_tui = "delete from Student where sno='" + textBox2.Text + "'";MyMeans.Sqlexcute(sql_tui);}else if (tab_num == 2){string sql_tui = "delete from teacher where tno='" + textBox2.Text + "'";MyMeans.Sqlexcute(sql_tui);}MessageBox.Show("数据删除成功", "系统提示");relogin();textBox2.Text = "";textBox3.Text = "";textBox4.Text = "";}}//修改学生信息private void button5_Click(object sender, EventArgs e){if (textBox2.Text == "" && textBox3.Text == "" && textBox4.Text == ""){MessageBox.Show("请完善所要修改的信息");}else{SqlConnection conn = new SqlConnection(sql);conn.Open();SqlCommand comm = new SqlCommand(sql, conn);if (tab_num == 1){string sql1 = "select sno,sname,spass from Student where sno='" + textBox2.Text.Trim() + "'and sname='" + textBox3.Text.Trim() + "'and spass='" + textBox4.Text.Trim() + "'";mandText = sql1;SqlDataReader datar = comm.ExecuteReader();if (datar.Read()){MessageBox.Show("该学生信息一样，修改无效");}else{string sql_tui = "delete from Student where sno='" + textBox2.Text + "'";MyMeans.Sqlexcute(sql_tui);string sql_xuan = "Insert into Student(sno,sname,spass) values ('" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox4.Text.Trim() + "')";MyMeans.Sqlexcute(sql_xuan);relogin();MessageBox.Show("数据保存成功", "系统提示");}}else if (tab_num == 2){string sql2 = "select tno,tname,tpass from teacher where tno='" + textBox2.Text.Trim() + "'and tname='" + textBox3.Text.Trim() + "'and tpass='" + textBox4.Text.Trim() + "'";mandText = sql2;SqlDataReader datar = comm.ExecuteReader();if (datar.Read()){MessageBox.Show("该教师信息一样，修改无效");}else{string sql_tui = "delete from teacher where tno='" + textBox2.Text + "'";MyMeans.Sqlexcute(sql_tui);string sql_xuan = "Insert into teacher(tno,tname,tpass) values ('" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox4.Text.Trim() + "')";MyMeans.Sqlexcute(sql_xuan);relogin();MessageBox.Show("数据保存成功", "系统提示");}}textBox2.Text = "";textBox3.Text = "";textBox4.Text = "";conn.Close();}}//删除多行信息private void button6_Click(object sender, EventArgs e){string sql = "Data Source=PC-20150826CYWO;Initial Catalog=MyData;Integrated Security=True";SqlConnection conn = new SqlConnection(sql);conn.Open(); //打開連接SqlCommand cmd = conn.CreateCommand();if (this.dataGridView1.SelectedRows.Count > 0 && tab_num == 1){DialogResult dr = MessageBox.Show("确定删除选中的记录? ", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);if (dr == DialogResult.OK){//遍历所选中的dataGridView记录行foreach (DataGridViewRow row in this.dataGridView1.SelectedRows){//取dataGridView1中的第一列的值string strN = row.Cells[0].Value.ToString();string sql1 = "delete from student where sno='" + strN + "'";mandText = sql1;cmd.ExecuteNonQuery(); //执行删除}}}else if (this.dataGridView2.SelectedRows.Count > 0 && tab_num == 2){DialogResult dr = MessageBox.Show("确定删除选中的记录? ", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);if (dr == DialogResult.OK){//遍历所选中的dataGridView记录行foreach (DataGridViewRow row in this.dataGridView2.SelectedRows){//取dataGridView1中的第一列的值string strN = row.Cells[0].Value.ToString();string sql1 = "delete from teacher where tno='" + strN + "'";mandText = sql1;cmd.ExecuteNonQuery(); //执行删除}}}conn.Close(); //关闭连接conn = null; //释放资源//删除后执行刷新操作relogin();}private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e){if (e.RowIndex >= 0){textBox2.Text =dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();textBox3.Text =dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();textBox4.Text =dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();}}private void dataGridView2_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e){if (e.RowIndex >= 0){textBox2.Text =dataGridView2.Rows[e.RowIndex].Cells[0].Value.ToString();textBox3.Text =dataGridView2.Rows[e.RowIndex].Cells[1].Value.ToString();textBox4.Text =dataGridView2.Rows[e.RowIndex].Cells[2].Value.ToString();}}//查询框改变时自动查询private void tbSearch_TextChanged(object sender, EventArgs e){search();}//刷新private void relogin(){if (tab_num == 1){string sql = "select*from Student";DataSet shuaxin = MyMeans.GetDataset(sql, "Student");dataGridView1.DataSource = shuaxin.Tables["Student"];}else if (tab_num == 2){string sql = "select*from teacher";DataSet shuaxin = MyMeans.GetDataset(sql, "teacher");dataGridView2.DataSource = shuaxin.Tables["teacher"];}}//返回private void bt_fanhui_Click(object sender, EventArgs e){frmLogin f1 = new frmLogin();this.Hide();f1.ShowDialog();}private void textBox2_TextChanged(object sender, EventArgs e){relogin();}private void AdminLogin_FormClosed(object sender, FormClosedEventArgs e){if (MessageBox.Show("你确定退出系统吗？", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == DialogResult.OK){Application.Exit();}}}}附录三主功能界面using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Diagnostics;using System.Drawing;using System.Drawing.Imaging;using System.IO;using System.IO.Ports;using System.Linq;using System.Text;using System.Windows.Forms;using System.Threading;using AForge;using AForge.Video;using AForge.Video.DirectShow;using AForge.Imaging;using AForge.Imaging.Filters;using AForge.Video.FFMPEG;using AForge.Controls;using AForge.Video.VFW;namespace MyVideo{public partial class Form1 : Form{#region 全局变量定义private FilterInfoCollection videoDevices;private VideoCaptureDevice videoSource1;private VideoCaptureDevice videoSource2;private VideoCaptureDevice videoSource3;private VideoCaptureDevice videoSource4;private bool _stopREC1 = true;private bool _stopREC2 = true;private bool _stopREC3 = true;private bool _stopREC4 = true;private bool _createNewFile1 = true;private bool _createNewFile2 = true;private bool _createNewFile3 = true;private bool _createNewFile4 = true;private VideoFileWriter _videoWriter1 = null;private VideoFileWriter _videoWriter2 = null;private VideoFileWriter _videoWriter3 = null;private VideoFileWriter _videoWriter4 = null;private string _videoFileName = string.Empty; //视频文件名private string _photoFileName = string.Empty; //视频文件名private string _videoFileFullPath1 = string.Empty; //视频文件全路径private string _videoFileFullPath2 = string.Empty;private string _videoFileFullPath3 = string.Empty; //视频文件全路径private string _videoFileFullPath4 = string.Empty;private int _frameRate = 8; //默认帧率private string _videoPath = AppDomain.CurrentDomain.BaseDirectory + "Video\\"; //视频文件路径private string _photoPath = AppDomain.CurrentDomain.BaseDirectory + "Photo\\"; //照片文件路径#endregion//private float X;//当前窗体的宽度//private float Y;//当前窗体的高度public Form1(){InitializeComponent();}private void Form1_Load(object sender, EventArgs e){//X = this.Width;//获取窗体的宽度//Y = this.Height;//获取窗体的高度//setTag(this);//调用方法try//try-catch 语句由一个try 块后跟一个或多个catch 子句构成，这些子句指定不同的异常处理程序。