一段顯示論壇貼子的程序 ///////////////////////////////////////////////////////////////////////////////
//
// File name:         showtopic.cs
//
// Description:       showtopic.aspx的后臺代碼
//
// date:              2000/11/01
//
// Programming:       Bigeagle
//
// History:           version 1.0
//                    start at 2000/11/01 11:00  finish at
//
////////////////////////////////////////////////////////////////////////////////

using BBS ;                           //my own namespace
using System;
using System.Data;
using System.Data.SQL;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Drawing ;
using System.Web.Security ;
using System.Collections ;
using System.Text.RegularExpressions ;


public class ShowTopic : Page
{

    public int ForumID ;
    public int ID ;

    public Label lblForumName ;              //板塊名稱
    public HyperLink linkMaster ;            //斑竹連接
    public Label lblTopicCounts ;            //論壇貼子數
    public HtmlImage imgNew1 ;               //是否新貼子圖片
    public HtmlImage imgOICQ ;               //oicq圖片
    public HyperLink linkForumName ;         //板塊名稱
    public HyperLink linkPrev ;              //上一主題
    public HyperLink linkPrev1 ;              //上一主題
    public HyperLink linkNext ;              //下一主題
    public HyperLink linkNext1 ;              //下一主題
    public Panel panReply ;                   //回復

    //本貼
    public HyperLink linkAuthor ;            //作者
    public Label lblTitle ;                  //主題
    public Label lblPostTime ;               //發表時間
    public Label lblHits ;                   //本貼點擊數
    public HtmlGenericControl  divSignature ;     //用戶簽名
    public HtmlGenericControl  divContent ;     //內容
    public HtmlImage imgFace ;               //表情圖片
  
    public void Page_Load(object sender , EventArgs e)
    {
        int m_intID = 0;
        //取頁面參數
        try
        {
            m_intID = Request.QueryString["id"].ToInt32() ;
            ID = m_intID ;
        }
        catch(Exception exp)
        {
            Response.Write("[ln48]:" + exp.ToString());
         
        }     
        finally
        {
     
            Dictionary objUserList = (Dictionary)Application["User"] ;    //用戶列表
     
            //取貼子
            SQLConnection myConnection = new SQLConnection("server=server1;uid=sa;pwd=;database=BBS");
            SQLCommand myCommand = new SQLCommand("up_GetTopics" , myConnection);

            myCommand.ActiveConnection = myConnection ;
            myCommand.CommandType = CommandType.StoredProcedure;
      
            SQLParameter workParam = null;

            //貼子id
            workParam = myCommand.Parameters.Add(new SQLParameter("@a_intID", SQLDataType.Int, 4));
            workParam.Direction = ParameterDirection.Input;
            workParam.Value = m_intID ;
        
            SQLDataReader myReader ;
          
            try
            {
                myConnection.Open();
                myCommand.Execute(out myReader);
          
                //首先取出上一主題、下一主題的id號
                if (myReader.Read())
                {    
                    linkPrev.NavigateUrl  = (int)myReader["ProvID"]==0 ? "" : "showtopic.aspx?id=" + myReader["ProvID"].ToString() ;
                    linkPrev1.NavigateUrl = linkPrev.NavigateUrl ;
                    linkNext.NavigateUrl  = (int)myReader["NextID"]==0 ? "" : "showtopic.aspx?id=" + myReader["NextID"].ToString() ;
                    linkNext1.NavigateUrl = linkNext.NavigateUrl ;
                }
                else
                {
                    Response.Redirect("default.aspx") ;
                }  
                
                
                //取出論壇信息             
                //if (myReader.NextResult() )
                //{
                    //myReader.Read() ;
                    //顯示板塊信息
                 
                    //Response.Write(myReader.FieldCount.ToString() );
                    //ShowForumInfo(5) ;
                //}
                //else
                //{
                    //Response.Redirect("default.aspx") ;
                //}    
              
                //顯示本貼內容
                if (myReader.NextResult() && myReader.Read())
                {
                    ForumID = (int)myReader[2] ;
                    ShowForumInfo((int)myReader[2]) ;
                    //作者
                    linkAuthor.NavigateUrl = myReader[5].ToString() == "" ? ""
                                             : "mailto:" + myReader[5].ToString() ;
                    linkAuthor.Text        = myReader[4].ToString() ;
                    linkAuthor.ToolTip     = objUserList.Contains(myReader[3].ToString())
                                              ? "當前在線，寫信給他。" : "不在線，寫信給他。" ;
                                          
                    //主題
                    lblTitle.Text = myReader[8].ToString() ;
                 
                    //發表時間
                    lblPostTime.Text = myReader[10].ToString() ;        
                 
                    //本帖點擊數
                    lblHits.Text = myReader[12].ToString() ;                                  
                                          
                    //簽名
                    divSignature.InnerHtml = myReader[13].ToString() ;  
                 
                    //內容
                    String strContent = myReader[9].ToString() ;
                    divContent.InnerHtml = ubb.UnEncode (strContent) ;
                 
                    //表情圖片
                    imgFace.Src = "images/icon" + myReader[11].ToString().Trim() + ".gif" ;
                }
                else
                {
                    //Response.Redirect("default.aspx") ;
                }    
                 
                //顯示回復
                myReader.NextResult() ;
                while (myReader.Read())
                {
                    //縮進
                    for (int i = 0 ; i < myReader[1].ToString().ToInt32() ; i ++)
                    {
                        panReply.Controls.Add(new LiteralControl("<ul>")) ;
                    }
                    

                    //顯示表情圖片
                    panReply.Controls.Add(new LiteralControl(
                            "<img src=images/icon" + myReader[11].ToString().Trim()
                            + ".gif>")) ;

                    //顯示id,點擊數
                    panReply.Controls.Add(new LiteralControl("(id："
                        + myReader[0].ToString() + " 點擊："
                        + myReader[12].ToString() + " )")) ;

                    //顯示標題
                    String strTemp ;
                    if (myReader.GetInt32(0) == m_intID)
                    {
                        strTemp = "<font class=title><font color=red>"
                            + myReader[8].ToString() + "</font></font>" ;
                    }
                    else
                    {
                        strTemp = "<a href=showtopic.aspx?id="
                            + myReader[0].ToString() + ">"
                            + "<font class=title><font color=green>"
                            + myReader[8].ToString() + "</font></font></a>" ;
                    }
                    panReply.Controls.Add(new LiteralControl(strTemp)) ;

                    //字節數
                    panReply.Controls.Add(new LiteralControl("("
                        + myReader[14].ToString() + "字節)")) ;
                            
                    //縮進
                    for (int i = 0 ; i < myReader[1].ToString().ToInt32() ; i ++)
                    {
                        panReply.Controls.Add(new LiteralControl("</ul>")) ;
                    }
                    //panReply.Visible = false ;
                }
              
            }       
            catch(Exception exp)
            {
                Response.Write(exp.ToString()) ;
             }
            finally
            {
                //myReader.Close() ;
                myConnection.Close();
                //Response.Redirect("default.aspx") ;
            }          
          
        }  
     }
      
