亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb

首頁 > 學院 > 開發設計 > 正文

關于.net生成靜態頁面的方法總結

2019-11-17 04:16:49
字體:
來源:轉載
供稿:網友

 這幾天在做國家教育平臺陽光工程,由于考慮到將來的用戶群比較多,所以我們考慮使用.net生成靜態頁面的方法來減少數據與數據庫的訪問量,雖然以前也寫過一些靜態的頁面,但是感覺沒有將來的比較復雜,所以搜索了一下網絡,再結合自己以前的一些經驗,總結出以下幾步思想:

1)做一個比較好的模板temp1.html,并在模板中寫好題目,內容,作者 以及發布日期的標記,如果還有其他列表的話也要寫好其他列表的標記,如 題目可以用標記:$Title$,內容可以用$cont$,發布日期$PubDate,最新發布新聞列表$DtNewest$;

2)設計數據庫,可以設置兩張表,一張表存放模板,一張用于存放發布新聞的內容

如 模板表:  TempTable   : ID ,classid,TempPath(存放模板的路徑);

    新聞表:   NesTable:   ID,ClassID,title,cont,Filepath(發布后存放靜態頁面的路徑),pubdate,author,status;

 

3)添加新聞時,現在記錄添加到新聞表中,然后再根據欄目的ID找到該欄目的模板,把模板中的內容讀取到一個字符串變量中,并用新聞表中的字段替換模板中的相應標記,然后調用c#中的讀寫文件的類,寫到一個靜態文件中如:News.HTml,寫成功后再更新數據中靜態文件路徑filepath;

 

這樣一個靜態文件就寫好了

 

另外本人也從網絡上搜集了一些資料,供大家參考(關于新聞內容分頁的情況下次敘述)

一、類似的模板

 模板頁Text.html代碼

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>$ShowArticle$</title>
<body>
$title$

<br>

 $author$
<br>
$content$<br>

</body>
</HTML>

 

