PersonInfo/JoinStudyList.aspx.cs

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

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.IO;

namespace EasyExam.PersonInfo
{
	/// <summary>
	/// JoinStudyList 的摘要说明。
	/// </summary>
	public partial class JoinStudyList : System.Web.UI.Page
	{
		protected int RowNum=0,LinNum=0;

		bool bWhere;
		string strSql="";
		string myUserID="";
		string myLoginID="";
		PublicFunction ObjFun=new PublicFunction();
		int intUserID=0,intSubjectID=0,intChapterID=0,intSectionID=0;
	
		#region//*******初始化信息********
		protected void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				myUserID=Session["UserID"].ToString();
				myLoginID=Session["LoginID"].ToString();
				intUserID=Convert.ToInt32(myUserID);
			}
			catch
			{
			}
			if (myLoginID=="")
			{
				Response.Redirect("../Login.aspx");
			}
			intSubjectID=Convert.ToInt32(Request["SubjectID"]);
			intChapterID=Convert.ToInt32(Request["ChapterID"]);
			intSectionID=Convert.ToInt32(Request["SectionID"]);

			strSql=LabCondition.Text;
			if (!IsPostBack)
			{
				ShowSubjectInfo();//显示科目信息
				DDLSubjectName.Items.FindByText("--全部--").Selected=true;

				bWhere=true;
				strSql="select a.SectionID,c.SubjectName,b.ChapterName,a.SectionName,a.BrowNumber,d.LoginID as CreateLoginID from SectionInfo a LEFT OUTER JOIN ChapterInfo b ON b.ChapterID=a.ChapterID LEFT OUTER JOIN SubjectInfo c ON c.SubjectID=a.SubjectID LEFT OUTER JOIN UserInfo d ON d.UserID=b.CreateUserID where (c.BrowAccount=1 or (c.BrowAccount=2 and Exists(select * from SubjectUser d where d.SubjectID=c.SubjectID and d.UserID="+intUserID+")) or Exists(select * from UserInfo e,DeptInfo f,SubjectUser g where e.UserID="+intUserID+" and e.DeptID=f.DeptID and f.DeptID=g.DeptID and g.SubjectID=c.SubjectID))";
				//显示以科目为条件的数据
				if (intSubjectID!=0)