jgGrid pivot reload重新加载及刷新数据-白红宇

jgGrid pivot reload重新加载及刷新数据

阅读量：4519 次

发布时间：2019-06-08

本文共 2432 字，大约阅读时间需要 8 分钟。

1.当使用jqGrid进行多维表时，reload方法会不停的重复增加标题的行数。

解决办法：直接删除jqGrid,重新初始化页面。

function query(){
   //crossTable pivot不能用新数据去reload,只能重新初始化和生成jqgrid    $("#showReport div").remove();    $("#showReport").append("
     
");    $("#showReport").append("
     
");    pageInit(newJson);}

2.初始化方法

function pageInit(jsonArray){$("#jqGridList").jqGrid('jqPivot',      jsonArray,//'<%=basePath%>js/data/data_copy.json',      // pivot options      {        xDimension : [          {            dataName: 'group',             width:90          },          {            dataName: 'name'          }        ],        yDimension : [          {            dataName: 'country',            width:130          }        ],        aggregates : [          {             member : 'amount',             aggregator : 'sum',             width:130,            label:'合计汇总',            formatter:'integer',            align:'right',            summaryType: 'sum'          }          ,{             member : 'amount',             aggregator : 'count',             width:100,            label:'Count',            formatter:'integer',            align:'right',            summaryType: 'sum'          }                  ],        colTotals: true,        rowTotals: true      },       // grid options      {        width: 1000,        rowNum : 10,        pager: "#pager2",        caption: "Rows grouping"      }); };

3.数据：

var newJson=[ {        "CategoryName" : "Beverages",        "ProductName" : "Steeleye Stout",        "Country" : "UK",        "Price" : "1008.0000",        "Quantity" : "65"    }, {        "CategoryName" : "Beverages",        "ProductName" : "Laughing Lumberjack Lager",        "Country" : "USA",        "Price" : "140.0000",        "Quantity" : "10"    }, {        "CategoryName" : "Beverages",        "ProductName" : "Lakkalik\u00f6\u00f6ri",        "Country" : "USA",        "Price" : "2160.0000",        "Quantity" : "120"    }, {        "CategoryName" : "Beverages",        "ProductName" : "Guaran\u00e1 Fant\u00e1stica",        "Country" : "USA",        "Price" : "436.5000",        "Quantity" : "97"    }, {        "CategoryName" : "Beverages",        "ProductName" : "Ipoh Coffee",        "Country" : "UK",        "Price" : "1656.0000",        "Quantity" : "36"    }];

4.html