static int errorcount = 0;
protected void Button1_Click(object sender, EventArgs e)
{
T_UserTableAdapter adapter = new T_UserTableAdapter();
string name = this.TextBox1.Text;
string pw=this.TextBox2.Text;
WebApplication1.DataSet1.T_UserDataTable dt = adapter.GetDataByPw(name);
int sqlerror = Convert.ToInt32( adapter.ScalarQuery(name));
if (sqlerror >=3)
{
int secondspan = Convert.ToInt32(adapter.GetDataErrorTime(name));
//如果间隔时间小于解锁时间则返回程序
if (secondspan < 60)
{
Response.Write("<script>alert(\"您已经连续3次输入错误的密码,已被系统锁定,请60秒之后再次重试,或者到服务窗口解锁\");</script>");
}
else
{
adapter.UpdateErrorCount(0, name);
}
return;
}
if (dt[0].password != pw)
{
//累加一次错误
errorcount++;
adapter.UpdateErrortime(DateTime.Now, name);//更新登录错误的时间
adapter.UpdateErrorCount(errorcount, name);//更新错误次数
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('用户名或密码不正确,请重新输入')", true);
}
else
{
adapter.UpdateErrorCount(0, name);
ClientScript.RegisterStartupScript(this.GetType(), "", "alert('登录成功')", true);
}
}