#region 密码输入三次错误后锁定用户功能
#region 增加错误次数的方法
///<summary>
///增加错误次数的方法
///</summary>
private
void
IncErrorTime()
{
string
ConnStr = ConfigurationManager.ConnectionStrings[
"ConnStr"
].ConnectionString;
using
(SqlConnection conn =
new
SqlConnection(ConnStr))
{
using
(SqlCommand updateCmd = conn.CreateCommand())
{
updateCmd.CommandText =
"update T_Admin set errortime=errortime+1 whereUsername=@username"
;
updateCmd.Parameters.Add(
new
SqlParameter(
"username"
, cmbuserName.Text));
conn.Open();
updateCmd.ExecuteNonQuery();
}
}
}
#endregion
#region 错误次数清0
///<summary>
///错误次数清0
///</summary>
private
void
NotErrorTime()
{
string
ConnStr = ConfigurationManager.ConnectionStrings[
"ConnStr"
].ConnectionString;
using
(SqlConnection conn =
new
SqlConnection(ConnStr))
{
using
(SqlCommand updateCmd = conn.CreateCommand())
{
updateCmd.CommandText =
"update T_Admin set errortime=0 whereUsername=@username"
;
updateCmd.Parameters.Add(
new
SqlParameter(
"username"
, cmbuserName.Text));
conn.Open();
updateCmd.ExecuteNonQuery();
}
}
}
#endregion
#region 密码错误3次,记录当前时间加30分钟
///<summary>
///密码错误3次,记录当前时间加30分钟
///</summary>
private
void
IncLoginTime()