コード例 #1
0
        void LocalRunProcess()
        {
            foreach (DataRow dr in dt.Rows)
            {
                ZKAccess FG = new ZKAccess(Convert.ToInt32(dr["SerialPort"]), Convert.ToInt32(dr["Port"]), Convert.ToInt32(dr["MachineNumber"]), Convert.ToInt32(dr["Baudrate"]), dr["IP"].ToString());
                if (FG.Connect_Net())
                {
                    DBLinker.Linker.ExecuteNonQuery("UPDATE d_machines SET  ConnectType = 1 WHERE ID=" + dr["ID"].ToString());
                    FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, false);
                    int    idwErrorCode    = 0;
                    string sdwEnrollNumber = "";
                    int    idwVerifyMode   = 0;
                    int    idwInOutMode    = 0;
                    int    idwYear         = 0;
                    int    idwMonth        = 0;
                    int    idwDay          = 0;
                    int    idwHour         = 0;
                    int    idwMinute       = 0;
                    int    idwSecond       = 0;
                    int    idwWorkcode     = 0;
                    int    y = 0;
                    FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, false);    //disable the device
                    if (FG.m_CZKEMClass.ReadGeneralLogData(FG.COM_MACHINENUMBER)) //read all the attendance records to the memory
                    {
                        while (FG.m_CZKEMClass.SSR_GetGeneralLogData(FG.COM_MACHINENUMBER, out sdwEnrollNumber, out idwVerifyMode,
                                                                     out idwInOutMode, out idwYear, out idwMonth, out idwDay, out idwHour, out idwMinute, out idwSecond, ref idwWorkcode))//get records from the memory
                        {
                            string  t     = idwYear.ToString() + "-" + idwMonth.ToString() + "-" + idwDay.ToString() + " " + idwHour.ToString() + ":" + idwMinute.ToString() + ":" + idwSecond.ToString();
                            DataRow sqlDt = DBLinker.Linker.GetDataRow("SELECT * FROM  d_atttransaction where  EnrollNumber='" + sdwEnrollNumber + "' and date='" + t + "'");
                            if (sqlDt == null)
                            {
                                string sql = "INSERT INTO d_atttransaction (EnrollNumber ,VerifyMethod ,InOutMode ,date ,WorkCode,MachineID) VALUES ('" + sdwEnrollNumber + "'," + idwVerifyMode + "," + idwInOutMode + ",'" + t + "'," + idwWorkcode + "," + FG.COM_MACHINENUMBER.ToString() + ")";
                                DBLinker.Linker.ExecuteNonQuery(sql);
                                y++;
                            }
                        }

                        DBLinker.Linker.ExecuteNonQuery("INSERT INTO d_machinesstate (sn,zt ,sj) VALUES  ('" + FG.COM_MACHINENUMBER.ToString() + "','下载完成',getdate())");
                        FG.m_CZKEMClass.ClearGLog(FG.COM_MACHINENUMBER);
                        FG.m_CZKEMClass.RefreshData(FG.COM_MACHINENUMBER);
                    }
                    else
                    {
                        FG.m_CZKEMClass.GetLastError(ref idwErrorCode);
                        DBLinker.Linker.ExecuteNonQuery("INSERT INTO d_machinesstate (sn,zt ,sj) VALUES  ('" + FG.COM_MACHINENUMBER.ToString() + "','下载失败',getdate())");
                    }


                    FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, true);
                }
                else
                {
                    FG.m_CZKEMClass.Disconnect();
                    DBLinker.Linker.ExecuteNonQuery("INSERT INTO d_machinesstate (sn,zt ,sj) VALUES  ('" + FG.COM_MACHINENUMBER.ToString() + "','连接失败',getdate())");
                    DBLinker.Linker.ExecuteNonQuery("UPDATE d_machines SET  ConnectType = 0 WHERE ID=" + dr["ID"].ToString());
                }
            }
        }
