jquery 处理 json 数据问题

Question

var json={"Table1":[{"XMID":"B0","ysdate":"2015-01-01T00:00:00","SZH":7373.0},{"XMID":"B0","ysdate":"2015-01-02T00:00:00","SZH":7845.0},{"XMID":"C0","ysdate":"2015-01-01T00:00:00","SZH":327.0},{"XMID":"C0","ysdate":"2015-01-02T00:00:00","SZH":295.0},{"XMID":"D","ysdate":"2015-01-01T00:00:00","SZH":211.0},{"XMID":"D","ysdate":"2015-01-02T00:00:00","SZH":254.0},{"XMID":"K","ysdate":"2015-01-01T00:00:00","SZH":7911.0},{"XMID":"K","ysdate":"2015-01-02T00:00:00","SZH":8394.0}]}

最终想要js输出表格：
ysdate B0 C0 D K
2015-01-01 7373.0 327.0 211.0 7911.0
2015-01-02 7845.0 295.0 254.0 9394.0

Answer 1

js处理就好了吧。。jquery还不一样是js写的，归类下数据

    var json = { "Table1": [
    { "XMID": "B0", "ysdate": "2015-01-01T00:00:00", "SZH": 7373.0 },
    { "XMID": "B0", "ysdate": "2015-01-02T00:00:00", "SZH": 7845.0 },
    { "XMID": "C0", "ysdate": "2015-01-01T00:00:00", "SZH": 327.0 },
    { "XMID": "C0", "ysdate": "2015-01-02T00:00:00", "SZH": 295.0 },
    { "XMID": "D", "ysdate": "2015-01-01T00:00:00", "SZH": 211.0 },
    { "XMID": "D", "ysdate": "2015-01-02T00:00:00", "SZH": 254.0 },
    { "XMID": "K", "ysdate": "2015-01-01T00:00:00", "SZH": 7911.0 },
    { "XMID": "K", "ysdate": "2015-01-02T00:00:00", "SZH": 8394.0}]
    };
    var rows = json.Table1,item;
    var result = {},ritem;
    for (var i = 0, j = rows.length; i < j; i++) {
        item = rows[i];
        ritem = result[item.ysdate] || {};
        if (ritem[item.XMID]) ritem[item.XMID] += ',' + item.SZH;
        else ritem[item.XMID] = item.SZH;
        result[item.ysdate] = ritem;
    }
    var s = '<table border="1"><tr><th>ysdate</th><th>B0</th><th>C0</th><th>D</th><th>K</th></tr>';
    for (k in result) {
        s += '<tr><td>' + (k.split('T')[0]) + '</td><td>' + result[k].B0 + '</td><td>' + result[k].C0 + '</td><td>' + result[k].D + '</td><td>' + result[k].K + '</td></tr>';
    }
    s += '</table>';
    document.write(s);