private DataSet DsGetCategoryByParentCategoryID(string t, string Lang) { ArticleCategory objCat = new ArticleCategory(); DataSet dsCategory = objCat.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, 0, Lang, t); return(dsCategory); }
/// <summary> /// Hiển thị level 2 và level 3 của ArticleCategory /// </summary> /// <param name="li"></param> /// <param name="Lang"></param> private void ShowListChildArticleCategory(DropDownList ddlArticleCategory, ListItem li, string Lang, string ContentType) { ArticleCategory obj = new ArticleCategory(); DataSet dsChild = obj.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, Convert.ToInt32(li.Value), Lang, ContentType); if (dsChild.Tables.Count > 0) { for (int i = 0; i < dsChild.Tables[0].Rows.Count; i++) { ListItem liChild = new ListItem("-------- " + Convert.ToString(dsChild.Tables[0].Rows[i]["CategoryName"]), Convert.ToString(dsChild.Tables[0].Rows[i]["CategoryID"])); ddlArticleCategory.Items.Add(liChild); DataSet dsLevel3 = obj.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, Convert.ToInt32(liChild.Value), Lang, ContentType); if (dsLevel3.Tables.Count > 0) { for (int j = 0; j < dsLevel3.Tables[0].Rows.Count; j++) { ListItem liLevel3 = new ListItem("------------ " + Convert.ToString(dsLevel3.Tables[0].Rows[j]["CategoryName"]), Convert.ToString(dsLevel3.Tables[0].Rows[j]["CategoryID"])); ddlArticleCategory.Items.Add(liLevel3); DataSet dsLevel4 = obj.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, Convert.ToInt32(liLevel3.Value), Lang, ContentType); if (dsLevel4.Tables.Count > 0) { for (int k = 0; k < dsLevel4.Tables[0].Rows.Count; k++) { ListItem liLevel4 = new ListItem("---------------- " + Convert.ToString(dsLevel4.Tables[0].Rows[k]["CategoryName"]), Convert.ToString(dsLevel4.Tables[0].Rows[k]["CategoryID"])); ddlArticleCategory.Items.Add(liLevel4); DataSet dsLevel5 = obj.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, Convert.ToInt32(liLevel4.Value), Lang, ContentType); if (dsLevel5.Tables.Count > 0) { for (int l = 0; l < dsLevel5.Tables[0].Rows.Count; l++) { ListItem liLevel5 = new ListItem("-------------------- " + Convert.ToString(dsLevel5.Tables[0].Rows[l]["CategoryName"]), Convert.ToString(dsLevel5.Tables[0].Rows[l]["CategoryID"])); ddlArticleCategory.Items.Add(liLevel5); } } } } } } } } }
public void LoadDropDownListArticleCategory(DropDownList ddlArticleCategory, string Lang, string SelectedText, string ContentType) { try { ddlArticleCategory.Items.Clear(); ddlArticleCategory.Attributes.Add("style", "color:Blue;font-size:14px;"); ddlArticleCategory.Items.Insert(0, new ListItem(SelectedText, "0")); ArticleCategory obj = new ArticleCategory(); DataSet dsParent = obj.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, 0, Lang, ContentType); for (int i = 0; i < dsParent.Tables[0].Rows.Count; i++) { ListItem liParent = new ListItem("---- " + Convert.ToString(dsParent.Tables[0].Rows[i]["CategoryName"]).ToUpper(), Convert.ToString(dsParent.Tables[0].Rows[i]["CategoryID"])); ddlArticleCategory.Items.Add(liParent); ShowListChildArticleCategory(ddlArticleCategory, liParent, Lang, ContentType); } } catch { } }
/// <summary> /// Load tên chuyên mục tin tức vào menu /// </summary> /// <param name="t"></param> public void LoadArticleCategoryMenu(string t) { try { string Lang = Globals.GetLang(); ArticleCategory objCat = new ArticleCategory(); DataSet ds = objCat.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, 0, Lang, t); string CatID = ""; string CategoryName = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { CatID = Convert.ToString(ds.Tables[0].Rows[i]["CategoryID"]); CategoryName = Convert.ToString(ds.Tables[0].Rows[i]["CategoryName"]); Response.Write("<li><a href=\"" + Globals.ApplicationPath + "ArticleList.aspx?CatID=" + CatID + "&t=" + t + "&Lang=" + Lang + "\">" + CategoryName + "</a>\n"); //Response.Write("<li><a href=\"" + Globals.ApplicationPath + "cdg/" + Lang + "/" + CatID + "/" + t + "/" + Globals.ConvertToVietnameseNotSignature(CategoryName) + ".html\">" + CategoryName + "</a>\n"); Response.Write("</li>\n"); } } catch { } }
/// <summary> /// Load các danh mục chủng loại Tin tức vào TreeViewCategory /// </summary> /// <param name="TreeViewCategory"></param> /// <param name="Lang"></param> public void LoadTreeViewCategory(TreeView TreeViewCategory, string Lang) { try { TreeViewCategory.Nodes.Clear(); ArticleCategory obj = new ArticleCategory(); DataSet dsParent = obj.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, 0, Lang, t); for (int i = 0; i < dsParent.Tables[0].Rows.Count; i++) { TreeNode newNode = new TreeNode(Convert.ToString(dsParent.Tables[0].Rows[i]["CategoryName"]), Convert.ToString(dsParent.Tables[0].Rows[i]["CategoryID"])); newNode.ToolTip = Convert.ToString(dsParent.Tables[0].Rows[i]["CategoryName"]); newNode.NavigateUrl = "Category.aspx?Action=Edit&CateID=" + Convert.ToString(dsParent.Tables[0].Rows[i]["CategoryID"]) + "&Lang=" + ddlLanguage2.SelectedValue + "&t=" + t; newNode.ExpandAll(); //RootNode.ChildNodes.Add(newNode); TreeViewCategory.Nodes.Add(newNode); PopulateCatagoryNode(newNode, Lang); } } catch { } }
/// <summary> /// Điền vào node con /// </summary> /// <param name="n"></param> private void PopulateCatagoryNode(TreeNode n, string Lang) { try { ArticleCategory obj = new ArticleCategory(); DataSet dsChild = obj.GetCategoryByParentCategoryID("ArticleCategory", Globals.AgentCatID, Convert.ToInt32(n.Value), Lang, t); if (dsChild.Tables.Count > 0) { for (int i = 0; i < dsChild.Tables[0].Rows.Count; i++) { TreeNode newNode = new TreeNode(Convert.ToString(dsChild.Tables[0].Rows[i]["CategoryName"]), Convert.ToString(dsChild.Tables[0].Rows[i]["CategoryID"])); newNode.Expand(); newNode.ToolTip = Convert.ToString(dsChild.Tables[0].Rows[i]["CategoryName"]); newNode.NavigateUrl = "Category.aspx?Action=Edit&CateID=" + Convert.ToString(dsChild.Tables[0].Rows[i]["CategoryID"]) + "&Lang=" + ddlLanguage2.SelectedValue + "&t=" + t; n.ChildNodes.Add(newNode); PopulateCatagoryNode(newNode, Lang); } } } catch { } }