aspx后台传递Json到前台的两种接收方法推荐

2019-05-22 16:18:55王冬梅

两者统一的后台 一般处理程序ashx:

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;

namespace RTC
{
  /// <summary>
  /// getrtchistorydata 的摘要说明
  /// </summary>
  public class getrtchistorydata : IHttpHandler
  {
    public void ProcessRequest(HttpContext context)
    {
      context.Response.ContentType = "text/plain";

      string strRTCNo = context.Request.QueryString["rtcno"].ToString();

      SqlConnection con = new SqlConnection("server=192.168.0.222;uid=sa;pwd=hiwits;database=CeShi_QingDao;Max Pool Size=2048;");
      SqlCommand cmd = new SqlCommand("select RtcNO,RoomTemp,InstallPlace,convert(varchar,RecordTime,120) as RecordTime,systime from RTCHistory where RtcNO='" + strRTCNo + "' order by InstallPlace,RecordTime", con);
      SqlDataAdapter da = new SqlDataAdapter(cmd);
      DataSet ds = new DataSet();
      da.Fill(ds);

      string stbList = "";
      stbList = "{"Rows":[";
      foreach (DataRow dr in ds.Tables[0].Rows)
      {
        stbList = stbList + "{ "RecordTime":"" + dr[3].ToString() + "",";
        stbList = stbList + " "RoomTemp":"" + dr[1].ToString() + ""},";
      }
      stbList = stbList.Substring(0, stbList.Length - 1);//去掉最后的一个逗号

      

      stbList = stbList + "],"; 
      stbList = stbList + ""Count":[{"total":" + ds.Tables[0].Rows .Count+ "}]";//用来记录一共返回了几条数据记录
      
      stbList = stbList + "}";

      context.Response.Write(stbList.ToString());
    }

    public bool IsReusable
    {
      get
      {
        return false;
      }
    }

    public void RetrunHistoryData()
    {


    }
  }
}

以上这篇aspx后台传递Json到前台的两种接收方法推荐就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持易采站长站。