select_del_examcard.aspx.cs

项目开发完整系统

using System;
using System.Data;
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;
using XTeamBBL;

public partial class teaching_manage_examcard_set_select_del_examcard : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btn_select_Click(object sender, EventArgs e)
    {
        int studentID = Convert.ToInt32(examcard_name.SelectedValue.ToString());
        string sql = "select * from examcard_info where student_ID="+studentID;
        DataSet ds = examcard.select_examcard(sql);
        examcardView.DataSource = ds;
        examcardView.DataBind();
    }
    private void Bind()
    {
        string sql = "select * from examcard_info";
        DataSet ds = examcard.select_examcard(sql);
        examcardView.DataSource = ds;
        examcardView.DataBind();
    }
    protected void examcardView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int examcardID = Convert.ToInt32(examcardView.DataKeys[e.RowIndex].Value.ToString());
        examcard ec = new examcard(examcardID);
        Boolean flag=examcard.del_examcard(ec);
        if (flag) Response.Write("<script>alert('删除成功');</script>");
        else Response.Write("<script>alert('删除失败');</script>");
        Bind();
    }
    protected void examcardView_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string examcardtype = ((TextBox)(examcardView.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
        string examcardnum = ((TextBox)(examcardView.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
        int examcardID = Convert.ToInt32(examcardView.DataKeys[e.RowIndex].Value.ToString());
        examcard ec = new examcard(examcardID, examcardtype, examcardnum);
        Boolean flag=examcard.alt_examcard(ec);
        if (flag) Response.Write("<script>alert('修改成功');</script>");
        else Response.Write("<script>alert('修改失败');</script>");
        examcardView.EditIndex = -1;
        Bind();

    }
    protected void examcardView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        examcardView.EditIndex = e.NewEditIndex;
        Bind();
    }
    protected void examcardView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        examcardView.EditIndex = -1;
        Bind();
    }
    protected void examcardView_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
           
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E0E0E0';this.style.cursor='hand'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='white'");

        }
    }
}