用户登录，并完成增加、查询、解锁操作

三天的奋战，完成了用户登录和操作的学习和编写，其中登录部分已在前两天的博文中展示，现将剩余的部分与诸位分享

 

 

这是admin登录后实现查询操作部分的代码

private void btnQuery_Click(object sender,EventArgs e)

       {

           string strcon =ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;

           SqlConnection sqlcnn = new SqlConnection(strcon);

           SqlCommand sqlcmm = new SqlCommand();

           sqlcmm.Connection = sqlcnn;

           sqlcnn.Open();

           string sqlstr = "select B.UserId ,A.username,B.name,B.sfzh,B.tell,B.Address,B.age,(case B.General when 1 then '男' when 0 then '女' end)General,A.Error from T_User Ainner join  T_UserInfo B on B.UserId=A.UserId where ";

           string sqlwhere = ReturnSqlWhere(sqlcmm);

           sqlcmm.CommandText=sqlstr+sqlwhere;

           SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);

           DataTable dt = new DataTable();

           adapter.Fill(dt);

           if (dt.Rows.Count > 0)

           {

                this.dataGridView1.DataSource =dt;

           }

           else

           {

                MessageBox.Show("您查询的数据不存在");

           }

       }

 

       private string ReturnSqlWhere(SqlCommand sqlcmm)

       {

           string sqlwhere = string.Empty;

           switch (cmbselect.Text)

           {

                case "姓名":

                    sqlwhere = "B.namelike @name";

                   sqlcmm.Parameters.AddWithValue("@name", "%" +txtcontent.Text + "%");

                    break;

                case "身份证号":

                    sqlwhere = "B.sfzhlike @sfzh";

                    sqlcmm.Parameters.AddWithValue("@sfzh","%" + txtcontent.Text + "%");

                    break;

                case "地址":

                    sqlwhere = "B.addresslike @address";

                   sqlcmm.Parameters.AddWithValue("@address", "%" +txtcontent.Text + "%");

                    break;

           }

           return sqlwhere;

       }

 

 

此为admin登录后添加和解锁部分的代码

private void btnAdd_Click(object sender,EventArgs e)

       {

           UserAdd a = new UserAdd();

           a.Show();

       }

 

       private void btnunlock_Click(object sender, EventArgs e)

       {

           string strcon =ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;

           SqlConnection sqlcnn = new SqlConnection(strcon);

           SqlCommand sqlcmm = new SqlCommand();

           sqlcmm.Connection = sqlcnn;

           sqlcnn.Open();

           int id = Convert.ToInt32(this.dataGridView1.SelectedCells[0].Value);

           sqlcmm.CommandText = "update T_User set Error=0 whereUserId=@userid";

           sqlcmm.Parameters.AddWithValue("@userid", id);

           if (sqlcmm.ExecuteNonQuery() > 0)

           {

                MessageBox.Show("解锁成功");

           }

           else

           {

                MessageBox.Show("解锁失败");

           }

       }

 

 

刷新部分与查询部分相类似，在此就不再列出

下面是点击添加按钮后，录入信息并将其保存部分的代码

private void btnSave_Click(object sender,EventArgs e)

       {

           #region

           string strcon =ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;

           SqlConnection sqlcnn = new SqlConnection(strcon);

           SqlCommand sqlcmm = new SqlCommand();

           sqlcmm.Connection = sqlcnn;

           sqlcnn.Open();

           #endregion

 

           sqlcmm.CommandText = "insert into T_User(UserName,Password) values(@username,@password)select @@identity";

           sqlcmm.Parameters.AddWithValue("@username", txtUserName.Text);

           sqlcmm.Parameters.AddWithValue("@password", txtPassword.Text);

           int result = Convert.ToInt32(sqlcmm.ExecuteScalar());

 

           if (result > 0)

           {

                int general = 0;

                switch (txtgeneral.Text)

                {

                    case "男":

                        general = 1;

                        break;

                    default:

                        general = 0;

                        break;

                }

                sqlcmm.CommandText ="insert into T_UserInfo(UserId,Name,Sfzh,Tell,Address,Age,General)values(@userid,@name,@sfzh,@tell,@address,@age,@general)";

               sqlcmm.Parameters.AddWithValue("@userid", result);

               sqlcmm.Parameters.AddWithValue("@name", txtName.Text);

               sqlcmm.Parameters.AddWithValue("@sfzh", txtSfzh.Text);

                sqlcmm.Parameters.AddWithValue("@tell",txtTell.Text);

               sqlcmm.Parameters.AddWithValue("@address", txtAddress.Text);

               sqlcmm.Parameters.AddWithValue("@age", txtage.Text);

               sqlcmm.Parameters.AddWithValue("@general", general);

 

                int result1 =sqlcmm.ExecuteNonQuery();

                if (result1 > 0)

                {

                    MessageBox.Show("插入数据成功");

                }

           }

           else

           {

                MessageBox.Show("数据插入不成功");

           }

       }