1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using MyLibrary.BusinessLogicLayer;
 12using System.Data.SqlClient;
 13
 14public partial class UsersManage_UserLists : System.Web.UI.Page
 15...{
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!this.IsPostBack)
 19        ...{
 20            GridViewBind();
 21        }
 22    }
 23
 24    //为GridView控件绑定数据
 25    private void GridViewBind()
 26    ...{
 27        Users user = new Users();//创建Users类对象user
 28        DataSet ds=user.QueryUsers();//使用Users类QueryUsers方法查询所有用户信息
 29        GridView1.DataSource = ds;//为GridView控件指名数据源
 30        GridView1.DataBind();//GridView控件绑定数据
 31    }
 32    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
 33    ...{
 34        if (((DropDownList)e.Row.FindControl("ddlPower")) != null)
 35        ...{
 36            DropDownList ddlpower = (DropDownList)e.Row.FindControl("ddlPower");
 37
 38            //  生成 DropDownList 的值，绑定数据
 39            string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;            
 40            DataSet ds = new DataSet();
 41            SqlConnection conn = new SqlConnection(connStr);
 42            if (conn.State.ToString() == "Closed") conn.Open();
 43            SqlDataAdapter da = new SqlDataAdapter("Proc_PowerList", conn);
 44            da.Fill(ds);
 45            if (conn.State.ToString() == "Open") conn.Close();
 46
 47            ddlpower.DataSource = ds.Tables[0].DefaultView;
 48            ddlpower.DataTextField = "Name";
 49            ddlpower.DataValueField = "ID";
 50            ddlpower.DataBind();            
 51            ddlpower.SelectedItem.Text = ((HiddenField)e.Row.FindControl("hdfPower")).Value;            
 52        }
 53
 54    }
 55    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
 56    ...{
 57        GridView1.EditIndex = -1;
 58        GridViewBind();
 59    }
 60    //GridView控件RowDeleting事件
 61    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
 62    ...{
 63        string userID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
 64        Users user = new Users();//创建Users类对象user
 65        if (user.DeleteByProc(userID))//根据主键使用DeleteByProc方法删除用户
 66        ...{
 67            Response.Write("<script language=javascript>alert('删除成功!')</script>");
 68        }
 69        else
 70        ...{
 71            Response.Write("<script language=javascript>alert('删除失败!')</script>");
 72        }
 73        GridView1.EditIndex = -1;
 74        GridViewBind();//重新绑定数据
 75        
 76    }
 77    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
 78    ...{
 79        GridView1.EditIndex = e.NewEditIndex;  //GridView编辑项索引等于单击行的索引
 80        GridViewBind();
 81    }
 82    //GridView控件RowUpdating事件
 83    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 84    ...{
 85        string userID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
 86        Users user = new Users();
 87        user.UserName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName")).Text;
 88        user.UserPower = int.Parse(((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlPower")).SelectedValue);   //取出修改后的值
 89        user.UserDepart = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDepart")).Text;
 90        user.UserTelephone = GridView1.Rows[e.RowIndex].Cells[4].Text;
 91        user.UserEMail = GridView1.Rows[e.RowIndex].Cells[5].Text;
 92        if (user.UpdateByProc(userID))//使用Users类UpdateByProc方法修改用户信息
 93        ...{
 94            Response.Write("<script language=javascript>alert('修改成功!')</script>");
 95        }
 96        else
 97        ...{
 98            Response.Write("<script language=javascript>alert('修改成功!')</script>");
 99        }
100        GridView1.EditIndex = -1;
101        GridViewBind();       
102    }
103}
104