Asp.Net MVC中使用ACE模板之Jqgrid-51CTO.COM

第一次看到ACE模板，有种感动，有种相见恨晚的感觉，于是迅速来研究。它本身是基于bootstrap和jqueryui，但更nice，整合之后为后台开发节省了大量时间。发现虽然不是完美，整体效果还是不错，特此分享给园友。这一节先讲其中的Jqgrid。按照国际惯例，先上两张图。

集成了button，form，treeview以及日历，时间轴、chart等控件，非常丰富。下面是Jqgrid在MVC中的使用。

jqgrid的加载，排序，查找都是基于后台方法，不是在内存中完成，但也有一些小坑。下面一一道来。

一、引入ace模板

ace本身考虑了对ie的兼容，加上bootstrap和jqueryui所以引入的样式和脚本文件比较多。我拿掉了一下googlefont的链接，请求太慢了，你懂的。现在MVC最关心的就是RenderBody的位置。在page-content下的Row，也可以将page-header放入子页面中去，自己多写几个元素，这个就在于你自己的选择了。

<div class="page-content"> 
                        <div class="page-header"> 
                            <h1> 
                                <span>控制台</span> 
                                <small> 
                                    <i class="icon-double-angle-right"></i> 
                                    <span>查看</span> 
                                </small> 
                            </h1> 
                        </div><!-- /.page-header --> 
 
                        <div class="row"> 
                            <div class="col-xs-12"> 
                                <!-- PAGE CONTENT BEGINS --> 
                                 @RenderBody()  
                                <!-- PAGE CONTENT ENDS --> 
                            </div><!-- /.col --> 
                        </div><!-- /.row --> 
                    </div><!-- /.page-content -->

全部的layout.cshtml

<!DOCTYPE html> 
<html > 
<head> 
    <meta charset="utf-8" /> 
    <meta name="viewport" content="width=device-width" /> 
      <meta http-equiv="X-UA-Compatible" content="IE=edge"> 
    <title>@ViewBag.Title</title> 
      
    <link href="~/Content/CSS/bootstrap.min.css" rel="stylesheet" /> 
    <link rel="stylesheet" href="~/Content/CSS/font-awesome.min.css" /> 
    <script src="~/Content/Js/jquery-2.0.3.min.js"></script> 
    <link href="~/Content/CSS/niqiu.css" rel="stylesheet" /> 
    <!--[if IE 7]> 
          <link rel="stylesheet" href="~/Content/CSS/font-awesome-ie7.min.css" /> 
        <![endif]--> 
 
        <!-- page specific plugin styles --> 
 
        <!-- ace styles --> 
 
        <link rel="stylesheet" href="~/Content/CSS/ace.min.css" /> 
        <link rel="stylesheet" href="~/Content/CSS/ace-rtl.min.css" /> 
        <link rel="stylesheet" href="~/Content/CSS/ace-skins.min.css" /> 
         
        <!--[if lte IE 8]> 
          <link rel="stylesheet" href="~/Content/CSS/ace-ie.min.css" /> 
        <![endif]--> 
 
        <!-- inline styles related to this page --> 
 
        <!-- ace settings handler --> 
 
        <script src="~/Content/Js/ace-extra.min.js"></script> 
        <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries --> 
        <!--[if lt IE 9]> 
        <script src="~/Content/Js/html5shiv.js"></script> 
        <script src="~/Content/Js/respond.min.js"></script> 
        <![endif]--> 
   
</head> 
<body> 
       
   <div class="navbar navbar-default" id="navbar"> 
            <script type="text/javascript"> 
                try { ace.settings.check('navbar', 'fixed') } catch (e) { }  
            </script> 
 
            <div class="navbar-container" id="navbar-container"> 
                <div class="navbar-header pull-left"> 
                    <a href="#" class="navbar-brand"> 
                        <small> 
                            <i class="icon-leaf"></i> 
                             XiaoNao Admin  
                        </small> 
                    </a><!-- /.brand --> 
                </div><!-- /.navbar-header --> 
 
                <div class="navbar-header pull-right" role="navigation"> 
                    <ul class="nav ace-nav"> 
                        <li class="green"> 
                            <a data-toggle="dropdown" class="dropdown-toggle" href="#"> 
                                <i class="icon-envelope icon-animated-vertical"></i> 
                                <span class="badge badge-success">5</span> 
                            </a> 
 
                            <ul class="pull-right dropdown-navbar dropdown-menu dropdown-caret dropdown-close"> 
                                <li class="dropdown-header"> 
                                    <i class="icon-envelope-alt"></i> 
