如何用sql查询到的数据生成需求的json格式
查询内容:
Dim cmd As New SQLCommand
cmd.C
cmd.CommandText = "S ELECT level,appType,desc FROM 明细"
cmd.CommandTimeOut = 50000
Dim dt As DataTable = cmd.ExecuteReader()
需求数据处理的格式
{
"data": {
"responseData": {
"data": [
{
"level": "A",
"appType": "小贷业务",
"desc": "风险小,借款多"
},
{
"level": "B",
"appType": "增值业务",
"desc": "风险小,借款多"
}
],
"totals": 2
},
"columnData": [
{
"key": "level",
"text": "风险级别"
},
{
"key": "appType",
"text": "业务类型"
},
{
"key": "desc",
"text": "风险描述"
}
]
}
}
[此贴子已经被作者于2021/6/24 20:53:47编辑过]