jqGrid常用方法

allRowsInGrid_in_page.js

//分页情况下获取全部数据
var allRowsInGrid = $('#list4').jqGrid('getGridParam','data');

custom row id

localReader: {
    id: "row_id"
}

customSearch.html

<script>
function searchGridFn() {
    grid = $("#myGrid");
    var searchFiler = $("#filter").val(), f;

    if (searchFiler.length === 0) {
        grid[0].p.search = false;
        $.extend(grid[0].p.postData, { filters: "" });
    }
    f = { groupOp: "OR", rules: [] };
    f.rules.push({ field: "name", op: "cn", data: searchFiler });
    f.rules.push({ field: "delCol", op: "cn", data: searchFiler });
    grid[0].p.search = true;
    $.extend(grid[0].p.postData, { filters: JSON.stringify(f) });
    grid.trigger("reloadGrid", [{ page: 1, current: true}]);
}
</script>


<input id="filter" />
<button id="searchButton" onclick="searchGridFn()">Search</button>
        

get-cur-page-no.js

$("#sp_1").text(); // total pages

$(".ui-pg-input").val(); // current page

$('#your_grid').getGridParam('page'); // current page

get-cur-sort-param.js

//You can examine the values of the jqGrid parameters sortname and sortorder ("desc" or "asc"). To get the parameters you can use getGridParam method:

var sortColumnName = $("#list").jqGrid('getGridParam','sortname');
//and

var sortOrder = $("#list").jqGrid('getGridParam','sortorder'); // 'desc' or 'asc'

get_data.js

var allRowsIdsOnCurrentPage = $('#file-grid').jqGrid('getDataIDs');
var allRowsOnCurrentPage = $('#file-grid').jqGrid('getRowData');

getFilters.js

$('#myGrid').getGridParam("postData").filters;

$('#myGrid').jqGrid('getGridParam', "postData").filters;

//will give you a string
// "{"groupOp":"AND","rules":[{"field":"Name","op":"bw","data":"a"}]}" 
//rules have the search criteria. If i have multiple search criteria, all would be there
// "{"groupOp":"AND","rules":[{"field":"Name","op":"bw","data":"a"},{"field":"Description","op":"bw","data":"d"}]}" 

goto-page.js

$('#uiGrid1').trigger("reloadGrid",[{page:5}]);

select-action.js

//取消选中
$('#grid').jqGrid('resetSelection');

select-all-row.js

// Select all row
var $grid = $("#Grid");
$grid.jqGrid('resetSelection');
var ids = $grid.getDataIDs();
for (var i=0, il=ids.length; i < il; i++) {
    $grid.jqGrid('setSelection',ids[i], false);
}

selectValue.js

var i, count, $grid = $("#myTable");
for (i = 0, count = rowArray.length; i < count; i += 1) {
    $grid.jqGrid('setSelection', rowArray[i], false);
}

setAjaxType.js

$.jgrid.ajaxOptions.type = 'post';
//这样可以避免中文查询参数乱码

中文乱码处理.xml

<!-- 修改tomcat的server.xml，增加useBodyEncodingForURI="true"  -->

<Connector port="8080" protocol="HTTP/1.1"   
              connectionTimeout="20000"   
              redirectPort="8443" useBodyEncodingForURI="true" />