Messages  
                                </li> 
 
                                <li> 
                                    <a href="#">   
                                        <img src="~/Content/avatars/avatar.png" class="msg-photo" alt="Alex's Avatar" /> 
                                        <span class="msg-body"> 
                                            <span class="msg-title"> 
                                                <span class="blue">Alex:</span> 
                                                Ciao sociis natoque penatibus et auctor ...  
                                            </span> 
 
                                            <span class="msg-time"> 
                                                <i class="icon-time"></i> 
                                                <span>a moment ago</span> 
                                            </span> 
                                        </span> 
                                    </a> 
                                </li> 
 
                                <li> 
                                    <a href="#"> 
                                        <img src="~/Content/avatars/avatar3.png" class="msg-photo" alt="Susan's Avatar" /> 
                                        <span class="msg-body"> 
                                            <span class="msg-title"> 
                                                <span class="blue">Susan:</span> 
                                                Vestibulum id ligula porta felis euismod ...  
                                            </span> 
 
                                            <span class="msg-time"> 
                                                <i class="icon-time"></i> 
                                                <span>20 minutes ago</span> 
                                            </span> 
                                        </span> 
                                    </a> 
                                </li> 
 
                                <li> 
                                    <a href="#"> 
                                        <img src="~/Content/avatars/avatar4.png" class="msg-photo" alt="Bob's Avatar" /> 
                                        <span class="msg-body"> 
                                            <span class="msg-title"> 
                                                <span class="blue">Bob:</span> 
                                                Nullam quis risus eget urna mollis ornare ...  
                                            </span> 
 
                                            <span class="msg-time"> 
                                                <i class="icon-time"></i> 
                                                <span>3:15 pm</span> 
                                            </span> 
                                        </span> 
                                    </a> 
                                </li> 
 
                                <li> 
                                    <a href="#"> 
                                        See all messages  
                                        <i class="icon-arrow-right"></i> 
                                    </a> 
                                </li> 
                            </ul> 
                        </li> 
 
                        <li class="light-blue"> 
                            <a data-toggle="dropdown" href="#" class="dropdown-toggle"> 
                                <img class="nav-user-photo" src="~/Content/avatars/user.jpg" alt="Jason's Photo" /> 
                                <span class="user-info"> 
                                    @if( Session["uname"]!=null){  
                                    <small>Welcome,</small> 
                                     @Session["uname"].ToString();  
                                    }  
                                </span> 
 
                                <i class="icon-caret-down"></i> 
                            </a> 
 
                            <ul class="user-menu pull-right dropdown-menu dropdown-yellow dropdown-caret dropdown-close"> 
                                <li> 
                                    <a href="#"> 
                                        <i class="icon-cog"></i> 
                                        Settings  
                                    </a> 
                                </li> 
                                <li> 
                                    <a href="#"> 
                                        <i class="icon-user"></i> 
                                        Profile  
                                    </a> 
                                </li> 
 
                                <li class="divider"></li> 
 
                                <li> 
                                    <a href="@Url.Action("LogOff","User")"> 
                                        <i class="icon-off"></i> 
                                        Logout  
                                    </a> 
                                </li> 
                            </ul> 
                        </li> 
                    </ul><!-- /.ace-nav --> 
                </div><!-- /.navbar-header --> 
            </div><!-- /.container --> 
        </div> 
 
        <div class="main-container" id="main-container"> 
            <script type="text/javascript"> 
                try { ace.settings.check('main-container', 'fixed') } catch (e) { }  
            </script> 
 
            <div class="main-container-inner"> 
                <a class="menu-toggler" id="menu-toggler" href="#"> 
                    <span class="menu-text"></span> 
                </a> 
 
                <div class="sidebar" id="sidebar"> 
                    <script type="text/javascript"> 
                        try { ace.settings.check('sidebar', 'fixed') } catch (e) { }  
                    </script> 
 
                    <div class="sidebar-shortcuts" id="sidebar-shortcuts"> 
                        <div class="sidebar-shortcuts-large" id="sidebar-shortcuts-large"> 
                            <button class="btn btn-success"> 
                                <i class="icon-signal"></i> 
                            </button> 
 
                            <button class="btn btn-info"> 
                                <i class="icon-pencil"></i> 
                            </button> 
 
                            <button class="btn btn-warning"> 
                                <i class="icon-group"></i> 
                            </button> 
 
                            <button class="btn btn-danger"> 
                                <i class="icon-cogs"></i> 
                            </button> 
                        </div> 
 
                        <div class="sidebar-shortcuts-mini" id="sidebar-shortcuts-mini"> 
                            <span class="btn btn-success"></span> 
 
                            <span class="btn btn-info"></span> 
 
                            <span class="btn btn-warning"></span> 
 
                            <span class="btn btn-danger"></span> 
                        </div> 
                    </div> 
                      
                    <!-- #sidebar-shortcuts --> 
 
                    <ul class="nav nav-list"> 
                        <li class="active"> 
                            <a href="@Url.Action("Index","Admin")"> 
                                <i class="icon-dashboard"></i> 
                                <span class="menu-text"> 控制台 </span> 
                            </a> 
                        </li> 
 
                        <li> 
                            <a href="#" class="dropdown-toggle"> 
                                <i class="icon-list"></i> 
                                <span class="menu-text"> 产品 </span> 
 
                                <b class="arrow icon-angle-down"></b> 
                            </a> 
 
                            <ul class="submenu"> 
                                <li> 
                                    <a href="@Url.Action("Index","Product")"> 
                                        <i class="icon-double-angle-right"></i> 
                                         产品管理  
                                    </a> 
                                </li> 
 
                                <li> 
                                    <a href="@Url.Action("CategoryList","Product")"> 
                                        <i class="icon-double-angle-right"></i> 
                                        分类管理  
                                    </a> 
                                </li> 
                            </ul> 
                        </li> 
                          
                            <li> 
                            <a href="#" class="dropdown-toggle"> 
                                <i class="icon-desktop"></i> 
                                <span class="menu-text"> 用户 </span> 
 
                                <b class="arrow icon-angle-down"></b> 
                            </a> 
 
                            <ul class="submenu"> 
                                <li> 
                                    <a href="@Url.Action("Index","User")"> 
                                        <i class="icon-double-angle-right"></i> 
                                        用户管理  
                                    </a> 
                                </li> 
                                <li> 
                                    <a href="@Url.Action("EditInfo","User")"> 
                                        <i class="icon-double-angle-right"></i> 
                                        个人设置  
                                    </a> 
                                </li> 
                            </ul> 
                        </li> 
                   
                    </ul><!-- /.nav-list --> 
 
                    <div class="sidebar-collapse" id="sidebar-collapse"> 
                        <i class="icon-double-angle-left" data-icon1="icon-double-angle-left" data-icon2="icon-double-angle-right"></i> 
                    </div> 
 
                    <script type="text/javascript"> 
                        try { ace.settings.check('sidebar', 'collapsed') } catch (e) { }  
                    </script> 
                </div> 
 
                <div class="main-content"> 
                    <div class="breadcrumbs" id="breadcrumbs"> 
                        <script type="text/javascript"> 
                            try { ace.settings.check('breadcrumbs', 'fixed') } catch (e) { }  
                        </script> 
 
                        <ul class="breadcrumb"> 
                            <li> 
                                <i class="icon-home home-icon"></i> 
                                <a href="@Url.Action("Index","Admin")">Home</a> 
                            </li> 
                            <li id="currentpart" class="active">控制台</li> 
                        </ul><!-- .breadcrumb --> 
 
                        <div class="nav-search" id="nav-search"> 
                            <form class="form-search"> 
                                <span class="input-icon"> 
                                    <input type="text" placeholder="Search ..." class="nav-search-input" id="nav-search-input" autocomplete="off" /> 
                                    <i class="icon-search nav-search-icon"></i> 
                                </span> 
                            </form> 
                        </div><!-- #nav-search --> 
                    </div> 
 
                    <div class="page-content"> 
                        <div class="page-header"> 
                            <h1> 
                                <span>控制台</span> 
                                <small> 
                                    <i class="icon-double-angle-right"></i> 
                                    <span>查看</span> 
                                </small> 
                            </h1> 
                        </div><!-- /.page-header --> 
 
                        <div class="row"> 
                            <div class="col-xs-12"> 
                                <!-- PAGE CONTENT BEGINS --> 
                                 @RenderBody()  
                                <!-- PAGE CONTENT ENDS --> 
                            </div><!-- /.col --> 
                        </div><!-- /.row --> 
                    </div><!-- /.page-content --> 
                </div><!-- /.main-content --> 
 
                <div class="ace-settings-container" id="ace-settings-container"> 
                    <div class="btn btn-app btn-xs btn-warning ace-settings-btn" id="ace-settings-btn"> 
                        <i class="icon-cog bigger-150"></i> 
                    </div> 
 
                    <div class="ace-settings-box" id="ace-settings-box"> 
                        <div> 
                            <div class="pull-left"> 
                                <select id="skin-colorpicker" class="hide"> 
                                    <option data-skin="default" value="#438EB9">#438EB9</option> 
                                    <option data-skin="skin-1" value="#222A2D">#222A2D</option> 
                                    <option data-skin="skin-2" value="#C6487E">#C6487E</option> 
                                    <option data-skin="skin-3" value="#D0D0D0">#D0D0D0</option> 
                                </select> 
                            </div> 
                            <span>&nbsp; Choose Skin</span> 
                        </div> 
 
                        <div> 
                            <input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-navbar" /> 
                            <label class="lbl" for="ace-settings-navbar"> Fixed Navbar</label> 
                        </div> 
 
                        <div> 
                            <input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-sidebar" /> 
                            <label class="lbl" for="ace-settings-sidebar"> Fixed Sidebar</label> 
                        </div> 
 
                        <div> 
                            <input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-breadcrumbs" /> 
                            <label class="lbl" for="ace-settings-breadcrumbs"> Fixed Breadcrumbs</label> 
                        </div> 
 
                        <div> 
                            <input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-rtl" /> 
                            <label class="lbl" for="ace-settings-rtl"> Right To Left (rtl)</label> 
                        </div> 
 
                        <div> 
                            <input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-add-container" /> 
                            <label class="lbl" for="ace-settings-add-container"> 
                                Inside  
                                <b>.container</b> 
                            </label> 
                        </div> 
                    </div> 
                </div><!-- /#ace-settings-container --> 
            </div><!-- /.main-container-inner --> 
 
            <a href="#" id="btn-scroll-up" class="btn-scroll-up btn btn-sm btn-inverse"> 
                <i class="icon-double-angle-up icon-only bigger-110"></i> 
            </a> 
        </div><!-- /.main-container --> 
 
        <!-- basic scripts --> 
 
        <!--[if !IE]> 
 
        <script src="http://ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script> 
 
        <![endif]-->    
 
        <!--[if IE]> 
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> 
<![endif]--> 
 
        <!--[if IE]> 
