dataTables的初次使用

 1 oTable = dataTableObj.dataTable({
 2 "bJQueryUI": true,            //是否启用jquery 界面
 3 "sPaginationType": "full_numbers",         //分页类型
 4 ‘bLengthChange‘: true,                     //是否可调整每页显示的条数
 5 "bFilter": false,                               
 6 "bInfo": true,                                 //是否提交表信息，如果要与服务器交互，要为true，后台接受表信息，进行处理
 7 ‘bPaginate‘: true,
 8 "bProcessing": true,                   //数据从后台传回来的过程中，是否显示提示信息
 9 "bAutoWidth": false,
10 "bServerSide": true,                 //是否与服务器交互
11 "bStateSave": false,
12 "iDisplayLength": 5,                //初次加载时，每页的条数，bLengthChange为true时，可以被aLengthMenu下拉框的值修改
13 "aLengthMenu": [[10, 20, 50, 100], [10, 20, 50, 100]],
14 "oLanguage": {                      //语言，表格的显示信息。
15 "sLengthMenu": "每页显示 _MENU_ 条记录",
16 "sZeroRecords": "对不起，查询不到任何相关数据",
17 "sInfo": "当前显示 _START_ 到 _END_ 条，共 _TOTAL_ 条记录",
18 "sInfoEmtpy": "找不到相关数据",
19 "sInfoFiltered": "数据表中共为 _MAX_ 条记录",
20 "sProcessing": "正在加载中...",
21 "sSearch": "搜索",
22 "oPaginate": {
23 "sFirst": "第一页",
24 "sPrevious": " 上一页 ",
25 "sNext": " 下一页 ",
26 "sLast": " 最后一页 "
27 }
28 },
29 "sAjaxSource": actionUrl,                  //与服务器交互式，获取数据时的页面路径，  actionUrl外面传进来的变量，“/Home/Index”
30 "aoColumns": aoColumns                 //表格每一列的属性aoColumns     结构如下。            
31 });

 1 var aoColumns = [
 2 {
 3 "sName": "Id",
 4 "bSortable": false,
 5 "fnRender": function (oObj) {
 6 return "<input type=checkbox value=" + oObj.aData[1] + ">";
 7 }
 8 },
 9 {
10 "sName": "Id",
11 "bSortable": false,
12 "fnRender": function (oObj) {
13 var btnArray = "";
14 @if (editButton != null)
15 {
16 <text>btnArray += ‘<button type="submit" class="btn btn-primary btn-normal" style="margin-left:5px" title="@editButton.Text" onclick="Edit(‘ + oObj.aData[1] + ‘)"><span >编辑</span></button>‘</text>
17 }
18 @if (deleteButton != null)
19 {
20 <text>btnArray += ‘<button type="submit" class="btn btn-danger btn-normal" title="@deleteButton.Text" style="margin-left:5px" onclick="Delete(‘ + oObj.aData[1] + ‘)"><span >删除</span></button>‘</text>
21 }
22 return btnArray;
23 }
24 },
25 {
26 "sName": "Id",
27 "bSortable": false,
28 },
29 {
30 "sName": "title", "bSortable": false, fnRender: function (oObj) {
31 return "<a href=‘https://www.toufuli.com/news/detail/" + oObj.aData[2] + "‘ target=‘_blank‘ >" + oObj.aData[3] + "</a>"
32 }
33 },
34 {
35 "sName": "cid",
36 "fnRender": function (oObj) {
37 if (oObj.aData[4]==1)
38 return "公司新闻";
39 if (oObj.aData[4] ==2)
40 return "网站公告";
41 if (oObj.aData[4] == 3)
42 return "行业资讯";
43 if (oObj.aData[4] == 4)
44 return "投资知识";
45 return "未知";
46 }, "bSortable": false
47 },
48 { "sName": "clicks", "bSortable": false },
49 { "sName": "status", 
50 "fnRender": function (oObj) {
51 if (oObj.aData[6]==0)
52 return "不显示";
53 if (oObj.aData[6] ==1)
54 return "显示";
55 return "未知";
56 }, "bSortable": false
57 },
58 { "sName": "addtime", "bSortable": false },
59 { "sName": "uptime", "bSortable": false },
60 ]

 1  var result = from c in filterResult
 2                          select new string[] { 
 3                           c.id.ToString(),
 4                           c.id.ToString(),
 5                           c.id.ToString(),
 6                           c.title,
 7                           c.cid.ToString(),
 8                           c.clicks.ToString(),
 9                           c.status.ToString(),
10                           c.addtime.ToString(), 
11                           c.uptime.ToString(),
12                          };