browersp.aspx.cs

ASP.NET简洁论坛源代码 这是一个简单的论坛

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;

namespace doughty_cn
{
	/// <summary>
	/// BrowersP 的摘要说明。
	/// </summary>
	public partial class BrowersP : System.Web.UI.Page
	{
		public string navigation;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			//过客的浏览权限
			if (System.Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["BorowsArea"])>1)
			{
				if (User.Identity.Name.ToString()=="")
				{
					this.Response.Redirect("logon.aspx");
				}
			}
			//初始化数据
			if(!IsPostBack)
			{
				try
				{
					int QID;
					if (Request.QueryString["QID"]==null)
						if (Request.QueryString["FID"]==null)
							QID=1;
						else
							QID=System.Convert.ToInt32(Request.QueryString["FID"].ToString());
					else
						QID=System.Convert.ToInt32(Request.QueryString["QID"].ToString());

					//点击次数加1
					DBOperate.ExcSQL("UPDATE Questions SET HiteCounter = HiteCounter + 1 WHERE (Q_ID = "+QID+")");

					DataTable Questions=DBOperate.SelectFormForum("SELECT Q_ID, author, Q_Note, Q_Content, ImageName, HiteCounter, ReleaseTime,ReferTime, BigClass_ID, SmallClass_ID, AnsCounter FROM Questions WHERE (Q_ID = "+QID+")");
					this.DataList_Q.DataSource=Questions;

					//写导航条
					DataRow Q = Questions.Rows[0];
					int BID,SID;
					BID=System.Convert.ToInt32(Q["BigClass_ID"]);
					SID=System.Convert.ToInt32(Q["SmallClass_ID"]);
					navigation="当前位置：<a href='default2.aspx'>"+doughty_cn.inputcon.ConvertString.TitleName(this.Request.Url.ToString())+"</a> → "
						+"<a href='BigcalssList.aspx?BID="+BID+"'>"+Navigation.GetBigClassName(BID)+"</a> → "
						+"<a href='MainList.aspx?BID="+BID+"&SID="+SID+"'>"+Navigation.GetSmallClassName(SID)+"</a> → 帖子内容";

					//写标题拦
					this.Response.Write("<title>"+doughty_cn.inputcon.ConvertString.TitleName(this.Request.Url.ToString())+"-"+Q["Q_Note"]+"</title>");

					this.Datalist_A.DataSource=DBOperate.SelectFormForum("SELECT Ans_ID, Question_ID, Ans_Man, Ans_Content, Ans_Time, ImageName FROM Answers WHERE (Question_ID = "+QID+")");
					//this.DList1.DataSource= DBOperate.SelectFormForum("SELECT Q_ID, CASE WHEN len(Q_Note) < 20 THEN Q_Note ELSE substring(Q_Note, 0, 20) + '...' END AS Q_Note, pith, BigClass_ID, HiteCounter, SmallClass_ID, kind FROM Questions WHERE (pith=1)and(Q_ID<"+QID+") AND(BigClass_ID = "+BID+") AND (SmallClass_ID ="+SID+") AND(kind > 0) ORDER BY Q_ID DESC",0,10,"Questions");
                    this.DList1.DataSource = DBOperate.SelectFormForum("SELECT Q_ID, Q_Note, pith, BigClass_ID, HiteCounter, SmallClass_ID, kind FROM Questions WHERE (pith=1)and(Q_ID<" + QID + ") AND(BigClass_ID = " + BID + ") AND (SmallClass_ID =" + SID + ") AND(kind > 0) ORDER BY Q_ID DESC", 0, 10, "Questions");
                    this.Page.DataBind();
				}
				catch (Exception) 
				{
					Response.Redirect("Logon.aspx");
				}
			}

		}
	
		public string ImgShow(string Imgname)
		{
            /*if ((Imgname==null)||(Imgname=="default.gif"))
				return "";
			else
				return "<a href='followUpImage/"+Imgname+"' target='_blank'><img src='followUpImage/"+Imgname+"'onmousewheel='return yuzi_img(event,this)' onload='javascript:if(this.width>screen.width-220)this.width=screen.width-220' border=0></a><br>";
            */
            string s = System.Configuration.ConfigurationSettings.AppSettings["followUpImagePath"];
            if ((Imgname == null) || (Imgname == "default.gif"))
                return "";
            else
                return "<a href='ImageView.aspx?IMG=" + s + Imgname + "' target='_blank'><img src='" + s + Imgname + "'onload='javascript:if(this.width>540)this.width=540' border=0 alt='点击图片放大看原图'></a><br>点击图片放大看原图<br>";
        }
		
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion
	}
}