コード例 #2
0
ファイル: frmUserOutLine.cs プロジェクト: xzc5858/WinAtt
        private void CmnLookData(DataRow dr, out DataTable dt, out string st)
        {
            //dt = (DataTable)RTable.Clone();
            dt = (DataTable)userdata.Clone();
            ZKAccess FG = new ZKAccess(ConvertUtil.GetDBInt(dr["SerialPort"]), ConvertUtil.GetDBInt(dr["Port"]), ConvertUtil.GetDBInt(dr["MachineNumber"]), ConvertUtil.GetDBInt(dr["Baudrate"]), dr["IP"].ToString());


            if (FG.Connect_Net())
            {
                st = "连接成功!";
                string sdwEnrollNumber = "";
                string sName           = "";
                string sPassword       = "";
                int    iPrivilege      = 0;
                bool   bEnabled        = false;

                //int idwFingerIndex;
                //string sTmpData = "";

                //int iTmpLength = 0;
                //int iFlag = 0;

                //string sFaceData = "";
                //int iFaceLength = 0;
                //int iFaceIndex = 50;
                FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, false);
                //Cursor = Cursors.WaitCursor;

                FG.m_CZKEMClass.ReadAllUserID(FG.COM_MACHINENUMBER);                                                                                          //read all the user information to the memory
                FG.m_CZKEMClass.ReadAllTemplate(FG.COM_MACHINENUMBER);                                                                                        //read all the users' fingerprint templates to the memory
                while (FG.m_CZKEMClass.SSR_GetAllUserInfo(FG.COM_MACHINENUMBER, out sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled)) //get all the users' information from the memory
                {
                    DataRow newdr = dt.NewRow();
                    newdr["EnrollNumber"] = sdwEnrollNumber.ToString();
                    newdr["UserName"]     = sName.ToString();
                    newdr["Privilege"]    = iPrivilege;
                    newdr["MPassword"]    = sPassword;
                    newdr["IsEnabled"]    = bEnabled;
                    dt.Rows.Add(newdr);
                }

                FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, true);
            }
            else
            {
                st = dr["MachineNumber"].ToString() + "指纹机连接失败";
            }
        }
