datatables-cn
datatables-cn copied to clipboard
ssy341
datatable columns超过8个报错
$('#sample_1').dataTable({
"iDisplayLength": 15,
"bLengthChange": false, //改变每页显示数据数量
"bFilter" : false, //是否启动过滤、搜索功能
"bSort": false,
"bStateSave":true,
"sDom": "Bfrtpi",//Bfrtip
"sAjaxDataProp":"aData",
//"pagingType": "full_numbers",
"ajax":{"url":"json_list/json_stafftarget_data.asp?funmenuid=<%=funmenuid%>","data":{"limitSql":"<%=limitSql%>"}},
"serverSide": true,
"columns": [
{ "data": "hmpm_year","bSortable":false,"sTitle":"年","width":"30px"},
{ "data": "hmpm_month","bSortable":false,"sTitle":"月"},
{ "data": "hmpm_sale","bSortable":false,"sTitle":"积分"},
{ "data": "hmpm_newuser","bSortable":false,"sTitle":"新客"},
{ "data": "hmpm_output","bSortable":false,"sTitle":"出货"},
{ "data": "hmpm_input","bSortable":false,"sTitle":"进货"},
{ "data": "hmpm_store","bSortable":false,"sTitle":"库存"},
{ "data": "hmpm_reward1","bSortable":false,"sTitle":"奖励基数"},
{ "data": "hmpm_reward2","bSortable":false,"sTitle":"Ex-com"},
{ "data": "hmpm_hemucpaimid","bSortable":false,"sTitle":"操作"}
],
"columnDefs":[
//{"aTargets":[9],"bSortable": false,"mRender":function(data,type,full){
//return "<button type='button' class='btn mini red' onclick="deleted('hemucpaim','hmpm','hmpm_hemucpaimid',"+full.hmpm_hemucpaimid+",this)">删除"
//}},
],
language: {
"sProcessing": "处理中...",
"sLengthMenu": "显示 MENU 项结果",
"sZeroRecords": "没有匹配结果",
"sInfo": "显示第 START 至 END 项结果，共 TOTAL 项",
"sInfoEmpty": "显示第 0 至 0 项结果，共 0 项",
"sInfoFiltered": "(由 MAX 项结果过滤)",
"sInfoPostFix": "",
"sSearch": "搜索:",
"sUrl": "",
"sEmptyTable": "表中数据为空",
"sLoadingRecords": "载入中...",
"sInfoThousands": ",",
"oPaginate": {
"sFirst": "首页",
"sPrevious": "上页",
"sNext": "下页",
"sLast": "末页"
},
"oAria": {
"sSortAscending": ": 以升序排列此列",
"sSortDescending": ": 以降序排列此列"
}
}
});
只要columns超过8个报错，用的包jquery-1.10.1.min.js，jquery.dataTables.min.js
