protected void Page_Load(object sender, EventArgs e) { //进行激活判断 //修改密码 //显示激活成功 //用户登录 if (!Page.IsPostBack) { lbl_info.Text = "至少包含一个大写字母,至少包含一个小写字母,至少包含一个数字,密码只能以字母开头,并且包含这些字母(!#@$%^&*)中的一个, 并且密码长度至少是8个"; string id_tmp = System.Web.HttpUtility.UrlEncode(Request.QueryString["id"], System.Text.UnicodeEncoding.UTF8); string id = id_tmp.Replace("%3d", "="); //string token = Request.QueryString["id"]; string de_id = EnDecrypt.Decrypt(id); hf_id.Value = id; if (de_id != "") { user_Pub = QueryPwd(de_id); string commonname = user_Pub.firstName; string oldpwd = user_Pub.password; lbl_username.Text = commonname; lbl_oldpwd.Text = oldpwd; } else { Response.Write("Invalid Link"); return; } } }
public static UserInfo_Normal QueryInfoByID(string id) { UserInfo_Normal user = new UserInfo_Normal(); // DataTable dt = DBHelp.GetDataSet("select userId,firstName,emailAddress,registrationToken,expTime,activited,password from local_users where registrationToken='" + token + "'"); DataTable dt = DBHelp.GetDataSet("select * from local_users where userId='" + id + "'"); if (dt.Rows.Count > 0) { user.userId = int.Parse(dt.Rows[0]["userId"].ToString()); user.firstName = dt.Rows[0]["firstName"].ToString(); user.emailAddress = dt.Rows[0]["emailAddress"].ToString(); user.registrationToken = dt.Rows[0]["registrationToken"].ToString(); user.tokenExpiredDatetime = Convert.ToDateTime(dt.Rows[0]["tokenExpiredDatetime"].ToString()); string act = dt.Rows[0]["activited"].ToString(); if (act == "true") { user.activited = 1; } else { user.activited = 0; } user.password = dt.Rows[0]["password"].ToString(); } return(user); }
private UserInfo_Normal QueryPwd(string id) { UserInfo_Normal user = new UserInfo_Normal(); SqlDataReader reader = DBHelper.DBHelp.GetReader("select userId,firstName,emailAddress,registrationToken,tokenExpiredDatetime,activited,password from local_users where userId=@id", new SqlParameter("@id", id)); while (reader.Read()) { user.userId = reader.GetInt32(0); user.firstName = reader.GetString(1); user.emailAddress = reader.GetString(2); user.registrationToken = reader.GetString(3); user.tokenExpiredDatetime = reader.GetDateTime(4); string act = reader[5].ToString(); if (act == "true") { user.activited = 1; } else { user.activited = 0; } user.password = reader.GetString(6); } reader.Close(); return(user); }
/// <summary> /// 向新用户发送邮件 /// </summary> private void SendSMTPEMail() { try { string addresser = "*****@*****.**"; //发送者的邮箱 string recipient = this.txt_usermail.Text.Trim(); //接收者的邮箱 string userName = this.txt_firstName.Text.Trim(); //接收者的用户名 //string emailPwd = "FBW08uos$";//发送者的邮箱密码 user_norm = QueryId(userName, recipient); string id = EnDecrypt.Encrypt(user_norm.userId.ToString()); string code = user_norm.registrationToken; string title = "Thanks for registering, please verify your email registration"; // string str = string.Format("http://localhost:24569/RegistSuccess.aspx?userName={0}&id={1}&token={2}", userName, id, code); //激活码链接 // string str = string.Format("http://localhost:24569/confirm.aspx?token={0}", code); //激活码链接 string str = "http://localhost:44567/confirm.aspx?id=" + id + "&token=" + code + ""; string content = "Please click the link to complete the email verification " + str;// +",也可以访问http://localhost:24569/confirm.aspx,输入激活码:" + code + "进行激活"; MailMessage message = new MailMessage(addresser, recipient); message.Subject = title; message.Body = content; message.Priority = MailPriority.High; SmtpClient client = new SmtpClient("KLAUVM19.kerrylogistics.com", 25);//更改,例如smtp.163.com,smtp.gmail.com client.EnableSsl = false; client.UseDefaultCredentials = false; //client.Credentials = new System.Net.NetworkCredential(addresser, emailPwd); client.Send(message); } catch (Exception ex) { // Response.Write("email send fail..."+ex.ToString()); lbl_msg.Text = "Sending error" + ex.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string token = Request.QueryString["token"]; string id_tmp = System.Web.HttpUtility.UrlEncode(Request.QueryString["id"], System.Text.UnicodeEncoding.UTF8); string id = id_tmp.Replace("%3d", "="); if (token != "" && id != "") { string de_id = EnDecrypt.Decrypt(id); //user_nom = OperData.QueryIdByToken(token); user_nom = OperData.QueryInfoByID(de_id); if (user_nom != null) { string first = user_nom.firstName; DateTime tokenExpiredDatetime = user_nom.tokenExpiredDatetime; //有效期 string code = user_nom.registrationToken; //激活码 int flag = user_nom.activited; //激活状态 DateTime curtime = DateTime.Now; if (flag == 0 && curtime < tokenExpiredDatetime) { if (OperData.UpdateActiveByID(de_id)) { //这就是打断点的方法 Response.Write("<script language=javascript>alert('Your account has been activated successfully!');window.location.href='active.aspx?id=" + id + "';</script>"); } else { Response.Write("<script language=javascript>alert('Failed to activate!');window.location.href='login.aspx';</script>"); } } else { if (flag == 1) { Response.Write("<script language=javascript>alert('Account has been activated!');window.location.href='active.aspx?id=" + id + "';</script>"); return; } if (flag == 0 && curtime > tokenExpiredDatetime) { Response.Write("<script language=javascript>alert('Code expired, activate fail!');window.location.href='delaccount.aspx?id=" + id + "';</script>"); return; } else { Response.Write("<script language=javascript>alert('Error Link!');window.location.href='login.aspx';</script>"); } } } } } }
protected void btn_active_Click(object sender, EventArgs e) { if (txt_regcode.Text != "" || txt_regcode.Text != null) { Response.Write(""); } else { string token = txt_regcode.Text.Trim(); if (token != "") { user_nom = OperData.QueryIdByToken(token); string first = user_nom.firstName; DateTime tokenExpiredDatetime = user_nom.tokenExpiredDatetime; //有效期 string code = user_nom.registrationToken; //激活码 int flag = user_nom.activited; //激活状态 DateTime curtime = DateTime.Now; if (code == token && flag == 0 && curtime < tokenExpiredDatetime) { if (OperData.UpdateActive(token)) { Response.Write("<script language=javascript>alert('Your account has been activated successfully!');window.location.href='active.aspx?token=" + token + "';</script>"); } else { Response.Write("<script language=javascript>alert('Failed to activate!');window.location.href='login.aspx';</script>"); } } else { if (code == token && flag == 1) { Response.Write("<script language=javascript>alert('Your account has been activated successfully!');window.location.href='active.aspx?token=" + token + "';</script>"); return; } if (code == token && flag == 0 && curtime > tokenExpiredDatetime) { Response.Write("<script language=javascript>alert('Code expired, failed to activate!');window.location.href='login.aspx" + token + "';</script>"); return; } else { Response.Write("<script language=javascript>alert('Error Link!');window.location.href='login.aspx';</script>"); } } } } }
private UserInfo_Normal QueryId(string firstname, string email) { UserInfo_Normal user = new UserInfo_Normal(); SqlDataReader reader = DBHelper.DBHelp.GetReader("select userId,firstName,emailAddress,registrationToken,tokenExpiredDatetime,activited from local_users where firstName=@firstName and emailAddress=@mail", new SqlParameter("@firstName", firstname), new SqlParameter("@mail", email)); while (reader.Read()) { user.userId = reader.GetInt32(0); user.registrationToken = reader.GetString(3); } reader.Close(); return(user); }
/// <summary> /// 是否用户已存在 /// </summary> /// <param name="userName"></param> /// <param name="Email"></param> /// <returns></returns> public UserInfo_Normal HaveUser(string userName, string Email) { UserInfo_Normal user = new UserInfo_Normal(); string sql = "select firstName,surName,emailAddress from local_users where firstName='" + userName + "' or emailAddress='" + Email + "'"; SqlDataReader reader = DBHelper.DBHelp.GetReader(sql); while (reader.Read()) { user.firstName = reader.GetString(0); user.emailAddress = reader.GetString(1); } reader.Close(); return(user); }
private static UserInfo_Normal QueryPwd(string token) { UserInfo_Normal user = new UserInfo_Normal(); SqlDataReader reader = DBHelper.DBHelp.GetReader("select userId,firstName,emailAddress,registrationToken,tokenExpiredDatetime,activited,password from local_users where registrationToken=@token", new SqlParameter("@token", token)); while (reader.Read()) { user.userId = reader.GetInt32(0); user.firstName = reader.GetString(1); user.emailAddress = reader.GetString(2); user.registrationToken = reader.GetString(3); user.tokenExpiredDatetime = reader.GetDateTime(4); user.activited = reader.GetInt32(5); user.password = reader.GetString(6); } reader.Close(); return(user); }
/// <summary> /// 插入用户信息到数据库表 /// </summary> /// <param name="user"></param> /// <returns></returns> private bool Insert(UserInfo_Normal user) { string sql = @"insert into local_users (firstName,surName,password,companyCode,position,workPhoneNumber,mobileNumber,emailAddress,userCreatedBy,userCreatedDatetime,userLatestEditedBy,userLatestEditedDatetime,activited,registrationToken,registrationDatetime,tokenExpiredDatetime) VALUES (@firstName,@surName,@password,@companyCode,@position,@workPhoneNumber,@mobileNumber,@emailAddress,@userCreatedBy,@userCreatedDatetime,@userLatestEditedBy,@userLatestEditedDatetime,@activited,@registrationToken,@registrationDatetime,@tokenExpiredDatetime)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@firstName", user.firstName), new SqlParameter("@surName", user.surName), new SqlParameter("@password", user.password), new SqlParameter("@companyCode", user.companyCode), new SqlParameter("@position", user.position), new SqlParameter("@workPhoneNumber", user.workPhoneNumber), new SqlParameter("@mobileNumber", user.mobileNumber), new SqlParameter("@emailAddress", user.emailAddress), new SqlParameter("@userCreatedBy", user.userCreatedBy), new SqlParameter("@userCreatedDatetime", user.userCreatedDatetime), new SqlParameter("@userLatestEditedBy", user.userLatestEditedBy), new SqlParameter("@userLatestEditedDatetime", user.userLatestEditedDatetime), new SqlParameter("@activited", user.activited = 0), new SqlParameter("@registrationToken", user.registrationToken), new SqlParameter("@registrationDatetime", user.registrationDatetime), new SqlParameter("@tokenExpiredDatetime", user.tokenExpiredDatetime) }; int i = DBHelp.ExecuteCommand(sql, para); if (i > 0) { return(true); } else { return(false); } }
private bool isUser() { string userName = txt_firstName.Text.Trim(); string surname = txt_surName.Text.Trim(); string companycode = txt_companyCode.Text.Trim(); string mail = txt_usermail.Text.Trim(); string password = "******";// txt_password.Text.Trim(); string workphonenum = txt_workPhoneNumber.Text.Trim(); user_norm = HaveUser(userName, mail); if (userName == "") { // Response.Write("用户名不能为空"); lbl_msg.Text = "Username cannot be empty"; return(false); } if (surname == "") { lbl_msg.Text = "Surname cannot be empty"; return(false); } if (password == "") { //Response.Write("密码不能为空"); lbl_msg.Text = "Password cannot be empty"; return(false); } if (companycode == "") { lbl_msg.Text = "Company code cannot be empty"; return(false); } if (workphonenum == "") { // Response.Write("邮箱不能为空"); lbl_msg.Text = "Work phnoe number cannot be empty"; return(false); } if (mail == "") { // Response.Write("邮箱不能为空"); lbl_msg.Text = "Email address cannot be empty"; return(false); } if (userName == user_norm.firstName) { // Response.Write("用户名已存在"); lbl_msg.Text = "Username already exists"; return(false); } //检查邮箱是否已注册 if (OperData.ChkReEmail(mail)) //if (mail == user_norm.emailAddress) { //Response.Write("邮箱已存在"); return(true); } else { userName = ""; surname = ""; companycode = ""; mail = ""; password = ""; workphonenum = ""; lbl_msg.Text = "The mailbox already exists"; return(false); } }