public List <IFaceAttendance> gueryLatestAttData(string time)
{
#region
string sql = @"select * from iface_attendance_record where Time > @Time";
try
{
var result = DapperDBContext.Query(sql, time);
if (result.Count > 0)
{
LogHelper.Log(LogLevel.Debug, "Get today's att success: " + result.Count);
}
return(result);
}
catch (Exception e)
{
LogHelper.Log(LogLevel.Fatal, "Get att failed:" + "with error:" + e.Message);
return(new List <IFaceAttendance>());
}
#endregion
}
public int SaveAttData(IFaceAttendance attData)
{
#region 插入单条数据
string sql = @"insert into iface_attendance_record
(EnrollNumber, IsInValid, AttState, VerifyMethod, WorkCode, Time, deviceName) values
(@EnrollNumber, @IsInValid, @AttState, @VerifyMethod, @WorkCode, @Time, @deviceName)";
try
{
var result = DapperDBContext.Execute(sql, attData);
if (result >= 1)
{
LogHelper.Log(LogLevel.Debug, "Save att success:" + JsonConvert.SerializeObject(attData));
}
return(result);
}
catch (Exception e)
{
LogHelper.Log(LogLevel.Fatal, "Save att failed:" + JsonConvert.SerializeObject(attData) + "with error:" + e.Message);
return(0);
}
#endregion
}
