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 MyOnLineExam.BusinessLogicLayer;
12
13public partial class Web_admin_UserLists : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!IsPostBack)
18        ...{
19            ImageButton1.Attributes.Add("OnClick", "javascript:return confirm('确实要删除这些用户吗？')");
20            InitData();  //绑定用户信息        
21        }
22    }
23    //初始化用户表格
24    protected void InitData()
25    ...{
26        Users user = new Users();           //创建Users对象
27        DataSet ds = user.QueryUsers();     //调用QueryUsers方法查询用户并将查询结果放到DataSet数据集中
28        GridView1.DataSource = ds;          //为GridView控件指名数据源        
29        GridView1.DataBind();               //绑定数据
30    }
31    //GridView控件RowDeleting事件
32    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
33    ...{
34        Users user = new Users();           //创建Users对象
35        string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
36        if (user.DeleteByProc(ID))
37        ...{
38            Response.Write("<script language=javascript>alert('成功删除该用户！')</script>");
39        }
40        else
41        ...{
42            Response.Write("<script language=javascript>alert('删除该用户失败！')</script>");
43        }
44        GridView1.EditIndex = -1;
45        InitData();
46    }
47    //GridView控件RowUpdating事件
48    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
49    ...{
50        string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
51        Users user = new Users();               //创建Users对象
52        user.UserName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName")).Text;
53        user.UserPower = int.Parse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtPower")).Text);        
54        if (user.UpdateByProc(ID))//使用Users类UpdateByProc方法修改用户信息
55        ...{
56            Response.Write("<script language=javascript>alert('修改成功!')</script>");
57        }
58        else
59        ...{
60            Response.Write("<script language=javascript>alert('修改失败!')</script>");
61        }
62        GridView1.EditIndex = -1;
63        InitData();
64    }
65    //GridView控件RowCanceling事件
66    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
67    ...{
68        GridView1.EditIndex = -1;
69        InitData();
70    }
71    //GridView控件RowEditing事件
72    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
73    ...{        
74        GridView1.EditIndex = e.NewEditIndex;  //GridView编辑项索引等于单击行的索引
75        InitData();
76    }
77    //批量删除事件
78    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
79    ...{
80        Users user = new Users(); //创建Users对象      
81        foreach (GridViewRow dr in GridView1.Rows)//对GridView中每行进行判断
82        ...{
83            if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果该行复选按钮选择则删除
84            ...{
85                string ID = ((Label)dr.FindControl("Label1")).Text;//取出主键
86                user.UserID = ID;
87                user.DeleteByProc(ID);//调用Users类DeleteByProc方法删除用户
88            }
89        }
90    }
91}
92