正在从数据集生成JSON
本文关键字:JSON 数据集 | 更新日期: 2024-10-23 00:20:48
我正在使用ExtJS生成一个树。它需要以下格式的JSON:
{ "children": [{
"text": "Invisible",
"expanded": true,
"children": [{
"text": "Billing",
"leaf": true
}, {
"text": "Sales",
"leaf": true
}]
},
{
"text": "Visible",
"expanded": true,
"children": [{
"text": "Equipment",
"leaf": true
}, {
"text": "Process",
"leaf": true
}]
}]
}
我在数据集中得到的结果是:
text nbsp nbsp nbsp nbsp nbsp nbsp nbsp 可见 nbsp nbsp;leaf nbsp nbsp;展开
计费 nbsp nbsp nbsp nbsp nbsp 0 nbsp nbsp nbsp nbsp nbsp nbsp;true nbsp false
销售 nbsp nbsp nbsp nbsp nbsp 0 nbsp nbsp nbsp nbsp nbsp nbsp;true nbsp false
设备 nbsp 1 nbsp nbsp nbsp nbsp nbsp nbsp;true nbsp false
流程 nbsp nbsp nbsp 1 nbsp nbsp nbsp nbsp nbsp nbsp;true nbsp false
所有visible="1"的记录都应在"visible"节点下生成,所有visibble="0"的记录均应在"Invisible"节点上生成。我只是无法生成JSON。如何以上述格式生成?
我创建了一个类,如下所示:
public class TreeNode
{
public string text { get; set; }
public bool leaf { get; set; }
public bool expanded { get; set; }
public List<TreeNode> children { get; set; }
public TreeNode()
{
leaf = false;
expanded = true;
children = new List<TreeNode>();
}
}
根据返回的数据集,我创建了如下对象:
List<TreeNode> treeNodeList = new List<TreeNode>();
treeNodeList.Add(new TreeNode
{
text = "Invisible",
expanded = true,
leaf = false
});
treeNodeList.Add(new TreeNode
{
text = "Visible",
expanded = true,
leaf = false
});
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
treeNodeList[0].children.Add(new TreeNode
{
text = ds.Tables[0].Rows[i][0].ToString(),
leaf = true
});
}
}
if (ds.Tables.Count > 1)
{
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
treeNodeList[1].children.Add(new TreeNode
{
text = ds.Tables[1].Rows[i][0].ToString(),
leaf = true
});
}
}
return treeNodeList;