userinfo.aspx.cs

该商品销售管理系统是一个基于WEB的适应于小型企业的管理系统！可以实现商品基本信息的查询。添加

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;
using LoginCheckClass;

public partial class 系统管理_userinfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //判断用户是否登陆
        //获取session值，防止直接通过URL访问页面，确保安全性
        LoginCheck a = new LoginCheck();    //实例化LoginCheck类的对象
        a.check();  //调用LoginCheck类的方法

        try
        {
            using (SqlConnection connection = new SqlConnection(_connectString))    //创建连接对象
            {
                connection.Open();  //打开连接
                using (SqlCommand command = new SqlCommand())   //创建Command对象
                {
                    command.Connection = connection;
                    command.Parameters.Add("@id", SqlDbType.Int).Value = (int)Session["user_manager_ID"];   //获取上个页面的ID
                    command.CommandText = "SELECT dbo.tb_User.username FROM tb_User WHERE id= @id";
                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        usernameTB.Text = reader.GetString(0);
                        //passwordTB.Text = reader.GetString(1);
                        //AddtimeTB.Text = reader[2].ToString();

                    }

                }
            }
        }
        catch (Exception ex) 
        {
            Response.Write(@"<script>alert('系统错误')</script>");  //抛异常
        }

    }
    private static readonly string _connectString = System.Configuration.ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString;

    protected void close_Click(object sender, EventArgs e)
    {
        Response.Write("<script>window.close()</script>");
    }
    //重置按钮的单击事件
    protected void resetbtn_Click(object sender, EventArgs e)
    {
        //this.usernameTB.Text = "";
        this.passwordTB.Text = "";
        //this.AddtimeTB.Text = "";
    }
    //修改按钮的单击事件
    protected void alterbtn_Click(object sender, EventArgs e)
    {

        try
        {
            using (SqlConnection conn = new SqlConnection(_connectString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    code codeuser_edit = new code();    //实例化加密解密类
                    string Finaldata = codeuser_edit.Encrypt(this.passwordTB.Text); //定义加密字符串
                    cmd.Parameters.Clear(); //清空参数
                    cmd.CommandText = "UPDATE tb_User SET userpwd = @userpwd,AddTime=@AddTime WHERE username =@username";   //更新选中用户，密码
                    cmd.Parameters.Add("@userpwd", SqlDbType.VarChar, 50).Value = Finaldata;    //将加密字符串赋给密码字段
                    cmd.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = this.usernameTB .Text;
                    cmd.Parameters.Add("@AddTime", SqlDbType.DateTime).Value = DateTime.Now.ToLongTimeString();
                    cmd.ExecuteNonQuery();
                    this.passwordTB.Text = "";
                    Response.Write("<script>alert('修改密码成功！');</script>");
                }
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('系统错误！');</script>");    //抛出异常
        }
       
    }
}