First, give a brief explanation of the Jqgrid grid plug-in. Among the many table plug-ins, Jqgrid has very distinctive features.
Features are as follows:
Complete table presentation and calculation functions, including page changing, field sorting, grouping, adding, modifying and deleting data, etc.
Customized toolbar
The default Navigator toolbar makes it easy to use functions such as adding, deleting, editing, viewing and searching.
Complete paging function
Click the header of any field to select that field as a sorting item. Either ascending or descending order is acceptable.
The preset action formatter can quickly and intuitively perform operations on each data.
Supports multiple data formats. Such as json, xml, array, etc.
The following is a code example to introduce to you the table data required to pop up the required table data by clicking on the jqgrid table. The specific content is as follows:
First, we define a function and then directly reference it in JQuery,
function GetJqGridRowValue(jgrid, code) { var KeyValue = ""; var selectedRowIds = $(jgrid).jqGrid("getGridParam", "selarrrow"); if (selectedRowIds != "") { var len = selectedRowIds.length; for (var i = 0; i < len ; i++) { var rowData = $(jgrid).jqGrid('getRowData', selectedRowIds[i]); KeyValue += rowData[code] + ","; } KeyValue = KeyValue.substr(0, KeyValue.length - 1); } else { var rowData = $(jgrid).jqGrid('getRowData', $(jgrid).jqGrid('getGridParam', 'selrow')); KeyValue = rowData[code]; } return KeyValue; }//自定义GetJqGridRowValue函数
The following is the JS file that displays the table
$(function () { $("#group").jqGrid({ url: '/Group/GetGroup', datatype: 'json', mtype: 'Get', colNames: ['GRP_ID', 'GRP_NAME', 'GRP_DESCRIPTION'],//GROUP colModel: [ { key: true, hidden: true, name: 'GRP_ID', index: 'GRP_ID' }, { key: false, name: 'GRP_NAME', index: 'GRP_NAME', editable: true }, { key: false, name: 'GRP_DESCRIPTION', index: 'GRP_DESCRIPTION', editable: true }, ], ondblClickRow: function (rowid) { var td_id = GetJqGridRowValue("#group", "GRP_ID"); alert(td_id); },//点击获取gqgird的当前列的'GRP_ID'的值 pager: jQuery('#pager1'), rowNum: 5, rowList: [5, 10, 15, 20], height: '19%', viewrecords: true, caption: 'Group_Table', emptyrecords: '没有记录显示', jsonReader: { rows: 'rows', page: 'page', total: 'total', records: 'records', repeatitems: false, id: '0', editurl: '/Group/EditGroup' }, autowidth: true, multiselect: false,//是否多选 }); jQuery("#group").jqGrid('navGrid', "#pager1", { edit: true, add: true, del: true, position: 'left', alerttext: "请选择需要操作的数据行!" }, { zIndex: 100, url: '/Group/EditGroup', closeOnEscape: true, closeAfterEdit: true, recreateForm: true, afterComplete: function (response) { if (response.responseText) { alert(response.responseText); } } }, { zIndex: 100, url: '/Group/CreateGroup', closeOnEscape: true, closeAfterEdit: true, afterComplete: function (response) { if (response.responseText) { alert(response.responseText); } } }, { zIndex: 100, url: '/Group/DeleteGroup', closeOnEscape: true, closeAfterEdit: true, recreateForm: true, msg: "你确定要删除么?", afterComplete: function (response) { if (response.responseText) { alert(response.responseText); } } } ); });
ps:jqGrid clears all row data in the table
The method for jqGrid to clear the data in the table is as follows:
jQuery("#gridTable").jqGrid("clearGridData");