bootstrap Table插件使用demo

更新時間：2017年08月07日 11:24:16 作者：一枚大帥哥

本篇文章主要介紹了bootstrap Table插件使用demo，小編覺得挺不錯的，現(xiàn)在分享給大家，也給大家做個參考。一起跟隨小編過來看看吧

最近研究bootstrap，它僅提供視覺效果，對于數(shù)據(jù)列表之類的并未涉及，網(wǎng)上找了一下，找到一個Table插件。

名為bootstrapTable。

官方地址：http://bootstrap-table.wenzhixin.net.cn/examples/

github:https://github.com/wenzhixin/bootstrap-table

因為英文差，研究了半天，做了一個demo，將就看

HTML:

<table class="table" id="dataShow" > 
     <thead> 
       <tr> 
         <th data-checkbox="true">選擇</th> 
         <th data-field="rkey">供應(yīng)商名稱</th> 
         <th data-field="rkey">供應(yīng)商編碼</th> 
         <th data-field="name">物料編碼</th> 
         <th data-field="sex">申請類型</th> 
         <th data-field="birthdayString">試用申請編碼</th> 
         <th data-field="age">試用狀態(tài)</th> 
         <th data-field="age">廠別</th> 
         <th data-field="age">審批狀態(tài)</th> 
         <th data-field="birthday">申請時間</th> 
         <th data-field="age">試用結(jié)果</th> 
       </tr> 
     </thead> 
  </table>

JS:

var currPageIndex = 0; 
    var currLimit = 10; 
 
    $(function () { 
      $("#dataShow").bootstrapTable({ 
        url: "TradHandler.ashx?request=getTradList", 
        sortName: "rkey",//排序列 
        striped: true,//條紋行 
        sidePagination: "server",//服務(wù)器分頁 
        //showRefresh: true,//刷新功能 
        //search: true,//搜索功能 
        clickToSelect: true,//選擇行即選擇checkbox 
        singleSelect: true,//僅允許單選 
        //searchOnEnterKey: true,//ENTER鍵搜索 
        pagination: true,//啟用分頁 
        escape: true,//過濾危險字符 
        queryParams: getParams,//攜帶參數(shù) 
        pageCount: 10,//每頁行數(shù) 
        pageIndex: 0,//其實頁 
        method: "get",//請求格式 
        //toolbar: "#toolBar", 
        onPageChange: function (number, size) { 
          currPageIndex = number; 
          currLimit = size 
        }, 
        onLoadSuccess: function () 
        { 
          $("#searchBtn").button('reset'); 
        } 
      }); 
 
      //搜索 
      $("#searchBtn").click(function () { 
        $(this).button('loading'); 
        var nullparamss = {}; 
        $("#dataShow").bootstrapTable("refresh", nullparamss); 
         
      }); 
      //enter鍵搜索 
      $("#searchKey").keydown(function (event) { 
        if (event.keyCode == 13) 
        { 
          $("#searchBtn").click(); 
        } 
      }); 
      //阻止enter鍵提交表單 
      $("#mainForm").submit(function () { 
        return false; 
      }); 
 
       
    }); 
    //默認(rèn)加載時攜帶參數(shù) 
    function getParams(params) { 
      var searchKey = $("#searchKey").val(); 
      return { bysex: 1, limit: params.limit, offset: params.offset, search: searchKey }; 
    }

TradHandler.ashx：

/// <summary> 
    /// 獲取批量數(shù)據(jù)示例 
    /// </summary> 
    /// <param name="context"></param> 
    private void getTradList(HttpContext context) 
    { 
      //用于序列化實體類的對象 
      JavaScriptSerializer jss = new JavaScriptSerializer(); 
 
      #region 模擬數(shù)據(jù)獲取 
      List<SimpleModel> list = new List<SimpleModel>(); 
      for (int i = 0; i < 1000; i++) 
      { 
        list.Add(new SimpleModel() { age = 18, name = "小李" + i, rkey = i + 1, sex = "男" }); 
      } 
 
 
      //請求中攜帶的條件 
      string bysex = context.Request.Params["bysex"]; 
      string searchKey = context.Request.Params["search"]; 
 
      //請求中攜帶的頁數(shù)和下標(biāo) 
      int dataIndex = Convert.ToInt32(context.Request.Params["offset"]); 
      int pageCount = Convert.ToInt32(context.Request.Params["limit"]); 
 
      //查詢滿足條件的數(shù)據(jù) 
      List<SimpleModel> getList; 
      if (bysex != null && searchKey != null) 
      { 
        getList = (from p in list 
              where p.sex == (bysex == "0" ? "女" : "男") && p.name.Contains(searchKey.Trim()) 
              select p).ToList(); 
      } 
      else 
      { 
        getList = list; 
      } 
      #endregion 
 
      //將結(jié)果增加一列序號列 
      Dictionary<int, SimpleModel> testModel = new Dictionary<int, SimpleModel>(); 
      for (int i=0;i< getList.Count;i++) 
      { 
        testModel.Add(i + 1, getList[i]); 
      } 
       
      //給分頁實體賦值 
      PageModels<SimpleModel> model = new PageModels<SimpleModel>(); 
      model.total = getList.Count; 
      if (getList.Count % pageCount == 0) 
        model.page = getList.Count / pageCount; 
      else 
        model.page = (getList.Count / pageCount) + 1; 
 
      //獲取對應(yīng)頁的數(shù)據(jù) 
      model.rows = testModel.Where(t => t.Key > dataIndex && t.Key <= dataIndex + pageCount).Select(t => t.Value).ToList(); 
 
      //將查詢結(jié)果返回 
      context.Response.Write(jss.Serialize(model)); 
    }

有同學(xué)問pagemodel實體類，這里也分享一下，泛型實體類，因為該插件需要這些屬性才能正常自動綁定

[Serializable] 
  public class TablePageModel<T> 
  { 
    /// <summary> 
    /// 總行數(shù) 
    /// </summary> 
    public long total { get; set; } 
 
    /// <summary> 
    /// 總頁數(shù) 
    /// </summary> 
    public int page { get; set; } 
 
    private List<T> _rows; 
    /// <summary> 
    /// 數(shù)據(jù)源 
    /// </summary> 
    public List<T> rows 
    { 
      get 
      { 
        if (_rows == null) 
          _rows = new List<T>(); 
        return _rows; 
      } 
      set 
      { 
        _rows = value; 
      } 
    } 
  }

展示數(shù)據(jù)結(jié)果如下：