showwenda.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;

public partial class showWenDa : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["adminId"] == null)
        {
            Response.Redirect("Default.aspx");
        }
        else
        {
        if (!IsPostBack)
        {

            DataSet ds = new DataSet();
            ds = (new projClass()).getCourses();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                ddl_course.Items.Add(row["courseName"].ToString());
            }
            if (Session["courseId"] != null)
            {
                string courseId = Convert.ToString(Session["courseId"]);
                lbl_courseId.Text = courseId;
                ddl_course.SelectedValue = (new projClass()).getCourseNameAsCourseId(courseId);
                BindGrid();
            }

        }
        }
    }

    DataView dv;
    void BindGrid()
    {
        string courseId = lbl_courseId.Text;
        DataSet ds = new DataSet();
        ds = (new projClass()).getWenDaShow(courseId);
        DataTable dt = ds.Tables["testInfo"];
        //DataView 
        dv = new DataView(dt);
        if (rbtn_showall.Checked)
        {
            if (this.ddl_course.SelectedItem.Text.Trim() != "")
                dv.RowFilter = "testCourse like '%" + (new projClass()).getCourseIdAsCourseName(this.ddl_course.SelectedItem.Text.Trim()) + "%'";
        }
        else if (rbtn_showpub.Checked)
            dv.RowFilter = "pub like '是' and testCourse like '%" + (new projClass()).getCourseIdAsCourseName(this.ddl_course.SelectedItem.Text.Trim()) + "%' ";
        else if (rbtn_shownopub.Checked)
            dv.RowFilter = "pub like '否' and testCourse like '%" + (new projClass()).getCourseIdAsCourseName(this.ddl_course.SelectedItem.Text.Trim()) + "%'";
        this.GridView1.DataSource = dv;
        if (dv.Count == 0)
        {
            lbl_noResult.Visible = true;
            GridView1.Visible = false;
        }
        else
        {
            lbl_noResult.Visible = false;
            GridView1.Visible = true;
        }
        Session["courseId"] = this.lbl_courseId.Text;
        GridView1.DataBind();
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        BindGrid();
    }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Detail")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            DataKey key = GridView1.DataKeys[index];
            string testId = key.Value.ToString();
            Session["testId"] = testId;
            Response.Redirect("updateWenDa.aspx");
        }
    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string testId = GridView1.DataKeys[e.RowIndex].Value.ToString();
        int deletTest = (new projClass()).deleteTestWenDaInfo(testId);
        BindGrid();
    }

    protected void ddl_course_SelectedIndexChanged(object sender, EventArgs e)
    {
        string courseId = this.lbl_courseId.Text; 
        string courseName = ddl_course.SelectedItem.Text;
        courseId = (new projClass()).getCourseIdAsCourseName(courseName);
        this.lbl_courseId.Text = courseId;
        Session["courseId"] = this.lbl_courseId.Text;
    }

    //确定事件
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        BindGrid();
    }

    //新增事件
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        Session["courseId"] = this.lbl_courseId.Text;
        Response.Redirect("addWenDa.aspx");
    }

}