jqxgrid未加载数据

Question

我正在尝试从我的控制器获取数据。查询可以正常工作，但我似乎无法在视图中加载数据。如果有人能看到我的错误，我将不胜感激。

控制器

  public ActionResult GetItemList(int RRGroupID)
        {

          var item = ReportEngineHelper.GetReportingEngine(Session).Generate<ItemListQuery>(new Filter()
            {
                Item=new Item()
                {
                    RRGroupID = RRGroupID,

                }
            }).ToQueryModel<ItemName>();
          var listItemName = new List<ItemName>();


            return Json(item, JsonRequestBehavior.AllowGet);
        }

视图

 var detailsSource =
                            {
                                    url: $.ajax({url: url,
                                                    type: "json",
                                                    data: {RRGroupID:RRGroupID},
                                                                }),
                                    datatype: "json",
                                datafields: [{ name: "ItemID", type: "int" }, { name: "FullItemName" }],
                            };
                            var detailsAdapter = new $.jqx.dataAdapter(detailsSource);
                            $("#jqxgrid").jqxGrid({
                                source: detailsAdapter,
                                autoheight:true,
                                autowidth: true,
                                columns: [
                           { text: 'Item Name', datafield: 'FullItemName', width: 200, editable: false },
                           { text: 'Unit', width: 100, editable: true },
                           { text: 'Beginning Balance', width: 180, editable: true },
                           { text: 'Loss', width: 80, editable: true, cellsalign: 'right' },
                           { text: 'Quantity Recieved', width: 90, editable: true, cellsalign: 'right'},
                           { text: 'DOS', width: 100, editable: true, cellsalign: 'right' },
                           { text: 'Requested Quantity', width: 100, editable: true, cellsalign: 'right'}
                                ],

                            });

Answer 1

   //this is your function build grid
   function buildDetail(data){
      var detailsSource:{
              localdata:data,
              datafields: [{ name: "ItemID", type: "int" }, { name: "FullItemName" }],
              type:'json',
           };
           var detailsAdapter = new $.jqx.dataAdapter(detailsSource);
                        $("#jqxgrid").jqxGrid({
                            source: detailsAdapter,
                            autoheight:true,
                            autowidth: true,
                            columns: [
                       { text: 'Item Name', datafield: 'FullItemName', width: 200, editable: false },
                       { text: 'Unit', width: 100, editable: true },
                       { text: 'Beginning Balance', width: 180, editable: true },
                       { text: 'Loss', width: 80, editable: true, cellsalign: 'right' },
                       { text: 'Quantity Recieved', width: 90, editable: true, cellsalign: 'right'},
                       { text: 'DOS', width: 100, editable: true, cellsalign: 'right' },
                       { text: 'Requested Quantity', width: 100, editable: true, cellsalign: 'right'}
                            ],

                        });
  }


 // now get your data with ajax then build grid.
 $(document).ready(function(){
     $.ajax({url: url,
             type: "json",
             data: {RRGroupID:RRGroupID},
            success:function(data){ 
               //now call your build function
               buildDetail(data);
             }
        });
 })

通过这种方式，您无需使用jqx.ajax即可加载数据