updatepwd.cs

程序设计语言上机考试系统

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

namespace WindowsApplication1.Systemweihu
{
    public partial class UpdatePWD : Form
    {
        SqlConnection cn = new SqlConnection("SERVER=(local);UID=sa;PWD=sa;Trusted_Connection=True;DATABASE=test1");
        baseclass.BaseOperate boperate = new baseclass.BaseOperate();
        public UpdatePWD()
        {
            InitializeComponent();
        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            if(txtOldPWD.Text.Trim() == ""||txtNewPWD.Text.Trim()== ""||txtRNewPWD.Text.Trim() == "")
                MessageBox.Show("请输入完整的信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            else
            {
                if(cn.State == ConnectionState.Closed)
                    cn.Open();
                string txtUserNamecur = txtUserName.Text.Trim().ToString().Replace("'", "''");
                string txtNewPWDcur = txtRNewPWD.Text.Trim().ToString().Replace("'", "''");
                string txtOldPWDcur = txtOldPWD.Text.Trim().ToString().Replace("'", "''");
                string txtRNewPWDcur = txtRNewPWD.Text.Trim().ToString().Replace("'", "''");

                SqlCommand cmd = new SqlCommand("select password from userinfo where username ='" + txtUserNamecur + "'", cn);
                //判断原始密码和数据库中的是否一致
                if (cmd.ExecuteScalar().ToString() != txtOldPWDcur)
                    errorProvider1.SetError(txtOldPWD,"原始密码不正确！");
                else
                {
                    errorProvider1.Clear();
                    //判断两次输入的新密码是否相同，相同则修改密码
                    if (txtRNewPWDcur != txtNewPWDcur)
                        errorProvider1.SetError(txtRNewPWD,"两次密码不一致，请重新输入！");
                    else
                    {
                        errorProvider1.Clear();
                        boperate.getcom("update userinfo set password ='" + txtRNewPWDcur +"' where username = '"+ txtUserName.Text.Trim() +"'" );
                        MessageBox.Show("密码修改成功，下次登录生效！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
                if(cn.State == ConnectionState.Open)
                    cn.Close();
            }
        }

        private void btnBack_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        
    }
}