家居門禁模塊功能實(shí)現(xiàn)KCa

1、家居門禁模塊功能實(shí)現(xiàn)智能家居綜合應(yīng)用系統(tǒng)設(shè)備編程與實(shí)施問(wèn)題導(dǎo)入1門禁管理界面功能門禁數(shù)據(jù)庫(kù)設(shè)計(jì)詳細(xì)代碼實(shí)現(xiàn)24目錄目錄關(guān)鍵代碼分析3第一部分門禁管理界面功能門禁管理界面功能.mp4第二部分門禁數(shù)據(jù)庫(kù)設(shè)計(jì)門禁數(shù)據(jù)庫(kù)設(shè)計(jì)門禁數(shù)據(jù)庫(kù)設(shè)計(jì)項(xiàng)名項(xiàng)類型備注kahao文本授權(quán)的RFID卡號(hào)，主鍵beizhu文本卡片使用者姓名門禁數(shù)據(jù)庫(kù)創(chuàng)建.mp4第三部分關(guān)鍵代碼分析query_menjin_dbquery_menjin_db函數(shù)函數(shù)private void query_menjin_db() string strConnection = Provider=Microsoft.ACE.OLEDB.12.0;D

2、ata Source=|DataDirectory|/user.accdb; OleDbConnection myconn = new OleDbConnection(strConnection); myconn.Open(); DataSet mydataset = new DataSet(); string strcmd = SELECT user.kahao, user.beizhu FROM user; OleDbDataAdapter mycommand = new OleDbDataAdapter(strcmd, myconn); mycommand.Fill(mydataset,

3、 user); myconn.Close(); dataGridView1.DataSource = mydataset.Tablesuser; 首先創(chuàng)建并打開與數(shù)據(jù)庫(kù)的鏈接創(chuàng)建數(shù)據(jù)集和數(shù)據(jù)適配器填充數(shù)據(jù)集，并設(shè)置為DataGridView控件的數(shù)據(jù)源IskahaoIskahao函數(shù)函數(shù) private int iskahao(string cardsn) string strConnection = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/user.accdb; OleDbConnection myconn

4、= new OleDbConnection(strConnection); myconn.Open(); string strcmd = select count(*) FROM user WHERE kahao = + cardsn + ; OleDbCommand cmd = new OleDbCommand(strcmd, myconn); int iret = Convert.ToInt32(cmd.ExecuteScalar(); myconn.Close(); return iret; 首先創(chuàng)建并打開與數(shù)據(jù)庫(kù)的鏈接以Select count SQL語(yǔ)句創(chuàng)建Command對(duì)象執(zhí)行Co

5、mmand對(duì)象的ExecuteScalar方法獲得結(jié)果dukahaodukahao函數(shù)函數(shù)private void dukahao() Byte data = new byte200; int idx; int bcc = 0; data0 = 0 x02; data1 = 0 x00; data2 = 0 x03; data3 = 0 x25; data4 = 0 x26; data5 = 0 x00; for (idx = 1; idx 6; idx+) bcc = bcc dataidx; dataidx+ = Convert.ToByte(bcc); dataidx+ = 0 x03; spComRfid.Write(data, 0, idx); 按照RFID命令包的格式構(gòu)造命令包命令包中讀卡命令為0 x25,讀卡模式為Idle模式，卡號(hào)讀取完成后不需要進(jìn)行HALT操作命令包構(gòu)造完成后，通過(guò)串