コード例 #3
0
ファイル: frmOutline.cs プロジェクト: xzc5858/WinAtt
        /// <summary>
        /// 指定下载
        /// </summary>
        /// <param name="dr"></param>
        /// <param name="dt"></param>
        public void ZDCmnDownLoadData(DataRow dv, out DataTable dt, out string callback)
        {
            dt       = (DataTable)attdt.Clone();
            callback = "";
            ZKAccess FG = new ZKAccess(Convert.ToInt32(dv["SerialPort"]), Convert.ToInt32(dv["Port"]), Convert.ToInt32(dv["MachineNumber"]), Convert.ToInt32(dv["Baudrate"]), dv["IP"].ToString());

            if (FG.Connect_Net())
            {
                int    idwErrorCode    = 0;
                string sdwEnrollNumber = "";
                int    idwVerifyMode   = 0;
                int    idwInOutMode    = 0;
                int    idwYear         = 0;
                int    idwMonth        = 0;
                int    idwDay          = 0;
                int    idwHour         = 0;
                int    idwMinute       = 0;
                int    idwSecond       = 0;
                int    idwWorkcode     = 0;

                FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, false);    //disable the device
                if (FG.m_CZKEMClass.ReadGeneralLogData(FG.COM_MACHINENUMBER)) //read all the attendance records to the memory
                {
                    while (FG.m_CZKEMClass.SSR_GetGeneralLogData(FG.COM_MACHINENUMBER, out sdwEnrollNumber, out idwVerifyMode,
                                                                 out idwInOutMode, out idwYear, out idwMonth, out idwDay, out idwHour, out idwMinute, out idwSecond, ref idwWorkcode))//get records from the memory
                    {
                        string  t   = idwYear.ToString() + "-" + idwMonth.ToString() + "-" + idwDay.ToString() + " " + idwHour.ToString() + ":" + idwMinute.ToString() + ":" + idwSecond.ToString();
                        string  sql = "SELECT * FROM d_atttransaction where [EnrollNumber]='" + sdwEnrollNumber + "' and [date]='" + t + "'";
                        DataRow ds  = DBLinker.Linker.GetDataRow(sql);
                        //DataRow sqlDr =SQLHelper.GetDataSet(SQLHelper.Conn, CommandType.Text,sql,null).Tables[0].DefaultView[0].Row;
                        if (ds == null)
                        {
                            //DataRow ndr = dt.NewRow();

                            //ndr["EnrollNumber"] = sdwEnrollNumber;
                            //ndr["VerifyMethod"] = idwVerifyMode;
                            //ndr["InOutMode"] = idwInOutMode;
                            //ndr["date"] = t;
                            //ndr["WorkCode"] = idwWorkcode;
                            //dt.Rows.Add(ndr);
                            sql = "INSERT INTO d_atttransaction (EnrollNumber,VerifyMethod ,InOutMode ,date ,WorkCode,MachineID) VALUES ('" + sdwEnrollNumber + "'," + idwVerifyMode + "," + idwInOutMode + ",'" + t + "'," + idwWorkcode + "," + FG.COM_MACHINENUMBER.ToString() + ")";
                            DBLinker.Linker.ExecuteNonQuery(sql);
                        }
                    }
                    //DBLinker.Linker.ExecuteNonQuery("INSERT INTO d_machinesstate (sn,zt ,sj) VALUES  ('" + FG.COM_MACHINENUMBER.ToString() + "','下载完成',getdate())");
                    string sql2 = "INSERT INTO [d_MachinesState] ([sn],[zt] ,[sj]) VALUES  ('" + FG.COM_MACHINENUMBER.ToString() + "','下载完成',getdate())";
                    DBLinker.Linker.ExecuteNonQuery(sql2);
                }
                else
                {
                    //Cursor = Cursors.Default;
                    FG.m_CZKEMClass.GetLastError(ref idwErrorCode);

                    if (idwErrorCode != 0)
                    {
                        MessageBox.Show("读取终端数据错误,代码:" + idwErrorCode.ToString());
                        callback = ("读取终端数据错误,代码:" + idwErrorCode.ToString());
                        //listBox1.Items.Add("读取终端数据错误,代码:" + idwErrorCode.ToString());
                    }
                    else
                    {
                        MessageBox.Show("终端没有任何数据");
                        callback = "终端没有任何数据";
                        //listBox1.Items.Add("终端没有任何数据");
                    }
                    DBLinker.Linker.ExecuteNonQuery("INSERT INTO [d_MachinesState] ([sn],[zt] ,[sj]) VALUES  ('" + FG.COM_MACHINENUMBER.ToString() + "','下载失败',getdate())");
                }

                FG.m_CZKEMClass.ClearGLog(FG.COM_MACHINENUMBER);
                FG.m_CZKEMClass.RefreshData(FG.COM_MACHINENUMBER);
                FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, true);
            }
            else
            {
                MessageBox.Show("连接机器失败");
                callback = ("连接机器失败");
                FG.m_CZKEMClass.Disconnect();
                DBLinker.Linker.ExecuteNonQuery("INSERT INTO [d_MachinesState] ([sn],[zt] ,[sj]) VALUES  ('" + FG.COM_MACHINENUMBER.ToString() + "','连接失败',getdate())");
                //SQLHelper.ExecuteNonQuery("UPDATE [d_Machines] SET  [ConnectType] = 0 WHERE ID=" + dr["ID"].ToString());
            }
        }
