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

1、家居門禁模塊功能實現(xiàn)智能家居綜合應用系統(tǒng)設備編程與實施問題導入1門禁管理界面功能門禁數(shù)據(jù)庫設計詳細代碼實現(xiàn)24目錄目錄關鍵代碼分析3第一部分門禁管理界面功能門禁管理界面功能.mp4第二部分門禁數(shù)據(jù)庫設計門禁數(shù)據(jù)庫設計門禁數(shù)據(jù)庫設計項名項類型備注kahao文本授權的RFID卡號，主鍵beizhu文本卡片使用者姓名門禁數(shù)據(jù)庫創(chuàng)建.mp4第三部分關鍵代碼分析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ù)庫的鏈接創(chuàng)建數(shù)據(jù)集和數(shù)據(jù)適配器填充數(shù)據(jù)集，并設置為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ù)庫的鏈接以Select count SQL語句創(chuàng)建Command對象執(zhí)行Co

5、mmand對象的ExecuteScalar方法獲得結果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命令包的格式構造命令包命令包中讀卡命令為0 x25,讀卡模式為Idle模式，卡號讀取完成后不需要進行HALT操作命令包構造完成后，通過串