二、C#生成靜態頁類代碼|支持列表生成代碼

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using zj123.Model;
using System.IO;
using System.Text.RegularExPRessions;
using System.Runtime.InteropServices;
using System.Text;
using System.Collections;
namespace WebUI.html
{
    public class EasyHtml
    {
        public bool MakeHtml(string artid)
        {
           
            bool succ = false;
            int len = Convert.ToInt32(Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["titlelength"]) ?? "20");
            //讀取數據
            string sql = string.Format("select a.*,b.ClassName,b.Depth,b.OrderBy,b.isTop,b.isList,b.IsLinks,b.Links,b.PicURL,b.ParentID,b.TemplateoutId,b.TemplateinNeiId,b.TemplateinListId from article a,zone b  where a.classid=b.classid and a.Status=3 and a.articleid={0}", artid);
            DataTable dt = DbHelperOleDb.Query(sql).Tables[0];
            if(dt.Rows.Count>0)
            {
            //外模板
                string waitemp = "";
                DataTable waidt  =DbHelperOleDb.Query(string.Format("select * from template where TemplateID={0}",Convert.ToString(dt.Rows[0]["TemplateoutId"]).Trim())).Tables[0];
                if (waidt.Rows.Count > 0)
                {
                    waitemp = Convert.ToString(waidt.Rows[0]["TemplateContent"]);
                }
            //內模板
                string neitemp = "";
                DataTable neidt = DbHelperOleDb.Query(string.Format("select * from template where TemplateID={0}", Convert.ToString(dt.Rows[0]["TemplateinNeiId"]).Trim())).Tables[0];
                if (neidt.Rows.Count > 0)
                {
                    neitemp = Convert.ToString(neidt.Rows[0]["TemplateContent"]);
                }
                //替換模板
                waitemp = waitemp.Replace("$intemplate$", neitemp);
                //替換類型
                string tempclassname = classes.Common.GetP(Convert.ToString(dt.Rows[0]["classid"]));
                waitemp = waitemp.Replace("$ClassName$", tempclassname);
            #region "文章列表"
 
                //最新的文章
                System.Text.StringBuilder sbneartitle = new System.Text.StringBuilder("<div align=/"left/">");
                DataTable nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 order by updatetime desc").Tables[0];
                for (int i = 0; i < nearTitledt.Rows.Count; i++)
                {
                    sbneartitle.AppendFormat("<li><a href=/"{0}/">{1}</a></li>",Convert.ToString(nearTitledt.Rows[i]["HtmlPath"]),Convert.ToString(nearTitledt.Rows[i]["Title"]));
                }
                sbneartitle.Append("</ol></div>");
                waitemp = waitemp.Replace("$NearTitle$", sbneartitle.ToString());
                sbneartitle.Remove(0,sbneartitle.ToString().Length);
                if (waitemp.Contains("$OnTopTitle$"))
                {
                    sbneartitle.Append("<div align=/"left/">");

                    //固定
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and OnTop=1 order by updatetime desc").Tables[0];
                    for (int i = 0; i < nearTitledt.Rows.Count; i++)
                    {
                    sbneartitle.AppendFormat("<li><a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[i]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[i]["Title"]));
                    }
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    sbneartitle.Append("</ol></div>");
                    waitemp = waitemp.Replace("$OnTopTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                }
             
                if (waitemp.Contains("$HitsTitle$"))
                {
                    sbneartitle.Append("<div align=/"left/">");
                    //熱門
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and Hits>1000 order by Hits desc,updatetime desc").Tables[0];
                    for (int i = 0; i < nearTitledt.Rows.Count; i++)
                    {
                    sbneartitle.AppendFormat("<li><a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[i]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[i]["Title"]));
                    }
                    sbneartitle.Append("</ol></div>");


                    waitemp = waitemp.Replace("$HitsTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                }
        
                if (waitemp.Contains("$Elite$"))
                {
                    sbneartitle.Append("<div align=/"left/">");
                    //推薦Elite
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and Elite=1 order by updatetime desc").Tables[0];
                    for (int i = 0; i < nearTitledt.Rows.Count; i++)
                    {
                    sbneartitle.AppendFormat("<li><a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[i]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[i]["Title"]));
                    }

                    sbneartitle.Append("</ol></div>");
                    waitemp = waitemp.Replace("$Elite$", sbneartitle.ToString());

                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                }

            
           
                //相關Classid
                if (waitemp.Contains("$ClassTitle$"))
                {
                    sbneartitle.Append("<div align=/"left/">");
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and classid=" + Convert.ToString(dt.Rows[0]["classid"]) + " order by updatetime desc").Tables[0];
                    for (int curr = 0; curr < nearTitledt.Rows.Count; curr++)
                    {
                        sbneartitle.AppendFormat("<li><a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[curr]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[curr]["Title"]));
                    }

                    sbneartitle.Append("</ol></div>");
                    waitemp = waitemp.Replace("$ClassTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                }

                //相關Classid
                if (waitemp.Contains("$LikeTitle$"))
                {
                    sbneartitle.Append("<div align='left'>");
                    DataTable dtlike = zj123.Model.Article.GetLike(artid);
                    for (int likei = 0; likei < dtlike.Rows.Count; likei++)
                    {
                        sbneartitle.AppendFormat("<li><a href=/"{0}/">{1}</a></li>", Convert.ToString(dtlike.Rows[likei]["HtmlPath"]), Convert.ToString(dtlike.Rows[likei]["Title"]));
                    }
                    sbneartitle.Append("</ol></div>");
                    waitemp = waitemp.Replace("$LikeTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                }

                    /////////////////////////////////////////////////////////////////////////////////////////////
            #endregion
                    //替換最新的數據
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        if (dt.Columns[j].ColumnName.Trim() == "Title")
                        {
                            string temp1 = "";
                            string temp2 = "";
                            string typefont = Convert.ToString(dt.Rows[0]["TitleFontType"]);
                            if (typefont == "0")
                            {
                                temp1 = "<strong>";
                                temp2 = "</strong>";
                            }
                            else if (typefont == "1")
                            {
                                temp1 = "<em>";
                                temp2 = "</em>";
                            }
                            else if (typefont == "2")
                            {
                                temp1 = "<strong><em>";
                                temp2 = "</strong></em>";
                            }
                            else
                            {

                            }
                            //System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex();
                            //Match match = Regex.Matches();
                            //reg.Replace(waitemp, Convert.ToString(dt.Rows[0][dt.Columns[j].ColumnName.Trim()]), 1, waitemp.IndexOf("$Title$"));
                            string temp11 = waitemp.Substring(0, waitemp.IndexOf("$Title$") + 8);
                            string temp22 = waitemp.Substring(waitemp.IndexOf("$Title$") + 8);
                            temp11 = temp11.Replace("$Title$", Convert.ToString(dt.Rows[0][dt.Columns[j].ColumnName.Trim()])+"---"+Regex.Replace(Regex.Replace(tempclassname,"<[^>]*>",""),"[>|<]*",""));
                            temp22 = temp22.Replace("$Title$", "<font color='" + Convert.ToString(dt.Rows[0]["TitleFontColor"]) + "'>" + temp1 + Convert.ToString(dt.Rows[0][dt.Columns[j].ColumnName.Trim()]) + temp2 + "</font>");
                            waitemp = temp11 + temp22;
                            temp11 = null;
                            temp22 = null;
                            //waitemp = waitemp.Replace("$" + dt.Columns[j].ColumnName.Trim() + "$", "<font color='" + Convert.ToString(dt.Rows[0]["TitleFontColor"]) + "'>" +temp1+ Convert.ToString(dt.Rows[0][dt.Columns[j].ColumnName.Trim()]) +temp2+ "</font>");
                        }
                        else if (dt.Columns[j].ColumnName.Trim().ToLower() == "hits")
                        {
                            waitemp = waitemp.Replace("$" + dt.Columns[j].ColumnName.Trim() + "$", Convert.ToInt16(dt.Rows[0][dt.Columns[j].ColumnName.Trim()]) > 1000 ? ("熱門") : (""));
                        }
                        else if (dt.Columns[j].ColumnName.Trim().ToLower() == "ontop")
                        {
                            waitemp = waitemp.Replace("$" + dt.Columns[j].ColumnName.Trim() + "$", Convert.ToString(dt.Rows[0][dt.Columns[j].ColumnName.Trim()]).ToLower() == "true" ? ("置頂") : (""));
                        }
                        else if (dt.Columns[j].ColumnName.Trim().ToLower() == "elite")
                        {
                            waitemp = waitemp.Replace("$" + dt.Columns[j].ColumnName.Trim() + "$", Convert.ToString(dt.Rows[0][dt.Columns[j].ColumnName.Trim()]).ToLower().ToString() == "true" ? ("推薦") : (""));
                        }
                        else
                        {
                            waitemp = waitemp.Replace("$" + dt.Columns[j].ColumnName.Trim() + "$", Convert.ToString(dt.Rows[0][dt.Columns[j].ColumnName.Trim()]));
                        }

                    }
                //替換鏈表信息
                //$typejs$
                waitemp = waitemp.Replace("$typejs$", Convert.ToString(dt.Rows[0]["ClassID"]));
                //$numjs$
                waitemp = waitemp.Replace("$numjs$", "10");
                //$setjs$
                waitemp = waitemp.Replace("$setjs$","");
               
                ///js腳本信息


               //根據路徑生成頁面
                //路徑 檢查
                string path = System.Web.HttpContext.Current.Request.PhysicalapplicationPath.Trim()  + Convert.ToString(dt.Rows[0]["Links"]) + "http://" + Convert.ToDateTime(dt.Rows[0]["CreateTime"]).ToString("yyyy-MM");
                if(!Directory.Exists(path))
                  Directory.CreateDirectory(path);
              string filename = "http://"+ Convert.ToString(dt.Rows[0]["ArticleID"]) + ".html";
                using(StreamWriter sw = new StreamWriter(path+"//"+filename,false,System.Text.Encoding.GetEncoding("gb2312")))
                {
                    sw.Write(waitemp);
                    sw.Flush();
                    sw.Close();
                }
                //修改文章轉臺
                try
                {
                    if (artid == null)
                        return false;
                    int j = int.Parse(artid);
                }
                catch
                {
                    return false;
                }

                string sql1 = string.Format("update article set iscreate=1,htmlpath='{0}' where articleid={1}", "/" + Convert.ToString(dt.Rows[0]["Links"]).Replace("////", "/") + "/" + Convert.ToDateTime(dt.Rows[0]["CreateTime"]).ToString("yyyy-MM") + filename, artid);
                DbHelperOleDb.ExecuteSql(sql1);
               
            }
            else
            {
                return false;
            }
     

            return succ;
        }
        /// <summary>
        /// 生成列表頁
        /// </summary>
        /// <param name="classid"></param>
        /// <returns></returns>
        public bool MakeList(string classid)
        {
            int len = Convert.ToInt32(Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["titlelength"]) ?? "20");
            bool succ = false;
            try
         {        
          int i = int.Parse(classid);

         }
         catch
         {
         
       return false;
         }
            DataTable dt = DbHelperOleDb.Query(string.Format("select a.*,b.ClassName,b.Depth,b.OrderBy,b.isTop,b.isList,b.IsLinks,b.Links,b.PicURL,b.ParentID,b.TemplateoutlistId,b.TemplateoutId,b.TemplateinNeiId,b.TemplateinListId,b.keyWords,b.[description] from article a,zone b  where a.classid=b.classid and  iscreate=1 and a.Status=3 and a.classid={0} order by a.UpdateTime desc,OnTop desc,Elite desc,Hits desc", classid)).Tables[0];
            if (dt.Rows.Count > 0)
            {
                string classpath = HttpContext.Current.Request.PhysicalApplicationPath + @"/" + Convert.ToString(dt.Rows[0]["Links"]).Trim();
                //讀取外模板信息
                string templatewai = "";
                DataTable templatewaidt = DbHelperOleDb.Query(string.Format("select * from template where TemplateID={0}", Convert.ToString(dt.Rows[0]["TemplateoutlistId"]))).Tables[0];
                if (templatewaidt.Rows.Count > 0)
                {
                    templatewai = Convert.ToString(templatewaidt.Rows[0]["TemplateContent"]);
                }
                //根據類型替換標題
                string tempclassname = classes.Common.GetP(classid);
                templatewai = templatewai.Replace("$Title$", Convert.ToString(dt.Rows[0]["ClassName"]).Trim() +"--"+Regex.Replace(Regex.Replace(tempclassname,"<[^>]*>",""),"[<|>]*",""));
                templatewai = templatewai.Replace("$ClassTitleTop$", Convert.ToString(dt.Rows[0]["ClassName"]).Trim());
                templatewai = templatewai.Replace("$ClassName$", tempclassname);
                templatewai = templatewai.Replace("$Keyword$", Convert.ToString(dt.Rows[0]["Keywords"]).Trim());
                templatewai = templatewai.Replace("$Description$", Convert.ToString(dt.Rows[0]["Description"]).Trim());

                int zong = dt.Rows.Count;
                int size = 10;
                try
                {
                    size = Convert.ToInt16(System.Configuration.ConfigurationManager.AppSettings["pagesize"]);
                }
                catch
                {

                    size = 10;
                }
                int pagecount = zong % size == 0 ? (zong / 10) : (zong / 10 + 1);
                string listcontent = "";
                DataTable dtlist = DbHelperOleDb.Query(string.Format("select * from template where TemplateID={0}", Convert.ToString(dt.Rows[0]["TemplateinListId"]))).Tables[0];
                if (dtlist.Rows.Count > 0)
                {
                    listcontent = Convert.ToString(dtlist.Rows[0]["TemplateContent"]);
                }
                //// Match mat = Regex.Match(this.rtbconten.Text.Trim(), "<tablehead>(?<content>.*)<tableheadend><tablebody></tablebodyend><tablepage></tablepage><tablebottom></tablebottomend>", RegexOptions.Multiline | RegexOptions.IgnoreCase);
                //// MessageBox.Show(mat.Groups["content"].Value);
                ////<tablehead>(?<content>.*)<tableheadend><tablebody></tablebodyend><tablepage></tablepage><tablebottom></tablebottomend>
                ////
                Match mat = Regex.Match(listcontent, "<tablehead>(?<head>.*)<tableheadend><tablebody>(?<body>.*)</tablebodyend><tablepage>(?<page>.*)</tablepage><tablebottom>(?<bottom>.*)</tablebottomend>",RegexOptions.IgnoreCase|RegexOptions.Multiline);
                string head = Convert.ToString(mat.Groups["head"]);
                string body = Convert.ToString(mat.Groups["body"]);
                string page = Convert.ToString(mat.Groups["page"]);
                string bottom = Convert.ToString(mat.Groups["bottom"]);
                //循環生成分頁
                for (int i = 0; i < pagecount; i++)
                {
                    //System.Text.StringBuilder sbneilist = new System.Text.StringBuilder("<TABLE cellSpacing=0 cellPadding=0 width=760 border=0><TBODY>");
                    System.Text.StringBuilder sbneilist = new System.Text.StringBuilder(head);


                    int l = 0;
                    for (int j = (i * size < zong) ? (i * size) : (zong); j < ((i + 1) * size < zong ? ((i + 1) * size) : (zong)); j++)
                    {
                        //sbneilist.Append(" <TR><TD vAlign=top align=center bgColor=#f7f7f7 >");
                        //string temp = listcontent;
                        string temp = body;
                        for (int k = 0; k < dt.Columns.Count; k++)
                        {
                          
                            temp = temp.Replace("$" + dt.Columns[k].ColumnName.Trim() + "$", Convert.ToString(dt.Rows[j][dt.Columns[k].ColumnName.Trim()]));
                        }
                        if ((++l) % 5 == 0)
                        {
                            sbneilist.Append(temp).Append("<dd class=/"l/"></dd>");
                        }
                        else
                        {
                            sbneilist.Append(temp);
                        }
                      
                        //sbneilist.Append("</td></tr>");

                    }

                    //sbneilist.Append("<TR><TD height=36>").Append(classes.Common.GetPage(i + 1, size, zong)).Append("</td></tr>");
                    sbneilist.Append(page.Replace("¥pages¥", classes.Common.GetPage(i + 1, size, zong)));
                    // sbneilist.Append("</tbody></table>");
                    sbneilist.Append(bottom);

                    #region "文章列表"

                    //最新的文章
                    System.Text.StringBuilder sbneartitle = new System.Text.StringBuilder("");
                    DataTable nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 order by updatetime desc").Tables[0];
                    for (int curr = 0; curr < nearTitledt.Rows.Count; curr++)
                    {
                        sbneartitle.AppendFormat("<li>·<a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[curr]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[curr]["Title"]));
                    }
                    sbneartitle.Append("");
                    templatewai = templatewai.Replace("$NearTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    sbneartitle.Append("");

                    //固定
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and OnTop=1 order by updatetime desc").Tables[0];
                    for (int curr = 0; curr < nearTitledt.Rows.Count; curr++)
                    {
                        sbneartitle.AppendFormat("<li>·<a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[curr]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[curr]["Title"]));
                    }
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    sbneartitle.Append("");
                    templatewai = templatewai.Replace("$OnTopTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    sbneartitle.Append("");
                    //熱門
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and Hits>1000 order by Hits desc,updatetime desc").Tables[0];
                    for (int curr = 0; curr < nearTitledt.Rows.Count; curr++)
                    {
                        sbneartitle.AppendFormat("<li>·<a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[curr]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[curr]["Title"]));
                    }
                    sbneartitle.Append("");


                    templatewai = templatewai.Replace("$HitsTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    sbneartitle.Append("");
                    //推薦Elite
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and Elite=1 order by updatetime desc").Tables[0];
                    for (int curr = 0; curr < nearTitledt.Rows.Count; curr++)
                    {
                        sbneartitle.AppendFormat("<li>·<a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[curr]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[curr]["Title"]));
                    }
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    sbneartitle.Append("");
                    templatewai = templatewai.Replace("$Elite$", sbneartitle.ToString());
                    sbneartitle.Append("");
                    //相關Classid
                    nearTitledt = DbHelperOleDb.Query("select top 10 case when len(title)>" + len + " then substring(title,1," + len + ") else title end as Title,HtmlPath from article where iscreate=1 and classid=" + classid + " order by updatetime desc").Tables[0];
                    for (int curr = 0; curr < nearTitledt.Rows.Count; curr++)
                    {
                        sbneartitle.AppendFormat("<li>·<a href=/"{0}/">{1}</a></li>", Convert.ToString(nearTitledt.Rows[curr]["HtmlPath"]), Convert.ToString(nearTitledt.Rows[curr]["Title"]));
                    }

                    sbneartitle.Append("");
                    templatewai = templatewai.Replace("$ClassTitle$", sbneartitle.ToString());
                    sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    //sbneartitle.Append("<div align='left'>");
                    //DataTable dtlike = zj123.Model.Article.GetLike(artid);
                    //for (int likei = 0; likei < dtlike.Rows.Count; likei++)
                    //{
                    //    sbneartitle.AppendFormat("<li><a href=/"{0}/">{1}</a></li>", Convert.ToString(dtlike.Rows[likei]["HtmlPath"]), Convert.ToString(dtlike.Rows[likei]["Title"]));
                    //}
                    //sbneartitle.Append("</ol></div>");
                    //waitemp = waitemp.Replace("$LikeTitle$", sbneartitle.ToString());
                    //sbneartitle.Remove(0, sbneartitle.ToString().Length);
                    /////////////////////////////////////////////////////////////////////////////////////////////
                    #endregion
                    //替換鏈表信息
                    //$typejs$
                    templatewai = templatewai.Replace("$typejs$", classid);
                    //$numjs$
                    templatewai = templatewai.Replace("$numjs$", "10");
                    //$setjs$
                    templatewai = templatewai.Replace("$setjs$", "");
                    string tempzong = templatewai.Replace("$intemplate$", sbneilist.ToString());
                    string indexshow = (i + 1).ToString() == "1" ? ("") : ((i + 1).ToString());

 


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb
亚洲国产精品久久久久久| zzijzzij亚洲日本成熟少妇| 91最新国产视频| 欧美激情xxxx| 亚洲成人在线网| 日韩免费av一区二区| 久精品免费视频| 欧美大成色www永久网站婷| 亚洲精品美女久久| 成人黄色在线免费| 久久久久久com| 国产美女91呻吟求| 国产免费一区二区三区在线观看| 欧美激情在线播放| 亚洲成人aaa| 国产精品视频永久免费播放| 久久久久久一区二区三区| 欧美三级免费观看| 亚洲最大av在线| 91精品国产一区| 欧美精品久久久久久久| 人体精品一二三区| 国产成人一区二区| 国产日韩欧美视频| 国产精品日韩欧美综合| 伦理中文字幕亚洲| 欧美视频二区36p| 欧美性xxxxxxxxx| 国产精品嫩草影院一区二区| 亚洲美女在线视频| 久久久免费av| 久国内精品在线| 国产亚洲精品91在线| 日韩中文在线中文网在线观看| 国产精品久久久久久久7电影| 97涩涩爰在线观看亚洲| 亚洲自拍小视频| 国产丝袜精品第一页| 色久欧美在线视频观看| 国产精品99久久久久久久久久久久| 亚洲视频网站在线观看| 欧美激情久久久| 久久久99久久精品女同性| 欧美午夜激情小视频| 91tv亚洲精品香蕉国产一区7ujn| 国产激情999| 黑人巨大精品欧美一区二区免费| 狠狠做深爱婷婷久久综合一区| www国产亚洲精品久久网站| 国产精品久久久久久中文字| 精品国模在线视频| 欧美激情在线狂野欧美精品| 日韩中文视频免费在线观看| 国产精品福利片| 秋霞成人午夜鲁丝一区二区三区| 欧美福利视频网站| 成人97在线观看视频| 欧美一性一乱一交一视频| 欧美肥臀大乳一区二区免费视频| 欧美激情在线观看视频| 亚洲自拍偷拍福利| 亚洲人成在线观| 久久久久女教师免费一区| 91系列在线播放| www.亚洲男人天堂| 性夜试看影院91社区| 欧美日韩免费区域视频在线观看| 国产一区二区在线免费视频| 日韩欧美高清视频| 久久韩国免费视频| 在线精品视频视频中文字幕| 亚洲成人激情视频| 国产va免费精品高清在线观看| 国产欧美一区二区三区视频| 国产精品丝袜高跟| 国产91在线播放精品91| 日本一欧美一欧美一亚洲视频| 亚洲a∨日韩av高清在线观看| 午夜精品福利电影| 国产视频精品一区二区三区| 国模视频一区二区| 久久久亚洲福利精品午夜| 91丨九色丨国产在线| 欧美激情亚洲国产| 欧美激情图片区| 亚洲第一视频在线观看| 精品视频在线观看日韩| 欧美激情综合亚洲一二区| 欧美寡妇偷汉性猛交| 欧美综合在线观看| 亚洲欧美国产高清va在线播| 日韩精品在线观看视频| 欧美午夜视频一区二区| 97久久精品在线| 57pao国产成人免费| 国内精品国产三级国产在线专| 久久激情五月丁香伊人| 国产成一区二区| 色婷婷综合久久久久| 欧美激情一级欧美精品| 伊人久久免费视频| 亚洲欧美国产精品久久久久久久| 日韩av成人在线观看| 色噜噜亚洲精品中文字幕| 亚洲国产成人久久综合| 7777免费精品视频| 国产在线播放不卡| 国产精品久久久久久久久久久不卡| 97精品久久久中文字幕免费| 日本国产高清不卡| 国产一区二区香蕉| 欧美激情啊啊啊| 亚洲另类图片色| 精品欧美国产一区二区三区| 亚洲精品国精品久久99热一| 成人亚洲综合色就1024| 一级做a爰片久久毛片美女图片| 欧美性20hd另类| 久久久精品电影| 亚洲成人久久久久| 美女福利精品视频| 国产欧美一区二区三区四区| 国产成人免费av| 18性欧美xxxⅹ性满足| 成人黄色短视频在线观看| 久久久久久999| 成人福利视频在线观看| 狠狠色噜噜狠狠狠狠97| 久久影视免费观看| 国产成人精品视频| 综合欧美国产视频二区| 亚洲理论片在线观看| 在线观看精品国产视频| 欧美午夜www高清视频| 欧美一乱一性一交一视频| 亚洲精品午夜精品| 亚洲色在线视频| 亚洲精品99999| 成人国产精品久久久| 亚洲色图综合网| 久久在线视频在线| 欧美日韩中文在线观看| 亚洲理论电影网| 成人激情免费在线| 亚洲午夜精品久久久久久久久久久久| 青青久久av北条麻妃海外网| 成人黄色在线免费| 91sao在线观看国产| 美女啪啪无遮挡免费久久网站| 欧美国产日韩一区二区三区| 欧美激情在线视频二区| 精品偷拍一区二区三区在线看| 亚洲色图日韩av| 成人欧美在线观看| 久久久久亚洲精品成人网小说| 国产精品入口日韩视频大尺度| 国产精品欧美亚洲777777| 国产视频一区在线| 国产精品视频不卡| 美乳少妇欧美精品| 国产va免费精品高清在线观看| 亚洲精品欧美日韩| 欧美裸体xxxxx| 在线成人中文字幕|