teacher/TExaminationResult.aspx.cs

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

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

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 teacher_TExaminationResult : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["teacher"] == null)
        {
            Response.Redirect("../Login.aspx");
        }
    }
    protected void btnserch_Click(object sender, EventArgs e)
    {
        sel();
    }

    public void sel()
    {
        string sql = "select * from tb_score where 1=1 ";

        string[] arrstr ={ };
        if (Session["KCname"] != null)
        {
            arrstr = Session["KCname"].ToString().Split('-');
        }
        if (ddltype.SelectedValue == "0")
        {
            if (arrstr.Length <= 2)
            {
                sql += " and LessonName='" + arrstr[0] + "'";
            }
            else
            {
                sql += " and (LessonName='" + arrstr[0] + "' or LessonName='" + arrstr[1] + "')";
            }
        }
        else
        {
            if (arrstr.Length <= 2)
            {
                sql += " and LessonName='" + arrstr[0] + "' and " + ddltype.SelectedValue + " like '%" + txtkey.Text + "%'";
            }
            else
            {
                sql += " and (LessonName='" + arrstr[0] + "' or LessonName='" + arrstr[1] + "') and " + ddltype.SelectedValue + " like '%" + txtkey.Text + "%' ";
            }
        }
        sql += " order by id desc";

        BaseClass.BindDG(gvExaminationresult, "ID", sql, "result");