我想將以下 JSON 對(duì)象加載到 Datatables.net 中，但它不起作用。我使用 SignalR 將 JSON 從服務(wù)器端傳遞到客戶端，并且它運(yùn)行，因?yàn)槲铱梢越邮?JSON，但無法將其加載到數(shù)據(jù)表中。請(qǐng)問有人可以幫助我嗎？提前致謝！C#代碼：cmm_dbEntities db = new cmm_dbEntities();var result = from a in db.TAB_PNjoin b in db.TAB_APPL on a.idapplicability equals b.idapplicabilityjoin c in db.TAB_ISSUE on a.idissue equals c.idissueselect new{? ? a.pn,? ? a.title,? ? b.appl_desc,? ? c.issue,? ? c.issue_date,? ? c.rev,? ? c.rev_date,? ? a.equipment,? ? a.formattype};var obj = new { data = result };string json = JsonConvert.SerializeObject(obj);return json;這是我的 JSON：{? ? "data": [{? ? ? ? "pn": "346B0300A3300.801",? ? ? ? "title": "Test Bench Replenish Unit, Engine Oil - Operation and Maintenance Manual with Illustrated Parts Breakdown",? ? ? ? "appl_desc": "DESCRIZIONE 005",? ? ? ? "issue": "ISSUE-003",? ? ? ? "issue_date": "2015-03-01T00:00:00",? ? ? ? "rev": "0003",? ? ? ? "rev_date": "AAAAAAAAB9M=",? ? ? ? "equipment": "Test Bench, Replenish Unit, Engine Oil",? ? ? ? "formattype": "XML"? ? }, {? ? ? ? "pn": "346B0300A3300.805",? ? ? ? "title": "Test Bench Replenish Unit, Engine Oil - Operation and Maintenance Manual with Illustrated Parts Breakdown",? ? ? ? "appl_desc": "DESCRIZIONE 015",? ? ? ? "issue": "ISSUE-004",? ? ? ? "issue_date": "2015-04-01T00:00:00",? ? ? ? "rev": "004",? ? ? ? "rev_date": "AAAAAAAAB9Q=",? ? ? ? "equipment": "Test Bench, Replenish Unit, Engine Oil",? ? ? ? "formattype": "XML"? ? }, {? ? ? ? "pn": "415808",? ? ? ? "title": "Operating and Maintenance Manual for Ni-Cd Aircraft batteries",? ? ? ? "appl_desc": "DESCRIZIONE 015",? ? ? ? "issue": "ISSUE-001",? ? ? ? "issue_date": "2015-01-01T00:00:00",? ? ? ? "rev": "0001",? ? ? ? "rev_date": "AAAAAAAAB9E=",? ? ? ? "equipment": "Battery",? ? ? ? "formattype": "XML"? ? },?}
2 回答
肥皂起泡泡
TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超6個(gè)贊
我沒有看到你設(shè)置屬性data。請(qǐng)data: data在初始化表時(shí)進(jìn)行賦值。
hub.client.inizializzaFiltri = function (data) {
console.log(data);
$('#PNTable').DataTable({
data: data //you are missing this
dataSrc: "objects",
columns: [
{ data: null, defaultContent: '' },
{ data: 'pn' },
{ data: 'title' },
{ data: 'appl_desc' },
{ data: 'issue' },
{ data: 'issue_date' },
{ data: 'rev' },
{ data: 'rev_date' },
{ data: 'equipment' },
{ data: 'formattype' }],
order: [[1, "asc"]],
columnDefs: [
{
orderable: false,
className: 'select-checkbox',
targets: 0
},
],
retrieve: true,
select: {
style: 'os',
selector: 'td:first-child'
}
});
}
蕭十郎
TA貢獻(xiàn)1815條經(jīng)驗(yàn) 獲得超13個(gè)贊
我是這樣解決的...
C#代碼：
? ? ...
? ? var obj = new { data = result };
? ? string json = JsonConvert.SerializeObject(obj);
? ? return json;
JS代碼：
hub.client.inizializzaFiltri = function (data) {
? ? var jsn = JSON.parse(data);
? ? $('#PNTable').DataTable({
? ? "bPaginate": false,
? ? "bLengthChange": false,
? ? "bFilter": true,
? ? "bInfo": true,
? ? "bAutoWidth": true,
? ? "dataSrc": "",
? ? "data": jsn.data,
? ? "dataSrc": jsn.data,
? ? ?responsive: true,
? ? ?columns: [
? ? ? ? { "data": null, defaultContent: '' },
? ? ? ? { "data": 'pn' },
? ? ? ? { "data": 'title' },? ? ? ??
? ? ? ? ?...
在將其放入數(shù)據(jù)表之前，我必須使用 JSON.parse(data) 反序列化 che JSON。
再次感謝
- 2 回答
- 0 關(guān)注
- 167 瀏覽
添加回答
舉報(bào)
0/150
提交
取消