/// <summary> /// 取左栏类别树 /// </summary> /// <returns>json</returns> private string doSelect() { string treeStr = ""; string langFlag = Convert.ToString(Utils.GetCookie("LangFlag")); using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + langFlag + "' order by [Cate_Order] asc"; DataTable cateDt = session.GetTable(Sql); //if (cateDt.Rows.Count > 0) //{ cateMangeTree jTree = new cateMangeTree(); treeStr = jTree.CreateTree(cateDt); parentSelectTree pTree = new parentSelectTree(); treeStr = treeStr + "$|&|$" + pTree.CreateTree(cateDt); //} } return(treeStr); }
/// <summary> /// 取左栏类别树 /// </summary> /// <returns>json</returns> private string doSelect() { string treeStr = ""; string langFlag = Convert.ToString(Utils.GetCookie("LangFlag")); using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession()) { string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_HasChild from [Dcms_Cate] where Cate_Lang='" + langFlag + "' order by [Cate_Order] asc"; DataTable cateDt = session.GetTable(Sql); //if (cateDt.Rows.Count > 0) //{ cateMangeTree jTree = new cateMangeTree(); treeStr = jTree.CreateTree(cateDt); parentSelectTree pTree = new parentSelectTree(); treeStr = treeStr + "$|&|$" + pTree.CreateTree(cateDt); //} } return treeStr; }