<script type="text/javascript"> 
 window.jQuery || document.write("<script src='~/Content/Js/jquery-1.10.2.min.js'>"+"<"+"/script>");  
</script> 
<![endif]--> 
 
        <script type="text/javascript"> 
            if ("ontouchend" in document) document.write("<script src='~/Content/Js/jquery.mobile.custom.min.js'>" + "<" + "/script>");  
        </script> 
        <script src="~/Content/Js/bootstrap.min.js"></script> 
        <script src="~/Content/Js/typeahead-bs2.min.js"></script> 
 
        <!-- page specific plugin scripts --> 
 
        <script src="~/Content/Js/jquery-ui-1.10.3.custom.min.js"></script> 
        <script src="~/Content/Js/jquery.ui.touch-punch.min.js"></script> 
        <script src="~/Content/Js/bootbox.min.js"></script> 
 
        <!-- ace scripts --> 
 
        <script src="~/Content/Js/ace-elements.min.js"></script> 
        <script src="~/Content/Js/ace.min.js"></script> 
 
        <!-- inline scripts related to this page --> 
 
        <script type="text/javascript"> 
            jQuery(function ($) {  
 
                /* initialize the external events  
                    -----------------------------------------------------------------*/  
 
                $('#external-events div.external-event').each(function () {  
 
                    // create an Event Object (http://arshaw.com/fullcalendar/docs/event_data/Event_Object/)  
                    // it doesn't need to have a start or end  
                    var eventObject = {  
                        title: $.trim($(this).text()) // use the element's text as the event title  
                    };  
 
                    // store the Event Object in the DOM element so we can get to it later  
                    $(this).data('eventObject', eventObject);  
 
                    // make the event draggable using jQuery UI  
                    $(this).draggable({  
                        zIndex: 999,  
                        revert: true,      // will cause the event to go back to its  
                        revertDuration: 0  //  original position after the drag  
                    });  
 
                });  
 
                /* initialize the calendar  
                -----------------------------------------------------------------*/  
            })  
        </script> 
    <div style="display:none"><script src='http://v7.cnzz.com/stat.php?id=155540&web_id=155540' language='JavaScript' charset='gb2312'></script></div> 
    <script src="~/Content/Js/niqiu.js"></script> 
     @RenderSection("scripts", required: false)  
   
</body></html>

#p#

二、引入Jqgrid

如果你的表格比较多，建议你做一个分部试图，重复利用，我的partview JqgridInit.cshtml 如下，

<link rel="stylesheet" href="~/Content/CSS/ui.jqgrid.css" /> 
<script src="~/Content/Js/jqGrid/jquery.jqGrid.min.js"></script> 
<script src="~/Content/Js/jqGrid/i18n/grid.locale-en.js"></script> 
<style> 
    #pager2 {  
        height: 40px;  
    }  
 
    .FormGrid ,#DelTb1_list2{  
        position: relative;  
        overflow: visible;  
        float: left;  
    }  
   .ui-jqgrid-sortable {  
       height: 30px !important;          
   }   
</style> 
<table id="list"></table> 
<div id="pager"></div> 
<span class="errorinfo"></span>

list用来呈现数据，pager用来分页，errorinfo用来提示错误。jqgrid，涉及的配置比较多。需要后台代码的全面的支持，所以在介绍配置之前，先介绍下模型和仓库。

1.Product：我们需要呈现的一个是一个产品，有很多不同的价格及其他，这些都将成为表格的列名。

public class Product  
    {  
        /// <summary>  
        /// Gets or sets the id.  
        /// </summary>  
        /// <value>The id.</value>  
        [Key]  
        public int ProductId { get; set; }  
 
        /// <summary>  
        /// 直接做型号处理  
        /// </summary>  
        public string ProductName { get; set; }  
        /// <summary>  
        /// Gets or sets the category.  
        /// </summary>  
        /// <value>The category.</value>  
        public string Category { get; set; }  
 
        /// <summary>  
        /// Gets or sets the brand.  
        /// </summary>  
        /// <value>The brand.</value>  
        public string Brand { get; set; }  
 
        public string Size { get; set; }  
 
        /// <summary>  
        /// Gets or sets the 规格.  
        /// </summary>  
        /// <value>The standard.</value>  
        public string Standard { get; set; }  
 
        /// <summary>  
        /// 专柜  
        /// </summary>  
        public decimal ZhuanGui { get; set; }  
 
        /// <summary>  
        /// Gets or sets the 莎莎 price.  
        /// </summary>  
        /// <value>The sa sa price.</value>  
        public decimal SaSaPrice { get; set; }  
 
        /// <summary>  
        /// Gets or sets the 卓越 price.  
        /// </summary>  
        /// <value>The zhuoyue price.</value>  
        public decimal ZhuoyuePrice { get; set; }  
        /// <summary>  
        /// Gets or sets the 卡莱美 price.  
        /// </summary>  
        /// <value>The ka lai price.</value>  
        public decimal KaLaiPrice { get; set; }  
 
        /// <summary>  
        /// 雅施  
        /// </summary>  
        public decimal YaShi { get; set; }  
 
        /// <summary>  
        /// Gets or sets the 万宁 price.  
        /// </summary>  
        /// <value>The wanning price.</value>  
        public decimal WanningPrice { get; set; }  
        /// <summary>  
        /// Gets or sets the 屈臣氏 price.  
        /// </summary>  
        /// <value>The quchengshi price.</value>  
        public decimal QuchengshiPrice { get; set; }  
        /// <summary>  
        /// Gets or sets the 药店 price.  
        /// </summary>  
        /// <value>The drugstore price.</value>  
        public decimal DrugstorePrice { get; set; }  
 
        /// <summary>  
        /// Gets or sets the others.  
        /// </summary>  
        /// <value>The others.</value>  
        public string Others { get; set; }  
 
        /// <summary>  
        /// Gets or sets the create time.  
        /// </summary>  
        /// <value>The create time.</value>  
        public DateTime CreateTime { get; set; }  
 
        public string ImgUrl { get; set; }  
 
        public Product()  
        {  
            CreateTime = DateTime.Now;  
        }  
    }

2.ProductRepository (仓库真的很好，独立了业务逻辑，可测试，复用快)，add、remove、update不用讲了，主要讲一讲排序。

1）排序查询的意义在于根据不同的属性进行排序。