  //顯示板塊信息函數
  private void ShowForumInfo(int a_intForumID)      
     {
      SQLConnection myConnection = new SQLConnection("server=server1;uid=sa;pwd=;database=BBS");
      SQLCommand myCommand = new SQLCommand("up_GetForum" , myConnection);

      myCommand.ActiveConnection = myConnection ;
      myCommand.CommandType = CommandType.StoredProcedure;
      
      SQLParameter workParam = null;

      //論壇id
      workParam = myCommand.Parameters.Add(new SQLParameter("@a_ForumID", SQLDataType.Int, 4));
      workParam.Direction = ParameterDirection.Input;
      workParam.Value = a_intForumID ;
        
      SQLDataReader myReader ;
      
      try
        {
          myConnection.Open();
          myCommand.Execute(out myReader);
          
          myReader.Read() ;
          
          //板塊名稱
          lblForumName.Text  = myReader["CategoryName"].ToString() ;       
          lblForumName.CssClass = "BigTitle" ;
          lblForumName.ToolTip = myReader["Description"].ToString() ;
          linkForumName.CssClass = "bigtitle" ;
          linkForumName.Text = lblForumName.Text ;
          linkForumName.ToolTip = myReader["Description"].ToString() ;
          linkForumName.NavigateUrl = "forum.aspx?id=" + myReader["CategoryID"].ToString() ;

          //oicq
          if (myReader["OICQ"].ToString() != "")
            {
              imgOICQ.Src = "http://infocenter.tencent.com/" + myReader["OICQ"].ToString() + "/s/00/99" ;
              imgOICQ.Alt = "OICQ:" + myReader["OICQ"].ToString() ;
              //imgOICQ.Src = "images/off.gif" ;
            }
          else
            {
              imgOICQ.Src = "" ;
              imgOICQ.Alt = "沒留OICQ。" ;
            }  
              
          //貼子數
          lblTopicCounts.Text = myReader["NewTopicNumber"].ToString() ;
          lblTopicCounts.ToolTip = "當前貼子數：" + lblTopicCounts.Text ;

          //版主
          linkMaster.Text = myReader["UserName"].ToString() ;
          linkMaster.NavigateUrl = (myReader["Email"].ToString() == "" ? "" :
                                  "MailTo:" + myReader["Email"].ToString()) ;
          linkMaster.ToolTip = (myReader["Email"].ToString() == "" ? "版主沒留Email。" :"寫信給版主。") ;
          
        }
      catch(Exception exp)
        {
          Response.Write(exp.ToString()) ;
          //Response.Redirect("error.asp") ;
        }
      finally
        {
          myConnection.Close();
          //Response.Redirect("default.aspx") ;
        }          
       
     }     

     //發新貼子
    public void OnPost(object Source, ImageClickEventArgs e)
    {
        Page.Navigate("post.aspx?forumid=" + ForumID.ToString ()) ;
        //Response.Write(e.ToString() ) ;
    }

    //回應
    public void OnReply(object Source, ImageClickEventArgs e)
    {
        Page.Navigate("post.aspx?id=" + ID.ToString ()) ;
        //Response.Write(e.ToString() ) ;
    }

}