Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True";
string sql = "select * from ProList";
DataSet ds = helper.ExecuteDataset(connString, CommandType.Text, sql);//helper类
DataTable dt = ds.Tables[0];
if (dt.Rows.Count / pagesize >= 1)
{
int maxi = 0;
//取出所有新闻列表
if (dt.Rows.Count % pagesize == 0)
{
maxi = dt.Rows.Count / pagesize;
}
else
{
maxi = (dt.Rows.Count / pagesize) + 1;
}
for (int i = 0; i < maxi; i++) // i 分页的页数(生成页面的个数)
{
StringBuilder sb = new StringBuilder();//新闻列表
//生成新闻列表
for (int h = i * pagesize; h < (i + 1) * pagesize; h++)//
{
if (h < dt.Rows.Count)
{
sb.Append("<li><span class=\"newstitle\"><a href=\"/news/" + dt.Rows[h]
["ID"].ToString() + ".html\" title=\"" + dt.Rows[h]["Name"].ToString() + "\">" + dt.Rows[h]["Name"].ToString() +
"</a></span><div class=\"clear\"></div></li>");
}
}
sb.Append("<div class=\"changepage\">"); //maxi
sb.Append("<div class=\"pre1\"><a href=\"news_1.html\"><img src=\"pre1.jpg\" width=\"15\"
height=\"10\" border=\"0\" alt=\"返回首页\" /></a></div>");
if (i == 0)//判断如果为第一页,则不把“上一页”设为超链接
{
sb.Append("<div class=\"pre2\"><a href=\"#\"><img src=\"pre2.jpg\" width=\"11\"
height=\"10\" border=\"0\" alt=\"上一页\" /></a></div>");
}
else
{
sb.Append("<div class=\"pre2\"><a href=\"news_" + i + ".html\"><img src=\"pre2.jpg\"
width=\"11\" height=\"10\" border=\"0\" alt=\"上一页\" /></a></div>");
}
if (i < 10)
{
for (int f = 1; f < 10; f++)//每页显示9个分页数字
{
if (f == i + 1)
{
sb.Append(" <div class=\"num\"><a href=\"news_" + f.ToString() + ".html\"
class=\"curpage\">" + f.ToString() + "</a></div>");
}
else if (f <= maxi)
{
sb.Append("<div class=\"num\"><a href=\"news_" + f.ToString() + ".html\">" +
f.ToString() + "</a></div>");
}
}
}
else
{
int maxfeye = i + 5;
int minfeye = i - 5;
for (int f = minfeye; f < maxfeye; f++)//每页显示9个分页数字
{
if (f == i + 1)
{
sb.Append("<div class=\"num\"><a href=\"news_" + f.ToString() + ".html\"
class=\"curpage\">" + f.ToString() + "</a></div>");
}
else if (f <= maxi)
{
sb.Append("<div class=\"num\"><a href=\"news_" + f.ToString() + ".html\">" +
f.ToString() + "</a></div>");
}
}
}
if (i == dt.Rows.Count / pagesize) //判断如果为最后一页,则不把“下一页”设为超链接
{
sb.Append("<a href=\"#\"><img src=\"next2.jpg\" width=\"11\" height=\"10\" border=\"0\"
alt=\"下一页\" /></a>");
}
else
{
sb.Append("<div class=\"pre2\"><a href=\"news_" + (i + 2) + ".html\"><img
src=\"next2.jpg\" width=\"11\" height=\"10\" border=\"0\" alt=\"下一页\" /></a></div>");
}
sb.Append("<div class=\"pre1\"><a href=\"news_" + (maxi).ToString() + ".html\"><img
src=\"next1.jpg\" width=\"15\" height=\"10\" border=\"0\" alt=\"末页\" /></a></div>");
sb.Append("<div class=\"clear\"></div> </div>");
Encoding code = Encoding.GetEncoding("gb2312");
StreamReader sr = null;
StreamWriter sw = null;
string str = null;
str = SqlHelper.re_lable(htm);
//根据新闻的ID
int fileName = i + 1;
string CreateFileName = "news_" + fileName.ToString();
str = str.Replace("[$NewsList$]", sb.ToString());//替换列表标签
//生成静态文件
try
{
str = SqlHelper.read_sys(str);
sw = new StreamWriter(System.Web.HttpContext.Current.Server.MapPath("./") + CreateFileName
+ ".html", false, code);
sw.Write(str);
sw.Flush();
}
catch (Exception ex)
{
throw ex;
}
finally
{
sw.Close();
}
}//for语句结束
}
}
}
联系客服