예제 #1
0
        public ActionResult GetTableFiledTreeJson(string dataBaseLinkId, string tableName, string nameId)
        {
            List <string> nameArray = new List <string>();

            if (!string.IsNullOrEmpty(nameId))
            {
                nameArray = new List <string>(nameId.Split(','));
            }
            var        data     = new DataBaseTableBLL(dataBaseLinkId).GetTableFiledList(dataBaseLinkId, tableName);
            var        treeList = new List <TreeEntity>();
            TreeEntity tree     = new TreeEntity();

            tree.id          = tableName;
            tree.text        = tableName;
            tree.value       = tableName;
            tree.parentId    = "0";
            tree.img         = "fa fa-list-alt";
            tree.isexpand    = true;
            tree.complete    = true;
            tree.hasChildren = true;
            treeList.Add(tree);
            foreach (DataBaseTableFieldEntity item in data)
            {
                tree                = new TreeEntity();
                tree.id             = item.f_column;
                tree.text           = item.f_remark + "(" + item.f_column + ")";
                tree.value          = item.f_remark;
                tree.parentId       = tableName;
                tree.img            = "fa fa-wrench";
                tree.isexpand       = true;
                tree.complete       = true;
                tree.showcheck      = true;
                tree.checkstate     = nameArray.Contains(item.f_column) == true ? 1 : 0;
                tree.hasChildren    = false;
                tree.Attribute      = "type";
                tree.AttributeValue = CommHelper.FindModelsTypeEx(item.f_datatype);
                treeList.Add(tree);
            }
            return(Content(treeList.TreeToJson()));
        }