ext 动态tree json算法

最新推荐文章于 2024-09-13 17:32:25 发布

cy609329119

最新推荐文章于 2024-09-13 17:32:25 发布

阅读量420

点赞数

文章标签： tree json ext database dataset string

本文链接：https://blog.csdn.net/cy609329119/article/details/5062367

版权

protected List<CLTreeNode> getTree(string userid,string node)
        {
            List<CLTreeNode> tree = null;
            DataBase db = new DataBase();
            string sql = string.Empty;
            if (userid == "")
            {
                sql = @"select FID,FMENU_ID,FMENU_NAME,FMENU_URL,'false' as Checked from dbo.T_MODULE
                            WHERE FMENU_VISIBLE='1' AND FPARENT_MENUID='" + node + "' order by FID ASC";
            }
            else {

                sql = @"select * from dbo.fun_QueqyUserPower('" + userid + "') where fparent_menuid='" + node + "' order by FID asc";

            }

            DataSet ds = db.RuncmdDs(sql);
            if (ds.Tables[0].Rows.Count > 0)
            {
                tree = new List<CLTreeNode>();
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    CLTreeNode _treeNode = new CLTreeNode();
                    _treeNode.id = dr["FMENU_ID"].ToString().Trim();
                    _treeNode.text = dr["fmenu_name"].ToString().Trim();
                    _treeNode.Checked = Convert.ToBoolean(dr["Checked"].ToString());

                    List<CLTreeNode> ChildNode = getTree(userid,dr["FMENU_ID"].ToString());
                    if (ChildNode != null)
                    {
                        _treeNode.children = ChildNode;
                        _treeNode.expanded = true;

                    }
                    else
                    {
                        _treeNode.leaf = true;
                       // _treeNode.href = dr["Fmenu_URL"].ToString() == "" ? "#" : dr["Fmenu_URL"].ToString();

}
tree.Add(_treeNode);

}

return tree;

}