ASP.NET MVC5 easyui 之 treegrid 初用记录

2023-01-24 12:08:55

菜鸟初次使用，参考论坛中介绍的方法仍走了一些弯路，把自己遇到的问题记录下来。

1.必须定义根节点；

2.根节点一个或多个均可；

4.根节点的父节点属性不必定义，或者定义为0；

5.各级子节点的父节点属性名称必须为“_parentId",不能用其它名称，此名称已在jquery.easyui.js中定义；

6.不必在后台ACTION中输出“树”形结构的json数据，只要下面结构的json给前台的treegrid，就可以建立树形输出到页面。（了解到后台以树形children格式输出也是一种选择。）

{"total":17,"rows":[
{"id":3,"goodsid":36120,"Qty":2.0000,"Rem":"15"},{"id":4,"goodsid":36123,"Qty":1.0000,"Rem":"21"},{"id":5,"goodsid":36124,"Qty":2.0000,"Rem":"23"},{"id":8,"goodsid":36130,"Qty":1.0000,"Rem":"1"},{"id":9,"goodsid":36131,"Qty":1.0000,"Rem":"2"},{"id":10,"goodsid":36132,"Qty":1.0000,"Rem":"3"},{"id":11,"goodsid":36133,"Qty":1.0000,"Rem":"4"},{"id":12,"goodsid":36134,"_parentId":8,"Qty":1.0000,"Rem":"1"},{"id":13,"goodsid":36135,"_parentId":8,"Qty":2.0000,"Rem":"2"},{"id":14,"goodsid":36136,"_parentId":8,"Qty":1.0000,"Rem":"3"},{"id":15,"goodsid":36137,"_parentId":8,"Qty":1.0000,"Rem":"4"},{"id":16,"goodsid":36138,"_parentId":8,"Qty":3.0000,"Rem":"5"},{"id":17,"goodsid":36139,"_parentId":8,"Qty":1.0000,"Rem":"6"},{"id":18,"goodsid":36142,"_parentId":9,"Qty":1.0000,"Rem":"1"},{"id":19,"goodsid":36143,"_parentId":9,"Qty":1.0000,"Rem":"2"},{"id":20,"goodsid":36144,"_parentId":9,"Qty":1.0000,"Rem":"3"},{"id":21,"goodsid":36145,"_parentId":9,"Qty":1.0000,"Rem":"4"}
]}

这是Controllers

var pls = ListAll(p.PartChild).ToList();

            List<Object> result = new List<object>();

            foreach(var item in pls)

            {

                if(item.PartParent == p.PartChild)

                {

                    result.Add( new { id = item.ListID, goodsid = item.PartChild, Qty = item.Qty, Rem = item.Rem });

                    //下面是调用生成树形数据方法的语句,多余！easyui可根据parentID自动建树

                    //Object l = new { id = item.ListID, text = item.PartChild, _parentId = 0,Qty = item.Qty, Rem = item.Rem, chlidren = TreeList(pls, item.PartChild) };

                    //result.Add(l);

                }

                else

                {

                    var parent = from a in pls

                                 where a.PartChild == item.PartParent

                                 select a;

                    result.Add(new { id = item.ListID, goodsid = item.PartChild, _parentId = parent.First().ListID, Qty = item.Qty, Rem = item.Rem });

                }

            }

这是前台View

<div style="margin:20px 0;"></div>

<table title="Parts List" class="easyui-treegrid" style="height:250px" data-options="

            url:'/ContosoBISite/PartsList/JList/',

            method: 'get',

            nowrap: false,

                        rownumbers: true,

                        animate: true,

                        collapsible: true,

                        fitColumns: true,

            idField: 'id',

                        treeField: 'goodsid'

    ">

    <thead>

        <tr>

            <th data-options="field:'goodsid'" width="100">goodsid</th>

            <th data-options="field:'id'" width="100">ListID</th>

            <th data-options="field:'ListVer'" width="100" align="right">ListVer</th>

            <th data-options="field:'ParentName'" width="100">ParentName</th>

            <th data-options="field:'Qty'" width="50">Qty</th>

            <th data-options="field:'Rem'" width="50">Rem</th>

            <th data-options="field:'_parentId'" width="50">parent</th>

        </tr>

    </thead>

</table>

JS版本：jquery.easyui-1.4.3.min.js；jquery-1.11.3.min.js

参考博客：http://www.cnblogs.com/mikel/archive/2011/10/29/2228671.html

补充一：showFooter

