modipwd.aspx.cs

本系统主要内容是围绕图书销售管理系统而展开讨论的

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class ZDWH_ModiPwd : System.Web.UI.Page
{
    string UserID;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Params["UserID"] != null)
        {
            if (!VCUtilities.IsValidUser(Request.Params["UserID"]))
            {
                Msg.Text = "对不起，该用户已不存在，可能已被其他用户删除！";
            }
        }
    }
    protected void CloseBtn_Click(object sender, EventArgs e)
    {
        Response.Redirect("userinfo.aspx");
    }
    protected void SubmitBtn_Click(object sender, EventArgs e)
    {        
        string codeStr = Request.Params["UserID"];
        string oldPwd = oldpwd.Text;
        string newPwd = newpwd.Text;
        string comfirmPwd = Rnewpwd.Text;
        if (Page.IsValid)
        {
            SqlDataReader Dr = null; ;
            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connection"]);
            SqlCommand cmd = new SqlCommand("select * from userinfosheet where code='" + codeStr + "'",conn);
            conn.Open();
            Dr = cmd.ExecuteReader();
            if (Dr.Read())
            {
                if (newPwd.Trim() != comfirmPwd.Trim())
                    Msg.Text = "两次密码不符，请重新输入！";
                else if (oldPwd.Trim()!=Dr["password"].ToString())
                {
                    Msg.Text = "旧密码错误，请重新输入！";
                }
                else
                {
                    Dr.Close();
                    cmd = new SqlCommand("update userinfosheet set password='" + newPwd.Trim() + "' where code='" +codeStr.Trim()+ "'", conn);
                    cmd.ExecuteNonQuery();
                    conn.Close();
                    Msg.Text = "密码修改成功！";
                }
            }
        }

    }
}