public SessionsInfo Merge(SessionsInfo other) { if (other == null) { return(this); } return(new SessionsInfo(Count + other.Count, Sessions.Concat(other.Sessions).ToList())); }
protected override void InSession() { try { if (_qrInfo != null) { //写入本地记录并且通知 var info = new SessionsInfo { SessionId = MyMatch.SessionId, CreateDate = DateTime.Now, Name = MyMatch.SessionName, IdNo = BarIdNo, IdCardPhoto = null, TakePhoto = PhotoOk, FaceData = FaceFun.StructToBytes(CameraRft), IdAddress = null, TicketType = 0, TicketNo = _qrInfo.Value.TicketNo, Area = _qrInfo.Value.Area, Row = _qrInfo.Value.Row, Seat = _qrInfo.Value.Seat, TelNo = IrAdvanced.ReadString("TelNo"), TelArea = IrAdvanced.ReadString("TelArea"), BuyName = "", BuyPhoto = null, BuyDate = null, ValidateType = 5, SyncTime = null, Status = 0, Remark = "", UserName = AftUserName, }; if (FaceFun.AddSessions(info) > 0) { Dispatcher.Invoke(() => { MyArea.Text = string.Format("区域:{0}{1}排{2}座", info.Area, info.Row, info.Seat); MyNum.Text = "票号:" + info.TicketNo; MyType.Text = "类型:散票"; MyTime.Text = "时间:" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ShowEventMsg("检票成功", MsgType.FaceOk); }); } else { ShowEventMsg("检票失败,数据库连接失败", MsgType.TipErr); } } } catch (Exception ex) { ex.ToSaveLog("InSession"); } }
/// <summary> 写入数据库 </summary> protected override void InSession() { try { //写入本地记录并且通知 var info = new SessionsInfo { SessionId = MyMatch.SessionId, CreateDate = DateTime.Now, Name = MyMatch.SessionName, IdNo = Cvr.Info.Number, IdCardPhoto = IrAdvanced.ReadBytesFromFile(FaceFun.BaseDir + "\\pic.bmp"), TakePhoto = PhotoOk, FaceData = FaceFun.StructToBytes(CameraRft), IdAddress = Cvr.Info.Address, TicketType = 2, TicketNo = null, Area = null, Row = null, Seat = null, TelNo = IrAdvanced.ReadString("TelNo"), TelArea = IrAdvanced.ReadString("TelArea"), BuyName = Cvr.Info.Name, BuyPhoto = null, BuyDate = null, ValidateType = 1, SyncTime = null, Status = 0, Remark = "", UserName = AftUserName, }; if (FaceFun.AddSessions(info) > 0) { Dispatcher.InvokeAsync(() => { MiniImg.Source = FaceFun.ByteToBitmapImage(PhotoOk); }); base.InSession(); } else { "写入数据库失败".ToSaveLog("入场记录时:"); } } catch (Exception ex) { ex.ToSaveLog("InSession"); } }
/// <summary> 写入本地记录并且通知 </summary> protected override void InSession() { //写入本地记录并且通知 var info = new SessionsInfo { SessionId = MyMatch.SessionId, CreateDate = DateTime.Now, Name = MyMatch.SessionName, IdNo = Cvr.Info.Number, IdCardPhoto = IrAdvanced.ReadBytesFromFile(FaceFun.BaseDir + "\\pic.bmp"), TakePhoto = PhotoOk, FaceData = FaceFun.StructToBytes(CameraRft), IdAddress = Cvr.Info.Address, TicketType = 0, TicketNo = _qrInfo.Value.TicketNo, Area = _qrInfo.Value.Area, Row = _qrInfo.Value.Row, Seat = _qrInfo.Value.Seat, TelNo = IrAdvanced.ReadString("TelNo"), TelArea = IrAdvanced.ReadString("TelArea"), BuyName = Cvr.Info.Name, BuyPhoto = null, BuyDate = null, ValidateType = 3, SyncTime = null, Status = 0, Remark = "", UserName = AftUserName, }; if (FaceFun.AddSessions(info) > 0) { ShowEventMsg("检票成功", MsgType.FaceOk); } else { "写入数据库失败".ToSaveLog("入场记录时:"); ShowEventMsg("检票失败", MsgType.FaceErr); } }
/// <summary> 写入数据库 </summary> protected override void InSession() { try { //写入本地记录并且通知 var info = new SessionsInfo { SessionId = MyMatch.SessionId, CreateDate = DateTime.Now, Name = MyMatch.SessionName, IdNo = Cvr.Info.Number, IdCardPhoto = IrAdvanced.ReadBytesFromFile(FaceFun.BaseDir + "\\pic.bmp"), TakePhoto = PhotoOk, FaceData = FaceFun.StructToBytes(CameraRft), IdAddress = Cvr.Info.Address, TicketType = 2, TicketNo = null, Area = null, Row = null, Seat = null, TelNo = IrAdvanced.ReadString("TelNo"), TelArea = IrAdvanced.ReadString("TelArea"), BuyName = Cvr.Info.Name, BuyPhoto = null, BuyDate = null, ValidateType = 1, SyncTime = null, Status = 0, Remark = "", UserName = AftUserName, }; AFT_System.Face.FaceFun.AddSessions(info); } catch (Exception ex) { ex.ToSaveLog("InSession"); } }
/// <summary> 添加入场流水记录进数据库 </summary> /// <param name="info">入场记录</param> public static int AddSessions(SessionsInfo info) { try { info.IdNo.ToSaveLog("写入场流水记录:"); var sb = new StringBuilder(); sb.Append("insert into in_sessions(session_id,create_date,name,id_no,id_card_photo,take_photo,face_data,id_address,ticket_type,ticket_no,area,row,seat,tel_no,tel_area,buy_name,buy_photo,buy_date,validate_type,sync_time,status,remark) "); sb.Append("VALUES(?session_id,?create_date,?name,?id_no,?id_card_photo,?take_photo,?face_data,?id_address,?ticket_type,?ticket_no,?area,?row,?seat,?tel_no,?tel_area,?buy_name,?buy_photo,?buy_date,?validate_type,?sync_time,?status,?remark) "); MySqlParameter[] parameters = { new MySqlParameter("?session_id", MySqlDbType.Int32), new MySqlParameter("?create_date", MySqlDbType.DateTime), new MySqlParameter("?name", MySqlDbType.VarChar), new MySqlParameter("?id_no", MySqlDbType.VarChar), new MySqlParameter("?id_card_photo", MySqlDbType.MediumBlob), new MySqlParameter("?take_photo", MySqlDbType.MediumBlob), new MySqlParameter("?face_data", MySqlDbType.MediumBlob), new MySqlParameter("?id_address", MySqlDbType.VarChar), new MySqlParameter("?ticket_type", MySqlDbType.Int32), new MySqlParameter("?ticket_no", MySqlDbType.VarChar), new MySqlParameter("?area", MySqlDbType.VarChar), new MySqlParameter("?row", MySqlDbType.VarChar), new MySqlParameter("?seat", MySqlDbType.VarChar), new MySqlParameter("?tel_no", MySqlDbType.VarChar), new MySqlParameter("?tel_area", MySqlDbType.VarChar), new MySqlParameter("?buy_name", MySqlDbType.VarChar), new MySqlParameter("?buy_photo", MySqlDbType.MediumBlob), new MySqlParameter("?buy_date", MySqlDbType.DateTime), new MySqlParameter("?validate_type", MySqlDbType.Int32), new MySqlParameter("?sync_time", MySqlDbType.DateTime), new MySqlParameter("?status", MySqlDbType.Int32), new MySqlParameter("?remark", MySqlDbType.VarChar), }; parameters[0].Value = info.SessionId; parameters[1].Value = info.CreateDate; parameters[2].Value = info.Name; parameters[3].Value = info.IdNo; parameters[4].Value = info.IdCardPhoto; parameters[5].Value = info.TakePhoto; parameters[6].Value = info.FaceData; parameters[7].Value = info.IdAddress; parameters[8].Value = info.TicketType; parameters[9].Value = info.TicketNo; parameters[10].Value = info.Area; parameters[11].Value = info.Row; parameters[12].Value = info.Seat; parameters[13].Value = info.TelNo; parameters[14].Value = info.TelArea; parameters[15].Value = info.BuyName; parameters[16].Value = info.BuyPhoto; parameters[17].Value = info.BuyDate; parameters[18].Value = info.ValidateType; parameters[19].Value = info.SyncTime; parameters[20].Value = info.Status; parameters[21].Value = info.Remark; return(MysqlHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, parameters)); } catch (Exception ex) { ex.ToSaveLog("写入数据库失败AddSessions:"); } return(0); }
/// <summary> 读写IC卡 </summary> private int CheckICard() { FaceFun.TimeStart(); var icInfo = new IdCardFunc.TicketCardInfo(); int i = IdCardFunc.GetTicketData_New(ref icInfo); if (i == 0) { if (IsIdSame && (Cvr.Info.Number != icInfo.IDCard)) { ShowEventMsg("身份证号码与票面不符合!", MsgType.Info); } else { tempTime = DateTime.Now; //检查白名单验证 if (!CheckWhite(icInfo.IDCard)) { return(1); } //写入本地记录并且通知 var info = new SessionsInfo { SessionId = MyMatch.SessionId, CreateDate = DateTime.Now, Name = MyMatch.SessionName, IdNo = icInfo.IDCard, IdCardPhoto = IrAdvanced.ReadBytesFromFile(FaceFun.BaseDir + "\\pic.bmp"), TakePhoto = PhotoOk, FaceData = FaceFun.StructToBytes(CameraRft), IdAddress = "", TicketType = 1, TicketNo = icInfo.CardNo, Area = icInfo.StadiumArea, Row = icInfo.Row, Seat = icInfo.Position, TelNo = IrAdvanced.ReadString("TelNo"), TelArea = IrAdvanced.ReadString("TelArea"), BuyName = icInfo.Name, BuyPhoto = null, BuyDate = null, ValidateType = 2, SyncTime = null, Status = 0, Remark = "", UserName = AftUserName, }; if (FaceFun.AddSessions(info) > 0) { Dispatcher.InvokeAsync(() => { ShowEventMsg("检票成功", MsgType.FaceOk); MyArea.Text = string.Format("区域:{0}{1}排{2}座", info.Area, info.Row, info.Seat); MyNum.Text = "票号:" + info.TicketNo; MyType.Text = "类型:年票"; MyTime.Text = "时间:" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); }); } } } else if (i == 16) { i.ToString().ToSaveLog("已刷卡:"); var str = (tempTime == null) ? "拒绝入场" : string.Format("{0}入场", tempTime); ShowEventMsg("一天只能入场一次!\n" + str, MsgType.InfoErr); ShowEventMsg("检票失败", MsgType.FaceErr); Thread.Sleep(500); } else if (i == 1) //未放卡 { tempTime = null; } else { i.ToString().ToSaveLog("IC卡读卡失败:"); Thread.Sleep(300); } FaceFun.TimeStop("IC读写耗时:"); return(i); }
/// <summary> 读写IC卡 </summary> private int CheckICard() { try { "准备请求读卡".ToSaveLog("CheckIcard:"); FaceFun.TimeStart(); var icInfo = new IdCardFunc.TicketCardInfo(); int i = IdCardFunc.GetTicketData_New(ref icInfo); if (i == 0) { tempTime = DateTime.Now; icInfo.IDCard.ToSaveLog("读取到IC卡:"); //判断是否超过时限 if (!icInfo.IDCard.IsNullOrEmpty()) { Dispatcher.Invoke(() => MyIdNo.Text = icInfo.IDCard); } var flag = true; Dispatcher.Invoke(() => { //黑名单检查 if (IsCheckBlack && FaceFun.IsInBlack(MyIdNo.Text)) { LeftImg.Visibility = Visibility.Visible; } if (IsCheckIdNo && MyIdNo.Text.IsNullOrEmpty()) { flag = false; } }); if (!flag) { ShowEventMsg("请录入身份证号码.", MsgType.TipErr); return(1); } //检查白名单验证 if (!CheckWhite(icInfo.IDCard)) { return(1); } PhotoOk = null; lock (Obj) { if (MyCapture != null) { "拍照获取Photo.".ToSaveLog(""); using (var myMap = MyCapture.QueryFrame()) { if (myMap != null) { PhotoOk = FaceFun.BitmapToByte(myMap.Bitmap); } else { "未取得摄像头Mat数据".ToSaveLog("OnlyQrView.BarCode_OnKeyUp:"); } } } } //写入本地记录并且通知 var info = new SessionsInfo { SessionId = MyMatch.SessionId, CreateDate = DateTime.Now, Name = MyMatch.SessionName, IdNo = icInfo.IDCard, IdCardPhoto = null, TakePhoto = PhotoOk, FaceData = null, IdAddress = "", TicketType = 1, TicketNo = icInfo.CardNo, Area = icInfo.StadiumArea, Row = icInfo.Row, Seat = icInfo.Position, TelNo = IrAdvanced.ReadString("TelNo"), TelArea = IrAdvanced.ReadString("TelArea"), BuyName = icInfo.Name, BuyPhoto = null, BuyDate = null, ValidateType = 4, SyncTime = null, Status = 0, Remark = "", UserName = AftUserName, }; if (FaceFun.AddSessions(info) > 0) { Dispatcher.Invoke(() => { MyArea.Text = string.Format("区域:{0}区{1}排{2}座", info.Area, info.Row, info.Seat); MyNum.Text = "票号:" + info.TicketNo; MyType.Text = "类型:年票"; MyTime.Text = "时间:" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); }); ShowEventMsg("检票成功", MsgType.FaceOk); Thread.Sleep(500); } FaceFun.TimeStop("IC读写耗时:"); } else if (i == 16) { i.ToString().ToSaveLog("已刷卡:"); var str = (tempTime == null) ? "拒绝入场" : string.Format("{0}入场", tempTime); ShowEventMsg("一天只能入场一次!\n" + str, MsgType.FaceErr); Thread.Sleep(500); } else if (i == 1) //未放卡 { tempTime = null; } else { i.ToString().ToSaveLog("IC卡读卡失败:"); Thread.Sleep(300); } icPass = false; return(i); } catch (Exception ex) { ex.ToSaveLog("CheckICard失败:"); } icPass = false; return(0); }