updatapwd.cs

一个不错的文档

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using MySchoolPrj.DAO;
using MySchoolPrj.Entity;


namespace MySchoolPrj.Login
{
    public partial class updataPwd : Form
    {
        public updataPwd()
        {
            InitializeComponent();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        public void setName()
        {
            txtname1.Text = UserHelper.loginId;
        }
        public string pwd;
        //获取数据
        public void setPwd()
        {
            try
            {
                DBHelper.con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = DBHelper.con;
                cmd.CommandType = CommandType.Text;
                string sql = string.Format("select * from userInfo where userName='{0}'", UserHelper.loginId);
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
                SqlDataReader reader = cmd.ExecuteReader();
                if (reader.HasRows)
                {
                    reader.Read();
                    pwd = (string)reader["pwd"];
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                DBHelper.con.Close();
            }
        }
        public bool Judge()
        {
            if (txtPwd11.Text != txtPwd22.Text)
            {
                MessageBox.Show("两次输入的密码不相同。请确认后重新输入！", "提示！");
                txtPwd11.Text = "";
                txtPwd22.Text = "";
                return false;
            }
            else
            {
                return true;
            }
        }
        //判断重复输入
        public bool JudgeConnectionPwd()
        {
            setPwd();
            if (pwd!= txtOldPwd.Text)
            {
                MessageBox.Show("输入的旧密码不正确，请重新输入！", "提示！");
                txtOldPwd.Text = "";
                return false;
            }
            else
            {
                return true;

            }
        }
         
        //判断旧密码和新修改的密码填写了没有
        public bool JudgePwd()
        {
            string oldpwd = txtOldPwd.Text;
            string pwd11 = txtPwd11.Text;
            string pwd22 = txtPwd22.Text;
            if (oldpwd.Length == 0 ||pwd11.Length == 0 || pwd22.Length == 0)
            {
                MessageBox.Show("想要修改密码必须要填写！", "提示！");
               

                return false;
            }
            else
            {
                return true;
            }
        }
        //提交数据
        private void btnOK_Click(object sender, EventArgs e)
        {
            
                if (JudgePwd())
                {
                    if (JudgeConnectionPwd())
                    {
                    if (Judge())
                    {
                        try
                        {
                            //string Name = txtname1.Text;


                            DBHelper.con.Open();
                            SqlCommand cmd = new SqlCommand();
                            cmd.Connection = DBHelper.con;
                            cmd.CommandType = CommandType.Text;
                            string sql = "update userInfo set pwd='" + txtPwd11.Text + "' where userName='" + txtname1.Text + "'";
                            cmd.CommandText = sql;
                            cmd.ExecuteNonQuery();
                            MessageBox.Show("修改成功！", "提示！");
                            this.Close();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                        finally
                        {
                            DBHelper.con.Close();
                        }
                    }
                }
            }
        }
        //设置初始化信息
        private void updataPwd_Load(object sender, EventArgs e)
        {
            txtname1.ReadOnly = true;
            setName();
        }

     }
}