畢業(yè)設計-視頻監(jiān)控系統(tǒng)代碼

附錄一登錄界面usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceMyVideo{publicpartialclassfrmLogin:Form{publicfrmLogin(){InitializeComponent();}privatevoidfrmLogin_Load(objectsender,EventArgse){this.timer1.Start();//啟動時間}//確定privatevoidbtQueding_Click(objectsender,EventArgse){if(tbName.Text.Trim()!=""&&tbPas.Text.Trim()!="")//信息輸入框都不為空{stringLJ=@"DataSource=PC-20150826CYWO;InitialCatalog=MyData;IntegratedSecurity=True";//建立連接SqlConnectionconn=newSqlConnection(LJ);SqlCommandcomm=conn.CreateCommand();//實例化數(shù)據(jù)庫的操作命令conn.Open();if(rbStudent.Checked)//學生{stringsql="selectsno,spass,snamefromstudentwhere(sno='"+tbName.Text+"')";comm.CommandText=sql;SqlDataReaderdatar=comm.ExecuteReader();//使SqlDataReader前進到下一條記錄。返回一個bool值，如果為真跳出循環(huán)while(datar.Read()){//讀取數(shù)據(jù)庫的內容，并與輸入的進行比較；判斷用戶輸入是否正確if(datar["spass"].ToString().Trim()!=tbPas.Text.Trim()){MessageBox.Show("密碼不正確，請重新輸入！");tbPas.Focus();//焦點：使光標聚焦在文本輸入框return;}else{Form1f1=newForm1();this.Hide();//this.Close();f1.ShowDialog();//信息正確，界面跳轉}}datar.Close();}elseif(rbTeacher.Checked)//老師{stringsql="selecttno,tpass,tnamefromteacherwhere(tno='"+tbName.Text+"')";comm.CommandText=sql;SqlDataReaderdatar=comm.ExecuteReader();while(datar.Read()){//判斷用戶輸入是否正確if(datar["tpass"].ToString().Trim()!=tbPas.Text.Trim()){MessageBox.Show("用戶名或密碼不正確，請重新輸入！");tbPas.Focus();return;}else{Form1f1=newForm1();this.Hide();//this.Close();f1.ShowDialog();}}datar.Close();}elseif(rbAdmin.Checked)//管理員{stringsql="SELECTadminname,adminpass,adminIDFROMadminWHERE(adminID='"+tbName.Text+"')";comm.CommandText=sql;SqlDataReaderdatar=comm.ExecuteReader();while(datar.Read()){if(datar["adminpass"].ToString().Trim()!=tbPas.Text.Trim()){MessageBox.Show("密碼不正確，請重新輸入！");tbPas.Focus();return;}else{AdminLoginf2=newAdminLogin();this.Hide();f2.ShowDialog();}}datar.Close();}tbName.Text="";//用戶信息錯誤，信息清除tbPas.Text="";}else{MessageBox.Show("用戶或密碼不能為空！");tbName.Focus();return;}}//取消privatevoidbtQuxiao_Click(objectsender,EventArgse){if(MessageBox.Show("你確定退出系統(tǒng)嗎？","系統(tǒng)提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Exclamation)==DialogResult.OK){Application.Exit();}}//時間顯示privatevoidtimer1_Tick(objectsender,EventArgse){time.Text="當前時間為："+DateTime.Now.ToLongDateString()+""+DateTime.Now.ToLongTimeString();//字幕滾動#regionthis.time.Left-=3;if(this.time.Left<0){this.time.Left=this.Width-200;}#endregion}}}附錄二信息維護界面usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceMyVideo{publicpartialclassAdminLogin:Form{publicAdminLogin(){InitializeComponent();}publicstaticstringsql="DataSource=PC-20150826CYWO;InitialCatalog=MyData;IntegratedSecurity=True";inttab_num=1;//學生工號改變選擇tab1privatevoidrbxsxh_CheckedChanged(objectsender,EventArgse){this.tabControl1.SelectedIndex=0;}//教師工號改變選擇tab2privatevoidrbjsgh_CheckedChanged(objectsender,EventArgse){this.tabControl1.SelectedIndex=1;}privatevoidtabControl1_SelectedIndexChanged(objectsender,EventArgse){if(tabControl1.SelectedTab.Name=="tabPage1"){tab_num=1;}elseif(tabControl1.SelectedTab.Name=="tabPage2"){tab_num=2;}}privatevoidAdminLogin_Load(objectsender,EventArgse){this.teacherTableAdapter.Fill(this.myDataTeacher.teacher);this.studentTableAdapter.Fill(this.myDataDataStudent.student);}//查詢按鈕privatevoidbt_search_Click(objectsender,EventArgse){if(tbSearch.Text.Trim()!=""){search();}else{MessageBox.Show("查詢條件不能為空");}}//查詢privatevoidsearch(){stringsql_student="select*fromStudentwhere1=1";stringsql_teacher="select*fromteacherwhere1=1";if(rbxsxh.Checked)//學生學號{if(tbSearch.Text.Trim()!=""){sql_student+="andsnolike'%"+tbSearch.Text.Trim()+"%'";}dataGridView1.DataSource=MyMeans.GetDataset(sql_student,"Student").Tables["Student"];}elseif(rbjsgh.Checked)//教學工號{if(tbSearch.Text.Trim()!=""){sql_teacher+="andtnolike'%"+tbSearch.Text.Trim()+"%'";}dataGridView2.DataSource=MyMeans.GetDataset(sql_teacher,"teacher").Tables["teacher"];}}//添加學生信息privatevoidbutton3_Click(objectsender,EventArgse){if(textBox2.Text==""&&textBox3.Text==""&&textBox4.Text==""){MessageBox.Show("請完善學生信息");}else{SqlConnectionconn=newSqlConnection(sql);conn.Open();SqlCommandcomm=newSqlCommand(sql,conn);if(tab_num==1){stringsql1="selectsnofromStudentwheresno='"+textBox2.Text.Trim()+"'";comm.CommandText=sql1;SqlDataReaderdatar=comm.ExecuteReader();if(datar.Read()){MessageBox.Show("該學生信息已經(jīng)存在");}else{stringsql_xuan="InsertintoStudent(sno,sname,spass)values('"+ textBox2.Text.Trim()+"','"+textBox3.Text.Trim()+"','"+ textBox4.Text.Trim()+"')";MyMeans.Sqlexcute(sql_xuan);MessageBox.Show("數(shù)據(jù)保存成功","系統(tǒng)提示");relogin();}}elseif(tab_num==2){stringsql2="selecttnofromteacherwheretno='"+textBox2.Text.Trim()+"'";comm.CommandText=sql2;SqlDataReaderdatar=comm.ExecuteReader();if(datar.Read()){MessageBox.Show("該教師信息已經(jīng)存在");}else{stringsql_xuan="Insertintoteacher(tno,tname,tpass)values('"+textBox2.Text.Trim()+"','"+textBox3.Text.Trim()+"','"+textBox4.Text.Trim()+"')";MyMeans.Sqlexcute(sql_xuan);MessageBox.Show("數(shù)據(jù)保存成功","系統(tǒng)提示");relogin();}}textBox2.Text="";textBox3.Text="";textBox4.Text="";conn.Close();}}//刪除信息privatevoidbutton4_Click(objectsender,EventArgse){if(textBox2.Text==""){MessageBox.Show("請?zhí)顚憚h除學生學號或教師工號");}else{if(tab_num==1){stringsql_tui="deletefromStudentwheresno='"+textBox2.Text+"'";MyMeans.Sqlexcute(sql_tui);}elseif(tab_num==2){stringsql_tui="deletefromteacherwheretno='"+textBox2.Text+"'";MyMeans.Sqlexcute(sql_tui);}MessageBox.Show("數(shù)據(jù)刪除成功","系統(tǒng)提示");relogin();textBox2.Text="";textBox3.Text="";textBox4.Text="";}}//修改學生信息privatevoidbutton5_Click(objectsender,EventArgse){if(textBox2.Text==""&&textBox3.Text==""&&textBox4.Text==""){MessageBox.Show("請完善所要修改的信息");}else{SqlConnectionconn=newSqlConnection(sql);conn.Open();SqlCommandcomm=newSqlCommand(sql,conn);if(tab_num==1){stringsql1="selectsno,sname,spassfromStudentwheresno='"+textBox2.Text.Trim()+"'andsname='"+textBox3.Text.Trim()+"'andspass='"+textBox4.Text.Trim()+"'";comm.CommandText=sql1;SqlDataReaderdatar=comm.ExecuteReader();if(datar.Read()){MessageBox.Show("該學生信息一樣，修改無效");}else{stringsql_tui="deletefromStudentwheresno='"+textBox2.Text+"'";MyMeans.Sqlexcute(sql_tui);stringsql_xuan="InsertintoStudent(sno,sname,spass)values('"+textBox2.Text.Trim()+"','"+textBox3.Text.Trim()+"','"+textBox4.Text.Trim()+"')";MyMeans.Sqlexcute(sql_xuan);relogin();MessageBox.Show("數(shù)據(jù)保存成功","系統(tǒng)提示");}}elseif(tab_num==2){stringsql2="selecttno,tname,tpassfromteacherwheretno='"+textBox2.Text.Trim()+"'andtname='"+textBox3.Text.Trim()+"'andtpass='"+textBox4.Text.Trim()+"'";comm.CommandText=sql2;SqlDataReaderdatar=comm.ExecuteReader();if(datar.Read()){MessageBox.Show("該教師信息一樣，修改無效");}else{stringsql_tui="deletefromteacherwheretno='"+textBox2.Text+"'";MyMeans.Sqlexcute(sql_tui);stringsql_xuan="Insertintoteacher(tno,tname,tpass)values('"+textBox2.Text.Trim()+"','"+textBox3.Text.Trim()+"','"+textBox4.Text.Trim()+"')";MyMeans.Sqlexcute(sql_xuan);relogin();MessageBox.Show("數(shù)據(jù)保存成功","系統(tǒng)提示");}}textBox2.Text="";textBox3.Text="";textBox4.Text="";conn.Close();}}//刪除多行信息privatevoidbutton6_Click(objectsender,EventArgse){stringsql="DataSource=PC-20150826CYWO;InitialCatalog=MyData;IntegratedSecurity=True";SqlConnectionconn=newSqlConnection(sql);conn.Open();//打開連接SqlCommandcmd=conn.CreateCommand();if(this.dataGridView1.SelectedRows.Count>0&&tab_num==1){DialogResultdr=MessageBox.Show("確定刪除選中的記錄?","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);if(dr==DialogResult.OK){//遍歷所選中的dataGridView記錄行foreach(DataGridViewRowrowinthis.dataGridView1.SelectedRows){//取dataGridView1中的第一列的值stringstrN=row.Cells[0].Value.ToString();stringsql1="deletefromstudentwheresno='"+strN+"'";cmd.CommandText=sql1;cmd.ExecuteNonQuery();//執(zhí)行刪除}}}elseif(this.dataGridView2.SelectedRows.Count>0&&tab_num==2){DialogResultdr=MessageBox.Show("確定刪除選中的記錄?","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);if(dr==DialogResult.OK){//遍歷所選中的dataGridView記錄行foreach(DataGridViewRowrowinthis.dataGridView2.SelectedRows){//取dataGridView1中的第一列的值stringstrN=row.Cells[0].Value.ToString();stringsql1="deletefromteacherwheretno='"+strN+"'";cmd.CommandText=sql1;cmd.ExecuteNonQuery();//執(zhí)行刪除}}}conn.Close();//關閉連接conn=null;//釋放資源//刪除后執(zhí)行刷新操作relogin();}privatevoiddataGridView1_CellMouseClick(objectsender,DataGridViewCellMouseEventArgse){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();}}privatevoiddataGridView2_CellMouseClick(objectsender,DataGridViewCellMouseEventArgse){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();}}//查詢框改變時自動查詢privatevoidtbSearch_TextChanged(objectsender,EventArgse){search();}//刷新privatevoidrelogin(){if(tab_num==1){stringsql="select*fromStudent";DataSetshuaxin=MyMeans.GetDataset(sql,"Student");dataGridView1.DataSource=shuaxin.Tables["Student"];}elseif(tab_num==2){stringsql="select*fromteacher";DataSetshuaxin=MyMeans.GetDataset(sql,"teacher");dataGridView2.DataSource=shuaxin.Tables["teacher"];}}//返回privatevoidbt_fanhui_Click(objectsender,EventArgse){frmLoginf1=newfrmLogin();this.Hide();f1.ShowDialog();}privatevoidtextBox2_TextChanged(objectsender,EventArgse){relogin();}privatevoidAdminLogin_FormClosed(objectsender,FormClosedEventArgse){if(MessageBox.Show("你確定退出系統(tǒng)嗎？","系統(tǒng)提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Exclamation)==DialogResult.OK){Application.Exit();}}}}附錄三主功能界面usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Diagnostics;usingSystem.Drawing;usingSystem.Drawing.Imaging;usingSystem.IO;usingSystem.IO.Ports;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Threading;usingAForge;usingAForge.Video;usingAForge.Video.DirectShow;usingAForge.Imaging;usingAForge.Imaging.Filters;usingAForge.Video.FFMPEG;usingAForge.Controls;usingAForge.Video.VFW;namespaceMyVideo{publicpartialclassForm1:Form{#region全局變量定義privateFilterInfoCollectionvideoDevices;privateVideoCaptureDevicevideoSource1;privateVideoCaptureDevicevideoSource2;privateVideoCaptureDevicevideoSource3;privateVideoCaptureDevicevideoSource4;privatebool_stopREC1=true;privatebool_stopREC2=true;privatebool_stopREC3=true;privatebool_stopREC4=true;privatebool_createNewFile1=true;privatebool_createNewFile2=true;privatebool_createNewFile3=true;privatebool_createNewFile4=true;privateVideoFileWriter_videoWriter1=null;privateVideoFileWriter_videoWriter2=null;privateVideoFileWriter_videoWriter3=null;privateVideoFileWriter_videoWriter4=null;privatestring_videoFileName=string.Empty;//視頻文件名privatestring_photoFileName=string.Empty;//視頻文件名privatestring_videoFileFullPath1=string.Empty;//視頻文件全路徑privatestring_videoFileFullPath2=string.Empty;privatestring_videoFileFullPath3=string.Empty;//視頻文件全路徑privatestring_videoFileFullPath4=string.Empty;privateint_frameRate=8;//默認幀率privatestring_videoPath=AppDomain.CurrentDomain.BaseDirectory+"Video\\";//視頻文件路徑privatestring_photoPath=AppDomain.CurrentDomain.BaseDirectory+"Photo\\";//照片文件路徑#endregion//privatefloatX;//當前窗體的寬度//privatefloatY;//當前窗體的高度publicForm1(){InitializeComponent();}privatevoidForm1_Load(objectsender,EventArgse){//X=this.Width;//獲取窗體的寬度//Y=this.Height;//獲取窗體的高度//setTag(this);//調用方法try//try-catch語句由一個try塊后跟一個或多個catch子句構成，這些子句指定不同的異常處理程序。{//枚舉所有視頻輸入設備videoDevices=newFilterInfoCollection(FilterCategory.VideoInputDevice);if(videoDevices.Count>0){tb_text.Text="設備已找到，但是未打開";}if(videoDevices.Count==0)thrownewApplicationException();//throw指拋出錯誤異常，讓上一級的cath去處理}catch(ApplicationException){//tscbxCameras.Items.Add("Nolocalcapturedevices");MessageBox.Show("Nolocalcapturedevices");videoDevices=null;}timer.Start();}//連接視頻1按鈕privatevoidbt_Link1_Click(objectsender,EventArgse){if(videoDevices.Count<1){MessageBox.Show("該視頻源未找到設備！","系統(tǒng)提示");}elseif(videoDevices.Count>=1){if(!videoSourcePlayer1.IsRunning&&bt_Link1.Text=="連接視頻1"){bt_Link1.Text="關閉視頻1";videoSource1=newVideoCaptureDevice(videoDevices[0].MonikerString);videoSourcePlayer1.VideoSource=videoSource1;videoSourcePlayer1.Start();//啟動設置tb_text.Text="視頻已打開";}else{if(bt_Link1.Text=="關閉視頻1"){//videoSource1.SignalToStop();videoSourcePlayer1.Stop();bt_Link1.Text="連接視頻1";}}}}//連接視頻2按鈕privatevoidbt_Link2_Click(objectsender,EventArgse){if(videoDevices.Count<2){MessageBox.Show("該視頻源未找到設備！","系統(tǒng)提示");}elseif(videoDevices.Count>=2){if(!videoSourcePlayer2.IsRunning&&bt_Link2.Text=="連接視頻2"){bt_Link2.Text="關閉視頻2";videoSource2=newVideoCaptureDevice(videoDevices[1].MonikerString);videoSourcePlayer2.VideoSource=videoSource2;videoSourcePlayer2.Start();//啟動設置tb_text.Text="視頻已打開";}else{if(bt_Link2.Text=="關閉視頻2"){//videoSource2.SignalToStop();videoSourcePlayer2.Stop();bt_Link2.Text="連接視頻2";}}}}//連接視頻3按鈕privatevoidbt_Link3_Click(objectsender,EventArgse){if(videoDevices.Count<3){MessageBox.Show("該視頻源未找到設備！","系統(tǒng)提示");}elseif(videoDevices.Count>=3){if(!videoSourcePlayer3.IsRunning&&bt_Link3.Text=="連接視頻3"){bt_Link3.Text="關閉視頻3";videoSource3=newVideoCaptureDevice(videoDevices[2].MonikerString);videoSourcePlayer3.VideoSource=videoSource3;videoSourcePlayer3.Start();//啟動設置tb_text.Text="視頻已打開";}else{if(bt_Link3.Text=="關閉視頻3"){//videoSource2.SignalToStop();videoSourcePlayer3.Stop();bt_Link3.Text="連接視頻3";}}}}//連接視頻4按鈕privatevoidbt_Link4_Click(objectsender,EventArgse){if(videoDevices.Count<4){MessageBox.Show("該視頻源未找到設備！","系統(tǒng)提示");}elseif(videoDevices.Count>=4){if(!videoSourcePlayer4.IsRunning&&bt_Link4.Text=="連接視頻4"){bt_Link4.Text="關閉視頻4";videoSource4=newVideoCaptureDevice(videoDevices[3].MonikerString);videoSourcePlayer4.VideoSource=videoSource4;videoSourcePlayer4.Start();//啟動設置tb_text.Text="視頻已打開";}else{if(bt_Link4.Text=="關閉視頻4"){//videoSource2.SignalToStop();videoSourcePlayer4.Stop();bt_Link4.Text="連接視頻4";}}}}#region拍照//拍照privatevoidbt_Capture_Click(objectsender,EventArgse){if(!videoSourcePlayer1.IsRunning&&!videoSourcePlayer2.IsRunning&&!videoSourcePlayer3.IsRunning&&!videoSourcePlayer4.IsRunning){MessageBox.Show("請打開攝像頭","提示");}else{if(videoSourcePlayer1.IsRunning){videoSource1.NewFrame+=newNewFrameEventHandler(videoSource1_NewFrame);}if(videoSourcePlayer2.IsRunning){videoSource2.NewFrame+=newNewFrameEventHandler(videoSource2_NewFrame);}if(videoSourcePlayer3.IsRunning){videoSource3.NewFrame+=newNewFrameEventHandler(videoSource3_NewFrame);}if(videoSourcePlayer4.IsRunning){videoSource4.NewFrame+=newNewFrameEventHandler(videoSource4_NewFrame);}tb_text.Text="拍照成功,完成時間:"+DateTime.Now.ToString("yyyyMMddhhmmss");}}voidvideoSource1_NewFrame(objectsender,AForge.Video.NewFrameEventArgseventArgs){Bitmapbmp=(Bitmap)eventArgs.Frame.Clone();_videoFileName=DateTime.Now.ToString("1-yyyyMMddhhmmss")+".bmp";bmp.Save(_photoPath+_videoFileName,System.Drawing.Imaging.ImageFormat.Bmp);//如果這里不寫這個，一會兒會不停的拍照，videoSource1.NewFrame-=newNewFrameEventHandler(videoSource1_NewFrame);}voidvideoSource2_NewFrame(objectsender,AForge.Video.NewFrameEventArgseventArgs){Bitmapbmp=(Bitmap)eventArgs.Frame.Clone();_videoFileName=DateTime.Now.ToString("2-yyyyMMddhhmmss")+".bmp";bmp.Save(_photoPath+_videoFileName,System.Drawing.Imaging.ImageFormat.Bmp);videoSource2.NewFrame-=newNewFrameEventHandler(videoSource2_NewFrame);}voidvideoSource3_NewFrame(objectsender,AForge.Video.NewFrameEventArgseventArgs){Bitmapbmp=(Bitmap)eventArgs.Frame.Clone();_videoFileName=DateTime.Now.ToString("3-yyyyMMddhhmmss")+".bmp";bmp.Save(_photoPath+_videoFileName,System.Drawing.Imaging.ImageFormat.Bmp);videoSource3.NewFrame-=newNewFrameEventHandler(videoSource3_NewFrame);}voidvideoSource4_NewFrame(objectsender,AForge.Video.NewFrameEventArgseventArgs){Bitmapbmp=(Bitmap)eventArgs.Frame.Clone();_videoFileName=DateTime.Now.ToString("4-yyyyMMddhhmmss")+".bmp";bmp.Save(_photoPath+_videoFileName,System.Drawing.Imaging.ImageFormat.Bmp);videoSource4.NewFrame-=newN