学步园

这几天一直在学习生成静态页面的知识，现在贴一段生成静态页面的处理类。不足之处请大家指正。

CreateHtml类

public class CreateHtml<br /> {<br /> DBHelper db = new DBHelper();</p> <p> internal void CreatHtml()<br /> {<br /> string sql = "select TID, TITLE,ANAME,CREATETIME,TXT from tb_ft order by tid asc";<br /> DataTable dt = db.getArticles(sql);</p> <p> string tmpHtml = System.Web.HttpContext.Current.Server.MapPath("temp.htm");<br /> for (int i = 0; i < dt.Rows.Count; i++)<br /> {<br /> StringBuilder htmltext = getMartherBode(tmpHtml);//取模板页</p> <p> ////----------替换htm里的标记为你想加的内容 </p> <p> htmltext.Replace("$htmlformat[0]", System.Web.HttpContext.Current.Server.HtmlDecode(dt.Rows[i][1].ToString()));<br /> htmltext.Replace("$htmlformat[1]", dt.Rows[i][2].ToString());<br /> htmltext.Replace("$htmlformat[2]", dt.Rows[i][3].ToString());<br /> htmltext.Replace("$htmlformat[3]", System.Web.HttpContext.Current.Server.HtmlDecode(dt.Rows[i][4].ToString()));// Server.HtmlDecode(dt.Rows[i][4].ToString()));</p> <p> // System.Web.HttpContext.Current.Server.HtmlDecode<br /> //----------生成htm文件------------------―― 　　<br /> WriteHtml(dt.Rows[i][0].ToString(), htmltext);</p> <p> }<br /> }</p> <p> private static void WriteHtml(string i, StringBuilder htmltext)<br /> {<br /> try<br /> {<br /> using (StreamWriter sw = new StreamWriter(System.Web.HttpContext.Current.Server.MapPath("html/news_" + i + ".html"), false, System.Text.Encoding.GetEncoding("GB2312")))<br /> {<br /> sw.WriteLine(htmltext);<br /> sw.Flush();<br /> sw.Close();<br /> }<br /> }<br /> catch (Exception e)<br /> {<br /> throw new Exception(e.ToString());<br /> }<br /> }</p> <p> private StringBuilder getMartherBode(string tmpHtml)<br /> {<br /> StringBuilder htmltext = new StringBuilder();<br /> try<br /> {<br /> using (StreamReader sr = new StreamReader(tmpHtml))<br /> {<br /> String line;<br /> while ((line = sr.ReadLine()) != null)<br /> {<br /> htmltext.Append(line);<br /> }<br /> sr.Close();<br /> }<br /> }<br /> catch (Exception e)<br /> {<br /> throw new Exception(e.ToString());<br /> }<br /> return htmltext;<br /> }<br /> }

分页处理

  static int total;<br /> static int index;<br /> DBHelper db = new DBHelper();<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> if (!IsPostBack)<br /> {<br /> index = 1;</p> <p> if (Request.QueryString["pageIndex"] != null)<br /> {<br /> int i = Convert.ToInt32(Request.QueryString["pageIndex"].ToString());<br /> index = i;<br /> }</p> <p> total = db.getCount();<br /> int page = 100;<br /> int pagecount = Convert.ToInt32((total / page));</p> <p> if (index == 1)<br /> {<br /> LinkButton2.Enabled = false;<br /> LinkButton4.Enabled = false;<br /> }<br /> else {<br /> LinkButton2.Enabled = true;<br /> LinkButton3.Enabled = true;<br /> }<br /> if (index == pagecount)<br /> {<br /> LinkButton1.Enabled = false;<br /> LinkButton3.Enabled = false;<br /> }<br /> else {<br /> LinkButton1.Enabled = true;<br /> LinkButton3.Enabled = true;<br /> }<br /> Label1.Text=Label2.Text="总记录数："+total.ToString()+" 页码："+pagecount.ToString()+"/"+index.ToString();</p> <p> dlBind(index);<br /> }<br /> }</p> <p> private void dlBind(int index)<br /> {<br /> string startid = Convert.ToString((index - 1) * 100 + 1);<br /> int endid1 = index * 100;<br /> string endid = Convert.ToString(endid1);<br /> if (endid1 > total)<br /> { endid = total.ToString(); }</p> <p> string sql = "SELECT * FROM "<br /> + "( SELECT A.*, ROWNUM RN "<br /> + "FROM (SELECT * FROM allTiziNews) A "<br /> + "WHERE ROWNUM <= " + endid<br /> + "order by a.tid asc)"<br /> + " WHERE RN >= " + startid;<br /> Repeater1.DataSource = db.getArticles(sql);<br /> Repeater1.DataBind();<br /> }<br /> protected void LinkButton2_Click(object sender, EventArgs e)<br /> {<br /> index = index - 1;<br /> Response.Redirect("WebForm1.aspx?pageIndex=" + index);<br /> }</p> <p> protected void LinkButton1_Click(object sender, EventArgs e)<br /> {<br /> index = index + 1;<br /> Response.Redirect("WebForm1.aspx?pageIndex=" + index);<br /> }

 绑定dadalist

  <div><br /> <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click">下一页</asp:LinkButton><br /> <asp:LinkButton ID="LinkButton2" runat="server" OnClick="LinkButton2_Click">上一页</asp:LinkButton></div><br /> <br /><br /> <asp:DataList ID="DataList1" runat="server" RepeatColumns="4" RepeatDirection="Horizontal"><br /> <ItemTemplate><br /> <table cellspacing="0" cellpadding="0"style="border-collapse:collapse; text-align:center;"><br /> <tr><td colspan="2" align="center" style="width:200px; height:200px"><asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("HEAD") %>'></asp:Image> </td></tr><br /> <tr align="center" style="height:30px"><td><b>作者：</b><%# Eval("ANAME") %></td><td><b>发布时间：</b><%# Eval("CREATETIME")%></td> </tr><br /> <tr style="height:30px" ><td colspan="2" align="center" style="width:250px"><a href='<%# "html/news_" + Eval("tid") + ".html"%>' target="_blank"><br /> <%# (DataBinder.Eval(Container.DataItem, "Title").ToString().Length > 20)? DataBinder.Eval(Container.DataItem,"Title").ToString().Substring(0,20)+"...":DataBinder.Eval(Container.DataItem,"Title").ToString()%><br /> </a></td></tr><br /> </table><br /> </ItemTemplate><br /> </asp:DataList><br /> <br /><br /> <div><br /> <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>  <asp:LinkButton ID="LinkButton3" runat="server" OnClick="LinkButton1_Click">下一页</asp:LinkButton><br /> <asp:LinkButton ID="LinkButton4" runat="server" OnClick="LinkButton2_Click">上一页</asp:LinkButton></div>