最近在学习web开发,显示数据,但现在遇到一个问题,弄了一天了,还是没有解决希望可以得到大家帮助.
我在用jqgrid显示数据,但一直没成功,代码如下
jQuery("#list4").jqGrid({
url: "/DataCollection/SpJj?StartDate=" + $("#StartDate").val() + "&StopDate" + $("#StopDate").val(),
datatype: "json",
colNames: ['承办部门',
'30日以内', '金额',
'30日以内', '金额',
'10日以内', '金额',
'20日以内, '金额',
'30日以内', '金额',
'60日以内', '金额',
'45日以内', '金额',
'15日以内', '金额',
'60日以内', '金额'], colModel: [{ name: 'cbbmmc', index: 'cbbmmc', width: 50, align: "center" },
{ name: 'MsIn30Days', index: 'MsIn30Days', width: 50, align: "center" },
{ name: 'JjMsIn30Days', index: 'JjMsIn30Days', width: 50, align: "center" },
{ name: 'XzIn30Days', index: 'XzIn30Days', width: 50, align: "center" },
{ name: 'JjXzIn30Days', index: 'JjXzIn30Days', width: 50, align: "center" },
{ name: 'XsIn10Days', index: 'XsIn10Days', width: 50, align: "center" },
{ name: 'JjXsIn10Days', index: 'JjXsIn10Days', width: 50, align: "center" },
{ name: 'FsxzIn20Days', index: 'FsxzIn20Days', width: 50, align: "center" },
{ name: 'JjFsxzIn20Days', index: 'JjFsxzIn20Days', width: 50, align: "center" },
{ name: 'ZjIn30Days', index: 'ZjIn30Days', width: 50, align: "center" },
{ name: 'JjZjIn30Days', index: 'JjZjIn30Days', width: 50, align: "center" },
{ name: 'MsIn60Days', index: 'MsIn60Days', width: 50, align: "center" },
{ name: 'JjMsIn60Days', index: 'JjMsIn60Days', width: 50, align: "center" },
{ name: 'XzIn45Days', index: 'XzIn45Days', width: 50, align: "center" },
{ name: 'JjXzIn45Days', index: 'JjXzIn45Days', width: 50, align: "center" },
{ name: 'XsIn15Days', index: 'XsIn15Days', width: 50, align: "center" },
{ name: 'JjXsIn15Days', index: 'JjXsIn15Days', width: 50, align: "center" },
{ name: 'ZjIn60Days', index: 'ZjIn60Days', width: 50, align: "center" },
{ name: 'JjZjIn60Days', index: 'JjZjIn60Days', width: 50, align: "center"}],
rowNum:10,
multiselect: true,
caption: "奖金发放情况"
});通过mvc 3框架,用C#返回的数据如下.
[
{"cbbmmc":"部门一","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门二","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门三","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门四","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门五","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门六","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门七","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门八","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门九","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门十","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门十一","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0}
不知为什么一直没办法显示.
我在用jqgrid显示数据,但一直没成功,代码如下
jQuery("#list4").jqGrid({
url: "/DataCollection/SpJj?StartDate=" + $("#StartDate").val() + "&StopDate" + $("#StopDate").val(),
datatype: "json",
colNames: ['承办部门',
'30日以内', '金额',
'30日以内', '金额',
'10日以内', '金额',
'20日以内, '金额',
'30日以内', '金额',
'60日以内', '金额',
'45日以内', '金额',
'15日以内', '金额',
'60日以内', '金额'], colModel: [{ name: 'cbbmmc', index: 'cbbmmc', width: 50, align: "center" },
{ name: 'MsIn30Days', index: 'MsIn30Days', width: 50, align: "center" },
{ name: 'JjMsIn30Days', index: 'JjMsIn30Days', width: 50, align: "center" },
{ name: 'XzIn30Days', index: 'XzIn30Days', width: 50, align: "center" },
{ name: 'JjXzIn30Days', index: 'JjXzIn30Days', width: 50, align: "center" },
{ name: 'XsIn10Days', index: 'XsIn10Days', width: 50, align: "center" },
{ name: 'JjXsIn10Days', index: 'JjXsIn10Days', width: 50, align: "center" },
{ name: 'FsxzIn20Days', index: 'FsxzIn20Days', width: 50, align: "center" },
{ name: 'JjFsxzIn20Days', index: 'JjFsxzIn20Days', width: 50, align: "center" },
{ name: 'ZjIn30Days', index: 'ZjIn30Days', width: 50, align: "center" },
{ name: 'JjZjIn30Days', index: 'JjZjIn30Days', width: 50, align: "center" },
{ name: 'MsIn60Days', index: 'MsIn60Days', width: 50, align: "center" },
{ name: 'JjMsIn60Days', index: 'JjMsIn60Days', width: 50, align: "center" },
{ name: 'XzIn45Days', index: 'XzIn45Days', width: 50, align: "center" },
{ name: 'JjXzIn45Days', index: 'JjXzIn45Days', width: 50, align: "center" },
{ name: 'XsIn15Days', index: 'XsIn15Days', width: 50, align: "center" },
{ name: 'JjXsIn15Days', index: 'JjXsIn15Days', width: 50, align: "center" },
{ name: 'ZjIn60Days', index: 'ZjIn60Days', width: 50, align: "center" },
{ name: 'JjZjIn60Days', index: 'JjZjIn60Days', width: 50, align: "center"}],
rowNum:10,
multiselect: true,
caption: "奖金发放情况"
});通过mvc 3框架,用C#返回的数据如下.
[
{"cbbmmc":"部门一","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门二","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门三","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门四","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门五","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门六","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门七","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门八","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门九","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门十","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0},
{"cbbmmc":"部门十一","MsIn30Days":0,"JjMsIn30Days":0,"XzIn30Days":0,"JjXzIn30Days":0,"XsIn10Days":0,"JjXsIn10Days":0,"FsxzIn20Days":0,"JjFsxzIn20Days":0,"ZjIn30Days":0,"JjZjIn30Days":0,"MsIn60Days":0,"JjMsIn60Days":0,"XzIn45Days":0,"JjXzIn45Days":0,"XsIn15Days":0,"JjXsIn15Days":0,"ZjIn60Days":0,"JjZjIn60Days":0}
不知为什么一直没办法显示.
jquery easyUI,是这样的!
url:'server.php?q=2',
datatype: "json",
colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
colModel:[
{name:'id',index:'id', width:60, sorttype:"int"},
{name:'invdate',index:'invdate', width:90, sorttype:"date"},
{name:'name',index:'name', width:100},
{name:'amount',index:'amount', width:80, align:"right",sorttype:"float"},
{name:'tax',index:'tax', width:80, align:"right",sorttype:"float"},
{name:'total',index:'total', width:80,align:"right",sorttype:"float"},
{name:'note',index:'note', width:150, sortable:false}
],
rowNum:20,
rowList:[10,20,30],
pager: '#pager3',
sortname: 'id',
viewrecords: true,
sortorder: "desc",
loadonce: true,
caption: "Load Once Example"
});这段是示例代表,应该不是这个问题.
{"total":1,"
page":1,
"records":11,
"rows":
[{"cbbmc":"部门1","MsIn30Days":18},
{"cbbmc":"部门2","MsIn30Days":148},
{"cbbmc":"部门3","MsIn30Days":0}]}
代码找成
$("#SpJjSearch").click(function () {
jQuery("#list4").jqGrid({
url: "/DataCollection/SpJj?StartDate=" + $("#StartDate").val() + "&StopDate" + $("#StopDate").val(),
datatype: "json",
mtype: 'POST',
colNames: ['承办部门', '民事'],
colModel: [{ name: 'cbbmmc', index: 'cbbmmc', align: "center" },
{ name: 'MsIn30Days', index: 'MsIn30Days', align: "center" }
],
rowNum: 11,
viewrecords: true,
sorttable: false,
pager:'div1',
caption: "奖金发放情况"
}); });用的是mvc3可结果还是不出来,大哥大姐们帮帮我吧.