public void SaveCardLog(string LogStr) { jsonBody <CardVerify> verifyPush = JsonConvert.DeserializeObject <jsonBody <CardVerify> >(LogStr); byte[] PhotoImage = null; int InOutMode = 0; string GUID = ""; MacSN = verifyPush.info.DeviceID.ToString(); attLog.Remark = verifyPush.info.CardNo; UInt32 FingerNo = 0; attLog = new TSeaLog(); attLog.CardID = FingerNo.ToString("0000000000"); attLog.CardTime = DateTime.Parse(verifyPush.info.CreateTime); attLog.FingerNo = FingerNo; if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } DataTableReader dr = db.GetDataReader("SELECT * FROM VSEA_MacInfoFace WHERE MacSN='" + MacSN + "'"); if (dr.Read()) { int.TryParse(dr["MacInOut"].ToString(), out InOutMode); } dr.Close(); attLog.InOutMode = InOutMode; readData.Sea_SetLogName(attLog, InOutMode, 1, 21); readData.WriteTextFile(attLog, Int32.Parse(MacSN), true); if (textFormat.Allow) { readData.WriteTextFormat(db, textFormat, attLog, Int32.Parse(MacSN), true); } readData.SeaSaveDB(db, attLog, Int32.Parse(MacSN), FingerNo, PhotoImage); if (attLog.VerifyMode == 0) { attLog.VerifyMode = attLog.DoorMode; attLog.VerifyModeName = attLog.DoorModeName; } readData.SeaSaveDBMJ(db, attLog, MacSN.ToString(), PhotoImage, ref GUID); if (prog != null) { prog(attLog, Int32.Parse(MacSN), GUID); } }
public void SaveFaceLog(string LogStr) { byte[] PhotoImage = null; DataTableReader dr = null; int InOutMode = 0; int VerifyStatus = 0; int VerifyType = 0; string GUID = ""; VerifyPush <VerifyPushInfo> verifyPush = null; VerifyPush <RemoteOpenDoorPushInfo> remoteOpenDoorPush = null; if (LogStr.Contains("RemoteOpenDoorPush")) { remoteOpenDoorPush = JsonConvert.DeserializeObject <VerifyPush <RemoteOpenDoorPushInfo> >(LogStr); MacSN = remoteOpenDoorPush.info.DeviceID.ToString(); attLog.Remark = ""; UInt32 FingerNo = 0; attLog = new TSeaLog(); attLog.CardID = FingerNo.ToString("0000000000"); attLog.CardTime = DateTime.Parse(remoteOpenDoorPush.info.CreateTime); attLog.FingerNo = FingerNo; VerifyStatus = 27; VerifyType = remoteOpenDoorPush.info.VerfyType; } else { verifyPush = JsonConvert.DeserializeObject <VerifyPush <VerifyPushInfo> >(LogStr); MacSN = verifyPush.info.DeviceID.ToString(); attLog.Remark = verifyPush.info.Notes; UInt32 FingerNo = 0; UInt32.TryParse(verifyPush.info.ToString(), out FingerNo); attLog = new TSeaLog(); attLog.CardID = FingerNo.ToString("0000000000"); attLog.CardTime = DateTime.Parse(verifyPush.info.CreateTime); attLog.FingerNo = FingerNo; attLog.Temperature = verifyPush.info.Temperature; attLog.TemperatureAlarm = verifyPush.info.TemperatureAlarm; VerifyType = verifyPush.info.VerfyType; VerifyStatus = verifyPush.info.VerifyStatus; if (verifyPush.SanpPic != null) { PhotoImage = Convert.FromBase64String(verifyPush.SanpPic.Replace("data:image/jpeg;base64,", "")); } else { PhotoImage = new byte[0]; } } if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader("SELECT * FROM VSEA_MacInfoFace WHERE MacSN='" + MacSN + "'"); if (dr.Read()) { int.TryParse(dr["MacInOut"].ToString(), out InOutMode); } dr.Close(); readData.Sea_SetLogName(attLog, InOutMode, VerifyStatus, VerifyType); readData.WriteTextFile(attLog, Int32.Parse(MacSN), true); if (textFormat.Allow) { readData.WriteTextFormat(db, textFormat, attLog, Int32.Parse(MacSN), true); } readData.SeaSaveDB(db, attLog, Int32.Parse(MacSN), attLog.FingerNo, PhotoImage); if (attLog.VerifyMode == 0) { attLog.VerifyMode = attLog.DoorMode; attLog.VerifyModeName = attLog.DoorModeName; } readData.SeaSaveDBMJ(db, attLog, MacSN.ToString(), PhotoImage, ref GUID); if (prog != null) { prog(attLog, Int32.Parse(MacSN), GUID); } }
public void ShowRealDataProcess(TSeaLog attLog, int MacSN, string GUID) { string EmpSysID = ""; string EmpNo = ""; string EmpName = ""; string DepartID = ""; string DepartName = ""; DataTableReader dr = null; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "240", attLog.CardID })); if (dr.Read()) { EmpSysID = dr["EmpSysID"].ToString(); EmpNo = dr["EmpNo"].ToString(); EmpName = dr["EmpName"].ToString(); DepartID = dr["DepartID"].ToString(); DepartName = dr["DepartName"].ToString(); } } catch { } finally { if (dr != null) { dr.Close(); } dr = null; } if (realGrid.RowCount > 0) { if (realGrid[1, realGrid.RowCount - 1].Value.ToString() == attLog.CardTime.ToString() && realGrid[2, realGrid.RowCount - 1].Value.ToString() == MacSN.ToString()) { return; } } realGrid.Rows.Add(); realGrid[0, realGrid.RowCount - 1].Value = Convert.ToInt32(attLog.CardID); realGrid[1, realGrid.RowCount - 1].Value = attLog.CardTime; realGrid[2, realGrid.RowCount - 1].Value = MacSN; realGrid[3, realGrid.RowCount - 1].Value = EmpNo; realGrid[4, realGrid.RowCount - 1].Value = EmpName; realGrid[5, realGrid.RowCount - 1].Value = DepartID; realGrid[6, realGrid.RowCount - 1].Value = DepartName; realGrid[7, realGrid.RowCount - 1].Value = EmpSysID; realGrid[8, realGrid.RowCount - 1].Value = GUID; realGrid.Rows[realGrid.RowCount - 1].Selected = true; realGrid.CurrentCell = realGrid.Rows[realGrid.RowCount - 1].Cells[0]; if (realGrid.RowCount == 1) { realGrid_SelectionChanged(null, null); } //if (!SystemInfo.UseRealSendKQ || !objRealSend.IsInit) return; //string PhotoData = RealSendPhoto ? ShowEmpPhoto(false) : ""; //objRealSend.SendDataKQ(MacSN.ToString(), EmpNo, EmpName, DepartID, DepartName, attLog.CardID, attLog.Time, PhotoData); }