JQGrid在编辑后未加载更新的数据。 [英] JQGrid not Loading updated Data after edit.

查看:88
本文介绍了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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