public static bool CheckPhoneNumCode(string phone, string code, int logId) { if (string.IsNullOrEmpty(code)) return false; SysMsnLog log = null; var query = DB.Select( ).Top("1").From<SysMsnLog>( ) .Where(SysMsnLog.PhoneNumberColumn).IsEqualTo(phone) .And(SysMsnLog.MsnCodeColumn).IsEqualTo(code) .And(SysMsnLog.IsCheckedColumn).IsEqualTo(false) .And(SysMsnLog.IdColumn).IsEqualTo(logId) .OrderDesc(SysMsnLog.MsnDateColumn.ColumnName); using (var dr = query.ExecuteReader( )) { if (dr.Read( )) { log = new SysMsnLog( ); log.Load(dr); } } if (log != null && log.MsnDate.HasValue) { var ts = DateTime.Now - log.MsnDate.Value; log.IsChecked = true; log.Save( ); return ts.Minutes <= 10; } return false; }
public static bool IsPhoneNumHasCheckCode(string phone) { SysMsnLog log = null; var query = DB.Select( ).Top("1").From<SysMsnLog>( ) .Where(SysMsnLog.PhoneNumberColumn).IsEqualTo(phone) .And(SysMsnLog.MsnCodeColumn).IsNotNull( ) .And(SysMsnLog.IsCheckedColumn).IsEqualTo(false) .OrderDesc(SysMsnLog.MsnDateColumn.ColumnName); using (var dr = query.ExecuteReader( )) { if (dr.Read( )) { log = new SysMsnLog( ); log.Load(dr); } } if (log != null && log.MsnDate.HasValue) { var ts = DateTime.Now - log.MsnDate.Value; return ts.Minutes <= 10; } return false; }