using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.IO.Ports;
using?System.Threading;
using?System.Data.OleDb;

namespace?Attendance
{
????public?partial?class?Form1?:?Form
????{
????????private?string[]?arryPorts;?/*系統(tǒng)可用串口號列表*/
????????private?string?exePath;?/*當前程序運行路徑*/
????????public?OleDbConnection?connAttendance;??/*attendance.mdb鏈接對象*/
????????private?OleDbConnection?connLog;????/*log.mdb鏈接對象*/
????????private?Form2?form2;????/*添加用戶窗口對象*/
????????private?byte[]?dataBuf;?/*串口數(shù)據(jù)接收buffer*/
????????private?int?readCnt?=?0;/*串口數(shù)據(jù)字節(jié)長度*/

????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
????????/*窗體加載回調(diào)函數(shù)*/
????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????/*獲取系統(tǒng)可用串口*/
????????????arryPorts?=?SerialPort.GetPortNames（）;
????????????cbxPort.Items.Clear（）;
????????????for?（int?i?=?0;?i?????????????{
????????????????cbxPort.Items.Add（arryPorts[i]）;
????????????}
????????????cbxPort.SelectedIndex?=?0;
????????????/*注冊串口控件數(shù)據(jù)接收回調(diào)函數(shù)*/
????????????sPort.DataReceived?+=?commDataReceived;
????????????/*創(chuàng)建數(shù)據(jù)庫鏈接*/
????????????exePath?=?System.Environment.CurrentDirectory;
????????????connAttendance?=?new?OleDbConnection（“provider=Microsoft.Jet.OLEDB.4.0;data?source=“?+?exePath?+?@“\attendance.mdb“）;
????????????connLog?=?new?OleDbConnection（“provider=Microsoft.Jet.OLEDB.4.0;data?source=“?+?exePath?+?@“\log.mdb“）;
????????????/*將數(shù)據(jù)庫中的數(shù)據(jù)顯示在界面DataGridView控件上*/
????????????string?cmdStr?=?“select?*?from?attendance“;
????????????queryDatabase（connAttendance?cmdStr?dgvUsrMng）;
????????????cmdStr?=?“select?*?from?log“;
????????????queryDatabase（connLog?cmdStr?dgvLogInfo）;
????????????form2?=?new?Form2（）;
????????????dataBuf?=?new?byte[29];
????????}
????????/*查詢，刷新數(shù)據(jù)庫*/
????????public?void?queryDatabase（OleDbConnection?conn?string?str?DataGridView?dgv）
????????{
????????????if?（（null?==?conn）?||?（null?==?str）?||?（null?==?dgv））
????????????????return;
????????????conn.Open（）;
????????????OleDbDataAdapter?da?=?new?OleDbDataAdapter（str?conn）;
????????????DataTable?dt?=?new?DataTable（）;
????????????da.Fill（dt）;
????????????dgv.DataSource?=?dt;
????????????conn.Close（）;
????????}
????????/*修改數(shù)據(jù)庫*/
????????public?void?modifyDatabase（OleDbConnection?conn?string?cmdStr）
????????{
????????????if?（（null?==?conn）?||?（null?==?cmdStr））
????????????????return;
????????????conn.Open（）;
????????????OleDbCommand?comm?=?new?OleDbCommand（cmdStr?conn）;
????????????comm.ExecuteNonQuery（）;
????????????conn.Close（）;
????????}
????????/*串口接收回調(diào)函數(shù)*/
????????private?void?commDataReceived（object?sender?SerialDataReceivedEventArgs?e）
????????{
????????????byte[]?readBuf?=?new?byte[29];
????????????byte[]?blk1Buf?=?new?byte[4];

????????????int?count?=?sPort.Read（readBuf?0?29）;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????..A..H.?????47616??2017-03-27?07:35??Attendance\.vs\Attendance\v14\.suo

????..A..H.?????79872??2017-03-27?10:09??Attendance\Attendance\App1\.vs\App1\v14\.suo

?????文件????????249??2017-03-27?10:04??Attendance\Attendance\App1\App1\App.xaml

?????文件???????3983??2017-03-27?10:04??Attendance\Attendance\App1\App1\App.xaml.cs

?????文件???????6559??2017-03-27?10:04??Attendance\Attendance\App1\App1\App1.csproj

?????文件????????355??2017-03-27?10:09??Attendance\Attendance\App1\App1\App1.csproj.user

?????文件???????2520??2017-03-27?10:05??Attendance\Attendance\App1\App1\App1_TemporaryKey.pfx

?????文件???????1430??2015-09-20?17:22??Attendance\Attendance\App1\App1\Assets\LockScreenLogo.scale-200.png

?????文件???????7700??2015-09-20?17:22??Attendance\Attendance\App1\App1\Assets\SplashScreen.scale-200.png

?????文件???????2937??2015-09-20?17:22??Attendance\Attendance\App1\App1\Assets\Square150x150Logo.scale-200.png

?????文件???????1647??2015-09-20?17:22??Attendance\Attendance\App1\App1\Assets\Square44x44Logo.scale-200.png

?????文件???????1255??2015-09-20?17:22??Attendance\Attendance\App1\App1\Assets\Square44x44Logo.targetsize-24_altform-unplated.png

?????文件???????1451??2015-09-20?17:22??Attendance\Attendance\App1\App1\Assets\StoreLogo.png

?????文件???????3204??2015-09-20?17:22??Attendance\Attendance\App1\App1\Assets\Wide310x150Logo.scale-200.png

?????文件????????468??2017-03-27?10:04??Attendance\Attendance\App1\App1\MainPage.xaml

?????文件????????821??2017-03-27?10:04??Attendance\Attendance\App1\App1\MainPage.xaml.cs

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\ARM\Debug\App.g.cs

?????文件???????7676??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\ARM\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\ARM\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\ARM\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\ARM\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\x86\Debug\App.g.cs

?????文件???????2253??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\x86\Debug\App.g.i.cs

?????文件??????40912??2017-03-27?10:06??Attendance\Attendance\App1\App1\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\x86\Debug\MainPage.g.cs

?????文件???????1563??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\x86\Debug\MainPage.g.i.cs

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\x86\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\x86\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2017-03-27?10:05??Attendance\Attendance\App1\App1\obj\x86\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件????????791??2017-03-27?10:06??Attendance\Attendance\App1\App1\obj\x86\Debug\XamlSaveStateFile.xml

............此處省略97個文件信息