当前文件路径：XuYuanQiang/App_Code/Html.cs

		            
  1using System;
  2using System.IO;
  3using System.Text;
  4using System.Data.SqlClient;
  5using System.Configuration;
  6using System.Data;
  7//源码下载及讨论地址：http://www.51aspx.com/CV/XuYuanQiang
  8namespace pizi
  9...{
 10    /**//// <summary>
 11    /// Html 的摘要说明。
 12    /// </summary>
 13    public class Html
 14    ...{
 15        int pageSize;
 16        
 17        int currentPage = 0;
 18        int tempNewsCount = 0;
 19        int currentNewsCount = 0; //累计的条数
 20        int pageCount;
 21        string newsList = null;
 22        string htmPath = null;
 23        SqlDataReader dr;
 24
 25        public int NewsPageSize
 26        ...{
 27            get...{return pageSize;}
 28            set...{pageSize = value;}
 29        }
 30
 31        public int CurrentPage
 32        ...{
 33            get...{return currentPage;}
 34            set...{currentPage = value;}
 35        }
 36
 37        读入模板文件#region 读入模板文件
 38        public StringBuilder ReadTemplate(string filePath)
 39        ...{
 40            //StreamReader sr = new StreamReader(filePath);
 41            StringBuilder sb = new StringBuilder();
 42            Encoding ecode = Encoding.GetEncoding("GB2312");
 43            using(StreamReader sr = new StreamReader(filePath,ecode))
 44            ...{
 45                string line;
 46                while((line = sr.ReadLine())!=null)
 47                    sb.Append(line);
 48                sr.Close();
 49            }
 50
 51            return sb;
 52                
 53        }
 54        #endregion
 55
 56
 57        得到总的页数#region 得到总的页数
 58        public int GetPageCount()
 59        ...{
 60            //有待完善！
 61            pageCount = 8;
 62            return pageCount;
 63        }
 64        #endregion
 65
 66        得到总的新闻条数#region 得到总的新闻条数
 67        public int GetNewsCount()
 68        ...{
 69            int newsCount = 0;
 70            string strCon = ConfigurationSettings.AppSettings["DSN"];
 71            SqlConnection conn = new SqlConnection(strCon);
 72            SqlCommand myCom = new SqlCommand("select count(*) from Products",conn);
 73            
 74            conn.Open();
 75            SqlDataReader dr = myCom.ExecuteReader();
 76            
 77            if(dr.Read())
 78            ...{
 79                newsCount = Convert.ToInt32(dr[0].ToString());
 80            }
 81            dr.Close();
 82            return newsCount;
 83            
 84        }
 85        #endregion
 86
 87
 88        分页#region 分页
 89
 90        public void MakeHtm()
 91        ...{
 92            string strCon = ConfigurationSettings.AppSettings["DSN"];
 93            SqlConnection conn = new SqlConnection(strCon);
 94            SqlCommand myCom = new SqlCommand("select ProductID,ProductName from Products order by ProductID asc",conn);
 95            Encoding ecode = Encoding.GetEncoding("GB2312");
 96            
 97            conn.Open();
 98            dr = myCom.ExecuteReader(CommandBehavior.CloseConnection);
 99            int myNewsCount = GetNewsCount();
100            while(dr.Read())
101            ...{
102                newsList += dr["ProductID"] + ". " + myNewsCount + "<a href=view.aspx?id=" + dr["ProductID"] + ">" + dr["ProductName"] + "</a><br />";
103                tempNewsCount++;
104                currentNewsCount++;
105                if ((tempNewsCount == pageSize) || (pageCount == 1) || (myNewsCount == currentNewsCount))
106                ...{
107                    if(currentPage == 0)
108                        htmPath = @"c:\htm\list.htm";
109                    else
110                        htmPath = @"c:\htm\list_" + currentPage + ".htm";
111                    currentPage++;
112
113                    StringBuilder sbNewsList = new StringBuilder(newsList);
114                    //Html.WriteHtml(sbNewsList,htmPath);
115                    using(StreamWriter sw = new StreamWriter(htmPath,false,ecode))
116                    ...{
117                        sw.Write(sbNewsList);
118                        sw.Flush();
119                        sw.Close();
120                    }
121                    tempNewsCount = 0;
122                    newsList = null;
123                }
124
125            }
126            dr.Close();
127        }
128
129        #endregion
130
131    }
132}
133