获取DataTable插件表中所有数据
jquery中初始化DataTable:
var tab = $('#sendOrdersManagementTable');
var oTab = tab.DataTable({
serverSide: true,//开启服务器模式:启用服务器分页
lengthChange: false,//是否允许用户改变表格每页显示的记录数
ordering: false,//是否允许用户排序
paging: true,//是否分页
pagingType: "full_numbers",//除首页、上一页、下一页、末页四个按钮还有页数按钮
searching: false,//是否开始本地搜索
stateSave: false,//刷新时是否保存状态
scrollX: true,
autoWidth: true,//自动计算宽度
language: langOpt,
ajax: {
url: $('#webPath').val() + "/work/sendOrdersManagementList",
type: "POST",
data: {
"searchMap": function () {
return JSON.stringify($('form.search-form').serializeObject());
}
}
},
columns: [
{
data: function () {
return "<input type='checkbox'>"
}
},
{
data: 'customerName'
},
{
data: 'customerPhone'
},
{
data: 'customerAddress'
},
{
data: function (row) {
return row.tenantName;
}
},
{
data: 'goods'
},
{
data: 'remark'
}
],
fnDrawCallback: function () {
$('a.need-select').addClass('disabled');
}
});
//选中行数据
checkBoxCtrl(tab, oTab, function (data) {
rowData = data;
});
获取table中所有的数据:
var table = tab.dataTable();
//获取表中所有行
var rows = table.fnGetNodes();
遍历每一行数据:
for (var i = 0; i < rows.length; i++) {
//获取每行中每列的具体数据
var tenantName = oTab.row(i).data().tenantName;
var customerName = oTab.row(i).data().customerName;
var customerPhone = oTab.row(i).data().customerPhone;
var customerAddress = oTab.row(i).data().customerAddress;
var goods = oTab.row(i).data().goods;
var remark = oTab.row(i).data().remark;
}