easyui datagrid json扩展

来源：互联网发布：2017淘宝设备管理在哪编辑：程序博客网时间：2024/05/06 18:21

如果使用mybatis association，那么封装对象后，返回到页面是json格式的，这种格式
在页面中显示出来，跟一下数组方式有很大区别，不过还好easyui loadFilter支持这种扩展
1 easyui json表格

function createDg(){    dgList=$('#dg').datagrid({        method: "post",url:ctx+'/smsHouseholdOrder/find', idField : 'id',singleSelect:true,    fit : true,fitColumns : false,border : false,striped:true,    pagination:true,rownumbers:true,pageNumber:1,pageSize : 20,pageList : [ 20, 30, 50 ],    columns:[[                                                {field:'smsHouseholdOrder.id',title:'ID',hidden:true}                                                ,{field:'smsHouseholdOrder.orderId',title:'订单号',sortable:true,width:100,align:'left',halign:'center' }                                                ,{field:'smsOrder.status',title:'状态',sortable:true,width:80,align:'left',halign:'center',formatter:fmtStatus }                                                ,{field:'smsOrder.appointmentTime',title:'预约服务时间',sortable:true,width:120,align:'left',halign:'center',formatter: DzmFrame.EasyUI.fmtDatetime}                                                ,{field:'smsOrder.memberName',title:'会员',sortable:true,width:100,align:'left',halign:'center' }                                                ,{field:'smsOrder.memberPhone',title:'会员手机号',sortable:true,width:100,align:'left',halign:'center' }                                                ,{field:'smsOrder.address',title:'服务地址',sortable:true,width:200,align:'left',halign:'center' }                                                ,{field:'smsHouseholdOrder.times',title:'服务时长',sortable:true,width:100,align:'right',halign:'center' }                                                ,{field:'smsHouseholdOrder.price',title:'单价',sortable:true,width:100,align:'right',halign:'center',formatter:DzmFrame.EasyUI.fmtMoney }                                                ,{field:'smsHouseholdOrder.discount',title:'折扣价',sortable:true,width:100,align:'right',halign:'center',formatter:DzmFrame.EasyUI.fmtMoney }                                                ,{field:'smsHouseholdOrder.amount',title:'金额',sortable:true,width:100,align:'right',halign:'center',formatter:DzmFrame.EasyUI.fmtMoney }                                                ,{field:'smsOrder.orderTime',title:'下单时间',sortable:true,width:120,align:'left',halign:'center',formatter: DzmFrame.EasyUI.fmtDatetime}                        ]],    sortName:'smsHouseholdOrder.orderId',sortOrder:'asc',    enableHeaderClickMenu: false,    enableHeaderContextMenu: false,    toolbar:'#tb',    loadFilter:function(data){        return DzmFrame.EasyUI.dataGridLoadFilter(data);    }    });}

2 dataGridLoadFilter
定义filter，解析smsHouseholdOrder.times这种方式的字段。

var _dataGridLoadFilter = function(data,row,pre){             if(pre)                      pre = pre+".";               for (var att in data) {                     var r = data[att];                     if(typeof(r) == "object"){                         if ($.array.isArray(r)){                           row[pre+att] = r;                       } else{                           _dataGridLoadFilter(r,row,pre+att);                         }                   }else{                                  row[pre+att] = r;                                                }                 }         }        var dataGridLoadFilter = function(data){            var value = {total:data.total,rows:[]};            if (!$.isEmptyObject(data.rows) && $.isArray(data.rows)){                for (var i=0; i<data.rows.length; i++){                    var row = {};                    _dataGridLoadFilter(data.rows[i],row,"");                    value.rows.push(row);                }            }            return value;        }

0 0