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

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

    }

    private void init_KC_Arr()
    {
        string sql = "select exam_ID,exclassroom_ID,exam_time,teacher_ID1,teacher_ID2,exam_stunum,exam_type from examArrange";
        DataSet ex_que = KC_Arr.que_examArry(sql);
        GridView1.DataSource = ex_que;
        GridView1.DataBind();
        GridView1.Visible = true;
    }

    protected void BtnQue_Click(object sender, EventArgs e)
    {
        string select_sql = "select exam_ID,exclass_ID,excourse_ID,exclassroom_ID,exam_time,teacher_ID1,teacher_ID2,exam_stunum,exam_type from examArrange where";
        if (DListType.SelectedItem.Text != "----请选择----")
            select_sql = select_sql + " exam_type='" + DListType.SelectedValue + "'";
        else
            select_sql = select_sql + " exam_type like '%'";
        if (DListCourse.SelectedItem.Text != "----请选择----")
            select_sql = select_sql + " and excourse_ID=" + Convert.ToInt32(DListCourse.SelectedValue);
        else
            select_sql = select_sql + " excourse_ID like '%'";
        if (DListClass.SelectedItem.Text != "----请选择----")
            select_sql = select_sql + " and exclass_ID=" + Convert.ToInt32(DListClass.SelectedValue);
        else
            select_sql = select_sql + " and exclass_ID like '%'";
        if (DListClassroom.SelectedItem.Text != "----请选择----")
            select_sql = select_sql + " and exclassroom_ID=" + Convert.ToInt32(DListClassroom.SelectedValue);
        else
            select_sql = select_sql + " exclassroom_ID like '%'";
        DataSet ex_que = KC_Arr.que_examArry(select_sql);
        GridView1.DataSource = ex_que;
        GridView1.DataBind();
        GridView1.Visible = true;
    }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            ((LinkButton)(e.Row.Cells[9].Controls[0])).Attributes.Add("onclick", "return confirm('确定要删除吗')");
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E0E0E0';this.style.cursor='hand'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='white'");

        }
    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Boolean flag = true;
        int exam_ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
        KC_Arr kcArr = new KC_Arr(exam_ID);
        try
        {
            flag = KC_Arr.del_examArry(kcArr);
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('删除失败,可能存在数据依赖,请先删除其他数据,再执行些操作');</script>");
        }
        finally
        {
            if (flag) { Response.Write("<script>alert('删除成功');</script>"); }
            else Response.Write("<script>alert('删除失败');</script>");
            init_KC_Arr();
        }
    }
}