/// <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;
}
}
