/// <summary> /// DataRow转换为Model /// </summary> /// <param name="dr"></param> /// <returns></returns> private static PosDataModel dataRowToModel(DataRow dr) { if (dr != null) { try { PosDataModel model = new PosDataModel(); model.Id = dr["VisitNo"].ToString(); model.CardNo = dr["CardId"].ToString().Trim(); model.Passed = dr["Passed"].ToString().Trim(); string tempTime = dr["VisitTime"].ToString().Trim(); if (!string.IsNullOrEmpty(tempTime)) { model.VisitTime = DateTime.Parse(dr["VisitTime"].ToString()); } else { model.VisitTime = DateTime.Parse("1900-1-1"); } string tempDirection = dr["direction"].ToString(); if (!string.IsNullOrEmpty(tempDirection)) { model.Direction = int.Parse(dr["direction"].ToString()); } else { model.Direction = -1; } model.HandleFlag = dr["HandleFlag"].ToString(); return(model); } catch (Exception ex) { SeatManage.SeatManageComm.WriteLog.Write(string.Format("解析刷卡数据遇到异常,该条数据被忽略。数据Id:{0} 异常原因:{1}", dr["VisitNo"].ToString(), ex.Message)); return(null); } } else { return(null); } }
/// <summary> /// 更新已经处理的记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Update(PosDataModel model) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("update shuakajilu set HandleFlag=1 where VisitNo={0} ", model.Id); try { int result = DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString()); if (result >= 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }