extjs用ajax获取json数据不能转换成Store
本帖最后由 showbo 于 2012-12-20 09:05:42 编辑 前台代码:
Ext.onReady(function () {
var store = new Ext.data.Store({
fields: [{ name: 'user_id' }, { name: 'user_name' }, { name: 'ssyj', type: "float"}],
reader: new Ext.data.JsonReader({ totalProperty: "results", root: 'data' })
// listeners: {
// load: function () {
// alert(store.getCount());
// }
// }
});
var requestConfig = {
url: '/WebService/test/tb_data.ashx', //请求的服务器地址
params: { userName: 'tom', password: '123' }, //请求参数
customer: '自定义属性', //附加属性
callback: function (options, success, response) {//回调函数
alert(response.responseText);
var forminfo = Ext.decode(response.responseText);
store.loadData(Ext.JSON.decode(response.responseText,true));
alert(store.getCount());
}
}
Ext.Ajax.request(requestConfig); //发送请求
public void ProcessRequest(HttpContext context)
{
context.Request.ContentEncoding = Encoding.GetEncoding("UTF-8");
context.Response.ContentEncoding = Encoding.GetEncoding("UTF-8");
context.Response.Charset = "UTF-8";
context.Response.ContentType = "text/plain";
string result = string.Empty;
string ygk_list = string.Empty;
string strSQL = string.Empty;
string state = context.Request["userName"];
string state1 = context.Request["password"];
try
{
strSQL = string.Format(@"select tb_user.user_name,tb_fwcjqr.user_id,sum(tb_fwcjqr.htzj)as ssyj from tb_fwcjqr
inner join tb_user on tb_user.id = tb_fwcjqr.user_id
group by tb_user.user_name ,tb_fwcjqr.user_id");
DataTable dt = LTP.DBUtility.DbHelperSQL.Query(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
result = LTP.BLL.Ext_Json.DataTable2Json(dt);
}
else
{
result = "false";
}
}
catch
{
result = "error";
}
context.Response.Write(result);
}