コード例 #4
0
ファイル: frmUserOutLine.cs プロジェクト: xzc5858/WinAtt
        /// <summary>
        /// 下载更新数据库的用户数据
        /// </summary>
        /// <param name="dr"></param>
        /// <param name="b"></param>
        protected void CmnDownLoadData(DataRow dr, out string b)
        {
            int    count    = 0;
            int    sumcount = 0;
            string rtstr    = "";

            b = "";
            ZKAccess FG = new ZKAccess(ConvertUtil.GetDBInt(dr["SerialPort"]), ConvertUtil.GetDBInt(dr["Port"]), ConvertUtil.GetDBInt(dr["MachineNumber"]), ConvertUtil.GetDBInt(dr["Baudrate"]), dr["IP"].ToString());

            if (FG.Connect_Net())
            {
                b = dr["MachineNumber"].ToString() + "指纹机连接成功";
                string sdwEnrollNumber = "";
                string sName           = "";
                string sPassword       = "";
                int    iPrivilege      = 0;
                bool   bEnabled        = false;

                int    idwFingerIndex;
                string sTmpData = "";

                int iTmpLength = 0;
                int iFlag      = 0;


                int    iFaceLength = 128 * 1024;
                int    iFaceIndex  = 50;
                byte[] sFaceData   = new byte[iFaceLength];
                FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, false);
                //Cursor = Cursors.WaitCursor;

                FG.m_CZKEMClass.ReadAllUserID(FG.COM_MACHINENUMBER);                                                                                          //read all the user information to the memory
                FG.m_CZKEMClass.ReadAllTemplate(FG.COM_MACHINENUMBER);                                                                                        //read all the users' fingerprint templates to the memory
                while (FG.m_CZKEMClass.SSR_GetAllUserInfo(FG.COM_MACHINENUMBER, out sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled)) //get all the users' information from the memory
                {
                    sumcount = sumcount + 1;
                    //if (FG.m_CZKEMClass.GetUserFaceStr(FG.COM_MACHINENUMBER, sdwEnrollNumber, iFaceIndex, ref sFaceData, ref iFaceLength))//get the face templates from the memory
                    //{

                    //}
                    if (FG.m_CZKEMClass.GetUserFace(FG.COM_MACHINENUMBER, sdwEnrollNumber, iFaceIndex, ref sFaceData[0], ref iFaceLength))
                    {
                    }
                    for (idwFingerIndex = 0; idwFingerIndex < 10; idwFingerIndex++)
                    {
                        if (FG.m_CZKEMClass.GetUserTmpExStr(FG.COM_MACHINENUMBER, sdwEnrollNumber, idwFingerIndex, out iFlag, out sTmpData, out iTmpLength))//get the corresponding templates string and length from the memory
                        {
                            if (DBLinker.Linker.GetDataRow("select 1 from d_user where EnrollNumber='" + sdwEnrollNumber.ToString() + "'") == null)
                            {
                                string sql = "insert into [d_user] ([LoginName],[UserName],[UserPassword] ,[AllowLogin],[MachineNumber] ,[EnrollNumber] ,[FingerIndex] ,[FaceIndex],[Finger] ,[photo],[Flag] ,[MPassword] ,[Privilege] ,[IsEnabled],FingerLength,FaceLength) VALUES ('" + sdwEnrollNumber + "','" + sName + "','r3B6n6Eq5z8=' ,1," + FG.COM_MACHINENUMBER.ToString() + " ,'" + sdwEnrollNumber + "' ," + idwFingerIndex + " ," + iFaceIndex + ",'" + sTmpData + "','" + sFaceData + "'," + iFlag.ToString() + " ,'" + sPassword + "' ," + iPrivilege.ToString() + " ,'" + bEnabled + "'," + iTmpLength + "," + iFaceLength + ")";
                                if (DBLinker.Linker.ExecuteNonQuery(sql) != -1)
                                {
                                    count = count + 1;
                                }
                                else
                                {
                                    rtstr = rtstr + sql + "\r\n";
                                }
                            }
                            else
                            {
                                string sql = "UPDATE [d_user] SET [MachineNumber] =" + FG.COM_MACHINENUMBER.ToString() + ",[FingerIndex] = " + idwFingerIndex + ",[FaceIndex] = " + iFaceIndex + " ,[Finger] =  '" + sTmpData + "',[photo] = '" + sFaceData + "' ,[Flag] =  " + iFlag.ToString() + " ,[MPassword] ='" + sPassword + "' ,[Privilege] =" + iPrivilege.ToString() + " ,[IsEnabled] =  '" + bEnabled + "',[FingerLength] = " + iTmpLength + " ,[FaceLength] = " + iFaceLength + " where  [EnrollNumber]='" + sdwEnrollNumber + "'";
                                if (DBLinker.Linker.ExecuteNonQuery(sql) != -1)
                                {
                                    count = count + 1;
                                }
                                else
                                {
                                    rtstr = rtstr + sql + "\r\n";
                                }
                            }
                        }
                    }
                }

                FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, true);

                b = ("下载或更新用户信息" + count.ToString() + "条,合计" + sumcount.ToString() + "条,错误提示:\r\n " + rtstr);
            }
            else
            {
                b = dr["MachineNumber"].ToString() + "指纹机连接失败";
            }
        }
