public string ShowArticles()
{
string tbarticle = "";
CDymanicviewArticles ArticleView = new CDymanicviewArticles();
try
{
int page = 1;
try
{
page = int.Parse(Request.QueryString["page"].ToString());
}
catch
{
}
if (Session["SSArticleAll"] != null)
{
ArticleView = (CDymanicviewArticles)Session["SSArticleAll"];
ArticleView.SetNumberArticleAll();
ArticleView.SetCurrentPage(page);
}
else
{
ArticleView.SetPageSize(20);
ArticleView.SetNumberArticleAll();
ArticleView.SetCurrentPage(page);
Session["SSArticleAll"] = ArticleView;
}
DataSet dsArticle = ArticleView.ArticleSelectAllFromTo();
int numArticle = 0;
if (dsArticle.Tables.Count > 0)
{
numArticle = dsArticle.Tables[0].Rows.Count;
}
string id = "";
string title = "";
string url = "";
string sum = "";
if (ArticleView.GetPages() > 1)
{
tpage += ": " + BuildPage(ArticleView.GetCurrentPage(), ArticleView.GetPages());
}
else
{
tpage = "";
}
tbarticle = "<table border='0' cellpadding='0' cellspacing='0' width='100%' align='left'>";
tbarticle += "<tr><td height='5' width='120'></td><td></td></tr>";
for (int i = 0; i < numArticle; i++)
{
id = dsArticle.Tables[0].Rows[i]["id"].ToString();
title = dsArticle.Tables[0].Rows[i]["title"].ToString();
sum = dsArticle.Tables[0].Rows[i]["sumarticle"].ToString();
url = dsArticle.Tables[0].Rows[i]["urlimage"].ToString();
if (url.Length > 0)
{
url = "image/img_article/" + url;
}
tbarticle += "<tr>";
if (url.Length > 0)
{
tbarticle += "<td height='95' align='center'><img src='" + url + "' width='110' height='85' /></td>";
tbarticle += "<td valign='top'>";
tbarticle += "<span class='text_2'><a href='?menu=da&id=" + id + "'>" + title + "</a></span>";
tbarticle += "<div>" + sum + " ...</div>";
tbarticle += "</td>";
}
else
{
tbarticle += "<td valign='top' height='95' colspan='2'>";
tbarticle += "<span class='text_2'><a href='?menu=da&id=" + id + "'>" + title + "</a></span>";
tbarticle += "<div>" + sum + " ...</div>";
tbarticle += "</td>";
}
tbarticle += "</tr>";
if (i + 1 < numArticle)
{
tbarticle += "<tr><td colspan='2' class='bg_line2'></td></tr>";
}
}
tbarticle += "</table>";
}
catch
{}
return(tbarticle);
}
