基于BootstrapTable的简单应用

系统管理员 2021-09-12 07:52 387阅读 0赞

Bootstrap Table基于Bootstrap的jQuery表格插件，通过简单的设置，就可以拥有强大的单选、多选、排序、分页，以及编辑、导出、过滤（扩展）等等的功能。

本文将以一个基于BootstrapTable控件的图书列表查询功能为实例（如图1）。注意本实例使用了ASP.NET MVC。

![Center][]

图1

**页面代码：**

@{
        Layout = null;
        ViewBag.Title = "基于BootstrapTable的简单应用";
    }
    
    
    <link href="~/Content/bootstrap.min.css" rel="stylesheet" />
    <link href="~/Content/bootstrap-table.min.css" rel="stylesheet" />
    
    <div class="container body-content" style="padding-top:20px;">
        <div class="panel panel-default">
            <div class="panel-heading">查询条件</div>
            <div class="panel-body">
                <form class="form-inline">
                    <div class="row">
                        <div class="col-sm-4">
                            <label class="control-label">图书名称：</label>
                            <input id="txtTitle" type="text" class="form-control">
                        </div>
                        <div class="col-sm-4">
                            <label class="control-label">图书作者：</label>
                            <input id="txtAuthor" type="text" class="form-control">
                        </div>
                        <div class="col-sm-4">
                            <label class="control-label">出版社：</label>
                            <input id="txtPublish" type="text" class="form-control">
                        </div>
                    </div>
    
                    <div class="row text-right" style="margin-top:20px;">
                        <div class="col-sm-12">
                            <input class="btn btn-primary" type="button" value="查询" onclick="SearchData()">
                            <input class="btn btn-default" type="button" value="批量删除" onclick="BtchDeleteBook()">
                        </div>
                    </div>
                </form>
            </div>
        </div>
        
        <table id="table"></table>
    </div>
    
    
    <script src="~/Scripts/jquery-1.10.2.min.js"></script>
    <script src="~/Scripts/bootstrap.min.js"></script>
    <script src="~/Scripts/bootstrap-table.min.js"></script>
    <script src="~/Scripts/bootstrap-table-zh-CN.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('#table').bootstrapTable({
                url: '@Url.Action("SearchBookInfo", "Home")',
                queryParamsType: '',              //默认值为 'limit' ,在默认情况下 传给服务端的参数为：offset,limit,sort
                queryParams: queryParams,
                method: "post",
                pagination: true,
                pageNumber: 1,
                pageSize: 2,
                pageList: [10, 20, 50, 100],
                sidePagination: "server",         //分页方式：client客户端分页，server服务端分页（*）
                striped: true,                    //是否显示行间隔色
                cache: false,
                uniqueId: "BookId",               //每一行的唯一标识，一般为主键列
                height:300,
                paginationPreText: "上一页",
                paginationNextText: "下一页",
                columns: [
                    { checkbox: true },
                    { title: '序号', width: 50, align: "center", formatter: function (value, row, index) { return index + 1; } },
                    { title: '图书名称', field: 'Title' },
                    { title: '图书作者', field: 'Author' },
                    { title: '销售价格', field: 'Price' },
                    { title: '出版社', field: 'Publish' },
                    {
                        title: '出版时间', field: 'PublishDate', formatter: function (value, row, index) {
                            if (value == null)
                                return "";
                            else {
                                var pa = /.*$(.*)$/;
                                var unixtime = value.match(pa)[1].substring(0, 10);
                                return getShortTime(unixtime);
                            }
                        }
                    },
                    {
                        title: '操作', field: 'BookId', formatter: function (value, row, index) {
                            var html = '<a href="javascript:EditBook('+ value + ')">编辑</a>';
                            html += '　<a href="javascript:DeleteBook(' + value + ')">删除</a>';
                            return html;
                        }
                    }
                ]
            });
        });
    
        //查询条件
        function queryParams(params) {
            return {
                pageSize: params.pageSize,
                pageIndex: params.pageNumber,
                Title: $.trim($("#txtTitle").val()),
                Author: $.trim($("#txtAuthor").val()),
                Publish: $.trim($("#txtPublish").val()),
            };
        }
    
        //查询事件
        function SearchData() {
            $('#table').bootstrapTable('refresh', { pageNumber: 1 });
        }
    
        //编辑操作
        function EditBook(bookId){
            alert("编辑操作，图书ID：" + bookId);
        }
    
        //删除操作
        function DeleteBook(bookId) {
            if (confirm("确定删除图书ID：" + bookId + "吗？"))
            {
                alert("执行删除操作");
            }
        }
    
        //批量删除
        function BtchDeleteBook(){
            var opts = $('#table').bootstrapTable('getSelections');
            if (opts == "") {
                alert("请选择要删除的数据");
            }
            else {
                var idArray = [];
                for (var i = 0; i < opts.length; i++) {
                    idArray.push(opts[i].BookId);
                }
                if (confirm("确定删除图书ID：" + idArray + "吗？")) {
                    alert("执行删除操作");
                }
            }
        }
    
        function getTime(/** timestamp=0 **/) {
            var ts = arguments[0] || 0;
            var t, y, m, d, h, i, s;
            t = ts ? new Date(ts * 1000) : new Date();
            y = t.getFullYear();
            m = t.getMonth() + 1;
            d = t.getDate();
            h = t.getHours();
            i = t.getMinutes();
            s = t.getSeconds();
            // 可根据需要在这里定义时间格式
            return y + '-' + (m < 10 ? '0' + m : m) + '-' + (d < 10 ? '0' + d : d) + ' ' + (h < 10 ? '0' + h : h) + ':' + (i < 10 ? '0' + i : i) + ':' + (s < 10 ? '0' + s : s);
        }
    
        function getShortTime(/** timestamp=0 **/) {
            var ts = arguments[0] || 0;
            var t, y, m, d, h, i, s;
            t = ts ? new Date(ts * 1000) : new Date();
            y = t.getFullYear();
            m = t.getMonth() + 1;
            d = t.getDate();
            // 可根据需要在这里定义时间格式
            return y + '-' + (m < 10 ? '0' + m : m) + '-' + (d < 10 ? '0' + d : d);
        }
    
    </script>

