protected void Button1_Click(object sender, EventArgs e)
{
//string validatecode = validate_code.Text;
//Request.Cookies["CheckCode"]为空时会导致异常故需先检测
//验证码模块有点bug,先留着
//if (Request.Cookies["CheckCode"]!=null && Request.Cookies["CheckCode"].Value == validatecode)
if (true)
{
//使用数据库操作对象简化代码
string pass = FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5");
myuser.UserName = username.Text;
myuser.PassWord = pass;
if (myuser.LoginByAccount(myuser).Tables[0].Rows.Count > 0)
{
//设置session
Session["username"] = username.Text;
// RegisterStartupScript("", "<script>alert('登录成功！')</script>");
//登陆成功后跳转的未激活页面，有该页面判断用户是否激活
//用于追踪在线用户
if (!isInOnlineUserReal(Session["username"].ToString()))
{
Application.Lock();
Application["users_online_count_real"] = (int)Application["users_online_count_real"] + 1;
Application["users_online_real"] = Application["users_online_real"] + "," + Session["username"].ToString();
Application.UnLock();
}
WebMessageBox.ShowNew("登录成功", "../user/noauth_user/prompt_activation.aspx");
//清空文本框
// txtCode.Text = txtUserName.Text = "";
//服务器端重定向
Server.Transfer("../index.aspx");
}
else
{
// RegisterStartupScript("", "<script>alert('用户名或密码错误！')</script>");
WebMessageBox.Show("用户名或密码错误");
}
}
else
{
RegisterStartupScript("", "<script>alert('验证码输入错误！')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
// string validatecode = validate_code.Text;
//Request.Cookies["CheckCode"]为空时会导致异常故需先检测
//验证码模块有点bug,先留着
//if (Request.Cookies["CheckCode"]!=null && Request.Cookies["CheckCode"].Value == validatecode)
if (true)
{
//使用MD5加密将用户输入的密码加密
string pass = FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5");
//创建数据库连接
/*SqlConnection con = new SqlConnection("server=.;database=MarriageAndLove;uid=sa;pwd=conan;");
* //打开数据库连接
* con.Open();
* //创建SQL语句，该语句用来查询用户输入的用户名和密码是否正确
* string sqlSel = "select count(*) from users where email=@email and password=@pass";
* //创建SqlCommand对象
* SqlCommand com = new SqlCommand(sqlSel, con);
* //使用Parameters的add方法添加参数类型
* com.Parameters.Add(new SqlParameter("email", SqlDbType.VarChar, 20));
* //设置Parameters的参数值
* com.Parameters["email"].Value = email.Text;
* com.Parameters.Add(new SqlParameter("pass", SqlDbType.VarChar, 32));
* com.Parameters["pass"].Value = pass;
* //判断ExecuteScalar方法返回的参数是否大于0大于表示登录成功并给出提示
*/
myuser.Email = email.Text;
myuser.PassWord = pass;
if (myuser.LoginByEmail(myuser).Tables[0].Rows.Count > 0)
{
Session["username"] = myuser.LoginByEmail_FindUserName(myuser).Tables[0].Rows[0]["username"].ToString();
//用于追踪在线用户
if (!isInOnlineUserReal(Session["username"].ToString()))
{
Application.Lock();
Application["users_online_count_real"] = (int)Application["users_online_count_real"] + 1;
Application["users_online_real"] = Application["users_online_real"] + "," + Session["username"].ToString();
Application.UnLock();
}
WebMessageBox.ShowNew("登录成功", "../index.aspx");
//RegisterStartupScript("", "<script>alert('登录成功！')</script>");
//清空文本框
// txtCode.Text = txtUserName.Text = "";
//服务器端重定向
//Server.Transfer("../index.aspx");
}
else
{
RegisterStartupScript("", "<script>alert('用户名或密码错误！')</script>");
}
}
else
{
RegisterStartupScript("", "<script>alert('验证码输入错误！')</script>");
}
}
