jquery Datatables 发ajax请求常用配置

 

<div class="row result-div">
    <div class="col-sm-12 col-md-12 col-lg-12">
        <table class="table table-responsive table-bordered-gene table-hover table-border-white-2 table-bg-light-blue" id="traitMarkerDatatable">
        </table>
    </div>
</div>

 

function showTraitMarkerDatatables(query)
    {
        var olddataTables = jQuery("#traitMarkerDatatable>thead");
        if(!isNullOrEmpty(olddataTables) && olddataTables.length>0)
        {
            jQuery("#traitMarkerDatatable").DataTable().destroy();
        }
        var columns =  [
            { "title": "编号","data": "snpName","width": "13%"},
            { "title": "位置","width": "15%"}, //,"data": "chr"
            { "title": "效果","data": "geneName","width": "13%" },
            { "title": "效应","data": "riskAlle","width": "10%" },
            { "title": "区间","data": "type","width": "13%" },
            { "title": "频率","data": "alleFreqStr","width": "13%" },
            { "title": "水平","data": "pval","width": "10%" },
            { "title": "EFO","data": "efoNo","width": "13%" }
        ]
    //        var data = res.data;
        jQuery("#traitMarkerDatatable").DataTable({
            responsive: true,
            processing: true,
            serverSide: true,
            columns:columns,
            ordering: false,
            searching: false,
            paging:true,
            info:true,
            autoWidth:false,
            pageLength: 50,
            lengthMenu: [ 10, 20, 30, 50, 100 ],
            lengthChange:false,
            pagingType: "full_numbers",
//            scrollX: "2000px",
            rowCallback:function( row, data, index ) {

                jQuery('td',row).addClass("tr-row");
            },
            language: {
                lengthMenu: "每页 _MENU_ 条记录",
                info: "当前第 _START_至_END_ 条,共 _MAX_ 条 (第 _PAGE_ 页,共 _PAGES_ 页)",
                infoEmpty: "当前第 0至0 项结果，共 0 项",
                infoFiltered: "",
                "zeroRecords": "无满足条件数据",
                "processing": "处理中,请稍候...",
                "paginate": {
                    "first": "首页",
                    "previous": "上一页",
                    "next": "下一页",
                    "last": "末页"
                },
            },
            ajax:
            {
                "url":"#springUrl('')/rest/trait/queryTraitMarker",
                "type": "POST",
                "data": function ( d ) {
                    return jQuery.extend({}, d, query );
                }
            },
            columnDefs: [
                {
                    "targets": [0],
    //                    "data": "traitId",
                    "render": function(data, type, full) {
                        return '<a class="origin-a-link" href="#" onclick="queryMarkerInfo(\''+full.snpName+'\')">'+full.snpName+'</a>';
                    }
                },
                {
                    "targets": [1],
                    "render": function(data, type, full) {
                        return full.chr+':'+formatNum(full.pos,0);
                    }
                },
                {
                    "targets": [2],
                    "data": "id",
                    "render": function(data, type, full) {
                        return '<a class="origin-a-link" href="#" onclick="queryGeneInfo(\''+full.geneName+'\')">'+full.geneName+'</a>';
                    }
                }
            ]
        });

    }