public static string loadMenuAll()
{
DataService db = new DataService();
basic b = new basic();
DataTable dt = db.myTable_sp("sp_Sel_Menu");
// DataTable dt1 = db.myTable_sp();
string s = "";
if (dt.Rows.Count > 0)
{
s += "<div class=\"menuTop\">";
s += "<ul id=\"nav\" class=\"mainmenuTop\">";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i < 2)
{
s += string.Format("<li> <a href=\"{0}\">{1}</a>", dt.Rows[i]["Link"].ToString(), dt.Rows[i]["Menu"].ToString());
}
else
{
s += string.Format("<li> <a href=\"{0}?m={2}&c=0&page=1\">{1}</a>", dt.Rows[i]["Link"].ToString(), dt.Rows[i]["Menu"].ToString(), dt.Rows[i]["Id"].ToString());
}
SqlParameter p = new SqlParameter("@where", b.toInt(dt.Rows[i]["Id"].ToString()));
DataTable dt1 = db.myTable_sp("sp_Sel_Where_Pages", p);
if (dt1.Rows.Count > 0)
{
s += "<ul id=\"nav1\" class=\"submenuTop\">";
for (int j = 0; j < dt1.Rows.Count; j++)
{
s += string.Format("<li> <a href=\"{0}?m={2}&c={3}&page=1\">{1}</a>", dt1.Rows[j]["Page"].ToString(), dt1.Rows[j]["Category"].ToString(), dt.Rows[i]["Id"].ToString(), dt1.Rows[j]["Id"].ToString());
s += "</li>";
}
s += "</ul>";
}
s += "</li>";
}
s += "</ul>";
s += "</div>";
}
return(s);
}
public static string load_OneGroup()
{
MenuBLL mnu = new MenuBLL();
PagesBLL p = new PagesBLL();
ArticleBLL at = new ArticleBLL();
basic b = new basic();
string xau = "";
DataTable menu = mnu.Menus();
for (int i = 2; i < 7; i++)
{
xau += " <div class='news_listbox'>" +
"<a class='home_news_rss' href='/ketqua.tintuc?hq=xahoi&mode=rss'></a>" +
" <div class='news_list_title'>" +
string.Format("<a href='articleGroup.aspx?m={0}&c=0&page=1' class='main_cat_tab'> <span>{1}</span> </a>", menu.Rows[i]["Id"].ToString(), menu.Rows[i]["Menu"].ToString()) +
" <div class='sub_main_cat'>";
DataTable subMenu = p.myPages_Where(int.Parse(menu.Rows[i]["Id"].ToString()));
DataTable aticle = at.myArticle_Top5tin(int.Parse(menu.Rows[i]["Id"].ToString()));
if ((subMenu.Rows.Count > 0))
{
for (int j = 0; j < subMenu.Rows.Count; j++)
{
xau += string.Format("<a class='menucon' href='articleGroup.aspx?m={0}&c={1}&page=1'>{2}</a> <span class='sub_main_sperator'>|</span>", menu.Rows[i]["Id"].ToString(), (subMenu.Rows[j]["Id"].ToString()), subMenu.Rows[j]["Category"].ToString());
}
}
xau += " </div>";
xau += "<div style='clear: both;'></div>";
xau += "</div>";
if ((aticle.Rows.Count > 0))
{
string title1 = aticle.Rows[0]["Title"].ToString();
string khongdau1 = b.ConvertToUnTitle(title1.ToLower());
xau += "<div class='news_list_content'>";
xau += "<div>";
xau += string.Format(" <a class='img_box' href=''><img src='../Uploaded/{0}' class='lazyload'", aticle.Rows[0]["Source"].ToString());
xau += " alt='' style='background: url(images/inline_photo.png") no-repeat scroll center center rgb(255, 255, 255);'></a>";
xau += string.Format(" <h3><a class='new_list_link' title='' href='../ArticleDetail/{2}-{0}'>{1} </a></h3>", aticle.Rows[0]["Id"].ToString(), aticle.Rows[0]["Title"].ToString(), khongdau1);
xau += "<p>" + aticle.Rows[0]["Discription"].ToString() + "</p> </div>";
xau += "<div>";
xau += "<ul class='haicon'>";
if ((aticle.Rows.Count > 1))
{
string title = aticle.Rows[1]["Title"].ToString();
string khongdau = b.ConvertToUnTitle(title.ToLower());
//xau += string.Format("<li><a title='' href='ArticleDetail.aspx?at={0}'>{1}</a></li>", aticle.Rows[1]["Id"].ToString(), aticle.Rows[1]["Title"].ToString());
xau += string.Format("<li><a title='' href='../ArticleDetail/{2}-{0}'>{1}</a></li>", aticle.Rows[1]["Id"].ToString(), aticle.Rows[1]["Title"].ToString(), khongdau);
}
if ((aticle.Rows.Count > 2))
{
string title = aticle.Rows[2]["Title"].ToString();
string khongdau = b.ConvertToUnTitle(title.ToLower());
xau += string.Format("<li><a title='' href='../ArticleDetail/{2}-{0}'>{1}</a></li>", aticle.Rows[2]["Id"].ToString(), aticle.Rows[2]["Title"].ToString(), khongdau);
}
if ((aticle.Rows.Count > 3))
{
string title = aticle.Rows[3]["Title"].ToString();
string khongdau = b.ConvertToUnTitle(title.ToLower());
xau += string.Format("<li><a title='' href='../ArticleDetail/{2}-{0}'>{1}</a></li>", aticle.Rows[3]["Id"].ToString(), aticle.Rows[3]["Title"].ToString(), khongdau);
}
if ((aticle.Rows.Count > 4))
{
string title = aticle.Rows[4]["Title"].ToString();
string khongdau = b.ConvertToUnTitle(title.ToLower());
xau += string.Format("<li><a title='' href='../ArticleDetail/{2}-{0}'>{1}</a></li>", aticle.Rows[4]["Id"].ToString(), aticle.Rows[4]["Title"].ToString(), khongdau);
}
xau += "</ul></div> </div> </div>";
}
}
return(xau);
}
