protected void btnSubmit_Click(object sender, EventArgs e)
{
amendPassword transfer = new amendPassword();
string NewPwd = this.txtPwd.Text.Trim();
string pwd = transfer.EncryptPassword(NewPwd, "MD5").Trim();
//string pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(NewPwd, "MD5");
int i = userNameValidate();
if (i == 0)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["VoteConnectionString"]);
SqlCommand cmd = new SqlCommand("insert into Users Values(@userId,@userPwd,@userName,@userSex,@userBirth,@userPhone,@userMobilePhone,@userCode,@userAddress,@userEmail,@userQQ)", conn);
cmd.Parameters.Add("@userPwd", SqlDbType.VarChar, 50);
cmd.Parameters.Add("@userId", SqlDbType.VarChar, 15);
cmd.Parameters.Add("@userName", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@userSex", SqlDbType.VarChar, 2);
cmd.Parameters.Add("@userBirth", SqlDbType.VarChar, 8);
cmd.Parameters.Add("@userPhone", SqlDbType.VarChar, 15);
cmd.Parameters.Add("@userMobilePhone", SqlDbType.VarChar, 15);
cmd.Parameters.Add("@userCode", SqlDbType.VarChar, 6);
cmd.Parameters.Add("@userAddress", SqlDbType.VarChar, 200);
cmd.Parameters.Add("@userEmail", SqlDbType.VarChar, 100);
cmd.Parameters.Add("@userQQ", SqlDbType.VarChar, 20);
cmd.Parameters["@userid"].Value = txtName.Text;
cmd.Parameters["@userPwd"].Value = pwd;
cmd.Parameters["@userName"].Value = txtUname.Text;
cmd.Parameters["@userSex"].Value = rltSex.SelectedItem.Text;
cmd.Parameters["@userBirth"].Value = Convert.ToDateTime(ddlYear.SelectedValue + "-" + ddlmonth.SelectedValue + "-" + ddlDay.SelectedValue);
cmd.Parameters["@userPhone"].Value = txtUtel2.Text;
cmd.Parameters["@userMobilePhone"].Value = txtUtel3.Text;
cmd.Parameters["@userCode"].Value = txtUzip.Text;
cmd.Parameters["@userAddress"].Value = txtUaddr.Text;
cmd.Parameters["@userEmail"].Value = txtUemail.Text;
cmd.Parameters["@userQQ"].Value = txtUQQ.Text;
try
{
conn.Open();
string msg = op.sortadd(txtName.Text);
int flag = cmd.ExecuteNonQuery();
if (flag > 0 && msg == "")
{
lblshow.Style["color"] = "red";
//Response.Redirect("Login.aspx");
//Response.Write("注册成功，请等待2秒......");
lblshow.Text = "注册成功，请等待2秒......<script language=javascript>"
+ "window.setTimeout(\"location.href='Login.aspx'\",2000);"
+ "</script>";
//Response.Write("<script language=javascript>window.setTimeout(\"location.href='Login.aspx'\",2000);</script>");
}
else
{
Response.Write("<script language=javascript>alert('注册失败!')</script>");
}
}
catch (System.Exception ee)
{
Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
}
finally
{
conn.Close();
}
}
}
