editpassword.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;


namespace BlueHill_Win_
{
    public partial class EditPassword : Form
    {
        public EditPassword()
        {
            InitializeComponent();
        }

        private void BtnCancel_Click(object sender, EventArgs e)
        {
            this.Dispose();
            //this.Hide();
            //Login L = new Login();
            //L.Show();
        }

        private void BtnOK_Click(object sender, EventArgs e)
        {
            if (txtOldPassword.Text.Trim() == "")
            {
                DialogResult = MessageBox.Show("请输入旧密码！", "提示");
                txtOldPassword.Focus();
            }
            else if (txtNewPassword1.Text.Trim() == "")
            {
                DialogResult = MessageBox.Show("请输入新密码！", "提示");
                txtNewPassword1.Focus();
            }
            else if (txtNewPassword2.Text.Trim() == "")
            {
                DialogResult = MessageBox.Show("请再次输入新密码！", "提示");
                txtNewPassword2.Focus();
            }
            else if (txtNewPassword1.Text.Length < 6)
            {
                DialogResult = MessageBox.Show("新密码至少6位！", "提示");
                txtNewPassword1.Focus();
                txtNewPassword1.Text = "";
                txtNewPassword2.Text = "";
            }
            else if (txtNewPassword1.Text.ToString().Trim() != txtNewPassword2.Text.ToString().Trim())
            {
                DialogResult = MessageBox.Show("两次新密码不一致,请认真填写！", "提示");
                txtNewPassword2.Focus();
                txtNewPassword1.Text = "";
                txtNewPassword2.Text = "";
            }
            else
            {
                try
                {
                    SqlConnection con = DB.connection();
                    con.Open();
                    SqlCommand cmd = new SqlCommand("select 员工密码 from 员工表 where 员工登录名='" + DB.getA + "'", con);
                    SqlDataReader dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        string password = dr[0].ToString().Trim();
                        dr.Close();
                        if (txtOldPassword.Text.ToString().Trim() == password)
                        {
                            SqlCommand cmdupdate = new SqlCommand("update 员工表 set 员工密码 =('" + txtNewPassword2.Text.ToString().Trim() + "') where 员工登录名= ('"+ DB.getA +"')", con);
                            int count = Convert.ToInt32(cmdupdate.ExecuteNonQuery());
                            if (count > 0)
                            {
                                DialogResult = MessageBox.Show("修改密码成功！", "提示");
                                con.Close();
                                this.Dispose();
                            }
                            else
                                DialogResult = MessageBox.Show("操作失败！", "提示");
                        }
                        else

                            DialogResult = MessageBox.Show("原密码不正确！", "提示");
                    }
                    else
                        dr.Close();
                    con.Close();
                }
                catch(Exception EV)
                {
                    DialogResult = MessageBox.Show(EV.ToString(), "提示");
                }
            }
        }

        private void EditPassword_FormClosing(object sender, FormClosingEventArgs e)
        {
            //取消关闭窗体
            e.Cancel = true;
        }

        private void EditPassword_Load(object sender, EventArgs e)
        {

        }
    }
}