jQuery MiniUI

 找回密码
 立即注册
查看: 2064|回复: 3
打印 上一主题 下一主题

datagrid 加载json 分页的问题 [复制链接]

Rank: 1

跳转到指定楼层
楼主
发表于 2017-5-8 17:17:29 |只看该作者 |倒序浏览
小菜一枚 初来乍到 求各位大神指教。
我用datagrid加载数据,因为数据业务比较复杂,在后台封装好json后传给前台,传过来是json字符串,result.put("json",formjson.toString()),内容如下:
[{"对象":"AC04","16:00期望":"60","16:00实际":"24","16:00预测":"83","17:00预测":"80","18:00预测":"52","19:00预测":"56","20:00预测":"29","21:00预测":"19"},{"对象":"AC04/BTO","16:00期望":"0 (0%)","16:00实际":"0 (0%)","16:00预测":"1 (1.2%)","17:00预测":"0 (0%)","18:00预测":"0 (0%)","19:00预测":"0 (0%)","20:00预测":"0 (0%)","21:00预测":"0 (0%)"},{"对象":"AC04/CDY","16:00期望":"0 (0%)","16:00实际":"2 (8.33%)","16:00预测":"4 (4.82%)","17:00预测":"2 (2.5%)","18:00预测":"1 (1.92%)","19:00预测":"2 (3.57%)","20:00预测":"1 (3.45%)","21:00预测":"0 (0%)"},{"对象":"AC04/CG","16:00期望":"0 (0%)","16:00实际":"5 (20.83%)","16:00预测":"22 (26.51%)","17:00预测":"24 (30%)","18:00预测":"10 (19.23%)","19:00预测":"19 (33.93%)","20:00预测":"10 (34.48%)","21:00预测":"5 (26.32%)"},{"对象":"AC04/HG","16:00期望":"0 (0%)","16:00实际":"0 (0%)","16:00预测":"24 (28.92%)","17:00预测":"34 (42.5%)","18:00预测":"13 (25%)","19:00预测":"14 (25%)","20:00预测":"7 (24.14%)","21:00预测":"7 (36.84%)"},{"对象":"AC04/HUR","16:00期望":"0 (0%)","16:00实际":"2 (8.33%)","16:00预测":"7 (8.43%)","17:00预测":"8 (10%)","18:00预测":"7 (13.46%)","19:00预测":"3 (5.36%)","20:00预测":"8 (27.59%)","21:00预测":"3 (15.79%)"},{"对象":"AC04/IDKUP","16:00期望":"0 (0%)","16:00实际":"8 (33.33%)","16:00预测":"22 (26.51%)","17:00预测":"6 (7.5%)","18:00预测":"16 (30.77%)","19:00预测":"16 (28.57%)","20:00预测":"2 (6.9%)","21:00预测":"0 (0%)"},{"对象":"AC04/SAKOD","16:00期望":"0 (0%)","16:00实际":"1 (4.17%)","16:00预测":"3 (3.61%)","17:00预测":"6 (7.5%)","18:00预测":"5 (9.62%)","19:00预测":"2 (3.57%)","20:00预测":"1 (3.45%)","21:00预测":"4 (21.05%)"},{"对象":"AC04/B215","16:00期望":"0","16:00实际":"1","16:00预测":"0","17:00预测":"0","18:00预测":"0","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/V30","16:00期望":"0","16:00实际":"0","16:00预测":"0","17:00预测":"0","18:00预测":"0","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/W80","16:00期望":"0","16:00实际":"0","16:00预测":"0","17:00预测":"0","18:00预测":"0","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/W41","16:00期望":"0","16:00实际":"0","16:00预测":"0","17:00预测":"0","18:00预测":"0","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/V9","16:00期望":"0","16:00实际":"0","16:00预测":"0","17:00预测":"0","18:00预测":"0","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/A461","16:00期望":"0","16:00实际":"2","16:00预测":"34","17:00预测":"40","18:00预测":"23","19:00预测":"20","20:00预测":"14","21:00预测":"10"},{"对象":"AC04/A593","16:00期望":"0","16:00实际":"0","16:00预测":"39","17:00预测":"48","18:00预测":"25","19:00预测":"22","20:00预测":"16","21:00预测":"9"},{"对象":"AC04/W40","16:00期望":"0","16:00实际":"7","16:00预测":"0","17:00预测":"0","18:00预测":"0","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/H54","16:00期望":"0","16:00实际":"0","16:00预测":"11","17:00预测":"19","18:00预测":"4","19:00预测":"14","20:00预测":"7","21:00预测":"6"},{"对象":"AC04/B339","16:00期望":"0","16:00实际":"2","16:00预测":"0","17:00预测":"0","18:00预测":"0","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/V31","16:00期望":"0","16:00实际":"0","16:00预测":"0","17:00预测":"1","18:00预测":"1","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/A326","16:00期望":"0","16:00实际":"0","16:00预测":"3","17:00预测":"2","18:00预测":"1","19:00预测":"0","20:00预测":"0","21:00预测":"0"},{"对象":"AC04/VYK","16:00期望":"0","16:00实际":"3","16:00预测":"6","17:00预测":"6","18:00预测":"3","19:00预测":"5","20:00预测":"2","21:00预测":"3"},{"对象":"AC04/LADIX","16:00期望":"0","16:00实际":"9","16:00预测":"4","17:00预测":"6","18:00预测":"2","19:00预测":"5","20:00预测":"2","21:00预测":"3"}]
前台的表名是动态变化的,调用和加载数据如下:
                    var grid = mini.get("mainGrid");
                    var column = new Array();
                          column.push({ type: "indexcolumn" });
                          for(var i=0;i<title.length;i++){
                          column.push({ field: title[i],align:"center", headerAlign: "center", header: title[i], });
                          }
                          console.log(column);
                    grid.set({
                         columns: column
                    });
                    var data = mini.decode(json);
                    grid.setData(data);
前台也能得到表单的结果,但是分页和设置页面条数却没有用,应该怎么改,求大神指导。

Rank: 8Rank: 8

沙发
发表于 2017-5-8 17:25:19 |只看该作者

Rank: 1

板凳
发表于 2017-5-8 19:19:41 |只看该作者
dforce 发表于 2017-5-8 17:25
http://www.miniui.com/demo/#src=datagrid/pager_client.html
请参考客户端分页的示例

谢谢大神 参考这个案例已经解决了我的问题

Rank: 8Rank: 8

地板
发表于 2017-5-9 08:58:27 |只看该作者
yuekongming 发表于 2017-5-8 19:19
谢谢大神 参考这个案例已经解决了我的问题

我们默认的分页是后台分页,前台传递参数到后台,后台组织数据,翻页后再次查询,具体可以看一下我们试用包的后台。

Archiver|普加软件

GMT+8, 2024-5-20 07:01 , Processed in 1.056548 second(s), 9 queries .

Powered by Discuz! X2

© 2001-2011 Comsenz Inc.

回顶部