JQGrid在编辑后未加载更新的数据。 [英] JQGrid not Loading updated Data after edit.
本文介绍了JQGrid在编辑后未加载更新的数据。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用JQGrid我能够编辑弹出页面中的行并发布数据,但网格未在提交后加载当前(更新)数据。
以下是我的代码:
I am using JQGrid I am able to edit the row in popup page and post the data but the grid is not loading with current(Updated) data after submit.
Below Is the my code:
var result;
//gets the data and adds each row
function getData() {
jQuery.ajax({
url: '/Customer/GetCustomers',
datatype: "Json",
async: false,
complete: function (jsondata, stat) {
if (stat == "success") {
result = JSON.parse(jsondata.responseText);
$(result).each(function (e) {
var p = new Date(this["Customer_Start_Dt"]);
$("#list1").addRowData(e, this);
});
}
}
});
}
//get all Location Type
var locations = jQuery.ajax({
url: '/Customer/GetLocations',
datatype: "Json",
async: false,
success: function (data, result1) {
if (!result1) alert('Failure to retrieve the Location Type.');
}
}).responseText;
$(document).ready(function () {
var lastsel;
debugger;
// Set up the jquery grid
$("#list1").jqGrid({
// Ajax related configurations
//url: jqDataUrl,
datatype: "json",
mtype: "get",
//loadonce: true,
// Specify the column names
colNames: ["Customer Id", "Customer Location", "Customer Name", "Categories Sold", "Credit Period", "Customer Start Date", "Customer End Date","Location"],
// Configure the columns
colModel: [
{
name: "Customer_Id", index: "Customer_Id", width: 150, align: "left",
sorttype: "int", key: true, editable: true, editrules: { edithidden: false },
hidedlg: true, hidden: true
},
{
name: "Location_Type", index: "LOCATION.Location_Type", width: 150, align: "left",
sorttype: "float", sortable: true
},
{
name: "Customer_Name", index: "Customer_Name", width: 150,
editable: true, edittype: "text", align: "left",
sorttype: "float", sortable: true, editrules: { required: true }
},
{
name: "Categories_Sold", index: "Categories_Sold", width: 150,
editable: true, edittype: "text", align: "left", sorttype: "float",
editrules: { required: true },
editoptions: {
size: 15, maxlengh: 10,
dataInit: function (element) {
$(element).keyup(function () {
var val1 = element.value;
var num = new Number(val1);
if (isNaN(num))
{ alert("Please enter a valid number"); }
})
}
}
},
{
name: "Credit_Period", index: "Credit_Period", width: 150,
editable: true, edittype: "text", align: "left",
sorttype: "float", editrules: { required: true },
editoptions: {
size: 15, maxlengh: 10,
dataInit: function (element) {
$(element).keyup(function () {
var val1 = element.value;
var num = new Number(val1);
if (isNaN(num))
{ alert("Please enter a valid number"); }
})
}
}
},
{
name: 'Customer_Start_Dt', height: 100, index: 'Customer_Start_Dt', align: 'right', sortable: false,
formatter: 'date', formatoptions: { newformat: 'm/d/y' }, editable: true,
editrules: { required: true },
editoptions: {
readonly: 'readonly',
dataInit: function (el) { $(el).datepicker(); }
}
},
{
name: 'Customer_End_Dt', height: 100, index: 'Customer_End_Dt', align: 'right', sortable: false,
formatter: 'date', formatoptions: { newformat: 'm/d/y' }, editable: true,
editrules: { required: true },
editoptions: {
readonly: 'readonly',
dataInit: function (el) { $(el).datepicker(); }
}
},
{
name: "Location_Id",
index: "Location_Type",
width: 0.00001,
editable: true,
edittype: "select",
editrules: { required: true, edithidden: false },
editoptions: {value: locations},
align: "left", sorttype: "int"
},
],
// Default sorting
sortname: "Customer_Name",
sortorder: "asc",
width: 840,
height: 200,
multiselect: true,
rowNum: 20,
rowList: [5, 10, 20, 50, 100],
pager: jQuery('#pager1'),
sortorder: "desc",
viewrecords: true,
reload:true,
caption: "Customer Data"
});
jQuery("#list1").jqGrid(
'navGrid',
'#pager1',
{ edit: true, add: true, del: true, jqModel: true },
{ url: '/customer/Edit', closeAfterEdit: true, reloadAfterSubmit: true, checkOnSubmit: true,checkOnUpdate: true, closeOnEscape: true },
{ url: '/customer/Create', closeAfterDelete: true, closeOnEscape: true },
{ url: '/customer/Delete', closeAfterAdd: true, reloadAfterSubmit: true, checkOnSubmit: true, closeOnEscape: true },
{ multipleSearch: true },
{ width: 450, jqModal: true, closeAfterAdd: true }
);
//jQuery("#list1").trigger("reloadGrid");
//load data
getData();
//grid.setGridParam({ datatype: 'json' });
//grid.trigger('reloadGrid');
jQuery("#list1").trigger('reloadGrid');
});
推荐答案
(结果).each(function(e){
var p = new 日期(此 [ Customer_Start_Dt]);
(result).each(function (e) { var p = new Date(this["Customer_Start_Dt"]);
( #list1)。addRowData(e, this );
});
}
}
});
}
// 获取所有位置类型
var locations = jQuery.ajax({
url:' / Customer / GetLocations',
数据类型: Json,
async : false ,
成功:函数(data,result1){
if (!result1)alert(' 无法检索位置类型。');
}
})。responseText;
("#list1").addRowData(e, this); }); } } }); } //get all Location Type var locations = jQuery.ajax({ url: '/Customer/GetLocations', datatype: "Json", async: false, success: function (data, result1) { if (!result1) alert('Failure to retrieve the Location Type.'); } }).responseText;
(document).ready(function(){
var lastsel;
调试器;
// 设置jquery网格
(document).ready(function () { var lastsel; debugger; // Set up the jquery grid
这篇关于JQGrid在编辑后未加载更新的数据。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文