简单blog

 1<div style="width:760px; float:right; margin:0px auto;">
 2    <div style="float:right;"><input style="border-top:solid 5px #c8e556; border-bottom:solid 5px #81c617; background-color:#9bce24" type="button" value="发表留言" onclick="javascript:window.location.href='bbsPublish.aspx'" /></div>
 3    <div style="float:right; clear:both; width:570px; background-color:#f4f4f4">
 4    <table border="1px"; style="text-align: left; width:570px;" cellpadding="0px" cellspacing="0px">
 5        <asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="Repeater1_ItemDataBound">           
 6            <ItemTemplate>
 7                <tr style="border:none;">
 8                    <td width="50px">
 9                        标题<asp:Label id="bbsID" Text='<%#Eval("id") %>' runat="server" style="display:none"></asp:Label></td>
10                        <td style="border-right:0px; width:250px">                          
11                        <%#Eval("title") %> 
12   </td>
13   <td style="border-left:0px; border-right:0px">                   
14                    &nbsp;&nbsp;
15                        <%#Eval("msgTime") %>
16                   &nbsp;&nbsp;</td>
17   <td style="border-left:0px; border-right:0px">  
18                        <%#Eval("realName") %>
19                    &nbsp;&nbsp;
20</td>
21   <td style="border-left:0px; border-right:0px">                      
22                        <input style="float:right; clear:both; border-bottom:solid 5px #5AAFCC; border-top:none; background-color:#71bbd4;" type="button" value="回复" onclick="javascript:window.location.href='reply.aspx?id=<%#Eval("id") %>'" />
23                        </td>
24                </tr>                
25                <tr style="border:none;">
26                    <td width="50px">
27                        内容</td>
28                    <td colspan="4" width="300px">
29                        <%#Eval("msgContent") %>
30                    </td>
31                </tr>                
32                <asp:Repeater ID="Repeater2" runat="server">
33                    <ItemTemplate>
34                        <tr style="display: block;">
35                            <td width="50px">
36                                回复</td>
37                            <td colspan="4" width="300px">
38                                <%#Eval("replyContent") %>
39                                &nbsp;&nbsp;
40                                <%#Eval("replyTime") %><br />
41                                <%#Eval("replyName") %>
42                            </td>
43                        </tr>                                           
44                    </ItemTemplate>
45                </asp:Repeater>
46            </ItemTemplate>     
47        </asp:Repeater>
48        </table>        
49        </div> 
50        <div style="text-align:right; float:right; clear:both;">
51        <asp:LinkButton ID="HomePage" runat="server" OnClick="HomePage_Onclick">首页</asp:LinkButton> &nbsp;
52        <asp:LinkButton ID="PreviousPage" runat="server" OnClick="PreviousPage_Click">上一页</asp:LinkButton>&nbsp;
53        <asp:LinkButton ID="NextPage" runat="server" OnClick="NextPage_Click">下一页</asp:LinkButton>&nbsp;
54        <asp:LinkButton ID="LastPage" runat="server" OnClick="LastPage_Click">尾页</asp:LinkButton>
55        </div>
56    </div> 
57

 后台code：

  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12using webest.comm;
 13using webest.sqlAgent;
 14
 15
 16public partial class BBSShow : System.Web.UI.Page
 17{
 18
 19    private int pageIndex = 1;
 20    private static int pageSize = 5;
 21    private int pageCount = 1;
 22    protected void Page_Load(object sender, EventArgs e)
 23    {
 24        if(!IsPostBack)
 25        {           
 26            getBBS();      
 27        }
 28        
 29    }
 30    void getBBS()
 31    {        
 32        sqlTools tool = new sqlTools(commTools.connStr);
 33        //string sql = "select id, realName,title,msgTime,msgContent from BBSSection ";
 34        string sql = "proc_BBSPage";       
 35        SqlParameter[] sqlpar = new SqlParameter[] { 
 36                new SqlParameter("@pageIndex",SqlDbType.Int),
 37                new SqlParameter("@pageSize",SqlDbType.Int),
 38                new SqlParameter("@pageCount",SqlDbType.Int)  
 39        };
 40           
 41        sqlpar[0].Value = pageIndex;
 42        sqlpar[1].Value = pageSize;
 43        sqlpar[2].Direction = ParameterDirection.Output;       
 44        DataSet bbsDb = tool.ExecuteProc(sql,sqlpar);
 45        pageCount = Convert.ToInt32(sqlpar[2].Value.ToString());
 46        pageCount = Convert.ToInt32(Math.Ceiling(double.Parse(sqlpar[2].Value.ToString()) / pageSize));
 47        this.Repeater1.DataSource = bbsDb.Tables[0];
 48        this.Repeater1.DataBind();
 49        if (pageIndex <= 1)
 50        {
 51            PreviousPage.Enabled = false;
 52        }
 53        else
 54        {
 55            PreviousPage.Enabled = true;
 56        }
 57        if (pageIndex > pageCount - 1)
 58        {
 59            NextPage.Enabled = false;
 60        }
 61        else
 62        {
 63            NextPage.Enabled = true;
 64        }
 65    }
 66    DataSet getReply(int id)
 67    {
 68        sqlTools tool = new sqlTools(commTools.connStr);
 69        string sql = "select id from BBSSection ";
 70        DataSet dsBBS = tool.ExecuteDataset(sql);
 71  
 72        string replySql = "select replyName, replyContent,replyTime from reply where replyID=" + id;       
 73        return tool.ExecuteDataset(replySql);
 74
 75    }
 76    protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
 77    {
 78        
 79        if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
 80        {
 81            DataRowView row = (DataRowView)e.Item.DataItem;
 82            int id = Convert.ToInt32(row["id"].ToString());
 83            (e.Item.FindControl("Repeater2") as Repeater).DataSource = getReply(id).Tables[0];
 84            (e.Item.FindControl("Repeater2") as Repeater).DataBind();
 85        }
 86    }
 87    
 88
 89    protected void HomePage_Onclick(object sender, EventArgs e)
 90    {
 91        pageIndex=1;
 92        getBBS();
 93    }
 94    protected void PreviousPage_Click(object sender, EventArgs e)
 95    {
 96        if (pageIndex > 1)
 97        {
 98            PreviousPage.Enabled = true;
 99            pageIndex--;
100            getBBS();
101
102        }
103        else
104        {
105            PreviousPage.Enabled = false;
106        }
107        
108
109    }
110    protected void NextPage_Click(object sender, EventArgs e)
111    {
112        if (pageIndex < pageCount)
113        {
114            NextPage.Enabled = true;
115            pageIndex++;
116            getBBS();
117        }
118        else
119        {
120            NextPage.Enabled = false;
121        }
122    }
123    protected void LastPage_Click(object sender, EventArgs e)
124    {
125        pageIndex = pageCount;
126        getBBS();
127    }
128}
129