public class ProductRepository:IProductRepository  
    {  
        private readonly XNDb _db = new XNDb();  
        //....  
        public IEnumerable<Product> Find(string sort = "asc", string property = "ProductName", int skip = 0, int take = 10)  
        {  
            var propertyInfo = typeof(Product).GetProperty(property);//反射出这个属性  
            Func<Product, object> expn = e => propertyInfo.GetValue(e, null);//委托  
            var rawpros = _db.Products;  
            IEnumerable<Product> pros = sort == "asc" ? rawpros.OrderBy(expn).Skip(skip).Take(take).ToArray()  
                : rawpros.OrderByDescending(expn).Skip(skip).Take(take).ToArray();//分页排序  
            return pros;  
        }  
        //....  
}

在只考虑排序的情况下，控制器的代码就相对简单：

public JsonResult GetAllPros( string sord = "asc", string sidx = "ProductName",int page = 1,  int rows = 10)  
        {  
            var pros = _repository.Find(sord, switchSidx(sidx), (page - 1) * rows, rows);  
            var objpros = new List<object>(pros);  
            var jsonData = JqGridModel.GridData(page, rows, _repository.Count, objpros);  
            return Json(jsonData, JsonRequestBehavior.AllowGet);  
        }

如果涉及到复杂些的查询，等于不等于，包含之类的，会多了后面mark部分的参数，这里我用很笨的办法实现了单列查询，也就就是根据包含、等于、不等于先查出来，再排序，如果是多重查询，大家可以参考博客：http://www.codeproject.com/Articles/58357/Using-jqGrid-s-search-toolbar-with-multiple-filter

public JsonResult GetAllPros( string sord = "asc", string sidx = "ProductName",int page = 1,   
            int rows = 10, bool _search = false,string searchField="", string searchOper="", string searchString="")  
        {  
 
            var rawpros = GetRawPros(_search, searchField, searchOper, searchString);  
            var propertyInfo = typeof(Product).GetProperty(switchSidx(sidx));  
            Func<Product, object> expn = e => propertyInfo.GetValue(e, null);  
 
            var enumerable = rawpros as Product[] ?? rawpros.ToArray();  
            IEnumerable<Product> pros = sord == "asc" ? enumerable.OrderBy(expn).Skip((page - 1) * rows).Take(rows).ToArray()  
                : enumerable.OrderByDescending(expn).Skip((page - 1) * rows).Take(rows).ToArray();  
 
            var objpros = new List<object>(pros);  
            var jsonData = JqGridModel.GridData(page, rows, enumerable.Count(), objpros);  
            return Json(jsonData, JsonRequestBehavior.AllowGet);  
        }

需要说明的是，这里的switchsidx就是将中文列名转为对象属性名，一堆case语句，然后JqgridModel的getdata，是jqgrid定义好的一种json格式，包含了每页行数和总页数等信息，因为前段的每页行数是可以变化的。

public class JqGridModel  
    {  
        /// <summary>  
        /// Grids the data.  
        /// </summary>  
        /// <param name="page1">当前页数.</param>  
        /// <param name="rows">每页显示数目.</param>  
        /// <param name="total"></param>  
        /// <param name="objects">集合对象</param>  
        /// <returns>System.Object.</returns>  
        public static object GridData(int page1, int rows, int total, IEnumerable<object> objects)  
        {  
            int pageSize = rows;  
            var totalPages = (int)Math.Ceiling((float)total / pageSize);  
 
            //可根据具体情况，实现排序。  
            var jsonData = new 
            {  
                total = totalPages,  
                page = page1,  
                records = total,  
                rows = objects.ToArray()  
            };  
 
            return jsonData;  
        }  
 
    }

2）需要一个新增：（记住返回json的时候要allowGet，不然可能造成添加失败，其他地方同理）

[HttpPost]  
        public ActionResult Create(Product product)  
        {  
            _repository.Add(product);  
            var fu = _repository.FindByName(product.ProductName);  
            return Json(fu, JsonRequestBehavior.AllowGet);  
        }

3）编辑和删除：这里的编辑有三个参数，一个对象，一个操作，一个id，id是个鸡肋，居然返回的是table的行号(会随着排序变化)，oper可能是add，del，这里我只用到了edit，del传回的id尝试改变它为对象的id，但没成功。用了因外一种方式实现删除。

[HttpPost]  
        public ActionResult Edit(Product pro, string oper, int id)  
        {  
            if (oper == "edit")  
            {  
                _repository.Update(pro);  
                pro.CreateTime = DateTime.Now;  
            }  
            return Json(pro, JsonRequestBehavior.AllowGet);  
        }  
 
       [HttpPost]  
       public ActionResult Delete(int id)  
       {  
        _repository.Remove(id);  
         return Json(id, JsonRequestBehavior.AllowGet); ;  
         }

有了这四个方法就ok了。下面来讲配置。先打个预防针，主要关心两个方法，一个设置table，一个设置分页。然后代码比较长..... 希望没有打消你驾驭它的渴望。

全部控制器代码：包含了分类的一些，道理一样

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Linq.Expressions;  
using System.Text;  
using System.Web;  
using System.Web.Mvc;  
using XNManage.Common;  
using XNManage.Models;  
using XNManage.Repository;  
using XNManage.ViewModel;  
 
namespace XNManage.Controllers  
{  
    public class ProductController : Controller  
    {  
        //  
        // GET: /Product/  
        private readonly IProductRepository _repository;  
 
        private IEnumerable<CategoryViewModel> _categoryViewModels = new List<CategoryViewModel>();   
 
 
        public ProductController(IProductRepository repository)  
        {  
            _repository = repository;  
        }  
 
        #region 产品  
 
        [LoginValid]  
        public ActionResult Index()  
        {  
            //CategoryInit();  
            //ProductsInits();  
            return View();  
        }  
 
 
        public JsonResult GetAllPros( string sord = "asc", string sidx = "ProductName",int page = 1,   
            int rows = 10, bool _search = false,string searchField="", string searchOper="", string searchString="")  
        {  
 
            var rawpros = GetRawPros(_search, searchField, searchOper, searchString);  
            var propertyInfo = typeof(Product).GetProperty(switchSidx(sidx));  
            Func<Product, object> expn = e => propertyInfo.GetValue(e, null);  
 
            var enumerable = rawpros as Product[] ?? rawpros.ToArray();  
            IEnumerable<Product> pros = sord == "asc" ? enumerable.OrderBy(expn).Skip((page - 1) * rows).Take(rows).ToArray()  
                : enumerable.OrderByDescending(expn).Skip((page - 1) * rows).Take(rows).ToArray();  
 
            var objpros = new List<object>(pros);  
            var jsonData = JqGridModel.GridData(page, rows, enumerable.Count(), objpros);  
            return Json(jsonData, JsonRequestBehavior.AllowGet);  
        }  
 
        private IEnumerable<Product> GetRawPros(bool search = false, string searchField = "", string searchOper = "", string searchString = "")  
        {  
            var rawpros = _repository.FindAll();  
            if (!search) return rawpros;  
 
            switch (switchSidx(searchField))  
            {  
                case "ProductName":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.ProductName.Contains(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.ProductName == searchString);  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.ProductName != searchString);  
                            break;  
                        default:  
                            rawpros = rawpros.Where(n => n.ProductName.Contains(searchString));  
                            break;  
                    }  
                    break;  
 
