在MVC中实现MongoDB的分页查询

使用的MongoDB net 驱动是：MongoDB.Driver.2.4.4

首先确定的是MongoDB的BsonDocument结构：

var document = new BsonDocument {                            {"UserName",user.UserName },                            {"LoginIp",RequestHelper.GetIP() },                            {"Operation",new BsonDocument{{ "操作类型","登录" },{"操作员",user.RealName} } },                            {"CreateTime",DateTime.Now }                        };

其中，Operation 中的BsonDocument中的key，value键值对是可变长的，也就是说，不一定都是2个，根据需要，可能是2个，也可能是3个，4个等。

MVC的action实现：

 public ActionResult AdminLogList(string name = "", DateTime? start = null, DateTime? end = null, int pageindex = 1, int pagesize = 10)        {            ViewBag.name = name;            ViewBag.start = start;            ViewBag.end = end;            var collection = DBHelper.GetCollection("AdminLog");            var builder = Builders<BsonDocument>.Filter;            FilterDefinition<BsonDocument> filter = builder.Empty;            if (name.IsNotNullAndEmpty())            {                //filter = filter & builder.Eq("UserName", name);                //模糊查询                filter = filter & builder.Regex("UserName", new BsonRegularExpression("/.*" + name + ".*/"));            }            if (start.IsNotNullAndEmpty())            {                filter = filter & builder.Gte("CreateTime", start);            }            if (end.HasValue)            {                filter = filter & builder.Lte("CreateTime", end);            }            var sort = Builders<BsonDocument>.Sort.Descending("CreateTime");            var documents = collection.Find(filter).Sort(sort).ToList();            var query = documents.ToPagedList(pageindex, pagesize);            return View(query);        }

查询条件，一个name，可以进行模糊查询，一个开始日期，一个结束日期。按定义的BsonDocument 文档中的CreateTime键进行降序排列。

以下是cshtml中的相关代码，可能是都觉得cshtml中的实现代码很简单，因此我在网上搜索n遍，找不到相关实现代码。而对于我这样第一次实现 mongoDB 查询的人来说，根本不知道如何实现。所以我列出了我的实现。

头部部分：

@model  PagedList.IPagedList<MongoDB.Bson.BsonDocument>@using MongoDB.Bson;@using PagedList.Mvc;

查询部分：

<div class="list-header">        @using (Html.BeginForm(ViewContext.RouteData.Values["action"].ToString(), ViewContext.RouteData.Values["Controller"].ToString(), FormMethod.Post, new { @class = "form-inline", id = "search_form", role = "form", style = "" }))        {            @Html.AntiForgeryToken()            <!-- #region 职位筛选条件区域 start -->            <div class="col-xs-12 no-padding">                <div class="container-fluid">                    <!-- Collect the nav links, forms, and other content for toggling -->                    <ul class="nav navbar-nav">                        <li class="">                            <input type="text" class="form-control  input-sm" id="name" name="name" placeholder="操作员" value="@ViewBag.name">                                                       </li>                        <li>                            <div class=" input-group date form_datetime" data-date="@((ViewBag.start ?? DateTime.Now.AddMonths(-1)).ToShortDateString())">                                <input type="text" class="form-control  input-sm" id="start" name="start" style="width:100px;" placeholder="起始日期" value="@ViewBag.start"><span class="input-group-btn">                                    <button class="btn default date-reset btn-sm" type="button"><i class="fa fa-times"></i></button>                                    <button class="btn default date-set btn-sm" type="button"><i class="fa fa-calendar"></i></button>                                </span>                            </div>--                            <div class=" input-group date form_datetime" data-date="@((ViewBag.end ?? DateTime.Now.AddMonths(-1)).ToShortDateString())">                                <input type="text" class="form-control input-sm" id="end" name="end" style="width:100px;" placeholder="截止日期" value="@ViewBag.end">                                <span class="input-group-btn">                                    <button class="btn default date-reset btn-sm" type="button"><i class="fa fa-times"></i></button>                                    <button class="btn default date-set btn-sm" type="button"><i class="fa fa-calendar"></i></button>                                </span>                            </div>                        </li>                        <li>                            <div class="btn-group  navbar-right" role="group" aria-label="...">                                <button type="submit" class="btn btn-primary btn-sm"><i class="fa fa-search"></i><strong>筛选</strong></button>                            </div>                        </li>                    </ul>                </div><!-- /.container-fluid -->            </div>        }    </div>

列表及分页实现部分，这部分感觉最难，各种尝试，最终实现：

<div class=" list-item padding">        <table class="table table-bordered  table-striped">            <thead>                <tr>                                       <th>                        操作员                    </th>                    <th>                        登录ip                    </th>                    <th>                        操作                    </th>                                         <th>                        时间                    </th>                                     </tr>            </thead>            <tbody>                @foreach (var item in Model)                {                    <tr>                                               <td>                            @item["UserName"]                        </td>                        <td>                            @item["LoginIp"]                        </td>                        <td class="operation">                                                       @item["Operation"].ToJson()                        </td>                        <td>                            @item["CreateTime"].ToUniversalTime()                        </td>                                           </tr>                }            </tbody>        </table>        @Html.PagedListPager(Model, page => Url.Action(ViewContext.RouteData.Values["action"].ToString(), new { name = @ViewBag.name, start = @ViewBag.start, end = ViewBag.end, pageIndex = page }),                new PagedListRenderOptions                {                    LinkToFirstPageFormat = "<span class='glyphicon glyphicon-fast-backward'></span>",                    LinkToPreviousPageFormat = "<span class='glyphicon glyphicon-backward'></span>",                    LinkToNextPageFormat = "<span class='glyphicon glyphicon-forward'></span>",                    LinkToLastPageFormat = "<span class='glyphicon glyphicon-fast-forward'></span>",                    DisplayPageCountAndCurrentLocation = true,                    PageCountAndCurrentLocationFormat = "{0}/{1}页",                    DisplayItemSliceAndTotal = true,                    ItemSliceAndTotalFormat = "共{2}条记录"                })        <div class="action text-center">        </div>    </div>

操作部分json分解实现源码：

$(function () {                        $(".operation").each(function (index) {                var self = $(this);                //console.info($(this).text());                var obj = eval("(" + self.text() + ")");                var str = "";                $.each(obj, function (index, item) {                    str += index + "：" + item + "<br/>";                });                self.html(str);            });          });