protected void imgbtnLanding_Click(object sender, ImageClickEventArgs e)
{
string name = txtName.Text;
string pass = Operate.Encrypting(txtPass.Text);
string yzm = txtYzm.Text;
if (Session["CheckCode"].ToString().Equals(yzm))
{
try
{
string sql = "select count(*) from tb_login where Name='" + name + "' and Pass ='******'";
int i = mydo.isData(sql);
if (i > 0)
{
sql = "select * from tb_login where Name='" + name + "'";
OleDbDataReader odr = mydo.row(sql);
odr.Read();
if (odr["lock"].ToString() == "0")
{
Session["UserName"] = name;
Response.Redirect("index.aspx");
}
else
{
Page.RegisterStartupScript("false", "<script>alert('此用户已被锁定！')</script>");
}
}
else
{
Response.Write("<script>alert('密码或用户名错误！')</script>");
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}
else
{
Page.RegisterStartupScript("false", "<script>alert('验证码错误！')</script>");
}
}
//添加用户
//自定义方法
protected bool add()
{
string name = txtName.Text;
string pass = Operate.Encrypting(txtPass.Text);
string sex;
//获取性别
if (RadioButtonMan.Checked)
{
sex = "男";
}
else
{
sex = "女";
}
string trueName = txtTrueName.Text; //获取真实姓名
string idCard = this.txtIDCard.Text; //获取电话
string passQuestion = this.txtPassQuestion.Text;
string passSolution = FormsAuthentication.HashPasswordForStoringInConfigFile(this.txtPassSolution.Text, "MD5");
string email = txtEmail.Text; //获取电子邮件
string sql = "insert into tb_login(Name,Pass,ZName,Sex,Email,IDCard,PassQuestion,PassSolution) values('" + name + "','" + pass + "','" + trueName + "','" + sex + "','" + email + "','" + idCard + "','" + passQuestion + "','" + passSolution + "')";
return(mydo.adlData(sql));
}
