asp.net MVC2 初探七

本节教你如何使用JQuery显示MVC数据。在这之前了解了解Json(张森)。前台代码

< %@ Page  Title ="" Language="C#"  MasterPageFile ="~/Views/Shared/Site.Master"  Inherits ="System.Web.Mvc.ViewPage" % > 

< asp:Content  ID ="Content1"  ContentPlaceHolderID ="TitleContent"  runat ="server" > 
        GridData 
</asp:Content> 
< asp:Content  ID ="Content3"  runat ="server"  ContentPlaceHolderID ="HeadContent" > 
        <link rel="stylesheet" type="text/css" href="../../Scripts/Themes/steel/grid.css" 
                title="green" media="screen" /> 
         < script  src ="../../Scripts/jquery-1.3.2.js"  type ="text/javascript" > </script> 
         < script  src ="../../Scripts/js/min/grid.locale-en-min.js"  type ="text/javascript" > </script> 
         < script  src ="../../Scripts/jquery.jqGrid.js"  type ="text/javascript" > </script> 
         < script  type ="text/javascript"  src ="../../Scripts/JS1/Common.js" > </script> 
         < script  type ="text/javascript" > 
                jQuery(document).ready(function () { 
                        jQuery("#list").jqGrid({ 
                                url: '/Movie/GridData', 
                                datatype: 'json', 
                                colNames: ['电影编号', '电影名称', '播放时间'], 
                                colModel: [ 
                                                    { name: 'Id', index: 'Id', width: 100, align: 'left', sorttype: "int" }, 
                                                    { name: 'Movie_Name', index: 'Movie_Name', width: 100, align: 'left' }, 
                                                    { name: 'Realease_Date', index: 'Realease_Date', width: 100, align: 'left'}], 
                                pager: jQuery('#pager'), 
                                rowNum: 10, 
                                rowList: [1, 2, 3], 
                                //autowidth: true,    
                                width: '500', 
                                sortname: 'Id', 
                                sortorder: 'desc', 
                                viewrecords: true, 
                                imgpath: '../../Scripts/themes/coffee/images', 
                                caption: '电影信息' 
                        }); 
                });    

         </script> 
</asp:Content> 
< asp:Content  ID ="Content2"  ContentPlaceHolderID ="MainContent"  runat ="server" > 
         < table  id ="list"  class ="scroll"  cellpadding ="0"  cellspacing ="0" > 
         </table> 
         < div  id ="pager"  class ="scroll"  style ="text-align: center;" > 
         </div> 
         < %: Html.ActionLink("跳转到主界面","Index") % > 
</asp:Content> 

这个页面通过向action请求数据，action返回Json格式数据，由Jqgrid显示数据。

action代码：

  public JsonResult GridData( string sidx,  string sord,  int page,  int rows) 
                { 
                        DataClasses1DataContext dc =  new DataClasses1DataContext(); 
                         int pageIndex = Convert.ToInt32(page) - 1; 
                         int pageSize = rows; 
                         int totalRecords = dc.Movies.Count(); 
                         int totalPages = ( int)Math.Ceiling(( float)totalRecords / ( float)pageSize); 
                        var orders = dc.Movies.OrderBy(sidx +  " " + sord).Skip(pageIndex * pageSize).Take(pageSize); 
                        var jsonData =  new 
                        { 
                                total = totalPages, 
                                page = page, 
                                records = totalRecords, 
                             
                                rows = ( 
                                         
                                        from order  in orders 
                                        select  new 
                                        { 
                                                cell =  new[] { order.ID.ToString(), order.Movie_Name.ToString(),    order.Realease_Date.ToString() } 
                                        }).ToArray() 
                                         
                        }; 
                         return Json(jsonData,JsonRequestBehavior.AllowGet); 
                }

返回的数据格式一定要和前台Json格式一致运行效果如下

本文转自 BruceAndLee 51CTO博客，原文链接：http://blog.51cto.com/leelei/323153，如需转载请自行联系原作者