对datatable对象参数进行部分配置以及说明

转自：http://blog.csdn.net/u013405778/article/details/51690038
http://blog.csdn.net/yibing548/article/details/45078123
详细参数
https://www.cnblogs.com/fuqiang88/p/4731526.html

注意：

1.返回的数据格式一定是json。例如： 数据是以aaData开头的。否则对不上

{  "aaData": [    {      "isDelete": 0,      "typeName": "住院信息",      "updateUserId": 2,      "createTime": "Nov 21, 2017 12:00:00 AM",      "modelName": "客户",      "updateTime": "Nov 21, 2017 12:00:00 AM",      "modelClass": "crm",      "orderIndex": 1,      "no": 1,      "createUserId": 2    },    {      "isDelete": 0,      "typeName": "门诊信息",      "updateUserId": 2,      "createTime": "Nov 21, 2017 12:00:00 AM",      "modelName": "客户",      "updateTime": "Nov 21, 2017 12:00:00 AM",      "modelClass": "crm",      "orderIndex": 2,      "no": 2,      "createUserId": 2    }  ]}

重要参数

iDisplayStart ：当开启分页的时候，定义展示的记录的起始序号，不是页数，因此如果你每个分页有10条记录而且想从第三页开始，需要把该参数指定为20
默认值 0
类型： int

iTotalRecords: 实际的行数

iTotalDisplayRecords: 过滤之后，实际的行数。

fnRender的参数是每行的数据，取的时候一定要oObj.aData得到数据。

