private int EditPwd_Trans(IDbHelp thelp, DbHelp.ITransM pMod) { EditPwd_TransM tmod = (EditPwd_TransM)pMod; //查询是否生效 string sql = "select FK_User from User_FindPwdEmail where FPEmail=@FPEmail and FPKey=@FPKey and AddDate>(dateadd(dd,-3,getdate())) order by AddDate desc"; IDataParameter[] param = { DbHelp.Def.AddParam("@FPEmail", Email), DbHelp.Def.AddParam("@FPKey", Key), }; string str = thelp.First(sql, param, "0"); if (str == "0") { tmod.returnValue = "此链接已失效"; return(0); } //更新密码 sql = "update User_Info set UserPwd=@UserPwd where UserSN=@UserSN"; IDataParameter[] param2 = { DbHelp.Def.AddParam("@UserPwd", Fn.MD5(tmod.sPwd)), DbHelp.Def.AddParam("@UserSN", str), }; //删除用户的找回密码记录 if (thelp.Update(sql, param2) <= 0) { tmod.returnValue = "找不到此用户"; return(0); } sql = "delete User_FindPwdEmail where FK_User=@FK_User"; IDataParameter[] param3 = { DbHelp.Def.AddParam("@FK_User", str), }; if (thelp.Update(sql, param3) <= 0) { tmod.returnValue = "设置失败"; return(0); } tmod.returnValue = "1"; return(1); }
protected void bOK_Click(object sender, EventArgs e) { string sPwd = Req.GetForm("cPwd").Trim(); string sPwdSure = Req.GetForm("cPwdSure").Trim(); if (sPwd.Length == 0) { Js.Alert("请输入密码"); } if (sPwd.Length < 5 || sPwd.Length > 30) { Js.Alert("密码不能小于5到30位数"); } if (sPwdSure.Length == 0) { Js.Alert("请输入确认密码"); } if (sPwd != sPwdSure) { Js.Alert("两次密码输入不一致"); } EditPwd_TransM tmod = new EditPwd_TransM(); tmod.sPwd = sPwd; tmod.sPwdSure = sPwdSure; tmod.sKey = Key; tmod.sEmail = Email; DbHelp.ExecuteTrans(new DbHelpParam(), EditPwd_Trans, tmod); if (tmod.returnValue == "1") { Response.Redirect("/user/findPwd3.aspx"); } else { Js.Alert(tmod.returnValue); } }