怎么使用ajax获取dataprovider返回的某个数据中的属性？

2016-09-07 15:46

题主

cgw2001
用户名称：	cgw2001
加入日期：	2012-06-23 15:23
登录次数：	16

返回数据如下，需要获取第一行USER_ID字段值的内容：

{"success":true,"metaData":{"fields":[{"name":"USER_ID","useNull":false,"type":"string"},{"name":"USER_NAME","useNull":false,"type":"string"},{"name":"DISPLAY_NAME","useNull":false,"type":"string"},{"name":"PASSWORD","useNull":false,"type":"string"},{"name":"STATUS","type":"float"},{"name":"CREATE_DATE","dateFormat":"Y-m-d H:i:s.u","type":"date"},{"name":"LOGIN_TIMES","type":"float"},{"name":"EMAIL","useNull":false,"type":"string"},{"name":"USE_LANG","useNull":false,"type":"string"},{"name":"LAST_LOGIN","dateFormat":"Y-m-d H:i:s.u","type":"date"}]},"columns":[{"xtype":"rownumberer"},{"dataIndex":"USER_ID","text":"USER_ID","category":"string","width":130,"editor":{"xtype":"textfield","maxLength":13,"allowBlank":false,"required":true},"editable":true,"metaType":"varchar","metaRequired":true,"metaSize":13,"metaScale":0},{"dataIndex":"USER_NAME","text":"USER_NAME","category":"string","width":180,"editor":{"xtype":"textfield","maxLength":50,"allowBlank":false,"required":true},"editable":true,"metaType":"nvarchar","metaRequired":true,"metaSize":50,"metaScale":0},{"dataIndex":"DISPLAY_NAME","text":"DISPLAY_NAME","category":"string","width":180,"editor":{"xtype":"textfield","maxLength":100,"allowBlank":false,"required":true},"editable":true,"metaType":"nvarchar","metaRequired":true,"metaSize":100,"metaScale":0},{"dataIndex":"PASSWORD","text":"PASSWORD","category":"string","width":180,"editor":{"xtype":"textfield","maxLength":32,"allowBlank":false,"required":true},"editable":true,"metaType":"varchar","metaRequired":true,"metaSize":32,"metaScale":0},{"dataIndex":"STATUS","text":"STATUS","align":"right","category":"number","width":90,"editor":{"xtype":"numberfield","decimalPrecision":0,"validator":Wb.numValidator(1,0),"allowBlank":false,"required":true},"editable":true,"metaType":"numeric","metaRequired":true,"metaSize":1,"metaScale":0},{"dataIndex":"CREATE_DATE","text":"CREATE_DATE","category":"timestamp","width":180,"editor":{"xtype":"datetimefield","allowBlank":false,"required":true},"editable":true,"metaType":"datetime","metaRequired":true,"metaSize":23,"metaScale":3},{"dataIndex":"LOGIN_TIMES","text":"LOGIN_TIMES","align":"right","category":"number","width":140,"editor":{"xtype":"numberfield","decimalPrecision":0,"validator":Wb.numValidator(9,0),"allowBlank":false,"required":true},"editable":true,"metaType":"numeric","metaRequired":true,"metaSize":9,"metaScale":0},{"dataIndex":"EMAIL","text":"EMAIL","category":"string","width":180,"editor":{"xtype":"textfield","maxLength":100},"editable":true,"metaType":"varchar","metaRequired":false,"metaSize":100,"metaScale":0},{"dataIndex":"USE_LANG","text":"USE_LANG","category":"string","width":110,"editor":{"xtype":"textfield","maxLength":10},"editable":true,"metaType":"varchar","metaRequired":false,"metaSize":10,"metaScale":0},{"dataIndex":"LAST_LOGIN","text":"LAST_LOGIN","category":"timestamp","width":180,"editor":{"xtype":"datetimefield"},"editable":true,"metaType":"datetime","metaRequired":false,"metaSize":23,"metaScale":3}],"rows":[{"USER_ID":"admin","USER_NAME":"admin","DISPLAY_NAME":"管理员","PASSWORD":"E2E8E7E53F93F9F3D8B5DFC0DFBC2748","STATUS":1,"CREATE_DATE":"2015-01-01 00:00:00.0","LOGIN_TIMES":59,"EMAIL":null,"USE_LANG":null,"LAST_LOGIN":null},{"USER_ID":"test","USER_NAME":"test","DISPLAY_NAME":"test","PASSWORD":"C5B7A146DAE268384F60D0B8EAE31D7A","STATUS":1,"CREATE_DATE":"2015-01-01 00:00:00.0","LOGIN_TIMES":1,"EMAIL":null,"USE_LANG":null,"LAST_LOGIN":null}],"total":2,"elapsed":3}

2016-09-08 13:45

Zhao WJ
用户名称：	zhaowj
加入日期：	2011-05-02 12:07
登录次数：	2009

使用Wb.request访问，在success事件中：

var userId=Wb.decode(resp.responseText).rows[0].USER_ID;为首行USER_ID值

2016-10-11 21:46

liutt1001
用户名称：	liutt1001
加入日期：	2012-09-01 12:41
登录次数：	156

怎么获取dataprovider控件生成的脚本呢？

2016-10-13 15:19

Zhao WJ
用户名称：	zhaowj
加入日期：	2011-05-02 12:07
登录次数：	2009

使用var script=app.output(sql,null,true);设置第三个参数为true即可获得脚本，见API文档

2016-10-17 15:33

jimmywang
用户名称：	jimmywang
加入日期：	2012-09-09 14:02
登录次数：	71

能在dataprovider里添加一些自定义数据吗？

如服务器当前时间等

2016-11-09 18:01

Zhao WJ
用户名称：	zhaowj
加入日期：	2011-05-02 12:07
登录次数：	2009

设置dataprovider的tag属性可以添加自定义的附加数据

2016-11-24 13:00

liutt1001
用户名称：	liutt1001
加入日期：	2012-09-01 12:41
登录次数：	156

怎么获取app.output得到的script首行记录呢？

返回开发者社区