/* * data-pagination 指定是否啟用分頁 * data-page-list 指定分頁的頁數(shù)據(jù)量數(shù)組 '[5,10]' * data-side-pagination 指定分頁是否是服務(wù)端(server)/客戶端(client) * 特別說明： * 客戶端，請求參數(shù)： * search:文本框內(nèi)容，在文本框內(nèi)容改變是自動提交請求 * order: 排序方式 * sort:排序列名 * offset:劃過條數(shù) * limit:要獲取的數(shù)據(jù)的條數(shù) * */ var $table1= $('#table1').bootstrapTable({  columns: [   { field: 'sno', title: '學(xué)生編號',sortable:true },   { field: 'sname', title: '學(xué)生姓名' },   { field: 'ssex', title: '性別' },   { field: 'sbirthday', title: '生日' },   { field: 'class', title: '課程編號' },  ],  url: '@Url.Action("GetStuList", "DataOne")',  pagination: true,  sidePagination: 'server',  pageList:[5,10,20,50],  queryParams: function (params) {   params.name = '張三豐';   //特別說明，返回的參數(shù)的值為空，則當(dāng)前參數(shù)不會發(fā)送到服務(wù)器端   //這種指定請求參數(shù)的方式和datatables控價類似   params.sex = $('input[name="sex"]:checked').val();   return params;  } }); //刷新方法 $('#heartBtn').click(function () {  $table1.bootstrapTable('refresh'); }); [html] view plain copy print?<table id="table1"   data-classes="table table-hover "   data-search="true"   data-show-refresh="true"   data-show-toggle="true"   data-show-columns="true"   data-toolbar="#toolbar"></table> <div id="toolbar">  <div class="btn-group">   <button class="btn btn-default">    <i class="glyphicon glyphicon-plus"></i>   </button>   <button class="btn btn-default">    <i class="glyphicon glyphicon-heart" id="heartBtn"></i>   </button>   <button class="btn btn-default">    <i class="glyphicon glyphicon-trash"></i>   </button>  </div>  <div class="form-group">   <label class="control-label">性別：</label>   <label class="radio-inline">    <input type="radio" name="sex" value="男" /> 男   </label>   <label class="radio-inline">    <input type="radio" name="sex" value="女" /> 女   </label>  </div> </div> 

public JsonResult GetStuList(string sex, string search, string sort, string order, int offset, int limit) {  var query = _Context.Student.AsQueryable();  if (string.IsNullOrEmpty(sex) == false)   query = query.Where(q => q.Ssex == sex);  if (string.IsNullOrEmpty(search) == false)   query = query.Where(q => q.Sno.Contains(search) || q.Sname.Contains(search));  //排序  if (sort == "sno")  {   if (order == "asc")    query = query.OrderBy(q => q.Sno);   else    query = query.OrderByDescending(q => q.Sno);  }  else   query = query.OrderBy(q => q.Sbirthday);  int total = query.Count();  var list = query.Skip(offset).Take(limit).ToList();  return Json(new  {   rows = list,   total = total  }); }