Usage analysis of JQGrid (column editing, adding rows, deleting rows)_jquery

Copy code The code is as follows: $(document).ready(function() { initPlsfList(); }); //初始化grid列表 function initPlsfList(){ //缓存表列数组,key 为页面元素的name ，value 对应数据库中的字段 var cellArray = new Array(); cellArray["zoneID"] ="ZONE_ID"; cellArray["factorPG"] ="FACTOR_PG"; cellArray["factorQG"] ="FACTOR_QG"; cellArray["factorPL"] ="FACTOR_PL"; cellArray["factorQL"] ="FACTOR_QL"; cellArray["valid"] ="VALID";

}, onSortCol:function(index,iCol,sortorder){ return false ; }, ondblClickRow: function (rowid,iRow,iCol,e) { /*var $plsfList = $("#plsfList"); if (isRowNeedSave($plsfList)){ showMessage("请先保存"); }else{ $("#operate").val("update"); newrowid = rowid ; $plsfList.setGridParam({cellEdit:false}); $plsfList.jqGrid('editRow', rowid, true); //确定按钮可用 $("#confirm_btn").attr("disabled",false);

}*/ }, beforeSubmitCell:function(rowid, cellname, value, iRow, iCol){ //列提交前的拦截方法 var $plsfList = $("#plsfList") ; var $editUrl = ' ' ; //设置列提交的url。updateCellName：要编辑的列名 ；updateCellValue ：是编辑的值 $editUrl = addParamToUrl($editUrl,'updateCellName',iCol == 3 ? cellArray['zoneID'] :cellArray[cellname]); $editUrl = addParamToUrl($editUrl,'updateCellValue',iCol == 3 ? $("#zone_id").val():value); //给jqgrid 从新设置cellurl 值 $plsfList.setGridParam({cellurl:$editUrl}); return false ; }, afterEditCell:function(rowid, cellname, value, iRow, iCol){ //动态修改lie时，当列 变为可修改状态时，给列add一个button，且列中元素不可编辑，点击button 弹出一个模态窗口，可以选择元素 ，赋值给grid当前编辑列中单行表单域中. $("#"+rowid+" input[type='checkbox']").attr("checked",value == " " ? true:false); if(iCol==3){ $("#irowNum").val(rowid); var $data = $("#"+rowid +">td"); //获取这个行里所有的td元素，即：获取所有子元素 $zoneInput = $data.find("input").eq("1") ; $zoneInput.css("width","100px"); $zoneInput.attr("disabled",true); $zoneInput.after(" "); } }

});

//Add a new row to grid var newrowid; function addRow() { $("#operate").val(""); var selectedId = $("#plsfList").jqGrid("getGridParam", "selrow"); var ids = jQuery("#plsfList").jqGrid('getDataIDs'); //Get the current Maximum row number (data number) var rowid = Math.max.apply(Math,ids); //Get the row number (data number) of the newly added row newrowid = rowid 1; var dataRow = { id: "", valid:"", zoneID:'', factorPG:'', factorQG:'', factorPL: '', factorQL:'', caseID:'' };

//Insert the newly added row into the first column $("#plsfList" ).jqGrid("addRowData", newrowid, dataRow, "first"); //Set grid cells to be non-editable $("#plsfList").setGridParam({cellEdit:false}); //Set grid cells to be editable $('#plsfList').jqGrid('editRow', newrowid, false); //Confirm button is available $("#confirm_btn"). attr("disabled",false); //Add a selection button to the added column var $zoneInput = $("#" newrowid "_zoneName"); $zoneInput.attr("disabled" ,true).css("width",100); $zoneInput.after(" ");

}

function insertPlsf(){ var $plsfList = $("#plsfList") ; var $operate = $("#operate").val(); // Set grid cells to be editable $plsfList.setGridParam({cellEdit:true}); //Set grid rows to be uneditable //$plsfList.jqGrid('editRow', newrowid, false); //URL of splicing request var url = ' ' "/lfc/powerlsfactor/save" ; var $params = $plsfList.find("input[id ^=" newrowid "]"); var $check_val = $params.eq(0).is(':checked') ? 1:0; url = addParamToUrl(url,'valid',$ check_val); url = addParamToUrl(url,'zoneID',$("#zone_id").val()); url = addParamToUrl(url,'factorPG',$params.eq(2). val()); url = addParamToUrl(url,'factorQG',$params.eq(3).val()); url = addParamToUrl(url,'factorPL',$params.eq(4 ).val()); url = addParamToUrl(url,'factorQL',$params.eq(5).val());

var $caseID = $("#caseID") .val(); url = addParamToUrl(url,'caseID',$caseID);

$.ajax({url:url,type:"post",timeout:5000, success:function(data){ showMessage(data); reloadGrid(); } }); //The newly added line number will initially be empty newrowid = '' ; //The confirmation button is unavailable $("#confirm_btn").attr( "disabled",true); }

//Format zone column output content function formatZone(cellvalue, options, rowObject){ if(cellvalue == 0){ return 0; }else if( cellvalue == 1){ return 1; }else if(cellvalue == 2){ return 2; }else{ return 3; } }

function isRowNeedSave($jqgrid){ var $editTr = $jqgrid.find("tr[editable=1]") ; var flag = false ; if ( $editTr && $editTr.length > 0){ flag = true ; } return flag ; }

function cancel(){ reloadGrid(); //Confirm button is not available $("#confirm_btn").attr("disabled",true); //Set grid cells to be editable $("#plsfList").setGridParam({cellEdit:true}); //Set grid cells to be editable $('#plsfList'). jqGrid('editRow', newrowid, true); }

function fnCallDialogForEidt(){ //Get the current line number (data number) var returnValue = ""; returnValue = window.showModalDialog(" ",window,""); if(returnValue==""||returnValue==null) return; var $plsfList = $("#plsfList"); var $params = $plsfList.find("input[id$='zoneName']"); var names = returnValue.split(","); $params.eq(0).val(names[1]); $("#zone_id").val(names[0]); }