中控考勤机本地mysql_中控考勤机接⼝开发
本⽂参考⼿册：《TFT 系列脱机通讯开发包开发⼿册》
业务需求：
新视野大学英语网站1、定时同步考勤机的刷卡记录到数据库
波兰人英文2、推送⼈员信息到考勤机
主要内容：
1、定时同步考勤记录到数据库
2、⽤户信息、指纹操作
3、考勤记录批量操作
正⽂
1、定时任务
1-1、定义全局变量
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 = newCZKEMClass();14 private bool bIsConnected = fal;15 private int iMachineNumber = 1;16
17 string sdwEnrollNumber = "";//⽤户ID
xongchu18 string sName = "";//姓名
19 string sPassword = "";//密码
20 int iPrivilege = 0;21 bool bEnabled = fal;22 string sCardnumber = "";//卡号
23 int dwWorkCode = 0;24 intdwVerifyMode;25 intdwInOutMode;26 int dwYear;//刷卡时间
contrail27 intdwMonth;28 intdwDay;29 intdwHour;30 intdwMinute;31 intdwSecond;32 string verifyMode = "";33 string privilege = "";34 string enabled = "";35 #endregion
View Code
1-2、连接考勤机
1 #region 考勤机功能：打开连接
2 private voidconnectZK()
3 {
4 //若IP、端⼝号为空则不能连接
5 if (txtIP.Text.Trim() == "" || txtPort.Text.Trim() == "")
6 {
7 WriteLog.Write("WARN", txtIP.Text, "打开连接时IP或端⼝不能为空");
8 return;
9 }10 //若状态为已连接则先关闭连接
11 if (bIsConnected == true)12 {13 disconnectZK();14 }15 //连接机器
16 int idwErrorCode = 0;17 Cursor =Cursors.WaitCursor;18 bIsConnected =axCZKEM1.Connect_Net(txtIP.Text,
Convert.ToInt32(txtPort.Text));19 if (bIsConnected == true)20 {21 lblState.Text = "Current State:Connected";22 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 u 1.
23 axCZKEM1.RegEvent(iMachineNumber, 65535);//Here you can register the realtime events that you want to be triggered(the parameters 65535 means registering all)
24 WriteLog.Write("INFO", txtIP.Text, "连接成功。");25 }26 el
27 {28 axCZKEM1.GetLastError(refidwErrorCode);29 WriteLog.Write("WARN", txtIP.Text, "连接失败。ErrorCode="
+idwErrorCode.ToString());30 }31 Cursor =Cursors.Default;32 }33 #endregion
34
35 #region 考勤机功能：关闭连接
36 private voiddisconnectZK()37 {38 if (txtIP.Text.Trim() == "" || txtPort.Text.Trim() == "")39 {40 WriteLog.Write("WARN", txtIP.Text, "关闭连接时IP或端⼝不能为空");41 return;42 }43
44 Cursor =Cursors.WaitCursor;45 if(bIsConnected)46 {47 axCZKEM1.Disconnect();48 bIsConnected = fal;49 lblState.Text = "Current State:DisConnected";50 WriteLog.Write("INFO", txtIP.Text, "连接关闭。");51 Cursor
=Cursors.Default;52 return;53 }54 el
55 {56 Cursor =Cursors.Default;57 }58 }59 #endregion
View Code
1-3、配置定时任务
这⾥使⽤⼯具箱提供的定时器System.Windows.Forms.Timer。
需要同步记录或推送⼈员时再打开连接，否则可能会出现因连接时间过长导致连接失去响应。
1 #region 定时任务配置
2 private void timerSync_Tick(objectnder, EventArgs e)
3 {
4 int nowhour = int.Par(DateTime.Now.Hour.ToString());
5 int nowminute = int.Par(DateTime.Now.Minute.ToString());
6 //8:00~23:00
天津翻译招聘7 if (nowhour >= 8 && nowhour <= 22)8 {9 //打开连接
10 connectZK();11 if (bIsConnected == true)12 {13 //同步刷卡
14 getLogData();15 //关闭连接
16 disconnectZK();17 }18 }19 //23:00
20 if (nowhour == 23 && nowminute == 00)21 {22 //打开连接
23 connectZK();24 if (bIsConnected == true)25 {26 //清空考勤机刷卡记录
27 clearRecord();28 //推送⼈员
29 pushEmp();30 //关闭连接
31 disconnectZK();32 }33 }34 }35 #endregion
View Code
1-4、同步刷卡记录
1 #region 任务-同步刷卡数据到MES数据库
2 private voidgetLogData()
3 {
4 if (bIsConnected == fal)
5 {
6 WriteLog.Write("WARN", "", "当前未连接考勤机");
7 return;
8 }
9 Cursor =Cursors.WaitCursor;10 //先禁⽤机器
11 axCZKEM1.EnableDevice(iMachineNumber, fal);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 ur information from memory
15 {16 switch(dwVerifyMode)17 {18 ca 0:19 verifyMode = "密码验证";20 break;21 ca 1:22 verifyMode = "指纹验证";23 break;24 ca 2:25 verifyMode = "卡验证";26 break;27 default:28 verifyMode = "其他验证";29 break;30 }31 //循环获取⽤户信息
32 axCZKEM1.SSR_GetUrInfo(iMachineNumber, sdwEnrollNumber, out sName, out sPassword, out iPrivilege, outbEnabled);33 if (axCZKEM1.GetStrCardNumber(out sCardnumber))//get the card number from the memory
34 {35 switch(iPrivilege)36 {37 ca 0:38 privilege = "普通⽤户";39 break;40 ca 3:41 privilege = "管理员";42 break;43 default:44 privilege = "其他权限";45 break;46 }47 switch(bEnabled)48 {49 ca true:50 enabled = "启⽤";51 break;52 ca fal:53 enabled = "禁⽤";54 break;55 }56 USERID =sdwEnrollNumber;57 CHARGE_TIME = dwYear.ToString() + "-" + dwMonth.ToString() + "-" + dwDay.ToString() + " " + dwHour.ToString() + ":" + dwMinute.ToString() + ":"
+dwSecond.ToString();58 CHARGE_DATE = dwYear.ToString("0000") + "-" +dwMonth.ToString("00") + "-" +
dwDay.ToString("00");59 VERIFYMODE =verifyMode;60 WORKCODE =dwWorkCode.ToString();61 //NAME = sName+
"\0";62 //NAME = NAME.Replace("\0", "");
63 PASSWORD =sPassword;64 PRIVILEGE =privilege;65 ENABLE =enabled;66 string ID = dwYear.ToString() +
dwMonth.ToString() + dwDay.ToString() + dwHour.ToString() + dwMinute.ToString() +dwSecond.ToString();67 DateTime now =DateTime.Now;68 string thisyear =now.Year.ToString();69 string thismonth =now.Month.ToString();70 string thisday =now.Day.ToString();71 //仅同步当天的刷卡记录
72 if (dwYear.ToString() == thisyear && dwMonth.ToString() == thismonth && dwDay.ToString() ==thisday)73 {74 //这个调⽤插⼊数据库的⽅法
75 WriteLog.Write("INFO", "", "同步刷卡记录到数据库");76 }77 }78 }79 axCZKEM1.EnableDevice(iM
achineNumber,
true);//enable the device
80 Cursor =Cursors.Default;81 }82 #endregion
View Code
1-5、推送数据库中⼈员到考勤机
1 private voidpushEmp()
2 {
3 if (bIsConnected == fal)
4 {
former
5 WriteLog.Write("WARN", "", "当前未连接考勤机");
6 return;
7 }
8 //获取orcale表推送状态为0的⼈员，推送到考勤机
9 DataTable pushdt =BllEmpSync.pushEmp();10 string[] push_num = new string[pushdt.Rows.Count];11 string[]
push_name = new string[pushdt.Rows.Count];12 string[] push_cardnum = new string[pushdt.Rows.Count];13
WriteLog.Write("INFO", txtIP.Text, "开始推送⼈员信息...待推送⼈员数：" +pushdt.Rows.Count.ToString());14 for (int i = 0; i < pushdt.Rows.Count; i++)15 {16 DataRow dr =pushdt.Rows[i];17 push_num[i] = Convert.ToString(dr["T_USERID"]);18
push_name[i] = Convert.ToString(dr["T_USERNAME"]);19 push_cardnum[i] = Convert.ToString(dr["CARDID"]);20
axCZKEM1.SetStrCardNumber(push_cardnum[i]);21 //2、设置⽤户信息
22 bool a = axCZKEM1.SSR_SetUrInfo(iMachineNumber, push_num[i], push_name[i], push_num[i], 0, true);23 if (a) WriteLog.Write("INFO", txtIP.Text, "推送⼈员" + push_num[i] + "成功。");24 el WriteLog.Write("WARN", txtIP.Text, "推送⼈员" + push_num[i] + "失败。");25 }26 BllEmpSync.updateEmp();27 }
View Code
1-6、每天定时清空考勤机刷卡记录
(防⽌同步时因数据太多⽽变卡，调⽤⽅法见2-7)
2、考勤机管理(注：以下⽅法省略了考勤机的打开与关闭连接)
2-1、查询考勤机内已注册⽤户
(注意：如果考勤机内没有注册指纹信息，代码⾥⾯有查询指纹，那么加载会变得⾮常慢。要提前注释掉查询指纹的代码！)
1 #region 考勤机功能：获取⽤户
2 private void btnGetStrCardNumber_Click(objectnder, EventArgs e)
3 {
4 if (bIsConnected == fal)
5 {6
MessageBox.Show("Plea connect the device first!", "Error");7 return;8 }9 lvCard.Items.Clear();10 lvCard.BeginUpdate();11 Cursor =Cursors.WaitCursor;12 //先禁⽤机器
13 axCZKEM1.EnableDevice(iMachineNumber, fal);//disable the device14 //获取所有⽤户的记录到缓存区
15 axCZKEM1.ReadAllUrID(iMachineNumber);//获取所有信息到缓存区(提⾼效率)
16 axCZKEM1.ReadAllTemplate(iMachineNumber);//获取所有指纹信息到缓存区(提⾼效率)
5杀英文
17 while (axCZKEM1.SSR_GetAllUrInfo(iMachineNumber, out sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled))//get ur information from memory
18 {19 //循环获取⽤户信息
20 if (axCZKEM1.GetStrCardNumber(out sCardnumber))//get the card number from the memory
21 {22 ListViewItem list = newListViewItem();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 el
33 {34 list.SubItems.Add("fal");35 }36
37 for (int dwFingerIndex = 0; dwFingerIndex < 10; dwFingerIndex++)38 {39 if
(axCZKEM1.SSR_GetUrTmpStr(iMachineNumber, sdwEnrollNumber, dwFingerIndex, out dwTmpData, outdwTmpLength))40 {41 list.SubItems.Add(dwTmpData);42 }43 el
父亲节快乐用英语怎么说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
View Code
2-2、注册单个⽤户到考勤机
1 #region 考勤机功能：注册⽤户
2 private void btnSetStrCardNumber_Click(objectnder, EventArgs e)
3 {
4 if (bIsConnected == fal)
5 {6
MessageBox.Show("Plea 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_SetUrInfo(iMachineNumber, "⽤户ID", "⽤户姓名", "密码", 0, true);15 }16 #endregion
View Code
2-3、批量注册⽤户
1 #region 考勤机功能：批量注册⽤户
2 private void btnSetStrCardNumbers_Click(objectnder, 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[] uruid = new string[dt.Rows.Count];8 string[] uruname = 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 uruid[i] =
Convert.ToString(dr["T_USERID"]);14 uruname[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_SetUrInfo(iMachineNumber, uruid[i], uruname[i], uruid[i], 0, true);21 }22 }23 }24 #endregion
ogenicView Code
2-4、删除⽤户
1 #region 考勤机功能：删除⽤户
2 private void btnDelStrCardNumber_Click(objectnder, EventArgs e)
3 {
4 if (bIsConnected == fal)
5 {6
MessageBox.Show("Plea 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
View Code
2-5、增删指纹
(这⾥有⼀点要注意：考勤机算法不同的话，增加指纹所调⽤的⽅法不同，使⽤前先查看考勤机算法)
