public static void CreateOneArticleHtml(int article_id)
{
ArtBll artBll = new ArtBll();
if (article_id > 0)
{
// string sql = @"Select t_article.id as articleId,t_article.title,t_article.title1,t_article.source,t_article.keyword,t_article.daoyu,t_article.content,
// t_article.type,t_article.update_date,t_article.declare_mark,t_article.pic as artPic,t_article.html,t_article.remark,
// t_article_type.id as type_id,t_article_type.type_name,tag,t_article.tag_id
// FROM t_article LEFT JOIN t_article_type ON t_article.type=t_article_type.id
// WHERE t_article.id=" + article_id;
string sql = @"Select t_article.id as articleId,t_article.title,t_article.title1,t_article.source,t_article.keyword,t_article.daoyu,t_article.content,t_article.type,t_article.update_date,t_article.declare_mark,t_article.pic as artPic,t_article.html,t_article.remark,t_article.last_id,t_article.next_id,
t_article1.html AS last_html,t_article1.title AS last_title,t_article2.html AS next_html,t_article2.title AS next_title,
t_article_type.id as type_id,t_article_type.type_name,t_article.tag,t_article.tag_id,t_article.search_keyword
FROM (((t_article
LEFT JOIN t_article_type ON (t_article.type=t_article_type.id) )
LEFT JOIN t_article t_article1 ON (t_article.last_id=t_article1.id) )
LEFT JOIN t_article t_article2 ON (t_article.next_id=t_article2.id))
WHERE t_article.id=" + article_id;
DataTable dt = artBll.SelectToDataTable(sql);
if (dt.Rows.Count > 0)
{
//articleId = Convert.ToInt32(dt.Rows[i]["id"]);
//string article_html = dt.Rows[i]["html"].ToString();
//this.CteateHTML(url + "/article/content.aspx?pc=" + pc + "&a_id=" + articleId, staticPath, article_html);
int articleId = Convert.ToInt32(dt.Rows[0]["articleId"]);
string title = dt.Rows[0]["title"].ToString();
string title1 = dt.Rows[0]["title1"].ToString();
string source = dt.Rows[0]["source"].ToString();
int articleType = Convert.ToInt32(dt.Rows[0]["type_id"]);
string articleTypeName = dt.Rows[0]["type_name"].ToString();
string content = dt.Rows[0]["content"].ToString();
string keyword = dt.Rows[0]["keyword"].ToString();
string search_keyword = dt.Rows[0]["search_keyword"].ToString();
string artPic = dt.Rows[0]["artPic"].ToString();
string article_html = dt.Rows[0]["html"].ToString();
string tagStr = dt.Rows[0]["tag"].ToString();
string tagIdHtml = dt.Rows[0]["tag_id"].ToString();
string update_date = Convert.ToDateTime(dt.Rows[0]["update_date"]).ToString("yyyy年M月d日");
string tag_id = dt.Rows[0]["tag_id"].ToString();
if (tagIdHtml.Trim() != "")
{
string[] tagArray = tagIdHtml.Split(',');
for (int j = 0; j < tagArray.Length; j++)
{
if (tagArray[j].Trim() != "" && tagArray[j].Trim() != ",")
{
tagIdHtml = tagArray[j].Trim();
break;
}
}
}
string last_title = "上一篇：" + dt.Rows[0]["last_title"].ToString();
string last_html = dt.Rows[0]["last_html"].ToString();
string next_title = "下一篇：" + dt.Rows[0]["next_title"].ToString();
string next_html = dt.Rows[0]["next_html"].ToString();
//生成静态页
CommonMethod.CreateArticleHtml(articleId, title, title1, source, articleType, articleTypeName, content, keyword, artPic, article_html, tagStr, tag_id, tagIdHtml, update_date, last_html, last_title, next_html, next_title, search_keyword);
}
}
}
