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.SetNumberArticlesGroup(idgroup); ArticleView.SetCurrentPage(page); } else { ArticleView.SetPageSize(20); ArticleView.SetNumberArticlesGroup(idgroup); ArticleView.SetCurrentPage(page); Session["SSArticleAll"] = ArticleView; } DataSet dsArticle = ArticleView.ArticleGroupSelectFromTo(idgroup); 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); }
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.SetNumberArticlesGroup(idgroup); ArticleView.SetCurrentPage(page); } else { ArticleView.SetPageSize(20); ArticleView.SetNumberArticlesGroup(idgroup); ArticleView.SetCurrentPage(page); Session["SSArticleAll"] = ArticleView; } DataSet dsArticle = ArticleView.ArticleGroupSelectFromTo(idgroup); 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; }
public void ShowListArticle() { int idgroup = 0; int page = 0; try { idgroup = int.Parse(Request.QueryString["idgroup"].ToString()); } catch { } try { page = int.Parse(Request.QueryString["page"].ToString()); } catch { } CDymanicviewArticles articleList = new CDymanicviewArticles(); if (Session["SSAdminArticle"] == null) { articleList.SetPageSize(20); if (idgroup > 0) { articleList.SetIdGroup(idgroup); articleList.BuildWhere(); } articleList.AdminSetNumarticle(); if (page > 0) { articleList.SetCurrentPage(page); } else { articleList.SetCurrentPage(1); } Session["SSAdminArticle"] = articleList; } else { articleList = (CDymanicviewArticles)Session["SSAdminArticle"]; if (idgroup > 0) { articleList.SetIdGroup(idgroup); articleList.BuildWhere(); } articleList.AdminSetNumarticle(); if (page > 0) { articleList.SetCurrentPage(page); } else { articleList.ReSetCurrentPage(); } } DataSet dsarticle = articleList.AdminArticleFromTo(); int numarticle = 0; if (dsarticle.Tables.Count > 0) { numarticle = dsarticle.Tables[0].Rows.Count; } if (articleList.GetPages() > 1) { BuildPage(articleList.GetCurrentPage(), articleList.GetPages()); } if (numarticle > 0) { strTable = "<table border='1' cellpadding='2' cellspacing='0' bordercolor='#DFDFDF' style='border-collapse:collapse;' width='730'>"; strTable += "<tr class='tlist'><td width='30'>STT</td><td width='200'>Tiêu đề tin đăng</td><td width='400'>Mô tả ngắn gọn</td><td width='50'>Hiển thị</td><td width='50'>Xóa bỏ</td></tr>"; for (int i = 1; i <= numarticle; i++) { string id = dsarticle.Tables[0].Rows[i - 1]["id"].ToString(); string check = ""; if (dsarticle.Tables[0].Rows[i - 1]["ishow"].ToString().Equals("1")) { check = "<input type='checkbox' checked='checked' DISABLED />"; } else { check = "<input type='checkbox' DISABLED />"; } strTable += "<tr><td align='center'>" + i.ToString() + "</td><td class='title1' width='200'><a href='?menu=edita&id=" + id + "'>" + dsarticle.Tables[0].Rows[i - 1]["title"].ToString() + "</a></td>"; strTable += "<td>" + dsarticle.Tables[0].Rows[i - 1]["sumarticle"].ToString() + "</td>"; strTable += "<td align='center'>" + check + "</td><td align='center'><span class='spanbt' onclick='Dfunction(" + id + ",7);'>Xóa</span></td></tr>"; } strTable += "</table>"; } else { strTable = "Chưa có tin nào"; } }