**控制器代码：**

/// <summary>
    /// 查询图书信息
    /// </summary>
    /// <param name="param"></param>
    /// <returns></returns>
    public JsonResult SearchBookInfo(BookInfo param, int pageSize, int pageIndex)
    {
        //获取图书列表
        List<BookInfo> bookList = GetBookList();
    
        //根据条件筛选数据
        if (!String.IsNullOrEmpty(param.Title))
        {
            bookList = bookList.Where(a => a.Title.Contains(param.Title)).ToList();
        }
        if (!String.IsNullOrEmpty(param.Author))
        {
            bookList = bookList.Where(a => a.Author.Contains(param.Author)).ToList();
        }
        if (!String.IsNullOrEmpty(param.Publish))
        {
            bookList = bookList.Where(a => a.Publish.Contains(param.Publish)).ToList();
        }
    
        //BootstrapTable的返回结果
        BootstrapTableResult<BookInfo> result = new BootstrapTableResult<BookInfo>();
        result.total = bookList.Count;
        result.rows = bookList;
        return Json(result);
    }
    
    /// <summary>    
    /// 获取图书列表    
    /// </summary>    
    /// <returns></returns>    
    public List<BookInfo> GetBookList()
    {
        List<BookInfo> bookList = new List<BookInfo>();
        BookInfo book1 = new BookInfo()
        {
            BookId = 8,
            Title = "ASP.NET MVC 5高级编程",
            Author = "加洛韦",
            Publish = "清华大学出版社",
            PublishDate = new DateTime(2017, 08, 15),
            Price = 29.99
        };
        bookList.Add(book1);
        BookInfo book2 = new BookInfo()
        {
            BookId = 9,
            Title = "Java从入门到精通",
            Author = "明日科技",
            Publish = "清华大学出版社",
            PublishDate = new DateTime(2015, 09, 28),
            Price = 38.55
        };
        bookList.Add(book2);
        BookInfo book3 = new BookInfo()
        {
            BookId = 10,
            Title = "Oracle从入门到精通",
            Author = "秦靖",
            Publish = "机械工业出版社",
            PublishDate = new DateTime(2014, 10, 08),
            Price = 38.55
        };
        bookList.Add(book3);
        return bookList;
    }

**其他代码：**

/// <summary>    
    /// 图书信息实体类    
    /// </summary>    
    public class BookInfo
    {
        public int BookId { set; get; }             //图书ID    
        public string Title { set; get; }           //图书名称    
        public string Author { set; get; }          //图书作者  
        public string Publish { set; get; }         //出版社
        public DateTime PublishDate { set; get; }   //出版时间    
        public Double Price { set; get; }           //销售价格    
    }

/// <summary>
    /// BootstrapTable返回结果类
    /// </summary>
    public class BootstrapTableResult<T>
    {
        public int total { get; set; }      //总记录数
        public List<T> rows { get; set; }   //数据列表
    }

Bootstrap Table资料网站：http://bootstrap-table.wenzhixin.net.cn/zh-cn/

[Center]: /images/20210724/aaa9d053aa784cf989449ad161844a83.png