实现方式:
在初始化dataTables时增加属性:
var param_index=0; //定义排序字段,在新增表的行时用到
$('#dt-table').DataTable({
.....
"rowReorder":{
dataSrc :"自己数据库中排序的索引" eq:param_index
},
...
})
参看官方例子:
https://datatables.net/extensions/rowreorder/examples/
//增加行
$('#addRow').on( 'click', function () {
dataTable.row.add({"param_index":param_index,"input_type":"","param_name":"","field_id":"","param_type":"","param_desc":""}).draw();
} );
//自动编号来显示序号
dataTable.column(0, {search:'applied', order:'applied'}).nodes().each( function (cell, i) {
param_index = i+1;
cell.innerHTML = i+1;
} );
//页面引入的js,官网可以下载到 (rowReorder.js)这是排序的主要js
<script type="text/javascript" src="../../js/plugin/datatables/jquery.dataTables4.min.js"></script>
<script type="text/javascript" src="../../js/plugin/datatables/dataTables.bootstrap4.min.js"></script>
<script type="text/javascript" src="../../js/plugin/datatables/dataTables.rowReorder.js"></script>
//css,拖动时行的样式
<link rel="stylesheet" type="text/css" href="../../css/rowReorder.dataTables.css">