生成静态页面的c#类

写了个生成静态页面的类,其实和前2篇一样是根据数据库的数据,然后替换模板页的例子,当然可以根据需要把类改的更加通用一些:

class RankingSet:

1. using System;
2. using System.Data;
3. using System.Configuration;
4. using System.Web;
5. using System.Web.Security;
6. using System.Web.UI;
7. using System.Web.UI.WebControls;
8. using System.Web.UI.WebControls.WebParts;
9. using System.Web.UI.HtmlControls;
10. using HoWaveDbHelper;
11. using System.Text;
12. using System.IO;
13. using System.Data.SqlClient;
15. /// <summary>
16. /// RankingSet 的摘要说明
17. /// </summary>
18. public class RankingSet
19. {
20.     string readUrl = "#";
21.     string url = "#";
22.     string htmStr = "失败";
23.     public RankingSet()
24.     {
25.     }
26.     public RankingSet(string readUrl, string url)
27.     {
28.         this.readUrl = readUrl;
29.         this.url = url;
30.     }
31.     public string RankingSetStr()
32.     {
33.         htmStr = ReadHtml(readUrl);
34.        return  RankingSetStr(htmStr);
35.     }
36.     public string RankingSetStr(string htmStr)
37.     {
38.         if (htmStr != "失败")
39.         {
40.             DataSet DsDay, DsWeek, DsMoon;
41.             GetRanking(out  DsDay, out DsWeek, out DsMoon);
42.             string strDiv = GetAllDiv(DsDay, DsWeek, DsMoon,htmStr);
43.             return strDiv;
44.         }
45.         else
46.         {
47.             return "";
48.         }
49.     }
50.     public string IntoHtm()
51.     {
52.         string strDiv = RankingSetStr();
53.         if(strDiv=="")
54.             return "写入失败!";
55.         return InsertHtml(url,strDiv);
56.     }
57.     public string IntoHtm(string htmStr)
58.     {
59.         string strDiv = RankingSetStr(htmStr);
60.         if (strDiv == "")
61.             return "写入失败!";
62.         return InsertHtml(url, strDiv);
63.     }
64.     /// <summary>
65.     /// 分别获取三钟排行的DataSet
66.     /// </summary>
67.     /// <param name="DsDay">日排行</param>
68.     /// <param name="DsWeek">周排行</param>
69.     /// <param name="DsMoon">月排行</param>
70.     private void GetRanking(out DataSet DsDay, out DataSet DsWeek, out DataSet DsMoon)
71.     {
72.         SqlParameter[] spDay ={ Product_Click.SqlParameters("@intTop", SqlDbType.Int, 0, 11), Product_Click.SqlParameters("@type", SqlDbType.Int, 0, 1) };
73.         SqlParameter[] spWeek ={ Product_Click.SqlParameters("@intTop", SqlDbType.Int, 0, 11), Product_Click.SqlParameters("@type", SqlDbType.Int, 0, 2) };
74.         SqlParameter[] spMoon ={ Product_Click.SqlParameters("@intTop", SqlDbType.Int, 0, 11), Product_Click.SqlParameters("@type", SqlDbType.Int, 0, 3) };
75.         DsDay = HoWaveDbHelper.DbHelperSQL.RunProcedure("S_HLShop_Product_Ranking", spDay, "strDay");
76.         DsWeek = HoWaveDbHelper.DbHelperSQL.RunProcedure("S_HLShop_Product_Ranking", spWeek, "strWeek");
77.         DsMoon = HoWaveDbHelper.DbHelperSQL.RunProcedure("S_HLShop_Product_Ranking", spMoon, "strMoon");
78.     }
80.     /// <summary>
81.     /// 生成HTML
82.     /// </summary>
83.     /// <param name="strDiv">要写入文本的字符串</param>
84.     /// <param name="url">文本路径</param>
85.     public string InsertHtml(string url,string strDiv)
86.     {
87.         if (strDiv == "")
88.             return "写入失败!";
89.         using (StreamWriter sw = new StreamWriter(url, false, System.Text.Encoding.GetEncoding("utf-8")))
90.         {
91.             try
92.             {
93.                 sw.Write(strDiv);
94.                 return "写入成功!";
95.             }
96.             catch
97.             {
98.                 return "写入失败!";
99.             }
100.             finally
101.             {
102.                 sw.Flush();
103.                 sw.Close();
104.             }
105.         }
106.     }
107.     /// <summary>
108.     /// 读取HTML
109.     /// </summary>
110.     /// <param name="url">文本路径</param>
111.     public string ReadHtml(string readUrl)
112.     {
113.         //Encoding code = Encoding.GetEncoding("gb2312");
114.         Encoding code = System.Text.Encoding.Default;
115.         StreamReader sr = null;
116.        // StreamWriter sw = null;
117.         //读取
118.         try
119.         {
120.             sr = new StreamReader(readUrl, code);
121.             htmStr = sr.ReadToEnd();
122.         }
123.         catch
124.         {
125.         }
126.         finally
127.         {
128.             sr.Close();
129.         }
130.         return htmStr;
131.     }
132.   /// <summary>
133.   /// 所有类排行数据填充
134.  /// </summary>
135.     /// <param name="DsDay">日排行</param>
136.     /// <param name="DsWeek">周排行</param>
137.     /// <param name="DsMoon">月排行</param>
138.   /// <param name="htmStr">网页内容</param>
139.   /// <returns></returns>
140.     private string GetAllDiv(DataSet DsDay, DataSet DsWeek, DataSet DsMoon, string htmStr)
141.     {
142.             string dataStr = htmStr;
143.             dataStr = GetDiv(1, DsDay, dataStr);
144.             dataStr = GetDiv(2, DsWeek, dataStr);
145.             dataStr = GetDiv(3, DsMoon, dataStr);
146.             return dataStr;
147.     }
149.     /// <summary>
150.     /// 具体类排行数据填充
151.     /// </summary>
152.     /// <param name="tit">类别</param>
153.     /// <param name="Ds">数据</param>
154.     /// <returns></returns>
155.     private string GetDiv(int tit, DataSet Ds, string htmStr)
156.     {
157.         int strLen = 8;
158.         if (Ds.Tables.Count == 0)
159.             return htmStr;
160.         string ProductID, ProductName, SubProductName;
161.         decimal pric = 0.0m;
162.         string dataStr = htmStr;
164.         dataStr = dataStr.Replace("{Date" + tit + "}", DateTime.Now.ToString());   //对缓存时间进行赋值
166.         int leftStr = dataStr.IndexOf("<!--li" + tit + "b-->");
167.         int rightStr = dataStr.IndexOf("<!--li" + tit + "e-->");
168.         if (leftStr < 1 || rightStr >= dataStr.Length || dataStr.Length < 1 || rightStr < 1 || leftStr > rightStr)
169.             return "数据有错";
170.         int sumStr = rightStr - leftStr;
171.         if (sumStr >= dataStr.Length || sumStr < 1)
172.             return "数据有错";
173.         string listStr = dataStr.Substring(leftStr, sumStr);    //获取要替换的列表
174.         if(listStr.Length<12)
175.             return "数据有错";
176.         listStr = listStr.Substring(11);
178.         StringBuilder sbDiv = new StringBuilder(5000);
179.         foreach (DataRow Dr in Ds.Tables[0].Rows)
180.         {
181.             ProductID = Dr["ProductID"].ToString();
182.             ProductName = Dr["ProductName"].ToString();
183.             SubProductName = ProductName;
184.             if (ProductName.Length > strLen)
185.              SubProductName = ProductName.Substring(0, strLen);
186.             pric = Convert.ToDecimal(Dr["Prices"]);
188.             string newList = listStr;
189.             newList = newList.Replace("{ProductID" + tit + "}", ProductID);
190.             newList = newList.Replace("{ProductName" + tit + "}", ProductName);
191.             newList = newList.Replace("{SubProductName" + tit + "}", SubProductName);
192.             newList = newList.Replace("{pric" + tit + "}", pric.ToString("C"));
193.             sbDiv.Append(newList);
194.             sbDiv.Append("/n");
195.         }
196.         dataStr = dataStr.Replace(listStr, sbDiv.ToString());
197.         return dataStr;
198.     }
199. }

