adminadd.aspx.cs

小型BBS 实现基本的论坛功能论坛风格参照了、CSDN论坛、LB论坛、动网论坛的风格,整个论坛的数据库结构设计一流,所以论坛运行速度一流,功能一流 数据库采用、SQL Server

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.Data.SqlClient;

namespace Forum
{
	/// <summary>
	/// adminadd 的摘要说明。
	/// </summary>
	public partial class adminadd : System.Web.UI.Page
	{
		public TimeSpan Timesp ;
		public SqlDataReader dr;
		public String Beg;
		public string sqlstring;
		public string LastFid;
		public SqlConnection MyConn;
		public DateTime StartTime ;
		public DateTime StopTime ;
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Request.QueryString["Beg"] == null)
			{
				sqlstring = "Select TopicTotal,id,Begin1,1End1,TopicName,TopicDes,Des,Toastmaster,ReplyTotal  from  ForumInform order by Begin1  asc ";
			}
			else 
			{
				Beg=Request.QueryString["Beg"].ToString();
				sqlstring = "Select TopicTotal,id,Begin1,End1,TopicName,TopicDes,Des,Toastmaster,ReplyTotal  from  ForumInform where Begin1="+Beg+" order by Begin1  asc ";
			}
			DateTime now = DateTime.Now;
			StartTime = DateTime.Now;
			//创建连接
			Forum ForumDBO = new Forum();
			MyConn=ForumDBO.Open();
			if (ForumDBO.adminck() == "Wrong")
			{
				Response.Redirect("Exceptions.aspx");
			}
			SqlCommand com_TopicTotal = new SqlCommand(sqlstring,MyConn);
			dr = com_TopicTotal.ExecuteReader();
		}

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

		}
		#endregion
		public void display()
		{
			int Beg;
			int End;
			int n = 0;
			String TopicName;
			String TopicDes;
			
			String Toastmaster;
			String ReplyTotal;
			String TopicTotal;
			String des;
			while(dr.Read())
			{
				Beg = (int)dr["Begin1"];
				End = (int)dr["End1"];
				TopicName = dr["TopicName"].ToString();
				TopicDes = dr["TopicDes"].ToString();				
				Toastmaster = dr["Toastmaster"].ToString();
				ReplyTotal = dr["ReplyTotal"].ToString();
				des = dr["des"].ToString();
				TopicTotal = dr["TopicTotal"].ToString();
				LastFid = dr["Begin1"].ToString();
				if (n == Beg)
				{
					Response.Write("<tr ><td width='5%'  align=center></td><td colspan=2>");
					Response.Write("<a href='Thread.aspx?Beg="+Beg.ToString()+"&End="+End.ToString()+"&page=1"+"'><b>1"+TopicDes+"</b></a><br>");
					Response.Write("</td></tr>");           
				}
				else 
				{
					Response.Write("<tr ><td  colspan=3 bgcolor=#E8F3F9 ><b>"+TopicName+"</b></a><a href='Adminattribu.aspx?action=addclass1&Beg="+Beg+"&TopicName="+TopicDes+"'><font color=red>  添加版块</font></a></td></tr>");
					Response.Write("<tr ><td width='5%'  align=center></td><td colspan=2>");
					Response.Write("<a href='Thread.aspx?Beg="+Beg.ToString()+"&End="+End.ToString()+"&page=1"+"'><b>"+TopicDes+"</b></a><br>");
					Response.Write("</td></tr>");
					n =  Beg;  
				}
			}
			dr.Close();
			StopTime = DateTime.Now;
			Timesp = StopTime-StartTime;
			MyConn.Close();
		}
	}
}