modpwd.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 UserCenter_ModPwd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btn_mod_Click(object sender, EventArgs e)
    {
        if (CheckPwd()  && Page.IsValid)
        {
            ModPassword();
            Response.Redirect("SuccessEdit.aspx");

        }
    }
    public bool CheckPwd()
    {
        string password = tbx_orignpwd.Text;
        if(password == "")
        {
            lbl_msg.Visible=true;
            lbl_msg.Text="您没有输入原始密码！";
            return false;
        }
        else
        {
            //读取数据库连接字符串
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
            //创建数据库连接
            SqlConnection myconn = new SqlConnection(settings);
            //打开数据库连接
            myconn.Open();
            
            SqlCommand mycmd = new SqlCommand("UserPwd", myconn);
            //设定命令类型为存储过程
            mycmd.CommandType=CommandType.StoredProcedure;

            //参数
            SqlParameter paraUserid = new SqlParameter("@UserID", SqlDbType.Int);
            paraUserid.Value = Convert.ToInt32(Session["UserID"].ToString());
            mycmd.Parameters.Add(paraUserid);

            SqlParameter paraPassword  = new SqlParameter("@Password", SqlDbType.NVarChar,12);
            paraPassword.Value=tbx_orignpwd.Text.Trim();
            mycmd.Parameters.Add(paraPassword);

            SqlDataReader dr = mycmd.ExecuteReader();

            if(dr.Read())
            {
                myconn.Close();
                return true;
            }
            else
            {
                lbl_msg.Visible=true;
                lbl_msg.Text="原始密码不正确！";
                return false;
            }
            
        }
    }
    public void ModPassword()
    {
        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        //创建数据库连接
        SqlConnection myconn = new SqlConnection(settings);
        //打开数据库连接
        myconn.Open();

        SqlCommand mycmd = new SqlCommand("ModPwd", myconn);
        //设定命令类型为存储过程
        mycmd.CommandType = CommandType.StoredProcedure;

        //参数
        SqlParameter paraUserid = new SqlParameter("@UserID", SqlDbType.Int);
        paraUserid.Value = Convert.ToInt32(Session["UserID"].ToString());
        mycmd.Parameters.Add(paraUserid);

        SqlParameter paraPassword = new SqlParameter("@Password", SqlDbType.NVarChar, 12);
        paraPassword.Value = tbx_newpwd.Text.Trim();
        mycmd.Parameters.Add(paraPassword);

        mycmd.ExecuteNonQuery();
        myconn.Close();
    }


    protected void btn_back_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Default.aspx");
    }
}