                case "Category":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.Category.Contains(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.Category == searchString);  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.Category != searchString);  
                            break;  
                        default:  
                            rawpros = rawpros.Where(n => n.Category.Contains(searchString));  
                            break;  
                    }  
                    break;  
                case "Brand":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.Brand.Contains(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.Brand == searchString);  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.Brand != searchString);  
                            break;  
                        default:  
                            rawpros = rawpros.Where(n => n.Brand.Contains(searchString));  
                            break;  
                    }  
                    break;  
                case "SaSaPrice":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.SaSaPrice >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.SaSaPrice == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.SaSaPrice != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
                case "ZhuanGui":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.ZhuanGui >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.ZhuanGui == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.ZhuanGui != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
                case "YaShi":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.YaShi >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.YaShi == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.YaShi != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
                case "ZhuoyuePrice":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.ZhuoyuePrice >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.ZhuoyuePrice == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.ZhuoyuePrice != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
                case "WanningPrice":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.WanningPrice >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.WanningPrice == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.WanningPrice != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
                case "QuchengshiPrice":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.QuchengshiPrice >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.QuchengshiPrice == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.QuchengshiPrice != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
                case "DrugstorePrice":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.DrugstorePrice >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.DrugstorePrice == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.DrugstorePrice != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
                case "Others":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.Others.Contains(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.Others ==searchString);  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.Others !=searchString);  
                            break;  
                    }  
                    break;  
                case "KaLaiPrice":  
                    switch (searchOper)  
                    {  
                        case "cn":  
                            rawpros = rawpros.Where(n => n.KaLaiPrice >= Convert.ToDecimal(searchString));  
                            break;  
                        case "eq":  
                            rawpros = rawpros.Where(n => n.KaLaiPrice == Convert.ToDecimal(searchString));  
                            break;  
                        case "ne":  
                            rawpros = rawpros.Where(n => n.KaLaiPrice != Convert.ToDecimal(searchString));  
                            break;  
                    }  
                    break;  
 
                default:  
                    break;  
            }  
 
            return rawpros;  
        }   
 
 
        /*  
        public JsonResult GetData(GridSettings grid)  
        {  
 
            var query = _repository.FindAll();  
 
            //filtring  
            if (grid.IsSearch)  
            {  
                //And  
                if (grid.Where.groupOp == "AND")  
                    foreach (var rule in grid.Where.rules)  
                        query = query.Where<Product>(  
                            rule.field, rule.data,  
                            (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));  
                else  
                {  
                    //Or  
                    var temp = (new List<Product>()).AsQueryable();  
                    foreach (var rule in grid.Where.rules)  
                    {  
                        var t = query.Where<Product>(  
                        rule.field, rule.data,  
                        (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));  
                        temp = temp.Concat<Product>(t);  
                    }  
                    //remove repeating records  
                    query = temp.Distinct<Product>();  
                }  
            }  
 
            //sorting  
            query = query.OrderBy<Product>(grid.SortColumn,  
                grid.SortOrder);  
 
            //count  
            var count = query.Count();  
 
            //paging  
            var data = query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize).ToArray();  
 
            //converting in grid format  
            var result = new  
            {  
                total = (int)Math.Ceiling((double)count / grid.PageSize),  
                page = grid.PageIndex,  
                records = count,  
                rows = data.ToArray()  
            };  
 
            //convert to JSON and return to client  
            return Json(result, JsonRequestBehavior.AllowGet);  
 
        }  
        */ 
 
 
        //这个函数其实不必要！index中可以写英文。列名和index没有关系  
        private string switchSidx(string sidx)  
        {  
            switch (sidx)  
            {  
                case "型号":  
                    return "ProductName";  
                case "类别":  
                    return "Category";  
                case "品牌":  
                    return "Brand";  
                case "规格":  
                    return "Standard";  
                case "专柜":  
                    return "ZhuanGui";  
                case "莎莎":  
                    return "SaSaPrice";  
                case "雅施":  
                    return "YaShi";  
                case "卓越":  
                    return "ZhuoyuePrice";  
                case "卡莱美":  
                    return "KaLaiPrice";  
                case "万宁":  
                    return "WanningPrice";  
                case "屈臣氏":  
                    return "QuchengshiPrice";  
                case "药店":  
                    return "DrugstorePrice";  
                case "其他":  
                    return "Others";  
                case "描述":  
                    return "Description";  
                case "更新时间":  
                    return "CreateTime";  
                default:  
                    return "ProductName";  
            }  
        }  
 
        public string CategorySelectList()  
        {  
            var cs = _repository.AllCategories();  
            var sb=new StringBuilder("<select>");  
 
            foreach (var category in cs)  
            {  
                sb.Append(string.Format("<option value='{0}' >{1}</option>", category.CategoryName, category.CategoryName));  
            }  
            sb.Append("</select>");  
            return sb.ToString();  
        }  
 
        [HttpPost]  
        public ActionResult Edit(Product pro, string oper, int id)  
        {  
            if (oper == "edit")  
            {  
                _repository.Update(pro);  
                pro.CreateTime = DateTime.Now;  
            }  
            return Json(pro, JsonRequestBehavior.AllowGet);  
        }  
 
        //  
        // POST: /Product/Create  
 
        [HttpPost]  
        public ActionResult Create(Product product)  
        {  
            _repository.Add(product);  
            var fu = _repository.FindByName(product.ProductName);  
            return Json(fu, JsonRequestBehavior.AllowGet);  
        }  
 
       
         
        //  
        // POST: /Product/Delete/5  
 
        [HttpPost]  
        public ActionResult Delete(int id)  
        {  
            _repository.Remove(id);  
            return Json(id);  
        }  
 
        private void CategoryInit()  
        {  
            if (!_repository.AllCategories().Any())  
            {  
                _repository.AddCategorie(new Category  
                {  
                    CategoryName = "护肤品",  
                    Description = "春天女生护肤专用" 
                });  
                _repository.AddCategorie(new Category()  
                {  
                    CategoryName = "防晒",  
                    Description = "夏日喷雾防晒" 
                }  
               );  
            }  
        }  
        private void ProductsInits()  
        {  
            if (!_repository.FindAll().Any())  
            {  
                _repository.Add(new Product()  
                {  
                    ProductName = "水宝宝",  
                    Others = "防晒",  
                    SaSaPrice = 78,  
                    DrugstorePrice = 98  
                });  
            }  
        }  
        #endregion   
 
        #region 分类  
 
        private IEnumerable<CategoryViewModel> initCategoryViewModels()  
        {  
            if (!_categoryViewModels.Any())  
            {  
                var cas = _repository.AllCategories();  
                _categoryViewModels = cas.Select(n => new CategoryViewModel()  
                {  
                    CategoryId = n.CategoryId,  
                    CategoryName = n.CategoryName,  
                    Description = n.Description,  
                    ProductCount = _repository.GetCategorieProducts(n.CategoryName).Count()  
                });  
            }  
            return _categoryViewModels;  
        }  
        public JsonResult GetAllCategorys(string sord = "asc", string sidx = "CategoryName", int page = 1, int rows = 10)  
        {  
            IList<object> pros = new List<object>(FindCategoryViewModels(sord, sidx, (page - 1) * rows, rows));  
            var jsonData = JqGridModel.GridData(page, rows, initCategoryViewModels().Count(), pros);  
            return Json(jsonData, JsonRequestBehavior.AllowGet);  
        }  
 
          
 
        public IEnumerable<CategoryViewModel> FindCategoryViewModels(string sort = "asc",  
            string property = "CategoryName", int skip = 0, int take = 10)  
        {  
            var propertyInfo = typeof(CategoryViewModel).GetProperty(property);  
            Func<CategoryViewModel, object> expn = e => propertyInfo.GetValue(e, null);  
            var fakeProfiles =initCategoryViewModels();  
            IEnumerable<CategoryViewModel> pros = sort == "asc" ? fakeProfiles.OrderBy(expn).Skip(skip).Take(take).ToArray()  
                : fakeProfiles.OrderByDescending(expn).Skip(skip).Take(take).ToArray();  
            return pros;  
        }  
 
        public ActionResult EditCategory(CategoryViewModel model,string oper, int id)  
        {  
            if (oper == "edit")  
            {  
                var ca = new Category()  
                {  
                    CategoryId = model.CategoryId,  
                    CategoryName = model.CategoryName,  
                    Description = model.Description,  
                };  
                _repository.UpdateCategorie(ca);  
            }  
            return Json(model, JsonRequestBehavior.AllowGet);  
        }  
 
        public ActionResult CategoryList()  
        {  
            return View();  
        }  
 
        [HttpPost]  
        public ActionResult CreateCategory(Category category)  
        {  
            _repository.AddCategorie(category);  
            var fu = _repository.FindCategorieById(category.CategoryId);  
 
            var cm = new CategoryViewModel()  
            {  
                CategoryName = fu.CategoryName,  
                CategoryId = fu.CategoryId,  
                Description = fu.Description,  
                ProductCount = _repository.GetCategorieProducts(fu.CategoryName).Count()  
            };  
 
            return Json(cm, JsonRequestBehavior.AllowGet);  
        }  
 
        public ActionResult DeletCategory(int id)  
        {  
            _repository.RemoveCategorie(id);  
            return Json(1);  
        }  
 
        public PartialViewResult JqgridInit()  
        {  
 
            return PartialView();  
        }  
 
        public JsonResult GetChartData()  
        {  
            var cms = initCategoryViewModels().ToList();  
            var count =_repository.Count;  
            var chartDatas = cms.Select(n => new ChartData  
            {  
                label = n.CategoryName,  
                data =  Math.Round((double)n.ProductCount / count, 3),  
            }).ToArray();  
            return Json(chartDatas, JsonRequestBehavior.AllowGet);  
        }  
 
        #endregion   
 
    }  
}

