中控考勤机接口开发

 1         #region 窗体变量
 2         string USERID = "";//同步到数据库的参数
 3         string CHARGE_TIME = "";//同步到数据库的参数
 4         string VERIFYMODE = "";//同步到数据库的参数
 5         string WORKCODE = "";//同步到数据库的参数
 6         string PASSWORD = "";//同步到数据库的参数
 7         string PRIVILEGE = "";//同步到数据库的参数
 8         string ENABLE = "";//同步到数据库的参数
 9         System.Timers.Timer atimer = new System.Timers.Timer(); //定时任务
10         #endregion    
11 
12         #region 考勤机变量
13         public CZKEMClass axCZKEM1 = new CZKEMClass();
14         private bool bIsConnected = false;
15         private int iMachineNumber = 1;
16 
17         string sdwEnrollNumber = "";//用户ID
18         string sName = "";//姓名
19         string sPassword = "";//密码
20         int iPrivilege = 0;
21         bool bEnabled = false;
22         string sCardnumber = "";//卡号
23         int dwWorkCode = 0;
24         int dwVerifyMode;
25         int dwInOutMode;
26         int dwYear;//刷卡时间
27         int dwMonth;
28         int dwDay;
29         int dwHour;
30         int dwMinute;
31         int dwSecond;
32         string verifyMode = "";
33         string privilege = "";
34         string enabled = "";
35         #endregion

 1 #region 考勤机功能：连接
 2         private void btnConnect_Click(object sender, EventArgs e)
 3         {
 4             if (txtIP.Text.Trim() == "" || txtPort.Text.Trim() == "")//考勤机的IP地址与端口
 5             {
 6                 MessageBox.Show("IP and Port cannot be null", "Error");
 7                 return;
 8             }
 9             int idwErrorCode = 0;
10 
11             Cursor = Cursors.WaitCursor;
12             if (btnConnect.Text == "DisConnect")
13             {
14                 axCZKEM1.Disconnect();
15                 bIsConnected = false;
16                 btnConnect.Text = "Connect";
17                 lblState.Text = "Current State:DisConnected";
18                 Cursor = Cursors.Default;      
19                 return;
20             }
21 
22             bIsConnected = axCZKEM1.Connect_Net(txtIP.Text, Convert.ToInt32(txtPort.Text));
23             if (bIsConnected == true)
24             {
25                 btnConnect.Text = "DisConnect";
26                 btnConnect.Refresh();
27                 lblState.Text = "Current State:Connected";
28                 iMachineNumber = 1;//In fact,when you are using the tcp/ip communication,this parameter will be ignored,that is any integer will all right.Here we use 1.
29                 axCZKEM1.RegEvent(iMachineNumber, 65535);//Here you can register the realtime events that you want to be triggered(the parameters 65535 means registering all)
30             }
31             else
32             {
33                 axCZKEM1.GetLastError(ref idwErrorCode);
34                 MessageBox.Show("Unable to connect the device,ErrorCode=" + idwErrorCode.ToString(), "Error");
35             }
36             Cursor = Cursors.Default;
37         }
38         #endregion

 1         #region 定时任务配置
 2         public void Timing_Task()
 3         {
 4             atimer.Enabled = true;
 5             atimer.Interval = 60000; //执行间隔时间,单位为毫秒; 这里实际间隔为1分钟  
 6             atimer.Elapsed += new System.Timers.ElapsedEventHandler(getLogData);
 7         }
 8         public void Timing_Task_Star()
 9         {
10             atimer.Enabled = true;
11             atimer.Start();
12         }
13         public void Timing_Task_Close()
14         {
15             atimer.Elapsed -= new System.Timers.ElapsedEventHandler(getLogData);
16             atimer.Stop();
17             atimer.Dispose();
18         }
19         #endregion

 1         #region 执行定时任务(同步数据到MES)
 2         private void getLogData(object source, ElapsedEventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             Cursor = Cursors.WaitCursor;
10             //先禁用机器
11             axCZKEM1.EnableDevice(iMachineNumber, false);
12             //获取所有用户的考勤记录到缓存区
13             axCZKEM1.ReadAllGLogData(iMachineNumber);
14             while (axCZKEM1.SSR_GetGeneralLogData(iMachineNumber, out sdwEnrollNumber, out dwVerifyMode, out dwInOutMode, out dwYear, out dwMonth, out dwDay, out dwHour, out dwMinute, out dwSecond, ref dwWorkCode))//get user information from memory
15             {
16                 switch (dwVerifyMode)
17                 {
18                     case 0:
19                         verifyMode = "密码验证";
20                         break;
21                     case 1:
22                         verifyMode = "指纹验证";
23                         break;
24                     case 2:
25                         verifyMode = "卡验证";
26                         break;
27                     default:
28                         verifyMode = "其他验证";
29                         break;
30                 }
31                 //循环获取用户信息
32                 axCZKEM1.SSR_GetUserInfo(iMachineNumber, sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled);
33                 if (axCZKEM1.GetStrCardNumber(out sCardnumber))//get the card number from the memory
34                 {
35                     switch (iPrivilege)
36                     {
37                         case 0:
38                             privilege = "普通用户";
39                             break;
40                         case 3:
41                             privilege = "管理员";
42                             break;
43                         default:
44                             privilege = "其他权限";
45                             break;
46                     }
47                     switch (bEnabled)
48                     {
49                         case true:
50                             enabled = "启用";
51                             break;
52                         case false:
53                             enabled = "禁用";
54                             break;
55                     }
56                     USERID = sdwEnrollNumber;
57                     CHARGE_TIME = dwYear.ToString() + "-" + dwMonth.ToString() + "-" + dwDay.ToString() + " " + dwHour.ToString() + ":" + dwMinute.ToString() + ":" + dwSecond.ToString();
58                     VERIFYMODE = verifyMode;
59                     WORKCODE = dwWorkCode.ToString();
60                     //NAME = sName+ "\0";
61                     //NAME = NAME.Replace("\0", "");
62                     PASSWORD = sPassword;
63                     PRIVILEGE = privilege;
64                     ENABLE = enabled;
65                     string ID = dwYear.ToString() + dwMonth.ToString() + dwDay.ToString() + dwHour.ToString() + dwMinute.ToString() + dwSecond.ToString();
66                     DateTime now = DateTime.Now;
67                     string thisyear = now.Year.ToString();
68                     string thismonth = now.Month.ToString();
69                     string thisday = now.Day.ToString();
70                     if (dwYear.ToString() == thisyear && dwMonth.ToString() == thismonth && dwDay.ToString() == thisday)
71                     {
72                         //取时间为今天的刷卡记录，若ID不存在则插入
73                         //INSERT WHEN NOT EXISTS (SELECT T.ID FROM TABLE T WHERE T.T_ID = ‘??‘) THEN INTO TABLE(...) VALUES (...)
74                     }
75                 }
76             }
77             axCZKEM1.EnableDevice(iMachineNumber, true);//enable the device
78             Cursor = Cursors.Default;
79 
80             checkDing();//检测是否超时
81         }
82         #endregion

 1         #region 考勤机功能：获取用户
 2         private void btnGetStrCardNumber_Click(object sender, EventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             lvCard.Items.Clear();
10             lvCard.BeginUpdate();
11             Cursor = Cursors.WaitCursor;
12             //先禁用机器
13             axCZKEM1.EnableDevice(iMachineNumber, false);//disable the device
14             //获取所有用户的记录到缓存区
15             axCZKEM1.ReadAllUserID(iMachineNumber);//获取所有信息到缓存区（提高效率）
16             axCZKEM1.ReadAllTemplate(iMachineNumber);//获取所有指纹信息到缓存区（提高效率）
17             while (axCZKEM1.SSR_GetAllUserInfo(iMachineNumber, out sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled))//get user information from memory
18             {
19                 //循环获取用户信息
20                 if (axCZKEM1.GetStrCardNumber(out sCardnumber))//get the card number from the memory
21                 {
22                     ListViewItem list = new ListViewItem();
23                     list.Text = sdwEnrollNumber;
24                     list.SubItems.Add(sName);
25                     list.SubItems.Add(sCardnumber);
26                     list.SubItems.Add(iPrivilege.ToString());
27                     list.SubItems.Add(sPassword);
28                     if (bEnabled == true)
29                     {
30                         list.SubItems.Add("true");
31                     }
32                     else
33                     {
34                         list.SubItems.Add("false");
35                     }
36 
37                     for (int dwFingerIndex = 0; dwFingerIndex < 10; dwFingerIndex++)
38                     {
39                         if (axCZKEM1.SSR_GetUserTmpStr(iMachineNumber, sdwEnrollNumber, dwFingerIndex, out dwTmpData, out dwTmpLength))
40                         {
41                             list.SubItems.Add(dwTmpData);
42                         }
43                         else
44                         {
45                             list.SubItems.Add("");
46                         }
47                     }
48 
49                     lvCard.Items.Add(list);
50                 }
51             }
52             
53             axCZKEM1.EnableDevice(iMachineNumber, true);//enable the device
54             lvCard.EndUpdate();
55             Cursor = Cursors.Default;
56         }
57         #endregion

 1         #region 考勤机功能：注册用户
 2         private void btnSetStrCardNumber_Click(object sender, EventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             //下发用户到机器        
10             //1、设置卡号
11             //string CardNo = System.Convert.ToInt32(txtCardNo.Text, 16).ToString();//转换16进制到十进制
12             axCZKEM1.SetStrCardNumber(txtCardNo.Text);
13             //2、设置用户信息
14             axCZKEM1.SSR_SetUserInfo(iMachineNumber, "用户ID", "用户姓名", "密码", 0, true);
15         }
16         #endregion

 1         #region 考勤机功能：批量注册用户
 2         private void btnSetStrCardNumbers_Click(object sender, EventArgs e)
 3         {
 4             if (XCMessageBox.Show("确定？", XCMessageBox.Buttons.OKCancel, XCMessageBox.Icon.Question) == DialogResult.OK)
 5             {
 6                 System.Data.DataTable dt = getEmp();//getEmp()获取数据库中需要注册的用户
 7                 string[] useruid = new string[dt.Rows.Count];
 8                 string[] useruname = new string[dt.Rows.Count];
 9                 string[] cardid = new string[dt.Rows.Count];
10                 for (int i = 0; i < dt.Rows.Count; i++)
11                 {
12                     DataRow dr = dt.Rows[i];
13                     useruid[i] = Convert.ToString(dr["T_USERID"]);
14                     useruname[i] = Convert.ToString(dr["T_USERNAME"]);
15                     cardid[i] = Convert.ToString(dr["CARDID"]);
16                     //16进制转10进制
17                     //string CardNo = System.Convert.ToInt32(cardid[i], 16).ToString();
18                     axCZKEM1.SetStrCardNumber(cardid[i]);
19                     //2、设置用户信息
20                     bool a = axCZKEM1.SSR_SetUserInfo(iMachineNumber, useruid[i], useruname[i], useruid[i], 0, true);
21                 }
22             }  
23         }
24         #endregion

 1         #region 考勤机功能：删除用户
 2         private void btnDelStrCardNumber_Click(object sender, EventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             if (XCMessageBox.Show("确定？", XCMessageBox.Buttons.OKCancel, XCMessageBox.Icon.Question) == DialogResult.OK)
10             {
11                 axCZKEM1.SSR_DeleteEnrollData(iMachineNumber, "用户ID", 12);
12             }
13         }
14         #endregion

 1         #region 考勤机功能：增删指纹
 2         private void btnDelTmp_Click(object sender, EventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             if (XCMessageBox.Show("确定？", XCMessageBox.Buttons.OKCancel, XCMessageBox.Icon.Question) == DialogResult.OK)
10             {
11                 bool a = axCZKEM1.SSR_DelUserTmp(iMachineNumber, "用户ID", "(int)第几个指纹");
12                 //bool a = axCZKEM1.SSR_DeleteEnrollDataExt(iMachineNumber, txtEmpNo.Text, 13);//删除所有指纹
13             }
14         }
15 
16         private void btnAddTmp_Click(object sender, EventArgs e)
17         {
18             if (bIsConnected == false)
19             {
20                 MessageBox.Show("Please connect the device first!", "Error");
21                 return;
22             }
23             System.Data.DataTable dt = new System.Data.DataTable();
24             for (int i = 0; i < 10; i++)
25             {
26                 
27                 //循环获取十个指纹
28                 dt = getEmpTmp(i.ToString());//获取数据库中第i个指纹
29                 for (int j = 0; j < dt.Rows.Count; j++)
30                 {
31                     
32                     //循环数据库中的用户数
33                     USERID = dt.Rows[j]["数据库中用户ID"].ToString();
34                     dwTmpData = dt.Rows[j]["数据库中第i个指纹"].ToString();
35                     bool a = axCZKEM1.SetUserTmpExStr(iMachineNumber, USERID, i, 1, dwTmpData);
36                 }    
37             }
38 
39             //获取算法版本
40             /*string sValue;
41             axCZKEM1.GetSysOption(1, "~ZKFPVersion", out sValue);
42             txtInfo.Text = sValue;*/
43         }
44         #endregion

 1         #region 考勤机功能：清空考勤机用户
 2         private void btnDel_Click(object sender, EventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             if (XCMessageBox.Show("确定？", XCMessageBox.Buttons.OKCancel, XCMessageBox.Icon.Question) == DialogResult.OK)
10             {
11                 Cursor = Cursors.WaitCursor;
12                 //先禁用机器
13                 axCZKEM1.EnableDevice(iMachineNumber, false);//disable the device
14                                                              //获取所有用户的记录到缓存区
15                 axCZKEM1.ReadAllUserID(iMachineNumber);//获取所有信息到缓存区（提高效率）
16                 while (axCZKEM1.SSR_GetAllUserInfo(iMachineNumber, out sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled))//get user information from memory
17                 {
18                     axCZKEM1.SSR_DeleteEnrollDataExt(iMachineNumber, sdwEnrollNumber, 12);
19                 }
20 
21                 axCZKEM1.EnableDevice(iMachineNumber, true);//enable the device
22                 Cursor = Cursors.Default;
23             }
24         }
25         #endregion

 1         #region 考勤机功能：清空考勤记录
 2         private void btnDelLogData_Click(object sender, EventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             if (XCMessageBox.Show("确定？", XCMessageBox.Buttons.OKCancel, XCMessageBox.Icon.Question) == DialogResult.OK)
10             {
11                 axCZKEM1.ClearGLog(iMachineNumber);
12             }
13         }
14         #endregion

 1         #region 考勤机功能：同步所有考勤机数据到数据库
 2         private void btnGetAllData_Click(object sender, EventArgs e)
 3         {
 4             if (bIsConnected == false)
 5             {
 6                 MessageBox.Show("Please connect the device first!", "Error");
 7                 return;
 8             }
 9             if (XCMessageBox.Show("确定？", XCMessageBox.Buttons.OKCancel, XCMessageBox.Icon.Question) == DialogResult.OK)
10             {
11                 Cursor = Cursors.WaitCursor;
12                 //先禁用机器
13                 axCZKEM1.EnableDevice(iMachineNumber, false);
14                 //获取所有用户的考勤记录到缓存区
15                 axCZKEM1.ReadAllGLogData(iMachineNumber);
16                 while (axCZKEM1.SSR_GetGeneralLogData(iMachineNumber, out sdwEnrollNumber, out dwVerifyMode, out dwInOutMode, out dwYear, out dwMonth, out dwDay, out dwHour, out dwMinute, out dwSecond, ref dwWorkCode))//get user information from memory
17                 {
18                     switch (dwVerifyMode)
19                     {
20                         case 0:
21                             verifyMode = "密码验证";
22                             break;
23                         case 1:
24                             verifyMode = "指纹验证";
25                             break;
26                         case 2:
27                             verifyMode = "卡验证";
28                             break;
29                         default:
30                             verifyMode = "其他验证";
31                             break;
32                     }
33                     //循环获取用户信息
34                     axCZKEM1.SSR_GetUserInfo(iMachineNumber, sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled);
35                     if (axCZKEM1.GetStrCardNumber(out sCardnumber))//get the card number from the memory
36                     {
37                         switch (iPrivilege)
38                         {
39                             case 0:
40                                 privilege = "普通用户";
41                                 break;
42                             case 3:
43                                 privilege = "管理员";
44                                 break;
45                             default:
46                                 privilege = "其他权限";
47                                 break;
48                         }
49                         switch (bEnabled)
50                         {
51                             case true:
52                                 enabled = "启用";
53                                 break;
54                             case false:
55                                 enabled = "禁用";
56                                 break;
57                         }
58                         USERID = sdwEnrollNumber;
59                         CHARGE_TIME = dwYear.ToString() + "-" + dwMonth.ToString() + "-" + dwDay.ToString() + " " + dwHour.ToString() + ":" + dwMinute.ToString() + ":" + dwSecond.ToString();
60                         VERIFYMODE = verifyMode;
61                         WORKCODE = dwWorkCode.ToString();
62                         //NAME = sName + "\0";
63                         //NAME = NAME.Replace("\0", "");
64                         PASSWORD = sPassword;
65                         PRIVILEGE = privilege;
66                         ENABLE = enabled;
67                         string ID = dwYear.ToString() + dwMonth.ToString() + dwDay.ToString() + dwHour.ToString() + dwMinute.ToString() + dwSecond.ToString();
68                         addRecords(USERID, CHARGE_TIME, VERIFYMODE, WORKCODE, PASSWORD, PRIVILEGE, ENABLE, ID);//插入到数据库表
69                     }
70                 }
71                 axCZKEM1.EnableDevice(iMachineNumber, true);//enable the device
72                 Cursor = Cursors.Default;
73             }
74         }
75         #endregion