登录错误，帐号冻结及解冻

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Configuration;

using System.Data.SqlClient;

 

namespace 复¡ä习¡ã登Ì?录?

{

    public partial class Form1 : Form

    {

        publicForm1()

        {

            InitializeComponent();

        }

        stringstr = ConfigurationManager.ConnectionStrings["sqlserver2008"].ConnectionString;

        DateTimedt1;

        privatevoid btn_login_Click(objectsender, EventArgs e)

        {

            using(SqlConnection cnn=newSqlConnection(str))

            {

                using(SqlCommand cmd=cnn.CreateCommand())

                {

                    cmd.CommandText = "select * from T_Users whereusername=@username";

                   cmd.Parameters.AddWithValue("@username",txt_username.Text);

                    cnn.Open();

                    using(SqlDataReader reader = cmd.ExecuteReader())

                    {

                        if (reader.Read())

                        {

                            int Error = Convert.ToInt32(reader["Error"].ToString());

                            if(Error >= 3)

                            {

 

                                string sqltime = reader["Errortime"].ToString();

                                dt1 = DateTime.Parse(sqltime);

                                DateTime dt2 = DateTime.Now;

                                TimeSpan ts = dt2 - dt1;

                                if (ts.TotalMinutes < 2)

                                {

                                    MessageBox.Show("对?不?起e，ê?你?已°?经-输º?入¨?3次ä?连¢?续?错䨪误¨®密¨¹码?，ê?系¦Ì统ª3已°?经-将?账?户¡ì冻3结¨¢，ê?请?在¨²两¢?分¤?钟¨®后¨®再¨´试º?");

                                    return;

                                }

                                else

                                {

                                   clearerror();

                                }

 

                            }

                            string sqlpassword = reader["Password"].ToString();

                            if (sqlpassword == txt_password.Text)

                            {

                                MessageBox.Show("登Ì?录?成¨¦功|");

                                clearerror();

                            }

                            else

                            {

                                MessageBox.Show("密¨¹码?错䨪误¨®");

                                adderror();

                            }

                        }

                        else

                        {

                            MessageBox.Show("用®?户¡ì名?不?存ä?在¨²");

                        }

                       

                    }

                }

            }

        }

 

        privatevoid adderror()

        {

            dt1 = DateTime.Now;

            using(SqlConnection cnn=newSqlConnection(str))

            {

                using(SqlCommand cmd=cnn.CreateCommand())

                {

                    cnn.Open();

                    cmd.CommandText = "update T_Users setError=Error+1,Errortime=@Errortime where username=@username";

                    cmd.Parameters.AddWithValue("@Errortime", dt1);

                   cmd.Parameters.AddWithValue("@username",txt_username.Text);

                    cmd.ExecuteNonQuery();

 

                }

            }

        }

        privatevoid clearerror()

        {

            using(SqlConnection cnn=newSqlConnection(str))

            {

                using(SqlCommand cmd=cnn.CreateCommand())

                {

                    cnn.Open();

                    cmd.CommandText = "update T_Users set Error=0 whereusername=@username";

                    cmd.Parameters.Add(new SqlParameter("username", txt_username.Text));

                    cmd.ExecuteNonQuery();

                }

            }

        }

    }

}

 

 

转载于:https://www.cnblogs.com/chinagg/archive/2012/02/22/3675123.html