Example #1
0
        /// <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);
        }
Example #2
0
 /// <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;
 }