假设我有以下数据集。
╔═════════════╦═══════════════╦═══════╗
║ Category ║ Item ║ Color ║
╠═════════════╬═══════════════╬═══════╣
║ Electronics ║ Mobile ║ Black ║
║ Electronics ║ Mobile ║ Green ║
║ Electronics ║ Laptop ║ Black ║
║ HomeNeeds ║ VaccumCleaner ║ white ║
║ HomeNeeds ║ Refrigerator ║ Red ║
║ Wearable ║ AppleWatch ║ Red ║
╚═════════════╩═══════════════╩═══════╝
我希望将其转换为以下JSON格式,以便加载到树形视图控件中。最好的方法是什么?主要区别在于合并相同的类别或项目!我可以在C#中逐个解析节点,检查它与前一个节点是否相同,如果相同则合并它!并手动创建它,但是否有其他替代方法而不是这个冗长和复杂的过程?
{
"Categories" : [
{"Electronics" : [
{"Mobile" : [
{"color":"Black"},
{"color":"Green"}
]},
{"Laptop":[
{"color":"Black"}
]}
]},
{"HomeNeeds":[
{"VaccumCleaner": [
{"color":"white"}
]},
{"Refrigerator":[
{"color": "Red"}
]}
]},
{"Wearable":[
{"Applewatch":[
{"color":"Red"}
]}
]}
]
}