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 OnLineExam.BusinessLogicLayer;
 12using System.Data.SqlClient;
 13
 14public partial class Web_DepartmentManage : System.Web.UI.Page
 15...{
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!Page.IsPostBack)
 19        ...{
 20            string loginName = Session["userID"].ToString();
 21            Users user = new Users();
 22            user.LoadData(loginName);
 23            labUser.Text = user.UserName;
 24            GridViewBind();
 25        } 
 26    }
 27    private void GridViewBind()
 28    ...{
 29        Department department = new Department();//创建Users类对象user
 30        DataSet ds = department.QueryDepartment();//使用Users类QueryUsers方法查询所有用户信息
 31        GridView1.DataSource = ds;//为GridView控件指名数据源
 32        GridView1.DataBind();//GridView控件绑定数据
 33    }
 34    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
 35    ...{
 36        GridView1.EditIndex = -1;
 37        GridViewBind();
 38    }
 39    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
 40    ...{
 41        GridView1.PageIndex = e.NewPageIndex;
 42        GridViewBind();
 43    }
 44    //GridView控件RowDeleting事件
 45    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
 46    ...{
 47        string departmentid = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
 48        Department department = new Department();//创建Users类对象user
 49        if (department.DeleteByProc(departmentid))//根据主键使用DeleteByProc方法删除用户
 50        ...{
 51            Response.Write("<script language=javascript>alert('删除成功!')</script>");
 52        }
 53        else
 54        ...{
 55            Response.Write("<script language=javascript>alert('删除失败!')</script>");
 56        }
 57        GridView1.EditIndex = -1;
 58        GridViewBind();//重新绑定数据
 59
 60    }
 61    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
 62    ...{
 63        GridView1.EditIndex = e.NewEditIndex;  //GridView编辑项索引等于单击行的索引
 64        GridViewBind();
 65    }
 66    //GridView控件RowUpdating事件
 67    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 68    ...{
 69        string departmentid = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出记录的主键值
 70        Department department = new Department();
 71        department.DepartmentName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDepartmentName")).Text;
 72        if (department.UpdateByProc(departmentid))//使用Users类UpdateByProc方法修改用户信息
 73        ...{
 74            GridViewBind();
 75            Response.Write("<script language=javascript>alert('修改成功!')</script>");
 76        }
 77        else
 78        ...{
 79            Response.Write("<script language=javascript>alert('修改成功!')</script>");
 80        }
 81        GridView1.EditIndex = -1;
 82        GridViewBind();
 83    }
 84      protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
 85      ...{
 86        int i;
 87        //执行循环，保证每条数据都可以更新
 88        for (i = 0; i < GridView1.Rows.Count; i++)
 89        ...{
 90            //首先判断是否是数据行
 91            if (e.Row.RowType == DataControlRowType.DataRow)
 92            ...{
 93                //当鼠标停留时更改背景色
 94                e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='Aqua'");
 95                //当鼠标移开时还原背景色
 96                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
 97            }
 98        }
 99      }
100}
101
102