如何在内联编辑后使用添加导航按钮将数据保存到jqgrid上的本地数据库中 [英] How do I save data into local database on jqgrid with add navigator button after inline editing
问题描述
我提到网格中的保存按钮并使用javascript将数据保存在本地数据库中
searchActionOptions:new JqGridNavigatorSearchActionOptions()
{
AdvancedSearching = true,
CloseAfterSearch = true,
宽度= 600,
Top = 300,
剩余= 320,
DataHeight = 150,
CloseOnEscape = true
} ).AddNavigatorButton(new JqGridNavigatorButtonOptions()
{
Caption =Save,
// Id =btnSave,>
Icon =ui-icon-disk,
ToolTip =保存,
OnClick =Savedata
});
}
我有什么试过:
@section scripts
{
@ *<脚本>
jQuery(#TodayHomeWorkGrid)。saveRow(rowid,successfunc,url,extraparam,aftersavefunc,errorfunc,afterrestorefunc);
< / script> * @
@ *< script>
var grid = $(#TodayHomeWorkGrid);
grid.jqGrid({
url:'GetTodayHomeWork',
数据类型:json,
mtype:'POST',
scroll:1,
multiselect:true,
multiboxonly:true,
scrollingRows:true,
autoencode:true,
prmNames:{id:_ rowid,oper:_ oper},
gridview:true,
toppager:true,
viewrecords:true,
editurl:'AddOrEditTodayHomeWork',
rownumbers:true,
ondblClickRow:function(StaffId){beginEdit(StaffId)},
});
函数SaveDocument(){
//如果要取消订单明细添加,则返回false
var res;
$ .ajax({type:POST,
url:'AddOrder',
data:$(#TodayHomeWork)。 serializeArray(),
错误:函数(jqXHR,textStatus,errorThrown){
alert('订单保存已取消,正确并重试'); res = false;
}
});
返回res ;
}
< / script> * @
< script>
$(#TodayHomeWork )。jqGrid('Savedata','#pager2',{
标题:保存,buttonicon:ui-icon-disk,
onClickButton:function ()
var ids = $('#TodayHomeWork')。jqGrid('getDataIDs');
for(var i = 0; i< ids.length + 1; i ++){
$('#TodayHomeWork')。jqGrid('saveRow',ids [i],false,'/ TodayHomeWork / Index');
}
}
});< / script>
< script>
jQuery(#TodayHomeWorkGrid)。jqGrid('saveRow',rowid,saveparameters);
调试器;
saveparameters = {
successfunc:true,
url:AddOrEditTodayHomeWork,
extraparam:{},
aftersavefunc:true,
errorfunc:null,
afterrestorefunc:null,
restoreAfterError:true,
mtype:POST
}
函数Savedata()
{
alert(你点击了一个自定义按钮。 );
}
< / script>
i mention the save button in grid and use javascript to save data in local database
searchActionOptions: new JqGridNavigatorSearchActionOptions()
{
AdvancedSearching = true,
CloseAfterSearch = true,
Width = 600,
Top = 300,
Left = 320,
DataHeight = 150,
CloseOnEscape = true
}).AddNavigatorButton(new JqGridNavigatorButtonOptions()
{
Caption = "Save",
// Id="btnSave",
Icon = "ui-icon-disk",
ToolTip = "Save",
OnClick = "Savedata"
});
}
What I have tried:
@section scripts
{
@*<script>
jQuery("#TodayHomeWorkGrid").saveRow(rowid, successfunc, url, extraparam, aftersavefunc, errorfunc, afterrestorefunc);
</script>*@
@*<script>
var grid = $("#TodayHomeWorkGrid");
grid.jqGrid({
url: 'GetTodayHomeWork',
datatype: "json",
mtype: 'POST',
scroll: 1,
multiselect: true,
multiboxonly: true,
scrollingRows : true,
autoencode: true,
prmNames: {id:"_rowid", oper: "_oper" },
gridview: true,
toppager: true,
viewrecords: true,
editurl: 'AddOrEditTodayHomeWork',
rownumbers: true,
ondblClickRow: function(StaffId) { beginEdit(StaffId) },
});
function SaveDocument() {
// Returns false if order detail adding should be cancelled
var res;
$.ajax({ type: "POST",
url: 'AddOrder',
data : $("#TodayHomeWork").serializeArray(),
error: function (jqXHR, textStatus, errorThrown) {
alert('Order save is cancelled, correct and try again'); res=false;
}
});
return res;
}
</script>*@
<script>
$("#TodayHomeWork").jqGrid('Savedata', '#pager2', {
caption: "Save", buttonicon: "ui-icon-disk",
onClickButton: function () {
var ids = $('#TodayHomeWork').jqGrid('getDataIDs');
for (var i = 0; i < ids.length + 1; i++) {
$('#TodayHomeWork').jqGrid('saveRow', ids[i], false, '/TodayHomeWork/Index');
}
}
});</script>
<script>
jQuery("#TodayHomeWorkGrid").jqGrid('saveRow', rowid, saveparameters);
debugger;
saveparameters = {
"successfunc": true,
"url": "AddOrEditTodayHomeWork",
"extraparam": {},
"aftersavefunc": true,
"errorfunc": null,
"afterrestorefunc": null,
"restoreAfterError": true,
"mtype": "POST"
}
function Savedata()
{
alert("You have clicked a custom button.");
}
</script>
推荐答案
( #TodayHomeWorkGrid);
grid.jqGrid({
url:'GetTodayHomeWork',
datatype:json,>
mtype:'POST',
滚动:1,
multiselect:true,
multiboxonly:true,
scrollingRows:true,
autoencode:true,
prmNames:{id:_ rowid,oper:_ oper},
gridview:是的,
toppager:true,
viewrecords:true,
editurl:'AddOrEditTodayHomeWork',
rownumbers:true,
ondblClickRow:function(StaffId){beginEdit(StaffId)},
});
function SaveDocument(){
//如果要取消订单明细添加,则返回false
var res;
("#TodayHomeWorkGrid");
grid.jqGrid({
url: 'GetTodayHomeWork',
datatype: "json",
mtype: 'POST',
scroll: 1,
multiselect: true,
multiboxonly: true,
scrollingRows : true,
autoencode: true,
prmNames: {id:"_rowid", oper: "_oper" },
gridview: true,
toppager: true,
viewrecords: true,
editurl: 'AddOrEditTodayHomeWork',
rownumbers: true,
ondblClickRow: function(StaffId) { beginEdit(StaffId) },
});
function SaveDocument() {
// Returns false if order detail adding should be cancelled
var res;
.ajax({type:POST,
url:'AddOrder',
data:
.ajax({ type: "POST",
url: 'AddOrder',
data :
(#TodayHomeWork)。serializeArray(),
错误:函数(jqXHR,textStatus,errorThrown){
alert('订单保存取消,纠正并再试一次'); res = false;
}
});
返回res ;
}
< / script> * @
< script>
("#TodayHomeWork").serializeArray(),
error: function (jqXHR, textStatus, errorThrown) {
alert('Order save is cancelled, correct and try again'); res=false;
}
});
return res;
}
</script>*@
<script>
这篇关于如何在内联编辑后使用添加导航按钮将数据保存到jqgrid上的本地数据库中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!