Ajax解析josn

A.js

//查询一行数据

              $("#Btsouso").bind("click", function () {
                  var searchid = $("#txtids").val();
                  $.ajax({
                      type: "post",
                      dataType: "json",
                      url: "Mnet.ashx",
                      cache: false,
                      //async: false,
                      data: { operate: "getuserdetails", sid: searchid },
                      success: function (text, textStatus) {
                          if (text != null) {
                              $("#results").html("用户名 ：" + text.userName + " + 姓名 ：" +

text.name + " 地址 ：" + text.place + " ");
                          }
                      },
                      complete: function (XMLHttpRequest, textStatus) {
                      },
                      error: function (XMLHttpRequest, textStatus, errorThrown) {
                          //alert(XMLHttpRequest.responseText);
                      }
                  });
              });


              //查询多行数据
              $("#btgetmoney").bind("click", function () {
                  var searchid = $("#txtids").val();
                  $.ajax({
                      type: "post",
                      dataType: "json",
                      url: "Mnet.ashx",
                      cache: false,
                      //async: false,
                      data: { operate: "getManyUser", sid: searchid },
                      success: function (text, textStatus) {
                          if (text != null) {
                              $.each(text, function (i, item) {
                                  $("#results").append("用户名 ：" + item.yhusername + " + 姓名 ：

" + item.yhname + " 地址 ：" + item.dizhi + "<br> ");
                              });
                          }
                      },
                      complete: function (XMLHttpRequest, textStatus) {
                      },
                      error: function (XMLHttpRequest, textStatus, errorThrown) {
                       
                      }
                  });

              });

ashx:

/// <summary>
    ///
    /// </summary>
    private void getuserdetails(HttpContext context)
    {
        var id = Convert.ToInt32(context.Request["sid"]);
        CodeModel.BLL.userinfo yhbll = new CodeModel.BLL.userinfo();
        CodeModel.Model.userinfo yhModel = new CodeModel.Model.userinfo();
        yhModel=yhbll.GetModel(int.Parse(id.ToString()));
        context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(yhModel));
    
    }

    /// <summary>
    ///
    /// </summary>
    private void getMoneyusers(HttpContext context)
    {
        var id = context.Request["sid"].ToString();
      CodeModel.BLL.userinfo yhbll = new CodeModel.BLL.userinfo();
        CodeModel.Model.userinfo yhModel = new CodeModel.Model.userinfo();
        IList<CodeModel.Model.userinfo> list = yhbll.GetUserList("type='"+id+"'");
        if (list.Count > 0)
        {
            var Json = Newtonsoft.Json.JsonConvert.SerializeObject(list.Select(
                               t => new
                               {
                                   yhid = t.id,
                                   yhname = t.name,
                                   yhusername=t.userName,
                                   dizhi = t.place,
                                
                               }));
            context.Response.Write(Json);
        }
    }
    C.SQL

        //DataSet转换成List<ProductTypeInfo>

        public IList <CodeModel.Model.userinfo> GetUserList(string strwhere)
        {
            IList<CodeModel.Model.userinfo> yhlist = new List<Model.userinfo>();
            CodeModel.BLL.userinfo yh = new BLL.userinfo();
           
            //等待转换的DataSet
            DataSet ds = yh.GetList(strwhere);
              //遍历ds中Tables[0]数据
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)//逐行遍历  i 是当前行
            {
                CodeModel.Model.userinfo yhmodel = new Model.userinfo();
                yhmodel.id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"]);
                yhmodel.userName = ds.Tables[0].Rows[i]["userName"].ToString();
                yhmodel.name = ds.Tables[0].Rows[i]["name"].ToString();
                yhmodel.place = ds.Tables[0].Rows[i]["place"].ToString();
                //将对象插入到List中
                yhlist.Add(yhmodel);
            }
             //返回List
            return yhlist;
        }