/// <summary> /// 删除用户手机的验证码 /// </summary> /// <param name="phoneNumber"></param> /// <returns></returns> public int DeleteVlidateCode(string phoneNumber) { rpt_mobilecode rpt_mobilecode = _db.rpt_mobilecode.Where(mobile => mobile.Phonenumber == phoneNumber).OrderByDescending(mobile => mobile.Adddatetime).FirstOrDefault(); if (rpt_mobilecode != null) { _db.rpt_mobilecode.Remove(rpt_mobilecode); return(_db.SaveChanges()); } return(0); }
/// <summary> /// 新增用户手机的验证码 /// </summary> /// <param name="phoneNumber"></param> /// <param name="PhoneCode"></param> /// <param name="thisUrl"></param> /// <returns></returns> public int InsertPhoneCode(string phoneNumber, string PhoneCode, string thisIp) { rpt_mobilecode rpt_mobilecode = new rpt_mobilecode(); rpt_mobilecode.Adddatetime = DateTime.Now; rpt_mobilecode.Phonenumber = phoneNumber; rpt_mobilecode.Validatecode = PhoneCode; rpt_mobilecode.Loginip = thisIp; rpt_mobilecode.Expirdatetime = DateTime.Now.AddHours(2.0); _db.rpt_mobilecode.Add(rpt_mobilecode); return(_db.SaveChanges()); }
public bool checkUserSendPhoneCode30After(string phonenumber) { bool isExit = false; //select * from rpt_mobilecode where phoneNumber=?phoneNumber and date_add(NOW(), INTERVAL -1 HOUR) <addDateTime and DATE_ADD(NOW(),INTERVAL 1 HOUR) >addDateTime and NOW()<expirDateTime ORDER BY addDateTime DESC LIMIT 1 DateTime begin = DateTime.Now.AddHours(-2.0); DateTime now = DateTime.Now; DateTime end = DateTime.Now.AddDays(1.0); rpt_mobilecode rpt_mobilecode = _db.rpt_mobilecode.Where(mobile => mobile.Phonenumber == phonenumber && mobile.Adddatetime > begin && mobile.Adddatetime <end && mobile.Expirdatetime> now).FirstOrDefault(); if (rpt_mobilecode != null) { isExit = true; } return(isExit); }
/// <summary> /// 验证验证码是否过期 是否尝试次数过对(最多5次) 如果验证码错误 则更新errorTime+1 /// </summary> /// <param name="phoneNumber"></param> /// <param name="PhoneCode"></param> /// <returns></returns> public bool CkeckPhoneCode(string phoneNumber, string PhoneCode, ref int Time) { bool isExit = false; DateTime now = DateTime.Now; rpt_mobilecode rpt_mobilecode = _db.rpt_mobilecode.Where(mobile => mobile.Expirdatetime > now && mobile.Phonenumber == phoneNumber && mobile.Errortime < 5).FirstOrDefault(); if (rpt_mobilecode != null) { string code = rpt_mobilecode.Validatecode; if (code == PhoneCode) { isExit = true; } else { _db.rpt_mobilecode.Attach(rpt_mobilecode); rpt_mobilecode.Errortime = rpt_mobilecode.Errortime + 1; Time = rpt_mobilecode.Errortime; _db.SaveChanges(); } } return(isExit); }