xzmanage.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 SubjectManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserID"] == null)
        {
            Response.Redirect("Default.aspx");
        }
        else
        {
            if (!IsPostBack)
            {
                string classifyID = Convert.ToString(Session["ClassifyID"]);
                tbClassifyID.Text = classifyID;
                if (tbClassifyID.Text == "")
                {
                    BindGrid();
                }
                else
                {
                    BindGrid1();
                }
            }
        }
    }
    void BindGrid()
    {
        DataSet ds = new DataSet();
        ds = (new UserDB()).getTestAllInfo();
        DataTable dt = ds.Tables["TestInfo"];
        DataView dv = new DataView(dt);
        
        if (DropDownList1.SelectedItem.Value == "IfIssue")
            dv.RowFilter = "IfIssue like '%" + DropDownList2.SelectedItem.Value + "%'";
        else dv.RowFilter = "" + DropDownList1.SelectedItem.Value.ToString() + " like '%" + tbSearch.Text.Trim() + "%'";
        GridView1.DataSource = dv;
        lblCount.Text = dv.Count.ToString();
        if (dv.Count == 0)
        {
            lbl_noResult.Visible = true;
            GridView1.Visible = false;
        }
        else
        {
            lbl_noResult.Visible = false;
            GridView1.Visible = true;
        }
        GridView1.AllowPaging = true;
        GridView1.PageSize = 5;
        GridView1.DataBind();

    }
    void BindGrid1()
    {
        DataSet ds = new DataSet();
        ds = (new UserDB()).getTestInfoAsClassifyID(tbClassifyID.Text.Trim());
        DataTable dt = ds.Tables["TestInfo"];
        DataView dv = new DataView(dt);
        if (DropDownList1.SelectedItem.Value == "IfIssue")
            dv.RowFilter = "IfIssue like '%" + DropDownList2.SelectedItem.Value + "%'";
        else dv.RowFilter = "" + DropDownList1.SelectedItem.Value.ToString() + " like '%" + tbSearch.Text.Trim() + "%'";
        GridView1.DataSource = dv;
        lblCount.Text = dv.Count.ToString();
        if (dv.Count == 0)
        {
            lbl_noResult.Visible = true;
            GridView1.Visible = false;
        }
        else
        {
            lbl_noResult.Visible = false;
            GridView1.Visible = true;
        }
        GridView1.AllowPaging = true;
        GridView1.PageSize = 5;
        GridView1.DataBind();

    }
    protected void imbtnAdd_Click(object sender, ImageClickEventArgs e)
    {
        Response.Write("<script>window.open('AddXZ.aspx','right');</script>");
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (DropDownList1.SelectedItem.ToString() == "是否发布")
            DropDownList2.Visible = true;
            else DropDownList2.Visible = false;
    }
    protected void imbtnSearch_Click(object sender, ImageClickEventArgs e)
    {
        ViewState.Clear();
        GridView1.PageIndex = 0;//从第一页开始显示数据
        if (tbClassifyID.Text == "")
        {
            BindGrid();
        }
        else
        {
            BindGrid1();
        }
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        if (tbClassifyID.Text == "")
        {
            BindGrid();
        }
        else
        {
            BindGrid1();
        }
        GridView1.DataBind();
    }
}