mainlist.aspx.cs

1。使用ASP.NET+C# VS.NET 2003制作

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 doughty_BBS
{
	/// <summary>
	/// Mainlist 的摘要说明。
	/// </summary>
	public class Mainlist : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand2;
		protected System.Data.SqlClient.SqlCommand sqlInsertCommand2;
		protected System.Data.SqlClient.SqlCommand sqlUpdateCommand2;
		protected System.Data.SqlClient.SqlCommand sqlDeleteCommand2;
		protected System.Data.SqlClient.SqlConnection sqlConnection2;
		protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;
		protected System.Data.SqlClient.SqlCommand sqlCmddelete;
		protected System.Web.UI.WebControls.HyperLink HyperLinkAddFiles;
		protected System.Web.UI.WebControls.HyperLink Hyperlinksearch;
		protected System.Web.UI.WebControls.HyperLink HyperlinkPith;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.LinkButton Linkbutton2;
		protected System.Web.UI.WebControls.Label LblManagers;
		protected System.Web.UI.WebControls.Label lblRecordCount;
		protected System.Web.UI.WebControls.Label lblCurrentPage;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Label Lbl_UserCou;
		protected System.Web.UI.WebControls.Label Lbl_UserName;
		protected System.Web.UI.WebControls.Label Lbl_UserGrade;
		protected System.Web.UI.WebControls.Label Lbl_IP;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.LinkButton Linkbutton4;
		protected System.Web.UI.WebControls.HyperLink lnkPrev;
		protected System.Web.UI.WebControls.HyperLink lnkNext;
		protected System.Web.UI.WebControls.Button BtnMove;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.Panel Panel2;
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand4;
		protected System.Data.SqlClient.SqlCommand sqlInsertCommand4;
		protected System.Data.SqlClient.SqlCommand sqlUpdateCommand4;
		protected System.Data.SqlClient.SqlCommand sqlDeleteCommand4;
		protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter4;
		protected System.Web.UI.WebControls.HyperLink HyperlinkNosolved;
		protected System.Web.UI.WebControls.HyperLink HyperlinkHavesolved;
		int PageSize,CurrentPage,PageCount;
		protected System.Web.UI.WebControls.Label LblB;
		protected System.Web.UI.WebControls.DataList DL_Main;
		protected System.Web.UI.WebControls.LinkButton Lb_logon;
		public string navigation;

		public void BindGrid() 
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				int BID,SID,solved;
				if ((Request.QueryString["BID"]==null)||(Request.QueryString["SID"]==null))
				{
					BID=1;
					SID=200;
				}
				else
				{
					BID=System.Convert.ToInt32(Request.QueryString["BID"]);
					SID=System.Convert.ToInt32(Request.QueryString["SID"]);
				}
				if (Request.QueryString["solved"]==null)
					solved=0;
				else
					solved=System.Convert.ToInt32(Request.QueryString["solved"]);

				navigation="<font color=#ffffff>当前位置：<a href='default2.aspx'><font color=#ffffff>"+doughty_BBS.inputcon.ConvertString.TitleName(this.Request.Url.ToString())+"</font></a> → "
					+"<a href='BigcalssList.aspx?BID="+BID+"'><font color=#ffffff>"+Navigation.GetBigClassName(BID)+"</font></a> → "
					+"<a href='Mainlist.aspx?BID="+BID+"&SID="+SID+"'><font color=#ffffff>"+Navigation.GetSmallClassName(SID)+"</font></a> → 帖子列表";
				HyperlinkNosolved.NavigateUrl="Mainlist.aspx?solved=0&BID="+BID+"&SID="+SID;
				HyperlinkHavesolved.NavigateUrl="Mainlist.aspx?solved=1&BID="+BID+"&SID="+SID;
				if (solved==0)
				{
					navigation=navigation+"(未解决)</font>";
					HyperlinkNosolved.Enabled=false;
				}
				else
				{
					navigation=navigation+"(已解决)</font>";
					HyperlinkHavesolved.Enabled=false;
				}
				HyperLinkAddFiles.NavigateUrl="AddFiles.aspx?BID="+BID+"&SID="+SID;
				Hyperlinksearch.NavigateUrl="search.aspx?BID="+BID+"&SID="+SID;
				HyperlinkPith.NavigateUrl="pith.aspx?BID="+BID+"&SID="+SID;

				PageSize=System.Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["MainList"]);
				CurrentPage = 0;	
				//计算总共有多少记录
				int RecordCount = DBOperate.CalculateQRecord(BID, SID,solved);
				lblRecordCount.Text = RecordCount.ToString();
				//计算总共有多少页
				PageCount = (RecordCount+PageSize-1)/PageSize;
				if (PageCount<=0)
					PageCount=1;
				lblPageCount.Text = PageCount.ToString();
				//获取页面参数
				if (Request.QueryString["Page"] != null)
					CurrentPage=Convert.ToInt32(Request.QueryString["Page"]);
				else
					CurrentPage=1;
				if (PageCount<CurrentPage)
					CurrentPage=PageCount;
				if (CurrentPage<=0)
					CurrentPage=1;

				//ListBind();
				//设定导入的起终地址
				int StartIndex = (CurrentPage-1)*PageSize;
				this.DL_Main.DataSource= DBOperate.SelectFormForum("SELECT Q_ID, author, Q_Note, Q_Content, ImageName, HiteCounter, ReleaseTime,ReferTime, BigClass_ID, SmallClass_ID, AnsCounter, kind, solved FROM Questions WHERE (SmallClass_ID = "+SID+") AND (kind > 0) AND (kind < 5) AND (solved ="+solved+") ORDER BY kind DESC, ReleaseTime DESC",StartIndex,PageSize,"Questions");
				this.Page.DataBind();

				lnkNext.Enabled = true;
				lnkPrev.Enabled = true;
				if(CurrentPage==(PageCount))
				{
					lnkNext.Enabled = false;
				}
				else
					lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?solved="+solved+"&BID="+ BID.ToString()+"&SID="+ SID.ToString()+"&Page=" + Convert.ToString(CurrentPage+1);
				if(CurrentPage==1)
					lnkPrev.Enabled = false;
				else
					lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?solved="+solved+"&BID="+ BID.ToString()+"&SID="+ SID.ToString()+"&Page=" + Convert.ToString(CurrentPage-1);
				lblCurrentPage.Text = CurrentPage.ToString();

				ShowManagers(BID, SID);//显示版主名单，并授权管理
			}
		}

		public void ShowManagers(int BID,int SID)
		{
			//显示版主名单，并授权管理
			DataTable d = DBOperate.SelectFormForum("SELECT PKID, Bigclass_ID, Smallclass_ID, ManagerName FROM Managers");
			DataRow [] drs = d.Select("SmallClass_ID="+ SID.ToString());
			string s="";
			bool ismanager=false;
			foreach( DataRow r in drs)
			{
				if (s!="")
					s=s+",";
				s=s+"<a href=\"SendSMsg.aspx?QID="+r["ManagerName"].ToString()+"\" target=\"_blank\">"+r["ManagerName"].ToString()+"</a>";
				if (User.Identity.Name.ToString()==r["ManagerName"].ToString())
				{
					ismanager=true;
				}
			}
			if (s=="")
				LblManagers.Text="版主：暂无";
			else
				LblManagers.Text="版主："+s;

			drs = d.Select("BigClass_ID="+ BID.ToString()+" and SmallClass_ID=0");
			s="";

			//大版主
			foreach( DataRow r in drs )
			{
				if (s!="")
					s=s+",";
				s=s+"<a href=\"SendSMsg.aspx?QID="+r["ManagerName"].ToString()+"\" target=\"_blank\">"+r["ManagerName"].ToString()+"</a>";
				if (User.Identity.Name.ToString()==r["ManagerName"].ToString())
				{