如果需要启用表格的统计、备注等功能，需要在View的<table>标签的data-options

内设置showFooter属性。格式：showFooter: true

后台输出的json应增加“footer"对象。格式：

{"total":21,"rows":[{{"id":1,"name":"tes1","Qty":1.0000},{"id":2,"name":"test2","Qty":1.0000},...],"footer":[{"name":"合计","Qty":23}]}

name和Qty与json传递的表列名一致。

补充二:自定义参数的传递

<table id="tg" title="Parts List" class="easyui-treegrid" data-options="

       url:'/ContosoBISite/PartsList/JList/',

       iconCls: 'icon-edit',

       toolbar: '#tb',

       method: 'get',

       lines: true,

       nowrap: false,

       rownumbers: true,

       animate: true,

       collapsible: true,

       fitColumns: true,

       idField: 'id',

       treeField: 'name',

       showFooter: true,

       queryParams: {'gid': '@Model.GoodsID'}

    ">

在前台定义,见最后一行.格式:queryParams: {'参数名': '参数值'}. (@Model.GoodsID是ASP.NET MVC5的Razor表达式,值为一个常量)

后台使用该参数只需要定义一个同名的变量即可,不要赋值.

补充三:搜索功能(datagrid)

前台View

添加工具栏:toolbar

<table id="dg" title="Goods List" class="easyui-datagrid" height="" data-options="

       url:'/ContosoBISite/Goods/List/',

       iconCls: 'icon-ok',

       toolbar: '#tb', //添加工具栏

       method: 'get',

       lines: true,

       nowrap: false,

       rownumbers: true,

       animate: true,

       collapsible: true,

       idField: 'GoodsID',

       showFooter: true,

       striped: true, //奇偶行是否区分

       fitColumns: true, //自适表大小

       pagination: true,

       pageNumber: ,

       pageSize: ,

       pageList: [,,,]

       ">

    <thead>

        <tr>

            <th data-options="field:'Name'" width="" sortable="true">品名</th>

            <th data-options="field:'Code'" width="" sortable="true">编码</th>

            <th data-options="field:'Lift'" width="" sortable="true">使用时限(小时)</th>

            <th data-options="field:'Type'" width="" sortable="true">货品属性</th>

            <th data-options="field:'GoodsID'" width="">GoodsID</th>

        </tr>

    </thead>

</table>

View的工具栏js

<div id="tb" style="padding:3px">

    <script type="text/javascript">

        function qq(value) {

            $('#dg').datagrid('load', {"searchValue": value });

        }

    </script>

    <input id="ss" class="easyui-searchbox" style="width:200px"

           data-options="searcher:qq,prompt:'请输入查询内容'">

</div>

用chrome浏览器查看传递的参数:

后台Controllers接收前台传递的searchValue并处理.(LoadPageItems(pageSize, pageIndex, goods, sort, order)函数用于处理分页和排序,有可能后面再补充)

public JsonResult List()

        {

            db.Configuration.ProxyCreationEnabled = false;

            var pageIndex = int.Parse(Request["page"]);  //接收前台传递的当前页

            var pageSize = int.Parse(Request["rows"]);  //接收前台传递的页面行数

            var sort = Request["sort"];  //接收前台传递的排序的列名

            bool order = Request["order"] == "asc" ? false : true; //接收前台传递的Asc or Desc

            var searchValue = Request["searchValue"];  //接收前台传递的搜索值

            if(searchValue == null)  //搜索功能应该此函数内处理,如果放到上面的分页,排序函数里会导致TOTAL统计的行数错误(goods.Count)

            {

                var g = from a in db.Goods

                        select a;

                var goods = g.ToList();

                var result = LoadPageItems(pageSize, pageIndex, goods, sort, order);

                Dictionary<string, Object> json = new Dictionary<string, Object>();

                json.Add("total", goods.Count);

                json.Add("rows", result);

                return Json(json, JsonRequestBehavior.AllowGet);

            }

            else

            {

                var g = from a in db.Goods

                        where a.Code.Contains(searchValue) || a.Name.Contains(searchValue) || a.Type.Contains(searchValue)

                        select a;

                var goods = g.ToList();

                var result = LoadPageItems(pageSize, pageIndex, goods, sort, order);

                Dictionary<string, Object> json = new Dictionary<string, Object>();

                json.Add("total", goods.Count);

                json.Add("rows", result);

                return Json(json, JsonRequestBehavior.AllowGet);

            }

码农公寓

相关文章