pqgrid对json数据的绑定

$(function () {
    var data = [[1, 'Exxon Mobil', '339,938.0', '36,130.0'],
        [2, 'Wal-Mart Stores', '315,654.0', '11,231.0'],
        [3, 'Royal Dutch Shell', '306,731.0', '25,311.0'],
        [4, 'BP', '267,600.0', '22,341.0'],
        [5, 'General Motors', '192,604.0', '-10,567.0'],
        [6, 'Chevron', '189,481.0', '14,099.0'],
        [7, 'DaimlerChrysler', '186,106.3', '3,536.3'],
        [8, 'Toyota Motor', '185,805.0', '12,119.6'],
        [9, 'Ford Motor', '177,210.0', '2,024.0'],
        [10, 'ConocoPhillips', '166,683.0', '13,529.0'],
        [11, 'General Electric', '157,153.0', '16,353.0'],
        [12, 'Total', '152,360.7', '15,250.0'],
        [13, 'ING Group', '138,235.3', '8,958.9'],
        [14, 'Citigroup', '131,045.0', '24,589.0'],
        [15, 'AXA', '129,839.2', '5,186.5'],
        [16, 'Allianz', '121,406.0', '5,442.4'],
        [17, 'Volkswagen', '118,376.6', '1,391.7'],
        [18, 'Fortis', '112,351.4', '4,896.3'],
        [19, 'Crédit Agricole', '110,764.6', '7,434.3'],
        [20, 'American Intl. Group', '108,905.0', '10,477.0']];
 
 
    var obj = { width: 700, height: 400, title: "Grid From Array" };
    obj.colModel = [{ title: "Rank", width: 100, dataType: "integer" },
    { title: "Company", width: 200, dataType: "string" },
    { title: "Revenues ($ millions)", width: 150, dataType: "float", align: "right" },
    { title: "Profits ($ millions)", width: 150, dataType: "float", align: "right"}];
    obj.dataModel = { data: data };
    var $grid = $("#grid_parts").pqGrid(obj);
    $("#grid_parts_topVisible").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "topVisible", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "topVisible"));
    $("#grid_parts_bottomVisible").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "bottomVisible", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "bottomVisible"));
    $("#grid_parts_columnBorders").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "columnBorders", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "columnBorders"));
    $("#grid_parts_rowBorders").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "rowBorders", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "rowBorders"));
    $("#grid_parts_oddRowsHighlight").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "oddRowsHighlight", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "oddRowsHighlight"));
    $("#grid_parts_numberCell").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "numberCell", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "numberCell"));
 
    $("#grid_parts_autoHeight").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "flexHeight", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "flexHeight"));
 
    $("#grid_parts_autoWidth").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "flexWidth", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "flexWidth"));
 
    $("#grid_parts_horizontal").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "scrollModel", { horizontal: $(this).is(":checked") });
    }).attr("checked", $grid.pqGrid("option", "scrollModel.horizontal"));
 
    $("#grid_parts_resizable").change(function (evt) {
        //alert("");
        $grid.pqGrid("option", "resizable", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "resizable"));
 
    $("#grid_parts_paging").change(function (evt) {
        var paging="";
        if ($(this).is(":checked")) {
            paging = "local";
        }
        $grid.pqGrid("option", "dataModel.paging", paging);
    }).attr("checked", ($grid.pqGrid("option", "dataModel.paging")=="local")?true:false);
 
    $("#grid_parts_roundCorners").change(function (evt) {
        $grid.pqGrid("option", "roundCorners", $(this).is(":checked"));
    }).attr("checked", $grid.pqGrid("option", "roundCorners"));
});

 因为它可以免费商用，也不需要你开源，而且完全支持jquery 很不错的一个前端表格控件。

转载于:https://www.cnblogs.com/angelasp/p/pqgrid.html