"aoColumnDefs":[{            "aTargets" : [0],            "fnRender" : function(oObj) {                    return '<input name="chk" value="' + oObj.aData.id                            + '" type="checkbox" />';                }            },{                "aTargets" : [6],                "fnRender" : function(oObj) {                        if(oObj.aData.isDelete==0){                            return '否';                        }else{                            return '是';                        }                    }            },{                "aTargets" : [7],                "fnRender" : function(oObj) {                    //alert(JSON.stringify(oObj.aData))                    var time=oObj.aData.createTime;                    if(time!='--'){                        time=new Date(time);                        return time.toLocaleString();                    }else{                        return '--';                    }                }            },{                "aTargets" : [9],                "fnRender" : function(oObj) {                    var time=oObj.aData.updateTime;                    if(time!='--'){                        time=new Date(time);                        time=new Date(time);                        return time.toLocaleString();                    }else{                        return '--';                    }                }            },{                "aTargets" : [11],                "fnRender" : function(oObj) {                    alert(JSON.stringify(oObj.aData.id))                    return "<a href='"+basePath+"model/updateModelById.action'>修改</a>";                }            }        ]

向服务端传递参数

    'fnServerParams' : function(aoData) {            aoData.push({                "name" : "phone",                "value" :  phone            });        },

 $('#example').dataTable({          //paging:false;        //设置paging选项，禁止表格分页(默认是打开的)          //scrollY: 100;        //在表格里使用滚动，你需要加上scrollY选项          //"sScrollY" : 450, //DataTables的高        //"sScrollX" : 820, //DataTables的宽           //"aaSorting" : [[2, "desc"]]          "sPaginationType": "full_numbers",  //分页风格，full_number会把所有页码显示出来          bFilter: true, //去掉搜索框          //对于从服务器端取数据，要指定以下两个参数bServerSide和sAjaxSource          "bServerSide": true,    //开启服务器模式，原始的静态页面不分页          //使用ajax源          "sAjaxSource": "ajax_data.php",          /* 从 Ajax 源加载数据的表的内容 如果加"type": "POST"，则使用post方式传递数据*/          //aoData是以post方式传递给php交互的key-value          "fnServerData": function ( sSource, aoData, fnCallback ) {              $.ajax( {                  "dataType": 'json',                  "type": "POST",                  "url": sSource,                  "data": aoData,                  "success": fnCallback              } );          },          "iDisplayLength": 5,    //设置datatables的默认显示条数          //定义每页显示数据数量数组          "aLengthMenu": [              [5,10, 20, 30, 40, -1],              [5,10, 20, 30, 40, "全部"]   //每页变化值 ，默认显示最后一个元组          ],          // 改变语言提示 把原始表示转换为中文          "oLanguage": {              "sLengthMenu": "每页 _MENU_ 条记录",              "sZeroRecords": "抱歉，没有找到",              "sInfo": "从 _START_ 到 _END_ / 共 _TOTAL_ 条数据",              "sInfoEmpty": "没有数据",              "sInfoFiltered": "(从 _MAX_ 条数据中检索)",              "sSearch":"搜索:",              "oPaginate": {                  "sFirst": "首页",                  "sPrevious": "上一页",                  "sNext": "下一页",                  "sLast": "尾页"              },              "sProcessing": "<img src='loading.gif' />",          },      });  

工作中用的参数

$('#modelTable').dataTable({        "bProcessing" : true,        'bServerSide' : true,        'fnServerParams' : function(aoData) {            aoData.push({                name : "modelItemVo.modelId",                value :  modelId            },{                name : "modelItemVo.modelClass",                value :  modelClass            });        },        "sAjaxSource" : basePath + "model/getModelItemList.action",        "sServerMethod" : "POST",        "sPaginationType" : "full_numbers",        "bPaginate" : true, // 翻页功能        "bStateSave" : true, // 状态保存        "bLengthChange" : false, // 改变每页显示数据数量        "bFilter" : false, // 过滤功能        "bSort" : false, // 排序功能        "bInfo" : true,// 页脚信息        "bAutoWidth" : false,// 自动宽度        "bDestroy" : true,        "iDisplayLength" : 15, // 每页显示多少行        "aoColumns" : [{                    "sTitle" : "<input type='checkbox' id='total' onclick='selectAll(this)'/>",                    "mDataProp" : null,                    "sClass" : "chk"                }, {                    "sTitle" : '序号',                    "mDataProp" : "no",                    "sWidth" : "20",                    "sClass" : "num"                }, {                    "sTitle" : '字段',                    "mDataProp" : "filed",                    "sWidth" : "60",                    "sClass" : "tdCenter"                }, {                    "sTitle" : '数据类型',                    "mDataProp" : "dataType",                    "sWidth" : "40",                    "sClass" : "tdCenter"                }, {                    "sTitle" : '名称',                    "mDataProp" : "itemLabel",                    "sWidth" : "80",                    "sClass" : "tdCenter"                }, {                    "sTitle" : '排序',                    "mDataProp" : "orderIndex",                    "sWidth" : "20",                    "sClass" : "tdCenter"                }, {                    "sTitle" : '是否删除',                    "mDataProp" : "isDelete",                    "sWidth" : "20",                    "sClass" : "tdCenter"                }, {                    "sTitle" : '独占一行',                    "mDataProp" : "isSingle",                    "sWidth" : "20",                    "sClass" : "tdCenter"                }, {                    "sTitle" : '是否显示',                    "mDataProp" : "isShow",                    "sWidth" : "20",                    "sClass" : "tdCenter"                }, {                    "sTitle" : '操作',                    "mDataProp" : null,                    "sWidth" : "40",                    "sClass" : "tdCenter"                }],        "oLanguage" : {              "sUrl" : basePath + "plugins/datatable/cn.txt" // 中文包        },        "fnInitComplete":function(){            // 重置iframe高度            window.parent.frameResize();        },        "aoColumnDefs":[{            "aTargets" : [0],            "fnRender" : function(oObj) {                    return '<input name="chk" value="' + oObj.aData.id                            + '" type="checkbox" />';                }            },{                "aTargets" : [3],                "fnRender" : function(oObj) {                        if(oObj.aData.dataType==1){                            return '字符串文本';                        }else if(oObj.aData.dataType==2){                            return '文本区';                        }else if(oObj.aData.dataType==3){                            return '日期';                        }else if(oObj.aData.dataType==4){                            return '下拉列表';                        }else if(oObj.aData.dataType==5){                            return '复选框';                        }else{                            return "单选框";                        }                    }            },{                "aTargets" : [6],                "fnRender" : function(oObj) {                        if(oObj.aData.isDelete==0){                            return '否';                        }else{                            return '是';                        }                    }            },{                "aTargets" : [7],                "fnRender" : function(oObj) {                        if(oObj.aData.isSingle==0){                            return '否';                        }else{                            return '是';                        }                    }            },{                "aTargets" : [8],                "fnRender" : function(oObj) {                        if(oObj.aData.isShow==0){                            return '显示';                        }else{                            return '不显示';                        }                    }            },{                "aTargets" : [9],                "fnRender" : function(oObj) {                    return "<a href='"+basePath+"model/findModelItemById.action?id="+oObj.aData.id+"'>修改</a>";                }            }        ]    });

cn.txt

{"sLengthMenu": "每页显示 _MENU_ 条记录","sZeroRecords": "抱歉， 没有找到","sInfo": "共 _TOTAL_ 条数据  ","sInfoEmpty": "","sInfoFiltered": "(从 _MAX_ 条数据中检索)","oPaginate": {      "sFirst": "首页",      "sPrevious": "上一页",    "sNext": "下一页",    "sLast": "尾页"  }, "sZeroRecords": "暂无数据！",  "sProcessing": "正在加载数据..."}