exam/Manage2.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

public partial class exam_Manage2 : System.Web.UI.Page
{
   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            (Master.FindControl("Label1") as Label).Text = "自动安排";
            DataSet ds = SqlHelper.ExecuteforDataSet("select cid,cname from classes");
            ddlcid.DataSource = ds;
            ddlcid.DataTextField = "cname";
            ddlcid.DataValueField = "cid";
            ddlcid.DataBind();
            ddlcid.Items.Insert(0, new ListItem("---全部---", ""));
            ds = SqlHelper.ExecuteforDataSet("select id,name1 from course");
            ddlid.DataSource = ds;
            ddlid.DataTextField = "name1";
            ddlid.DataValueField = "id";
            ddlid.DataBind();
            ddlid.Items.Insert(0, new ListItem("---全部---", ""));

            BindData();
        }
    }

    // 绑定
    private void BindData()
    {
        string where = " where 1=1 ";

        if (ddlid.SelectedValue != "")
        {
            where += " and a.id=" + ddlid.SelectedValue + "";
        }

        if (ddlcid.SelectedValue != "")
        {
            where += " and a.cid=" + ddlcid.SelectedValue + "";
        }

        string sql = "select a.*,b.cname,name1,rname,e.tname as tname1,f.tname as tname2 from exam a left join classes b on a.cid=b.cid left join course c on a.id=c.id left join classroom d on a.rid=d.rid" +
            " left join teachers e on a.tid1=e.tid left join teachers f on a.tid2=f.tid ";

        GridView1.DataSource = SqlHelper.ExecuteforDataSet(sql+ where + " order by eid desc");
        GridView1.DataBind();

    }

    /// <summary>