一个关于jqgrid的问题

最近在学习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}
不知为什么一直没办法显示.

解决方案 »

  1.   

     colModel[[]]是不是需要2个这样的，
    jquery easyUI，是这样的！
      

  2.   

    jQuery("#list3").jqGrid({
        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"
    });这段是示例代表,应该不是这个问题.
      

  3.   

    我把数据换成了
    {"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可结果还是不出来,大哥大姐们帮帮我吧.