被调用的html:

1. <link type="text/css" rel="stylesheet" href="IndexStyle.css" />
2. <div class="r0"><h2><span class="title">热点3C排行(本日)</span></h2>
3.  <div class="dian pro2"  >
4.  <!--缓存时间：{Date1}-->
5.  <ul class="paihang">
6.  <!--li1b--><li><span class="span_title">
7.  <a href="/Shop/Auction/Auction.aspx?ProductID={ProductID1}" target="_blank"  title="{ProductName1}">{SubProductName1}</a>
8.  </span>
9.  <span class="span_ProductPrice">{pric1}</span>
10.  </li><!--li1e-->
11.  </ul></div>
12.  </div>
13.  <div class="r1"><h2><span class="title">热点3C排行(本周)</span></h2>
14.  <div class="dian pro2"  >
15.   <!--缓存时间：{Date2}-->
16.   <ul class="paihang">
17.   <!--li2b--><li><span class="span_title"> <a href="/Shop/Auction/Auction.aspx?ProductID={ProductID2}" target="_blank"  title="{ProductName2}">{SubProductName2}</a></span>
18.   <span class="span_ProductPrice">{pric2}</span></li><!--li2e-->
19.   </ul>
20.   </div></div>
21.    <div class="r1"><h2><span class="title">热点3C排行(本月)</span></h2>
22.  <div class="dian pro2"  >
23.   <!--缓存时间：{Date3}-->
24.   <ul class="paihang">
25.   <!--li3b--><li><span class="span_title"> <a href="/Shop/Auction/Auction.aspx?ProductID={ProductID3}" target="_blank"  title="{ProductName3}">{SubProductName3}</a></span>
26.   <span class="span_ProductPrice">{pric3}</span></li><!--li3e-->
27.   </ul></div></div>

调用代码:

1.         string readUrl = Server.MapPath("../Label/LabelOutPut/网站访问排行.htm");
2.         string url = Server.MapPath("../top/index_Ranking.htm");
3.         RankingSet Rks = new RankingSet(readUrl, url);
4.         string strReturn = Rks.IntoHtm(); 
5.         Response.Write( Rks.RankingSetStr());   //获取要写入网页的字符串
6.        Response.Write("<script>alert('"+strReturn+"')</script");