MyExam/JoinExam.aspx.cs

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

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

using System;
using System.Data;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class MyExam_JoinExam : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Cookies["roleid"] != null)
        {
            Authority myauthority = new Authority();
            int RoleID = Convert.ToInt16(Server.HtmlEncode(Request.Cookies["roleid"].Value));
            int ModuleID = 37;
            if (myauthority.QXExists(RoleID, ModuleID))
            {
                if (!IsPostBack)
                {
                    binddr();
                }

            }
            else
            {
                MessageBox.ShowAndRedirect(this.Page, "对不起！您无权操作此版块。", "../Main.aspx");
            }
        }
        else
        {
            MessageBox.ShowAndRedirect(this.Page, "对不起！您还没有登录系统。", "../Logout.aspx");
        }
    }
    //绑定用户记录
    public void binddr()
    {
        Test my = new Test();
        //string sqlstr = "1=1 ";
        //sqlstr = sqlstr + " and  ClassID  like '%|" + Server.HtmlEncode(Request.Cookies["classid"].Value) + "|%'   order by TestID desc ";
        string sqlstr = " select * from Test where ClassID  like '%|" + Server.HtmlEncode(Request.Cookies["classid"].Value) + "|%'  and  TestID not in (select TextID from StuResult where StuID = " + Convert.ToInt16(Server.HtmlEncode(Request.Cookies["userid"].Value)) + " )  order by TestID desc";
        DataView dv = my.GetListA(sqlstr).Tables[0].DefaultView;
        PagedDataSource pds = new PagedDataSource();
        AspNetPager1.RecordCount = dv.Count;
        pds.DataSource = dv;
        pds.AllowPaging = true;
        pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
        pds.PageSize = AspNetPager1.PageSize;
        repCategory.DataSource = pds;
        repCategory.DataBind();
    }
    // 分页
    protected void AspNetPager1_PageChanged(object src, EventArgs e)
    {
        binddr();
    }
    //查找
    protected void butSelect_Click(object sender, ImageClickEventArgs e)
    {
        binddr();
    }