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 = dataBaseTableBLL.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.column;
tree.text = item.remark + "（" + item.column + "）";
tree.value = item.remark;
tree.parentId = tableName;
tree.Attribute = "type";
if (item.datatype == "varchar" || item.datatype == "nvarchar" || item.datatype == "text" || item.datatype == "ntext")
{
tree.AttributeValue = "字符串";
}
else if (item.datatype == "int" || item.datatype == "smallint" || item.datatype == "tinyint" || item.datatype == "decimall")
{
tree.AttributeValue = "数字";
}
else if (item.datatype == "datetime" || item.datatype == "smalldatetime")
{
tree.AttributeValue = "日期";
}
else
{
tree.AttributeValue = "字符串";
}
tree.img = "fa fa-wrench";
tree.isexpand = true;
tree.complete = true;
tree.showcheck = true;
tree.checkstate = nameArray.Contains(item.column) == true ? 1 : 0;
tree.hasChildren = false;
treeList.Add(tree);
}
return(Content(treeList.TreeToJson()));
}
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 = dataBaseTableBLL.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.column_name;
tree.text = item.remark + "（" + item.column_name + "）";
tree.value = item.remark;
tree.parentId = tableName;
tree.img = "fa fa-wrench";
tree.isexpand = true;
tree.complete = true;
tree.showcheck = true;
tree.checkstate = nameArray.Contains(item.column_name) == true ? 1 : 0;
tree.hasChildren = false;
treeList.Add(tree);
}
return(Content(treeList.TreeToJson()));
}