DT Editor Post Changed only
by V G
HTML
<link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.1.1/css/responsive.dataTables.min.css">
<script src="https://cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/keytable/2.2.1/css/keyTable.dataTables.min.css">
<script src="https://cdn.datatables.net/keytable/2.2.1/js/dataTables.keyTable.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.1.1/js/dataTables.responsive.min.js"></script>
<table id="siteListTable" class="table table-striped table-bordered responsive" cellspacing="0" width="100%">
<thead>
<tr>
<th>Site Name</th>
<th>Description</th>
<th>Site Name in Data Source</th>
<th>Rank</th>
</tr>
</thead>
</table>
JavaScript
var editObj = (function ()
{
return {
data: [
{"siteID":25,"siteSourceID":26,"siteName":"System Load","siteNameInSource":null,"description":"Hourly System Load Data for the New England Bulk Power System","rank":0},
{"siteID":27,"siteSourceID":28,"siteName":"VSite 27z","siteNameInSource":"vtest","description":"vtest","rank":9,}
],
editTable: null
};
}());
var editor = new $.fn.dataTable.Editor({
//ajax: window.baseUri + 'api/PQView/SaveSites',
ajax: function (method, url, data, successCallback, errorCallback)
{
$.ajax({
url: window.baseUri + "api/DBEdit/SaveSites",
type: "POST",
data: data.data,
async: true
})
.done(function (rtnData)
{
alert(rtnData);
successCallback( rtnData );
})
.fail(function (e)
{
alert(e.status + " - " + e.statusText + "\n\n" + e.responseText);
})
;
},
table: "#siteListTable",
idSrc: 'siteID',
formOptions:{
inline:{
drawType: 'full-hold',
onFieldError: 'none',
submit: 'changed'
}
},
fields: [
{
type: "hidden",
name: "siteID"
},
{
label: "Site Name:",
name: "siteName"
},
{
label: "Description:",
name: "description"
},
{
label: "Site Name in Data Source:",
name: "siteNameInSource"
},
{
label: "Rank:",
name: "rank"
},
]
});
editObj.editTable =
$('#siteListTable').DataTable({
data: editObj.data,
"responsive": true,
"deferRender": true,
"lengthMenu": [[15, 25, 50, 100, 200, 500, 1000, -1], [15, 25, 50, 100, 200, 500, 1000, "All"]],
"autoWidth": true,
"responsive": {
...