- A+
所属分类:Bootstrap Table
Html
- <div class="fixed-table-toolbar">
- <div class="pull-right search">
- <input id="Query" class="form-control input-outline" placeholder="搜索" type="text">
- </div>
- </div>
- <table id="Table"></table>
JavaScript
- var search = '';
- $('#Query').bind('keydown', function (e) {
- if (e.keyCode == "13") {
- search = $('#Query').val();
- $('#Table').bootstrapTable('refresh', { silent: true, url: 'JsonTable', query: { searchText: search } });
- }
- });
- $('#Table').bootstrapTable({
- toolbar: '#toolbar',//一个jQuery 选择器,指明自定义的toolbar
- toolbarAlign: 'right',
- minimumCountColumns: '2',//当列数小于此值时,将隐藏内容列下拉框。
- pagination: true,//设置为 true 会在表格底部显示分页条
- idField: 'ID',//指定主键列
- pageList: '[10, 25, 50, 100, ALL]',//如果设置了分页,设置可供选择的页面数据条数。设置为All 则显示所有记录。
- queryParams: queryParam,//
- sidePagination: 'server',//设置在哪里进行分页,可选值为 'client' 或者 'server'。设置 'server'时,必须设置 服务器数据地址(url)或者重写ajax方法
- url: 'JsonTable',//服务器数据的加载地址
- method: 'get',
- columns: [{
- checkbox: true,
- },{
- field: 'ID',
- title: '系统ID'
- }, {
- field: 'C1',
- title: ''
- }]
- });
- function queryParam(Params) {
- var P = {
- pageSize: Params.limit,
- offset: Params.offset,
- sortOrder: Params.order,
- searchText: search
- };
- return P;
- }
Controller
- public ActionResult JsonTable(int pageSize, int offset, string sortOrder,string searchText) {
- int total = 0;
- List<BOOTSTRAPTABLE> rows = null;
- string json = "";
- if (searchText != "")
- {
- total = db.BOOTSTRAPTABLE.Where(a => a.ID.Contains(searchText) || a.C1.Contains(searchText)).Count();
- rows = db.BOOTSTRAPTABLE.Where(a => a.ID.Contains(searchText) || a.C1.Contains(searchText)).OrderByDescending(b => b.ID).Skip(offset).Take(pageSize).ToList();
- json = JsonConvert.SerializeObject(new { total = total, rows = rows });
- }
- else {
- total = db.BOOTSTRAPTABLE.Count();
- rows = db.BOOTSTRAPTABLE.OrderByDescending(b => b.ID).Skip(offset).Take(pageSize).ToList();
- json = JsonConvert.SerializeObject(new { total = total, rows = rows });
- }
- return Content(json, "text/json");
- }