?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;

        // 遍列所有數(shù)據(jù)
        while (i < userList.Rows.Count)
        {
            GridViewRow gvr = userList.Rows[i];

            //判斷用戶類型，根據(jù)類型標識顯示為中文信息
            if (gvr.Cells[cellNum].Text == "1")
            {
                gvr.Cells[cellNum].Text = "系統(tǒng)管理員";
            }
            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>
    /// 保存數(shù)據(jù)
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button1_Click(object sender, EventArgs e)
    {
        plEdit.Visible = false;

        // 創(chuàng)建數(shù)據(jù)連接
        DataAccess db = new DataAccess();

        // 創(chuàng)建 SQL 命令對象
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        try
        {
            // 判斷執(zhí)行存儲過程為添加還是更新數(shù)據(jù)
            if (UserID.Value != "")
            {
                // 更新數(shù)據(jù)存儲過程
                // 設置存儲過程參數(shù)
                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
            {
                // 添加數(shù)據(jù)存儲過程
                // 設置存儲過程參數(shù)
                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);
            }
            
            // 執(zhí)行存儲過程
            oleComm.ExecuteNonQuery();
        }
        catch { }
        finally
        {
            // 關閉數(shù)據(jù)連接
            db.Close();
        }

        // 綁定數(shù)據(jù)
        userList.DataBind();
    }

    /// <summary>
    /// 選擇要修改的數(shù)據(jù)時將用戶信息顯示到指定控件中
    /// </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());

        // 創(chuàng)建數(shù)據(jù)連接
        DataAccess db = new DataAccess();


        // 創(chuàng)建 SQL 命令對象
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        try
        {
            // 設置存儲過程參數(shù)
            oleComm.CommandText = "GetUserInfo";
            oleComm.CommandType = CommandType.StoredProcedure;
            oleComm.Parameters.Add("@UserID", OleDbType.Integer, 4);
            oleComm.Parameters["@UserID"].Value = key;

            // 創(chuàng)建適配器
            OleDbDataReader da = oleComm.ExecuteReader();

            // 開始讀取數(shù)據(jù)
            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
        {
            // 關閉數(shù)據(jù)連接
            db.Close();
        }
    }
}