jqGrid查询案例(实用)

var ThisTime = getNowFormatDate();

    //加载表格

    function GetGrid() {

        var selectedRowIndex = 0;

        var $gridTable = $('#gridTable');

        $("#Time").val(ThisTime);

        $gridTable.jqGrid({

            url: "../../CaseManage/CasesStatistics/CityLevelStatistics" ,

            datatype: "json",

            postData: { time: ThisTime},//向后台传递的参数

            height: $(window).height() - 169.5,

            autowidth: true,

            colNames: ['单位', '本月', '累计', '本月', '累计', '本月', '累计',],

            colModel: [

                { name: 'fullname', index: 'fullname', width: 200, align: "center"},

                { name: 'summonthcase', index: 'summonthcase', width: 230, align: "center" },

                { name: 'addupmonthcase', index: 'addupmonthcase', width: 230, align: "center" },

                { name: 'thismonthcase', index: 'thismonthcase', width: 230, align: "center" },

                { name: 'addupendmonthcase', index: 'addupendmonthcase', width: 230, align: "center" },

                { name: 'monthforfeit', index: 'monthforfeit', width: 230, align: "center" },

                { name: 'addupmonthforfeit', index: 'addupmonthforfeit', width: 230, align: "center" }

            ],

            viewrecords: true,

            rowNum: 30,

            rowList: [30, 50, 100],

            pager: "#gridPager",

            rownumbers: true,

            shrinkToFit: false

        });

        $("#btn_Search").click(function () {

            //ThisTime = $("#form1").val();

           // $("#gridTable").jqGrid("clearGridData");//清空表格数据

            $('#gridTable').jqGrid('setGridParam', {

                postData: { time: $("#Time").val() },//为发送请求的数据，以key:value的形式发送，多个参数可以以逗号”,”间隔；

                page: 1 //为指定查询结果跳转到第一页；

            }).trigger('reloadGrid');//为重新载入jqGrid表格。

        });

    }