JQuery EasyUI DataGrid 绑定数据无法成功

游园密语 2011-03-15 11:03:47

页面生成的json格式数据是这样子的

{"total":100,"rows":[{"ID":"7","OID":"17","HotelID":"57","RoomTypeID":"216","SourceCID":"1","CID":"1","Indate":"2010-9-11 0:00:00","Price":"","THPrice":"","RoomNum":"1","PriceCB":"","PriceAC":"","HotelStatus":"0","SourceStatus":"0","CusPriceAC":"","RoomIn":"0","PrivataRoom":"0","CusPrice":"0","CUsID":"1","InStatus":"","OutStatus":"","InMoney":"","OutMoney":"","TableName":"T_OrderRoom"},{"ID":"202","OID":"67","HotelID":"57","RoomTypeID":"579","SourceCID":"1","CID":"1","Indate":"2010-10-7 0:00:00","Price":"825","THPrice":"660","RoomNum":"1","PriceCB":"700","PriceAC":"660","HotelStatus":"0","SourceStatus":"0","CusPriceAC":"","RoomIn":"0","PrivataRoom":"0","CusPrice":"0","CUsID":"1","InStatus":"","OutStatus":"","InMoney":"","OutMoney":"","TableName":"T_OrderRoom"}]}

读取页面的代码是这样子的

  $(document).ready(function() {



     $('#list').datagrid({

        title:'统计 报表',

        iconCls:'icon-save',

        width:800,

        height:250,

        url: "../ajax/order/aggregate.aspx",

        columns:[[

			        {title:'统计',colspan:6},

					{field:'OID',title:'标题',width:100,align:'center', rowspan:2,

						formatter:function(value,rec){

							return '<span style="color:red">Edit Delete</span>';

						}

					}

				],[

                {field:'oid',title:'订单ID',width:100},

                {field:'indate',title:'入住日期',width:100,align:'right'},

                {field:'outdate',title:'离店日期',width:100,align:'left'},

                {field:'roomnum',title:'房间数',width:100},

                {field:'price',title:'价格',width:100},

                {field:'pricecb',title:'成本价格',width:100}

            ]],

        pagination:true,

        rownumbers:true

    });

}

);

可是无法绑定出数据就是无法显示出来只是显示了100行的空行
效果就是这样子的

...全文

1774 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

xpfoo2010 2013-07-07

打赏
举报

同样的问题折磨我了一天，感谢。

fzhang007 2013-04-17

打赏
举报

大小写，关键字问题

herojhc 2013-01-28

打赏
举报

问题就是处在大小写上啊。。。。真愁人啊。。。

bao22314483 2011-07-21

打赏
举报

[Quote=引用 4 楼 nanjim 的回复:]
引用 3 楼 a410787073 的回复:
你没设置主键列好像

設置了我發現問題了是因為綁定的時候字段的大小寫問題大家都知道js是大小寫敏感的沒想到jquery easyui datagrid這種用來綁定數據字段的字符串都不轉一下害的大小寫敏感還繼續存在綁定數據字段中
數據字段ID 你綁定的時候寫成id Id iD等都等於沒效果了我那天正好測試的時候就全部寫成小寫的了……
[/Quote]



{"total":100,"rows":[{"ID":"7","OID":"17","HotelID":"57","RoomTypeID":"216","SourceCID":"1","CID":"1","Indate":"2010-9-11 0:00:00","Price":"","THPrice":"","RoomNum":"1","PriceCB":"","PriceAC":"","HotelStatus":"0","SourceStatus":"0","CusPriceAC":"","RoomIn":"0","PrivataRoom":"0","CusPrice":"0","CUsID":"1","InStatus":"","OutStatus":"","InMoney":"","OutMoney":"","TableName":"T_OrderRoom"},{"ID":"202","OID":"67","HotelID":"57","RoomTypeID":"579","SourceCID":"1","CID":"1","Indate":"2010-10-7 0:00:00","Price":"825","THPrice":"660","RoomNum":"1","PriceCB":"700","PriceAC":"660","HotelStatus":"0","SourceStatus":"0","CusPriceAC":"","RoomIn":"0","PrivataRoom":"0","CusPrice":"0","CUsID":"1","InStatus":"","OutStatus":"","InMoney":"","OutMoney":"","TableName":"T_OrderRoom"}]}

你這個怎樣從後臺發送這個字符串出來,比如說我datagrid控件只有2個列是name,age,我在後臺想綁定2條記錄分別是name:a1,age:13 name:a2,age14 那我後臺代碼怎樣寫

游园密语 2011-03-20

打赏
举报

[Quote=引用 3 楼 a410787073 的回复:]
你没设置主键列好像
[/Quote]

設置了我發現問題了是因為綁定的時候字段的大小寫問題大家都知道js是大小寫敏感的沒想到jquery easyui datagrid這種用來綁定數據字段的字符串都不轉一下害的大小寫敏感還繼續存在綁定數據字段中
數據字段ID 你綁定的時候寫成id Id iD等都等於沒效果了我那天正好測試的時候就全部寫成小寫的了就導致了出現這樣子的問題

以後注意就是了也希望jquery easyui 能夠改善這種問題