工具栏搜索本地数据,即使搜索后仍保留单元格中的值 [英] Toolbar search local data, retain value in cell even after searching
问题描述
我正在使用工具栏搜索本地数据(因为我正在使用option loadonce: true
).在我的网格中,有一列传输数量".默认情况下是可编辑的.
I am using toolbar searching on local data(because I am using optionloadonce: true
). In my grid, there is one column 'Transfer Qty.' which is by default editable.
我想要一个类似的功能,假设我在"Transfer Qty"列中输入了一些值.在第4行中,其批号名称为'OpStk_Leher_Mumbai-500'(为此,请参见上图),如果我使用搜索字符串'P-35'进行搜索,然后按Enter,它将给我根据我的搜索字符串,前三行作为搜索结果,它将排除我在其中输入值的第四行.要了解一个想法,请参考以下图片...
I want a functionality like, suppose I entered some value in column 'Transfer Qty.' in 4th row whose Lot No. name is 'OpStk_Leher_Mumbai-500' (for that please refer above image) and if I make search with search-string 'P-35' and press enter, it gives me first three row as a search result as per my search string and it will exclude 4th row in which I entered a value. To get an idea please refer following image...
但是,如果我从搜索框中删除搜索字符串并按Enter,它会给我所有记录,但是,我在"TransferQty"列的第4行中输入的值会消失,并且无论如何我都希望保留该值. /strong>
But if I remove search string from search box and press enter, it gives me all records but, the value I entered in 4th row in column 'TransferQty' gets disappeared and I want to retain that value anyhow.
如果有人知道该怎么做,请分享您的宝贵想法.
If anyone knows how to do this, kindly share your valuable ideas.
要从技术角度理解,我的jQgrid代码如下:
To get understanding as per technical perspective, my jQgrid code is as follows:
var oGrid = $('#tbLots'),
topPagerSelector = '#' + $.jgrid.jqID(oGrid[0].id) + "_toppager", lastSel;
oGrid.jqGrid({
url: sRelativePath + '/WSAjax.asmx/GetDataForGrid',
mtype: "POST",
datatype: "json",
ajaxGridOptions: { contentType: "application/json; charset=utf-8" },
serializeGridData: function (data) {
return JSON.stringify(data);
},
jsonReader: {
root: "d.rows",
page: "d.page",
total: "d.total",
records: "d.records"
},
colNames: ['SISDIdForExch', 'SubLotId', 'Lot#', 'Expiry Date', 'Qty.', 'Transfer Qty.'],
colModel: [
{ name: 'SISDIdForExch', index: 'SISDIdForExch', hidden: true },
{ name: 'SubLotId', index: 'SubLotId', hidden: true },
{ name: 'LotNo', index: 'LotNo', editable: false, sortable: false, width: 100},
{name: 'Expiry', index: 'Expiry', editable: false, search: false, align: 'center', formatter: 'date', formatoptions: { srcformat: 'm/d/Y', newformat: 'd/m/Y' }, sortable: false, width: 60 },
{ name: 'BucketQty', index: 'BucketQty', editable: false, search: false, template: viewNumTemplate, width: 60 },
{ name: 'TransferQty', index: 'TransferQty', editable: true, search: false, template: editNumTemplate, width: 60, editrules: { minValue: 0.00 },
editoptions: {
dataInit: function (domElem) {
$(domElem).on("blur", function () {
calculateTotalTransferQty($("#tbLots"));
});
}
}
}
],
prmNames: { page: "pageIndex", rows: "pageSize", sort: "sortIndex", order: "sortDirection", search: "_search" },
search: false,
postData: {
filters: null,
spName: 'GetLotDetails',
paramXML: $xmlDoc.html().toString()
},
width: 'auto',
height: 'auto',
rowNum: 1000,
sortname: '',
sortorder: 'asc',
page: 1,
gridview: true,
toppager: true,
autoencode: true,
ignoreCase: true,
viewrecords: true,
caption: 'Item Lots',
editurl: 'clientArray',
footerrow: true,
loadonce: true,
gridComplete: function () {
$("table#tbLots tr:last").addClass('ireg-jqgrid-lastrow');
$("tr.footrow td").addClass('ireg-jqgrid-lastrow').addClass('ireg-jqgrid-footer');
},
loadComplete: function (data) {
updateJqGridButtonState($(this), jqGridMode.None);
//Following piece of code made 'Transfer Qty.' column by default editable.
var l_oIds = oGrid.jqGrid('getDataIDs'), i;
for (i = 0; i < l_oIds.length; i++) {
oGrid.jqGrid('editRow', l_oIds[i], true);
}
//Set focus on first editable cell.
if (l_oIds.length > 0)
$('#' + l_oIds[0] + '_TransferQty').get(0).focus();
},
onSelectRow: function (rowid) {
if (rowid && rowid != lastSel) {
if (typeof lastSel !== "undefined") {
$(this).jqGrid('restoreRow', lastSel);
}
lastSel = rowid;
}
updateJqGridButtonState($(this), jqGridMode.None);
}
});
oGrid.jqGrid('filterToolbar', { stringResult: true, defaultSearch: 'cn', //groupOp: 'OR',
beforeSearch: function () {
if (colDataTypes.length != 0 && colDataTypes != undefined) {
var oRules = new Array();
var postdata = $('#tbLots').jqGrid('getGridParam', 'postData'),
oCustFilter = $.parseJSON(postdata.filters), colName, searchStr, operator, groupOperator = '';
for (var i = 0; i < oCustFilter.rules.length; i++) {
groupOperator = oCustFilter.groupOp;
searchStr = oCustFilter.rules[i].data;
colName = oCustFilter.rules[i].field;
operator = oCustFilter.rules[i].op;
oRules.push({ field: colName, op: operator, data: searchStr });
}
if (searchVal != null && searchVal != '') {
var oFilter = { groupOp: groupOperator, rules: oRules };
$.extend(postdata, { filters: JSON.stringify(oFilter) });
$('#tbLots').jqGrid('setGridParam', { search: true, postData: postdata });
$('#tbLots').trigger("reloadGrid", [{ page: 1}]);
}
}
return true;
}
});
//Added afterRefresh function to clear toolbar.
oGrid.jqGrid('navGrid', topPagerSelector, { add: false, edit: false, del: false, search: false,
afterRefresh: function () {
$(this)[0].clearToolbar();
}
}, {}, {}, {}, {});
这是我更新的代码,您教我做的方式
oGrid.jqGrid('filterToolbar', { stringResult: true, defaultSearch: 'cn', //groupOp: 'OR',
beforeSearch: function () {
if (colDataTypes.length != 0 && colDataTypes != undefined) {
var oRules = new Array();
var postdata = $('#tbLots').jqGrid('getGridParam', 'postData'),
oCustFilter = $.parseJSON(postdata.filters), colName, searchStr, operator, groupOperator = '';
for (var i = 0; i < oCustFilter.rules.length; i++) {
groupOperator = oCustFilter.groupOp;
searchStr = oCustFilter.rules[i].data;
colName = oCustFilter.rules[i].field;
operator = oCustFilter.rules[i].op;
//iReg-1821: Uncommneted the following code.
var colIndex = getColumnIndexByName($('#tbLots'), colName);
var searchVal = '', bAttachQuote = false;
if ('STRING' === colDataTypes[colIndex]) {
searchVal = searchStr;
bAttachQuote = true;
}
oRules.push({ field: colName, op: operator, data: searchStr, coldatatype: colDataTypes[colIndex], attachquote: bAttachQuote });
}
if (searchVal != null && searchVal != '') {
var oFilter = { groupOp: groupOperator, rules: oRules };
$.extend(postdata, { filters: JSON.stringify(oFilter) });
$('#tbLots').jqGrid('setGridParam', { search: true, postData: postdata });
$('#tbLots').trigger("reloadGrid", [{ page: 1}]);
}
}
HERE IS MY CODE, WHAT YOU TAUGHT ME TO DO
var l_oIds = oGrid.jqGrid('getDataIDs'), i;
for (i = 0; i < l_oIds.length; i++) {
oGrid.jqGrid('saveRow', l_oIds[i], false, 'clientArray');
}
return true;
}
});
推荐答案
解决方案:-我已经实现了loadonce: true
oGrid.jqGrid('filterToolbar', { stringResult: true, defaultSearch: 'cn', //groupOp: 'OR',
beforeSearch: function () {
var oRules = new Array();
var postdata = $('#tbLots').jqGrid('getGridParam', 'postData'),
oCustFilter = $.parseJSON(postdata.filters), colName, searchStr, operator, groupOperator = '';
for (var i = 0; i < oCustFilter.rules.length; i++) {
groupOperator = oCustFilter.groupOp;
searchStr = oCustFilter.rules[i].data;
colName = oCustFilter.rules[i].field;
operator = oCustFilter.rules[i].op;
oRules.push({ field: colName, op: operator, data: searchStr });
}
var oFilter = { groupOp: groupOperator, rules: oRules };
$.extend(postdata, { filters: JSON.stringify(oFilter) });
$('#tbLots').jqGrid('setGridParam', { search: true, postData: postdata });
//$('#tbLots').trigger("reloadGrid", [{ page: 1}]);
}
/*here is the code, what you taught me to do*/
var l_oIds = oGrid.jqGrid('getDataIDs'), i;
for (i = 0; i < l_oIds.length; i++) {
oGrid.jqGrid('saveRow', l_oIds[i], false, 'clientArray');
}
//reloading grid after saverow
$('#tbLots').trigger("reloadGrid", [{ page: 1}]);
return true;
});
这篇关于工具栏搜索本地数据,即使搜索后仍保留单元格中的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!