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