usermanage.aspx.cs

电子册

using System;
using System.Data;
using System.Data.OleDb;
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;

public partial class userManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        DataAccess db = new DataAccess();

        datasource.ConnectionString = db.getConnstr();
    }

    /// <summary>
    /// 用户列表GridView绑定事悠扬
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void userList_DataBound(object sender, EventArgs e)
    {
        int i = 0;
        int cellNum = 5;

        // 遍列所有数据
        while (i < userList.Rows.Count)
        {
            GridViewRow gvr = userList.Rows[i];

            //判断用户类型，根据类型标识显示为中文信息
            if (gvr.Cells[cellNum].Text == "1")
            {
                gvr.Cells[cellNum].Text = "系统管理员";
            }
            if (gvr.Cells[cellNum].Text == "2")
            {
                gvr.Cells[cellNum].Text = "普通用户";
            }
            ++i;
        }
    }

    // 翻页时处理
    protected void userList_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        userList.PageIndex = e.NewPageIndex;
        userList.DataBind();
    }
    protected void userList_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Select")
        {
            plEdit.Visible = true;
        }
        if (e.CommandName == "New")
        {
            txtUName.ReadOnly = false;
            UserID.Value = "";
            txtUCName.Text = "";
            txtUName.Text = "";
            txtPwd.Text = "";
            plEdit.Visible = true;
        }
    }

    /// <summary>
    /// 保存数据
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button1_Click(object sender, EventArgs e)
    {
        plEdit.Visible = false;

        // 创建数据连接
        DataAccess db = new DataAccess();

        // 创建 SQL 命令对象
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        try
        {
            // 判断执行存储过程为添加还是更新数据
            if (UserID.Value != "")
            {
                // 更新数据存储过程
                // 设置存储过程参数
                oleComm.CommandText = "UpdateUser";
                oleComm.CommandType = CommandType.StoredProcedure;
                oleComm.Parameters.Add("@UserID", OleDbType.Integer, 4);
                oleComm.Parameters.Add("@UserName", OleDbType.VarChar, 40);
                oleComm.Parameters.Add("@UserCName", OleDbType.VarChar, 20);
                oleComm.Parameters.Add("@Password", OleDbType.VarChar, 40);
                oleComm.Parameters.Add("@UserType", OleDbType.TinyInt, 1);

                oleComm.Parameters["@UserID"].Value = UserID.Value;
                oleComm.Parameters["@UserName"].Value = txtUName.Text;
                oleComm.Parameters["@UserCName"].Value = txtUCName.Text;
                oleComm.Parameters["@Password"].Value = txtPwd.Text;
                oleComm.Parameters["@UserType"].Value = Convert.ToInt16(listType.Text);
            }
            else
            {
                // 添加数据存储过程
                // 设置存储过程参数
                oleComm.CommandText = "AddUser";
                oleComm.CommandType = CommandType.StoredProcedure;
                oleComm.Parameters.Add("@UserName", OleDbType.VarChar, 40);
                oleComm.Parameters.Add("@UserCName", OleDbType.VarChar, 20);
                oleComm.Parameters.Add("@Password", OleDbType.VarChar, 40);
                oleComm.Parameters.Add("@UserType", OleDbType.TinyInt, 1);

                oleComm.Parameters["@UserName"].Value = txtUName.Text;
                oleComm.Parameters["@UserCName"].Value = txtUCName.Text;
                oleComm.Parameters["@Password"].Value = txtPwd.Text;
                oleComm.Parameters["@UserType"].Value = Convert.ToInt16(listType.Text);
            }
            
            // 执行存储过程
            oleComm.ExecuteNonQuery();
        }
        catch { }
        finally
        {
            // 关闭数据连接
            db.Close();
        }

        // 绑定数据
        userList.DataBind();
    }

    /// <summary>
    /// 选择要修改的数据时将用户信息显示到指定控件中
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void userList_SelectedIndexChanged(object sender, EventArgs e)
    {
        // 获取用户ID
        int key = Convert.ToInt32(userList.DataKeys[userList.SelectedIndex].Value.ToString());

        // 创建数据连接
        DataAccess db = new DataAccess();


        // 创建 SQL 命令对象
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        try
        {
            // 设置存储过程参数
            oleComm.CommandText = "GetUserInfo";
            oleComm.CommandType = CommandType.StoredProcedure;
            oleComm.Parameters.Add("@UserID", OleDbType.Integer, 4);
            oleComm.Parameters["@UserID"].Value = key;

            // 创建适配器
            OleDbDataReader da = oleComm.ExecuteReader();

            // 开始读取数据
            da.Read();

            // 将用户信息分别显示到指定控件中
            UserID.Value = da.GetValue(0).ToString();
            txtUName.Text = da.GetValue(1).ToString();
            txtUName.ReadOnly = true;
            txtUCName.Text = da.GetValue(2).ToString();
            txtPwd.Text = da.GetValue(3).ToString();
            listType.SelectedValue = da.GetValue(4).ToString();
        }
        catch { }
        finally
        {
            // 关闭数据连接
            db.Close();
        }
    }
}