| 以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- json 生成 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=123544) |
| -- 作者：blackzhu -- 发布时间：2018/8/17 11:43:00 -- json 生成 {"headers":[ {"一月份":"Jan","二月份":"Feb"} ],"bodys":[ {"Jan":"20000","Feb":"30000"} ]
} 这种格式的json 是怎么生成的?
|
| -- 作者：blackzhu -- 发布时间：2018/8/17 11:44:00 -- headers 是 列名 bodys 是数据 |
| -- 作者：有点蓝 -- 发布时间：2018/8/17 11:45:00 -- 参考：http://www.foxtable.com/mobilehelp/scr/0167.htm |
| -- 作者：有点蓝 -- 发布时间：2018/8/17 11:52:00 -- Dim jo As New JObject Dim jo2 As New JObject Dim ja As New Jarray \'定义数组 jo2("一月份") = "Jan" jo2("二月份") = "Feb" ja.Add(jo2) jo("headers") = ja jo2 = New JObject jo2("Jan") = "20000" jo2("Feb") = "30000" ja = New Jarray ja.Add(jo2) jo("bodys") = ja Output.Show(jo.ToString)
|
| -- 作者：blackzhu -- 发布时间：2018/8/17 12:39:00 -- Dim ja As New JArray Dim jo As New JObject Dim jo2 As New JObject For Each cl As Col In Tables("排版表").Cols jo2(cl.Name) = cl.Name.ToString Next ja.Add(jo2) jo("headers") = ja Output.show(CompressJson(ja)) 这个代码有啥问题? 怎么headers 没了
[此贴子已经被作者于2018/8/17 13:43:39编辑过]
|
| -- 作者：blackzhu -- 发布时间：2018/8/17 13:58:00 -- Dim ja As New JArray Dim jo As New JObject Dim jo2 As New JObjectFor Each cl As Col In Tables("排版表").Cols If cl.Caption.Contains("_") Then jo2(cl.Name) = cl.Caption.Split("_")(1).tostring Else jo2(cl.Name) = cl.Caption.tostring End If Next ja.Add(jo2) jo("headers") = ja Output.show(ja.tostring) For Each dr As Row In Tables("排版表").Rows For Each cl As Col In Tables("排版表").Cols jo2(cl.Name) = dr(cl.Name).ToString Next ja.Add(jo2) Next jo("bodys") = ja Dim json As String = jo.ToString output.show(json) [ { "姓名": "姓名", "2018-08-01": "周三", "2018-08-02": "周四", "2018-08-03": "周五", "2018-08-04": "周六", "2018-08-05": "周日", "2018-08-06": "周一", "2018-08-07": "周二", "2018-08-08": "周三", "2018-08-09": "周四", "2018-08-10": "周五", "2018-08-11": "周六", "2018-08-12": "周日", "2018-08-13": "周一", "2018-08-14": "周二", "2018-08-15": "周三", "2018-08-16": "周四", "2018-08-17": "周五", "2018-08-18": "周六", "2018-08-19": "周日", "2018-08-20": "周一", "2018-08-21": "周二", "2018-08-22": "周三", "2018-08-23": "周四", "2018-08-24": "周五", "2018-08-25": "周六", "2018-08-26": "周日", "2018-08-27": "周一", "2018-08-28": "周二", "2018-08-29": "周三", "2018-08-30": "周四", "2018-08-31": "周五" } ] { "headers": [ { "姓名": "李爽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "病假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "黄丽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "休息", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李超男", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "年假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李爽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "病假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "黄丽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "休息", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李超男", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "年假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李爽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "病假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" } ], "bodys": [ { "姓名": "李爽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "病假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "黄丽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "休息", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李超男", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "年假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李爽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "病假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "黄丽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "休息", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李超男", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "年假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" }, { "姓名": "李爽", "2018-08-01": "", "2018-08-02": "", "2018-08-03": "", "2018-08-04": "", "2018-08-05": "", "2018-08-06": "", "2018-08-07": "", "2018-08-08": "", "2018-08-09": "", "2018-08-10": "", "2018-08-11": "", "2018-08-12": "", "2018-08-13": "", "2018-08-14": "", "2018-08-15": "", "2018-08-16": "病假", "2018-08-17": "", "2018-08-18": "", "2018-08-19": "", "2018-08-20": "", "2018-08-21": "", "2018-08-22": "", "2018-08-23": "", "2018-08-24": "", "2018-08-25": "", "2018-08-26": "", "2018-08-27": "", "2018-08-28": "", "2018-08-29": "", "2018-08-30": "", "2018-08-31": "" } ] } 数据格式变成这样的了, 问题出在什么地方?
[此贴子已经被作者于2018/8/17 14:01:24编辑过]
|
| -- 作者：blackzhu -- 发布时间：2018/8/17 14:15:00 -- 搞定了! |