无分页的datatable

来源：互联网发布：淘宝韩都衣舍编辑：程序博客网时间：2024/05/24 13:27

<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<meta name="renderer" content="webkit|ie-comp|ie-stand">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
<meta http-equiv="Cache-Control" content="no-siteapp" />

<link rel="stylesheet" type="text/css" href="static/h-ui/css/H-ui.min.css" />
<link rel="stylesheet" type="text/css" href="static/h-ui.admin/css/H-ui.admin.css" />
<link rel="stylesheet" type="text/css" href="lib/Hui-iconfont/1.0.8/iconfont.css" />
<link rel="stylesheet" type="text/css" href="static/h-ui.admin/skin/default/skin.css" id="skin" />
<link rel="stylesheet" type="text/css" href="static/h-ui.admin/css/style.css" />
<style type="text/css">
.table td {
text-align:center;
}
</style>

<title>汽车品牌管理</title>
</head>
<body>
<nav class="breadcrumb"><i class="Hui-iconfont"></i> 首页 <span class="c-gray en">></span> 商户管理 <span class="c-gray en">></span> 汽车品牌管理 <a class="btn btn-success radius r" style="line-height:1.6em;margin-top:3px" href="javascript:location.replace(location.href);" title="刷新"><i class="Hui-iconfont"></i></a></nav>
<div class="page-container">
<div class="text-c">

<span class="select-box inline">
<input type="text" name="CarName" id="CarName" placeholder=" 汽车品牌" style="width:250px" class="input-text">
<input type="text" name="CarType" id="CarType" placeholder=" 车型" style="width:250px" class="input-text">

<button name="" id="" class="btn btn-success" type="submit" onclick="Totals();"><i class="Hui-iconfont"></i> 搜汽车</button>
</div>
<div class="cl pd-5 bg-1 bk-gray mt-20">
<span class="l">
<a class="btn btn-primary radius" data-title="导入汽车" onclick="basecar_import('导入汽车', 'car_excelimport.html')" href="javascript:;"> <i class="Hui-iconfont"></i> 导入汽车</a>
<a class="btn btn-primary radius" data-title="导出汽车" onclick="ExcelExport()" href="javascript:;"><i class="Hui-iconfont"></i> 导出汽车</a>
</span> </div>
<div class="mt-20">
<table class="table table-border table-bordered table-bg table-hover table-sort table-responsive" id="cartable">
<thead>
<tr class="text-c">

<th width="40">ID</th>
<th width="80">商户拼音首字母</th>
<th width="80">汽车品牌</th>
<th width="120">车型</th>
<th width="60">状态</th>
<th width="120">操作</th>
</tr>
</thead>

</table>
</div>
</div>

<script type="text/javascript" src="lib/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript" src="lib/layer/2.4/layer.js"></script>
<script type="text/javascript" src="static/h-ui/js/H-ui.min.js"></script>
<script type="text/javascript" src="static/h-ui.admin/js/H-ui.admin.js"></script> 

<script type="text/javascript" src="lib/My97DatePicker/4.8/WdatePicker.js"></script>
<script type="text/javascript" src="lib/datatables/1.10.0/jquery.dataTables.min.js"></script>

</body>
</html>

<script>
$(function () {
Totals();

});

function Totals() {

var CarName = $("#CarName").val();
var CarType = $("#CarType").val();

$('#cartable').DataTable({

"searching": true,//搜索框
"destroy": true,//Cannot reinitialise DataTable,解决重新加载表格内容问题,即可搜索查询
"ajax": {
"type": "get",
"url": 'Ajax/BaseAjax/BaseCarBrandAjax.aspx?type=CarbrandinfoJson&CarType=' + CarType + '&CarName=' + CarName ,

},

columns: [
{ data: 'ID' },
{ data: 'CarFirstChara' },
{ data: 'CarName' },
{ data: 'CarType' },
{
data: 'State',
render: function (data, type, full, meta) {

if (data == 1) {
return '<td class="td-status"><span class="label label-success radius">可用</span></td>';
}
else {
return '<td class="td-status"><span class="label label-danger radius">禁用</span></td>';
}

}
},
{ data: null },
],
"columnDefs": [{
// 定义操作列
"targets": -1,
orderable: false,
"data": null,
"render": function (data, type, row) {
var html = '<a style="text-decoration:none" class="ml-5" onClick="basecar_edit(\'汽车编辑\',\'car_add.html\',\'' + row.ID + '\')" href="javascript:;" title="编辑"><i class="Hui-iconfont"></i></a>'

return html;
}
}],

language: {
"processing": "正在加载中...",
"lengthMenu": "每页显示 _MENU_ 项结果",
"zeroRecords": "没有匹配结果",
"info": "显示第 _START_ 至 _END_ 项结果，共 _TOTAL_ 项",
"infoEmpty": "显示第 0 至 0 项结果，共 0 项",
"infoFiltered": "(由 _MAX_ 项结果过滤)",
"infoPostFix": "",
"search": "搜索:",
"url": "",
"emptyTable": "表中数据为空",
"loadingRecords": "载入中...",
"infoThousands": ",",
"paginate": {
"first": "首页",
"previous": "上页",
"next": "下页",
"last": "末页"
},
"aria": {
"sortAscending": ": 以升序排列此列",
"sortDescending": ": 以降序排列此列"
}
}
});

}

/*汽车-编辑*/
function basecar_edit(title, url, id) {
var index = layer.open({
type: 2,
title: title,
content: url + "?cid=" + id,

});
layer.full(index);
}

/*汽车-导入*/
function basecar_import(title, url) {
var index = layer.open({
type: 2,
title: title,
content: url,

});
layer.full(index);
}

//Excel导出
function ExcelExport() {
var CarName = $("#CarName").val();
var CarType = $("#CarType").val();
$.ajax({
type: "POST",
url: "Ajax/BaseAjax/BaseCarBrandAjax.aspx?type=Carbrandinfoexport&CarName=" + CarName + "&CarType=" + CarType ,
dataType: "json",
success: function (data) {

location.href = location.origin + '/' + data;
}
});
}

</script>

阅读全文

0 0