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