免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

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 分頁的頁數(shù)(生成頁面的個(gè)數(shù))
                {
                    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)//判斷如果為第一頁，則不把“上一頁”設(shè)為超鏈接
                    {
                        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個(gè)分頁數(shù)字
                        {
                            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個(gè)分頁數(shù)字
                        {
                            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) //判斷如果為最后一頁，則不把“下一頁”設(shè)為超鏈接
                    {
                        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);
                    //根據(jù)新聞的ID
                    
                    int fileName = i + 1;
                    string CreateFileName = "news_" + fileName.ToString();
                    str = str.Replace("[$NewsList$]", sb.ToString());//替換列表標(biāo)簽
                    //生成靜態(tài)文件
                    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語句結(jié)束
                
            }
        }
    }