コード例 #5
0
ファイル: frmUserOutLine.cs プロジェクト: xzc5858/WinAtt
        /// 上传用户数据到机器
        private void CmnUpLoadData(DataRow dr, out string b)
        {
            b = "";
            ZKAccess FG = new ZKAccess(ConvertUtil.GetDBInt(dr["SerialPort"]), ConvertUtil.GetDBInt(dr["Port"]), ConvertUtil.GetDBInt(dr["MachineNumber"]), ConvertUtil.GetDBInt(dr["Baudrate"]), dr["IP"].ToString());

            if (FG.Connect_Net())
            {
                int    idwErrorCode    = 0;
                string sdwEnrollNumber = "";
                string sName           = "";
                int    idwFingerIndex  = 0;
                string sTmpData        = "";
                ///权限级别0:一般用户1:登记员2:管理员3:超级管理员
                int    iPrivilege  = 0;
                string sPassword   = "";
                string sEnabled    = "";
                bool   bEnabled    = true;
                int    iFlag       = 1;
                int    iFaceLength = 128 * 1024;
                int    iFaceIndex  = 50;
                byte[] sFaceData   = new byte[iFaceLength];

                int iUpdateFlag = 1;

                FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, false);
                //    if (FG.m_CZKEMClass.BeginBatchUpdate(FG.COM_MACHINENUMBER, iUpdateFlag))//create memory space for batching data
                //    {
                //        string sLastEnrollNumber = "";//the former enrollnumber you have upload(define original value as 0)
                //        for (int i = 0; i < gridView.RowCount; i++)
                //        {
                //            DataRow newdr = gridView.GetDataRow(i);
                //            if (newdr["uploaded"].ToString() == "1")
                //            {
                //                sdwEnrollNumber = newdr["EnrollNumber"].ToString();
                //                sName = newdr["UserName"].ToString();
                //                idwFingerIndex = ConvertUtil.GetDBInt(newdr["FingerIndex"]);
                //                sTmpData = newdr["Finger"].ToString();
                //                iPrivilege = ConvertUtil.GetDBInt(newdr["Privilege"]);
                //                sPassword = newdr["MPassword"].ToString();
                //                sEnabled = newdr["IsEnabled"].ToString();
                //                iFlag = ConvertUtil.GetDBInt(newdr["Flag"]);
                //                iFaceLength = ConvertUtil.GetDBInt(newdr["FingerLength"]);

                //                sFaceData = (byte[])newdr["photo"];
                //                if (sEnabled == "true")
                //                {
                //                    bEnabled = true;
                //                }
                //                else
                //                {
                //                    bEnabled = false;
                //                }
                //                if (sdwEnrollNumber != sLastEnrollNumber)//identify whether the user information(except fingerprint templates) has been uploaded
                //                {
                //                    if (FG.m_CZKEMClass.SSR_SetUserInfo(FG.COM_MACHINENUMBER, sdwEnrollNumber, sName, sPassword, iPrivilege, bEnabled))//upload user information to the memory
                //                    {
                //                        FG.m_CZKEMClass.SetUserTmpExStr(FG.COM_MACHINENUMBER, sdwEnrollNumber, idwFingerIndex, iFlag, sTmpData);//upload templates information to the memory
                //                    }
                //                    else
                //                    {
                //                        FG.m_CZKEMClass.GetLastError(ref idwErrorCode);

                //                        FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, true);
                //                        return;
                //                    }

                //                }
                //                else//the current fingerprint and the former one belongs the same user,that is ,one user has more than one template
                //                {
                //                    FG.m_CZKEMClass.SetUserTmpExStr(FG.COM_MACHINENUMBER, sdwEnrollNumber, idwFingerIndex, iFlag, sTmpData);
                //                }
                //                //更新照片模版。先不要用,免得出错,丢失数据。试验能够成功再使用。
                //                //FG.m_CZKEMClass.SetUserFace(FG.COM_MACHINENUMBER, sdwEnrollNumber, 50,ref  sFaceData[0], iFaceLength);
                //                sLastEnrollNumber = sdwEnrollNumber;//change the value of iLastEnrollNumber dynamicly
                //            }
                //        }
                //    }
                //    FG.m_CZKEMClass.BatchUpdate(FG.COM_MACHINENUMBER);//upload all the information in the memory
                //    FG.m_CZKEMClass.RefreshData(FG.COM_MACHINENUMBER);//the data in the device should be refreshed
                //    FG.m_CZKEMClass.EnableDevice(FG.COM_MACHINENUMBER, true);
                //    b = "上传完成";
            }
            else
            {
                listBox1.Items.Add(dr["MachineNumber"].ToString() + "指纹机无法连机");
            }
        }