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 }