jquery $.getJSON 在asp.net中的用法例子

代码

代码

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Data;
using System.Text;
public class Handler : IHttpHandler {

    public void ProcessRequest (HttpContext context) {
        /*context.Response.ContentType = "text/plain";
        string data = "[{name:\"fan\",age:26},{name:\"wang\",age:25}]";//构建的json数据
        context.Response.Write(data);*/

        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        dt.Columns.Add("name", typeof(string));
        dt.Columns.Add("year", typeof(string));
        dt.Columns.Add("avg", typeof(string));
        DataRow tr = dt.NewRow();
        tr["name"] = "shshshdy";
        tr["year"] = "2005-02-02";
        tr["avg"] = "男";
        dt.Rows.Add(tr);
        //ds.Tables.Add(dt);
        DataRow tr2 = dt.NewRow();
        tr2["name"] = "xiaoming";
        tr2["year"] = "2007-02-02";
        tr2["avg"] = "女";
        dt.Rows.Add(tr2);
        ds.Tables.Add(dt);

        context.Response.Clear();
        context.Response.ContentEncoding = Encoding.UTF8;
        context.Response.ContentType = "application/json";
        //Response.Write("{\"success\":true,\"name\":\"shshshdy\",\"year\":\"2009-12-12\"}");
        context.Response.Write(getJSON(ds));
        context.Response.Flush();
        context.Response.End();
    }

    public bool IsReusable {
        get {
            return false;
        }
    }
    private static string getJSON(DataSet ds)//这里调用了JSON帮助文件，jsonHelp.cs 就不放出源码了
    {
        Json.JSONHelper jsonHelp = new Json.JSONHelper();

        jsonHelp.success = true;
        //jsonHelp.totlalCount = getPrjListCount();
        jsonHelp.totlalCount = ds.Tables[0].Rows.Count;

        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            jsonHelp.AddItem("name", dr["name"].ToString());
            jsonHelp.AddItem("avg", dr["avg"].ToString());

            if (dr["year"] != DBNull.Value)
            {
                jsonHelp.AddItem("year", Convert.ToDateTime(dr["year"]).ToString("yyyy/MM/dd"));
            }
            else
            {
                jsonHelp.AddItem("year", string.Empty);
            }

            jsonHelp.ItemOk();
        }

        string strResult = jsonHelp.ToString();
        return strResult;
    }
}

代码

protected void Page_Load(object sender, EventArgs e)
        {
            string planNo = string.Empty;
            if (Request.QueryString["planNo"] != null)
            {

                 planNo = Request.QueryString

["planNo"].ToString();
            }
        if (!string.IsNullOrEmpty(planNo))
        {
//从数据库中取到OpenServiceInfo 对象
            //BLL.OpenSevice bll = new

Sysnet.EDP.EAF.F3.BLL.OpenSevice();
            //OpenServiceInfo info =

bll.GetOpenServiceByPlanNo(planNo);
   OpenServiceInfo info =new OpenServiceInfo();
   info.IsAccount =true;
info.IsTrustee = false;
info.LoginName ="张三";

//序列化对象
            JavaScriptSerializer jss = new

JavaScriptSerializer();
            string strJson =jss.Serialize(info);

            Response.Clear();
            Response.ContentEncoding = Encoding.UTF8;
            Response.ContentType = "application/json";
            Response.Write(strJson);
            Response.Flush();
            Response.End();
        }

      }

  public class OpenServiceInfo
    {
        private string _ID;
        private string _PlanNo;
        private bool _IsTrustee=false;
        private bool _IsAccount = false;
        private bool _IsInvestment = false;
        private string _EnterpriseManagement;
        private string _LoginName;
        private string _Remark;
        /// <summary>
        /// ID
        /// </summary>
        public string ID
        {
            get
            {
                return _ID;
            }
            set
            {
                _ID = value;
            }
        }
        /// <summary>
        /// 计划登记号
        /// </summary>
       public string PlanNo
        {
            get
            {
                return _PlanNo;
            }
            set
            {
                _PlanNo = value;
            }
        }
       /// <summary>
       /// 受托服务
       /// </summary>
       public bool  IsTrustee
       {
           get
           {
               return _IsTrustee;
           }
           set
           {
               _IsTrustee = value;
           }
       }
       /// <summary>
       /// 账管服务
       /// </summary>
       public bool IsAccount
       {
           get
           {
               return _IsAccount;
           }
           set
           {
               _IsAccount = value;
           }
       }
       /// <summary>
       /// 投资服务
       /// </summary>
       public bool IsInvestment
       {
           get
           {
               return _IsInvestment;
           }
           set
           {
               _IsInvestment = value;
           }
       }
       /// <summary>
       /// 可管理的企业
       /// </summary>
       public string EnterpriseManagement
       {
           get
           {
               return _EnterpriseManagement;
           }
           set
           {
               _EnterpriseManagement = value;
           }
       }
       /// <summary>
       /// 登陆名-账号
       /// </summary>
       public string LoginName
       {
           get
           {
               return _LoginName;
           }
           set
           {
               _LoginName = value;
           }
       }
       /// <summary>
       /// 备注
       /// </summary>
       public string Remark
       {
           get
           {
               return _Remark;
           }
           set
           {
               _Remark = value;
           }
       }
    }