#p#

1）table的设置

jQuery("#list").jqGrid({  
        url: '/Product/GetAllPros', //获取数据源  
        datatype: "json",  
        colNames: ['操作', 'ProductId', '类别', '品牌', '型号', '规格', '专柜', '莎莎', '卓越', '卡莱美', '雅施', '万宁', '屈臣氏', '药店', '其他', '更新时间'], //定义列名   
        colModel: [ //name 是对应我们的Product模型的属性，Index可以为中文也可以为英文，不必于上面colnames对应，顺序对就行了。查询的时候传到后台的是index。  
            {  
                name: 'myac', index: '操作', width: 60, fixed: true, sortable: false, resize: false, formatter: 'actions', formatoptions: {  
                    keys: true,   
                    delOptions: { recreateForm: true, beforeShowForm: beforeDeleteCallback, },  
                }                  
            },  
           //详细的字段配置信息请见博客:http://www.cnblogs.com/huozhicheng/archive/2012/11/20/2778649.html   
           { name: 'ProductId', index: 'ProductId', hidden: true, editable: true },  
           { name: 'Category', index: '类别', editable: true, edittype: 'select', editoptions: { dataUrl: "/Product/CategorySelectList" }, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'Brand', index: '品牌', editable: true, editrules: { required: false }, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'ProductName', index: '型号', editable: true, editrules: { required: true }, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'Standard', index: '规格', editable: true, edittype: 'textarea', searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'ZhuanGui', index: '专柜', editable: true, width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },//formatter: 'integer',  formatter: 'integer',   
           { name: 'SaSaPrice', index: '莎莎', editable: true,width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'ZhuoyuePrice', index: '卓越', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'KaLaiPrice', index: '卡莱美', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'YaShi', index: '雅施', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'WanningPrice', index: '万宁', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'QuchengshiPrice', index: '屈臣氏', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'DrugstorePrice', index: '药店', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'Others', index: '其他', editable: true, edittype: 'textarea', searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            {  
                name: 'CreateTime', index: '更新时间', width: 200, formatter: 'date', //时间格式显示  
                formatoptions: { srcformat: 'Y-m-d H:i:s', newformat: 'Y-m-d H:i:s', searchoptions: { sopt: ['eq', 'ne', 'cn'] } }  
            }  
        ],  
        rowNum: 10,  
        rowList: [10, 20, 30],  
        sortorder: "asc",  
        pager: '#pager2',  
        sortname: 'ProductName',  
        viewrecords: true,  
        caption: "产品明细",  
        autowidth: true,  
        multiselect: true,  
        height: 180,  
        gridComplete: function () {  
            var icons = $(".ui-icon-trash");//隐藏删除键  
            icons.hide();//我隐藏了删除键 因为id的问题  
            //var ids = jQuery("#list2").jqGrid('getDataIDs');  
            //for (var i = 0; i < ids.length; i++) {  
            //    be = "<span class='ui-icon ui-icon-pencil'></span>";//修改  
            //    se = "<span class='ui-icon ui-icon-trash'></span>";//删除  
            //    ce = "<span class='icon-ok  ui-icon'></span>";//删除  
            //    jQuery("#list2").jqGrid('setRowData', ids[i], { act: be + se + ce });  
            //}  
             //这个部分是可以添加定义的按钮，自己用脚本去实现。  
 
        },  
        loadComplete: function () {  
            $("#grid-table").hide();  
            var table = this;  
            enableTooltips(table);  
            updatePagerIcons(table);  
        },  
 
        editurl: "/Product/Edit", //编辑的地址 操作栏触发的操作都会丢到这个action中响应。 add edit del  
        //改变传id的方法无效！！！！  
        serializeDelData: function (postdata) {  
            var rowdata = jQuery('#list2').getRowData(postdata.id);  
            return { id: postdata.id, oper: postdata.oper, user: rowdata };  
        }  
        //edit  del  
    });

形成样子如下：

[[115287]]

colModel涉及的配置较多，不同的字段有不同的呈现，可以参考博客 http://www.cnblogs.com/huozhicheng/archive/2012/11/20/2778649.html

2）pager 用来形成分页和集成一些操作。

jQuery("#list").jqGrid('navGrid', '#pager2', {  
             //调整ui 也就是我们看到的： ，但这个删除图标是我代码加上去的。  
            edit: true,  
            editicon: 'icon-pencil blue',  
            add: true,  
            addicon: 'icon-plus-sign purple',  
            del: false,  
            delicon: 'icon-trash red',  
            search: true,  
            searchicon: 'icon-search orange',  
            refresh: true,  
            refreshicon: 'icon-refresh green',  
            view: false,  
            viewicon: 'icon-zoom-in grey',  
        },  
        {  
            //eidt  
            url: '/Product/Edit', mtype: 'POST',  
            afterSubmit: function (xhr, postdata) {  
                var id = $("#list2").jqGrid('getGridParam', 'selrow');  
                jQuery("#list2").jqGrid('setRowData', id, postdata);  
            }, closeAfterEdit: true, closeOnEscape: true 
        },  
        {  
            //add  
            recreateForm: true,  
            url: '/Product/Create',  
            mtype: 'POST',  
            afterSubmit: function (xhr, postdata) {  
                var id = $("#list2").jqGrid('getGridParam', 'selrow');  
                jQuery("#list2").jqGrid('addRowData', postdata.Id, postdata);  
                return [true, 'successfule!', false];  
            }, closeAfterAdd: true 
        },  
        {  
            //delete 此处无效  
            recreateForm: true,  
            url: '/Product/Delete', mtype: 'POST',  
            beforeShowForm: function (e) {  
                var form = $(e[0]);  
                if (form.data('styled')) return false;  
                form.closest('.ui-jqdialog').find('.ui-jqdialog-titlebar').wrapInner('<div class="widget-header" />');  
                styleDeleteForm(form);  
                form.data('styled', true); return true;  
            },  
            afterSubmit: function (xhr, postdata) {  
                var consoleDlg = $("#list2");  
                var selectedRowIds =  
                    $("#list2").jqGrid("getGridParam", "selarrrow");  
                var len = selectedRowIds.length;  
                for (var i = 0; i < len ; i++) {  
                    $("#list2").jqGrid("delRowData", selectedRowIds[0]);  
                }  
            },  
 
            closeAfterDel: true 
 
        },  
        {  
            //search  
            recreateForm: true,  
            afterShowSearch: function(e){  
                var form = $(e[0]);  
                form.closest('.ui-jqdialog').find('.ui-jqdialog-title').wrap('<div class="widget-header" />')  
                styleSearchForm(form);  
            },  
            afterRedraw: function(){  
                styleSearchFilters($(this));  
            }  
                        ,  
           // multipleSearch: true,  
            closeAfterSearch: true 
 
         },  
        {  
            //view       
 
            }  
    );

在下面加入按钮的方法以及执行删除：jquery2.0中的绑定写法有些不同，也就是on的用法。

function updatePagerIcons() {  
 //...  
  var x = $("#pager2_left").find("#coco");  
        if (x.length == 0) {  
            $("#pager2_left table tbody>tr").prepend("<td class='ui-pg-button ui-corner-all' title data-original-title='Remove a row'><div id='coco'  class='ui-pg-div'>" +  
                "<span class='ui-icon icon-trash blue'></span></div></td>");  
        }  
 
}  
 //绑定事件 执行删除   
    $("#pager2_left table tbody>tr").on("click", '#coco', function () {  
        var selectedRowIds = $("#list2").jqGrid("getGridParam", "selarrrow");  
        var len = selectedRowIds.length;  
        if (len != 0) {  
            if (confirm("确定要删除选中项？")) {  
                for (var i = 0; i < len; i++) {  
                    var rowData = $("#list2").jqGrid('getRowData', selectedRowIds[i]);  
                    $.post('/Product/Delete', { id: rowData.ProductId }, function (data) {  
                        $("#list2").jqGrid("delRowData", selectedRowIds[0]);  
                    });  
                }  
            }  
        } else {  
            $.infoShow("未勾选", 0);  
        }  
    });

形成这个样子：

[[115288]]

全部前台代码：

@{  
    ViewBag.Title = "Index";  
    Layout = "~/Views/Shared/_Layout.cshtml";  
}  
@Html.Partial("JqgridInit")  
<script>  
    $(function () {  
    $(".page-header h1 span,#currentpart").html("产品");  
    $(".page-header h1 small span").html("产品管理");  
    $(".nav-list>li:eq(1)").addClass("active").siblings().removeClass("active");  
      
    jQuery("#list2").jqGrid({  
        url: '/Product/GetAllPros',  
        datatype: "json",  
        colNames: ['操作', 'ProductId', '类别', '品牌', '型号', '规格', '专柜', '莎莎', '卓越', '卡莱美', '雅施', '万宁', '屈臣氏', '药店', '其他', '更新时间'],  
        colModel: [  
            {  
                name: 'myac', index: '操作', width: 60, fixed: true, sortable: false, resize: false, formatter: 'actions', formatoptions: {  
                    keys: true,   
                    delOptions: { recreateForm: true, beforeShowForm: beforeDeleteCallback, },//改变原来的样式  msg: '您确定要删除这条记录？</span>  
                    searchoptions: { sopt: ['eq', 'ne', 'cn'] },  
                }  
                //    name: 'act', index: 'act', width: 75, sortable: false  
            },  
           { name: 'ProductId', index: 'ProductId', hidden: true, editable: true },  
           { name: 'Category', index: '类别', editable: true, edittype: 'select', editoptions: { dataUrl: "/Product/CategorySelectList" }, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'Brand', index: '品牌', editable: true, editrules: { required: false }, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'ProductName', index: '型号', editable: true, editrules: { required: true }, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'Standard', index: '规格', editable: true, edittype: 'textarea', searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
           { name: 'ZhuanGui', index: '专柜', editable: true, width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },//formatter: 'integer',  formatter: 'integer',   
           { name: 'SaSaPrice', index: '莎莎', editable: true,width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'ZhuoyuePrice', index: '卓越', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'KaLaiPrice', index: '卡莱美', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'YaShi', index: '雅施', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'WanningPrice', index: '万宁', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'QuchengshiPrice', index: '屈臣氏', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'DrugstorePrice', index: '药店', editable: true, formatter: 'integer', width: 60, searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            { name: 'Others', index: '其他', editable: true, edittype: 'textarea', searchoptions: { sopt: ['eq', 'ne', 'cn'] } },  
            {  
                name: 'CreateTime', index: '更新时间', width: 200, formatter: 'date',  
                formatoptions: { srcformat: 'Y-m-d H:i:s', newformat: 'Y-m-d H:i:s', searchoptions: { sopt: ['eq', 'ne', 'cn'] } }  
            }  
        ],  
        rowNum: 10,  
        rowList: [10, 20, 30],  
        sortorder: "asc",  
        pager: '#pager2',  
        sortname: 'ProductName',  
        viewrecords: true,  
        caption: "产品明细",  
        autowidth: true,  
        multiselect: true,  
        height: 180,  
        gridComplete: function () {  
            var icons = $(".ui-icon-trash");//隐藏删除键  
            icons.hide();  
            //var ids = jQuery("#list2").jqGrid('getDataIDs');  
            //for (var i = 0; i < ids.length; i++) {  
            //    be = "<span class='ui-icon ui-icon-pencil'></span>";//修改  
            //    se = "<span class='ui-icon ui-icon-trash'></span>";//删除  
            //    ce = "<span class='icon-ok  ui-icon'></span>";//删除  
            //    jQuery("#list2").jqGrid('setRowData', ids[i], { act: be + se + ce });  
            //}  
        },  
        loadComplete: function () {  
            $("#grid-table").hide();  
            var table = this;  
            enableTooltips(table);  
            updatePagerIcons(table);  
        },  
 
        editurl: "/Product/Edit",  
        //无效！！！！  
        serializeDelData: function (postdata) {  
            var rowdata = jQuery('#list2').getRowData(postdata.id);  
            return { id: postdata.id, oper: postdata.oper, user: rowdata };  
        }  
        //edit  del  
    });  
    jQuery("#list2").jqGrid('navGrid', '#pager2', {  
            edit: true,  
            editicon: 'icon-pencil blue',  
            add: true,  
            addicon: 'icon-plus-sign purple',  
            del: false,  
            delicon: 'icon-trash red',  
            search: true,  
            searchicon: 'icon-search orange',  
            refresh: true,  
            refreshicon: 'icon-refresh green',  
            view: false,  
            viewicon: 'icon-zoom-in grey',  
        },  
        {  
            //eidt  
            url: '/Product/Edit', mtype: 'POST',  
            afterSubmit: function (xhr, postdata) {  
                var id = $("#list2").jqGrid('getGridParam', 'selrow');  
                jQuery("#list2").jqGrid('setRowData', id, postdata);  
            }, closeAfterEdit: true, closeOnEscape: true 
        },  
        {  
            //add  
            recreateForm: true,  
            url: '/Product/Create',  
            mtype: 'POST',  
            afterSubmit: function (xhr, postdata) {  
                var id = $("#list2").jqGrid('getGridParam', 'selrow');  
                jQuery("#list2").jqGrid('addRowData', postdata.Id, postdata);  
                return [true, 'successfule!', false];  
            }, closeAfterAdd: true 
        },  
        {  
            //delete  
            recreateForm: true,  
            url: '/Product/Delete', mtype: 'POST',  
            beforeShowForm: function (e) {  
                var form = $(e[0]);  
                if (form.data('styled')) return false;  
                form.closest('.ui-jqdialog').find('.ui-jqdialog-titlebar').wrapInner('<div class="widget-header" />');  
                styleDeleteForm(form);  
                form.data('styled', true); return true;  
            },  
            afterSubmit: function (xhr, postdata) {  
                var consoleDlg = $("#list2");  
                var selectedRowIds =  
                    $("#list2").jqGrid("getGridParam", "selarrrow");  
                var len = selectedRowIds.length;  
                for (var i = 0; i < len ; i++) {  
                    $("#list2").jqGrid("delRowData", selectedRowIds[0]);  
                }  
            },  
 
            closeAfterDel: true 
 
        },  
        {  
            //search  
            recreateForm: true,  
            afterShowSearch: function(e){  
                var form = $(e[0]);  
                form.closest('.ui-jqdialog').find('.ui-jqdialog-title').wrap('<div class="widget-header" />')  
                styleSearchForm(form);  
            },  
            afterRedraw: function(){  
                styleSearchFilters($(this));  
            }  
                        ,  
           // multipleSearch: true,  
            closeAfterSearch: true 
 
         },  
        {  
            //view       
 
            }  
    );  
    //添加注释  
    function enableTooltips(table) {  
        $('.navtable .ui-pg-button').tooltip({ container: 'body' });  
        $(table).find('.ui-pg-div').tooltip({ container: 'body' });  
    }  
 
 
    function beforeDeleteCallback(e) {  
        var form = $(e[0]);  
        if (form.data('styled')) return false;  
        form.closest('.ui-jqdialog').find('.ui-jqdialog-titlebar').wrapInner('<div class="widget-header" />');  
        styleDeleteForm(form);  
        form.data('styled', true);  
        return true;  
    }  
 
 
    //修改 删除form的样式  
    function styleDeleteForm(form) {  
        var buttons = form.next().find('.EditButton .fm-button');  
        buttons.addClass('btn btn-sm').find('[class*="-icon"]').remove();//ui-icon, s-icon  
        buttons.eq(0).addClass('btn-danger').prepend('<i class="icon-trash"></i>');  
        buttons.eq(1).prepend('<i class="icon-remove"></i>');  
    }  
 
    //更新分页图标  
    function updatePagerIcons() {  
 
        var replacement =  
        {  
            'ui-icon-seek-first': 'icon-double-angle-left bigger-140',  
            'ui-icon-seek-prev': 'icon-angle-left bigger-140',  
            'ui-icon-seek-next': 'icon-angle-right bigger-140',  
            'ui-icon-seek-end': 'icon-double-angle-right bigger-140' 
        };  
        $('.ui-pg-table:not(.navtable) > tbody > tr > .ui-pg-button > .ui-icon').each(function () {  
            var icon = $(this);  
            var $class = $.trim(icon.attr('class').replace('ui-icon', ''));  
 
            if ($class in replacement) icon.attr('class', 'ui-icon ' + replacement[$class]);  
        });  
 
        var x = $("#pager2_left").find("#coco");  
        if (x.length == 0) {  
            $("#pager2_left table tbody>tr").prepend("<td class='ui-pg-button ui-corner-all' title data-original-title='Remove a row'><div id='coco'  class='ui-pg-div'>" +  
                "<span class='ui-icon icon-trash blue'></span></div></td>");  
        }  
    }  
 
    function styleSearchForm(form) {  
        var dialog = form.closest('.ui-jqdialog');  
        var buttons = dialog.find('.EditTable')  
        buttons.find('.EditButton a[id*="_reset"]').addClass('btn btn-sm btn-info').find('.ui-icon').attr('class', 'icon-retweet');  
        buttons.find('.EditButton a[id*="_query"]').addClass('btn btn-sm btn-inverse').find('.ui-icon').attr('class', 'icon-comment-alt');  
        buttons.find('.EditButton a[id*="_search"]').addClass('btn btn-sm btn-purple').find('.ui-icon').attr('class', 'icon-search');  
    }  
    function styleSearchFilters(form) {  
        form.find('.delete-rule').val('X');  
        form.find('.add-rule').addClass('btn btn-xs btn-primary');  
        form.find('.add-group').addClass('btn btn-xs btn-success');  
        form.find('.delete-group').addClass('btn btn-xs btn-danger');  
    }  
 
    //绑定事件 执行删除  
    $("#pager2_left table tbody>tr").on("click", '#coco', function () {  
        var selectedRowIds = $("#list2").jqGrid("getGridParam", "selarrrow");  
        var len = selectedRowIds.length;  
        if (len != 0) {  
            if (confirm("确定要删除选中项？")) {  
                for (var i = 0; i < len; i++) {  
                    var rowData = $("#list2").jqGrid('getRowData', selectedRowIds[i]);  
                    $.post('/Product/Delete', { id: rowData.ProductId }, function (data) {  
                        $("#list2").jqGrid("delRowData", selectedRowIds[0]);  
                    });  
                }  
            }  
        } else {  
            $.infoShow("未勾选", 0);  
        }  
    });  
    });  
</script>

至此基本告成，还有些可以优化。

如果本文对你有帮助，请霸气的支持下 :） tks~

需要源码的同学，请留邮箱。备注：数据库是EntityFramework + CE4.0，账户密码都是：admin

模板源码：http://pan.baidu.com/s/1gdEGg2v

参考博客：

参数设定 http://www.cnblogs.com/younggun/archive/2012/08/27/2657922.html

jqgridDemo：http://www.trirand.com/blog/jqgrid/jqgrid.html

多重查询：http://www.codeproject.com/Articles/58357/Using-jqGrid-s-search-toolbar-with-multiple-filter

其他后台模板：http://www.tystudio.net/2013/03/11/back-manage-system-template/

本文出自：http://www.cnblogs.com/stoneniqiu/p/3815028.html