showtest.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 showTest : 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()).getTestDanXuanShow(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;
        }
        GridView1.DataBind();
    }


    
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        BindGrid();
    }
  
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string testId = GridView1.DataKeys[e.RowIndex].Value.ToString();
        int deletTest = (new projClass()).deleteTestInfo(testId);
        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;
            Session["courseId"] = this.lbl_courseId.Text;
            Response.Redirect("testUpdate.aspx");
        }

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

    }

    //确定事件
    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("testAdd.aspx");
    }
}