board.aspx.cs

网上考试系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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.Data.SqlClient;

namespace ClassOnline
{
	/// <summary>
	/// Board 的摘要说明。
	/// </summary>
	public class Board : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataList dltBoard;
		protected System.Web.UI.WebControls.Label lblName;
		protected System.Web.UI.WebControls.TextBox txtTheme;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox txtContent;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Button btnOK;
		string strSQL;
		int i;
		SqlDataAdapter da;
		DataSet ds;
		SqlDataReader dr;
		SqlCommand objcmd;
		SqlConnection objconn;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Session.Count==0) Page.Response.Redirect("default.aspx");
			else 
				if(Session["UserID"].ToString()=="") Page.Response.Redirect("default.aspx");
			//Page.Response.Write("One time");
			//创建数据库连接并打开
            objconn =new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			objconn.Open();
			//定义SQL语句
			strSQL="select BID,BTheme,BUID,BDate,BEditer,BEdittime,BCnt,BTop from Board where BCID="+Page.Request["CID"].ToString()+" and BDelFlag='0' ORDER BY BTop,BDate DESC";
			
			da=new SqlDataAdapter(strSQL,objconn);
			ds=new DataSet();

			da.Fill(ds,"board");
			ds.Tables["board"].Columns.Add("editinfo");
			ds.Tables["board"].Columns.Add("editurl");
			ds.Tables["board"].Columns.Add("delurl");
			ds.Tables["board"].Columns.Add("name");
			ds.Tables["board"].Columns.Add("imgurl");
			ds.Tables["board"].Columns.Add("topurl");

			for(i=0;i<ds.Tables[0].Rows.Count;i++)
			{
				strSQL="select UserName from UserInfo where UserID="+ds.Tables[0].Rows[i]["BUID"].ToString();
				objcmd=new SqlCommand(strSQL,objconn);
				dr=objcmd.ExecuteReader();
				while(dr.Read())
					ds.Tables[0].Rows[i]["name"]=dr[0].ToString();
				objcmd.Dispose();
				dr.Close();
			}

			for(i=0;i<ds.Tables[0].Rows.Count;i++)
				if(ds.Tables[0].Rows[i]["BEditer"].ToString()!="0")
				{
					strSQL="select UserName from UserInfo where UserID="+ds.Tables[0].Rows[i]["BEditer"].ToString();
					objcmd=new SqlCommand(strSQL,objconn);
					dr=objcmd.ExecuteReader();
					while(dr.Read())
						ds.Tables[0].Rows[i]["editinfo"]="[此贴最后由 <font color=red>"+dr[0].ToString()+"</font> 在<font color=red>"+ds.Tables[0].Rows[i]["BEdittime"].ToString()+"</font>编辑]";
					objcmd.Dispose();
					dr.Close();
				}
			strSQL="select CManager1,CManager2 from ClassInfo where CID="+Page.Request["CID"].ToString();
			objcmd=new SqlCommand(strSQL,objconn);
			dr=objcmd.ExecuteReader();
			while(dr.Read())
			{
			
				for(i=0;i<ds.Tables[0].Rows.Count;i++)
				{
					ds.Tables[0].Rows[i]["imgurl"]="<img src=image/"+ds.Tables[0].Rows[i]["BTop"].ToString()+".gif>";//添加贴子状态图片				
					if(Session["UserID"].ToString()==dr[0].ToString()|Session["UserID"].ToString()==dr[1].ToString())//为管理员添加固顶选项
					
						if(ds.Tables[0].Rows[i]["BTop"].ToString()=="1")
							ds.Tables[0].Rows[i]["topurl"]="<A href=lockmsg.aspx?msgid="+ds.Tables[0].Rows[i]["BID"].ToString()+">[固顶]</A>";
						else
							ds.Tables[0].Rows[i]["topurl"]="<A href=ulockmsg.aspx?msgid="+ds.Tables[0].Rows[i]["BID"].ToString()+">[取消固顶]</A>";

							
					if(Session["UserID"].ToString()==ds.Tables[0].Rows[i]["BUID"].ToString()|Session["UserID"].ToString()==dr[0].ToString()|Session["UserID"].ToString()==dr[1].ToString())//为管理员和贴子作者添加编辑删除选项
					{
						ds.Tables[0].Rows[i]["editurl"]="<A href=editmsg.aspx?msgid="+ds.Tables[0].Rows[i]["BID"].ToString()+">[编辑]</A>";
						ds.Tables[0].Rows[i]["delurl"]="<A href=delmsg.aspx?msgid="+ds.Tables[0].Rows[i]["BID"].ToString()+">[删除]</A>";					
					}
				}
				
			}
			objcmd.Dispose();
			dr.Close();

			strSQL="select UserName from UserInfo where UserID="+Session["UserID"].ToString();
			objcmd=new SqlCommand(strSQL,objconn);
			dr=objcmd.ExecuteReader();
			while(dr.Read())
				lblName.Text=dr[0].ToString();
			objcmd.Dispose();
			dr.Close();

			
			dltBoard.DataSource=ds.Tables["board"].DefaultView;
			dltBoard.DataBind();
			ds.Dispose();
			objconn.Close();

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnOK_Click(object sender, System.EventArgs e)
		{
			//创建数据库连接并打开
			objconn =new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			objconn.Open();
			strSQL="Insert INTO Board(BTheme,BUID,BCnt,BDelFlag,BCID) Values ('"+txtTheme.Text.Replace("<","&lt").Replace(">","&gt").Replace(" ","&nbsp;").Replace("\n","<br>")+"',"+Session["UserID"].ToString()+",'"+txtContent.Text+"','0',"+Page.Request["CID"].ToString()+")";
		
			 objcmd=new SqlCommand(strSQL,objconn);
		
			objcmd.ExecuteNonQuery();
			objcmd.Dispose();
			objconn.Close();
			Page.Response.Redirect("board.aspx?CID="+Page.Request["CID"].ToString());
		}
	}
}