C# JS 前后端互传数据

---恢复内容开始---

 

后端：

public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string IMEI = context.Request.QueryString["ID"];
string currentDateTime = DateTime.Now.ToShortDateString();
string cmd = "select TOP 20 温度,电池电压,电池电量,采集时间 from View_GPRS where 采集时间>'" + currentDateTime + "' and 设备号 ='" + IMEI + "' order by 采集时间 desc";
// 访问数据库
using (SqlDataReader reader = SqlHelper.ExcuteDataReader(cmd))
{
if (reader.HasRows)
{
while (reader.Read())
{

if (reader[0].ToString() == ""||reader[1].ToString()==""|| reader[2].ToString()==""|| reader[3].ToString()=="")
{
continue;
}

//在第一个位置插入元素，相当于倒序排列，将元素从旧到新排序
energyInfo.Temp.Insert(0,Convert.ToDouble(reader[0]));//温度
energyInfo.BatteryVoltage.Insert(0,Convert.ToDouble(reader[1]));//电压
energyInfo.BatterySOC.Insert(0,Convert.ToDouble(reader[2]));//电量
DateTime colleTime = Convert.ToDateTime(reader[3].ToString()) ;
string sss = colleTime.ToString("T");
energyInfo.CollectionTime.Insert(0, colleTime.ToString("T"));//采集时间

}
}
}
object JSONObj = JsonConvert.SerializeObject(energyInfo);

//数据库内容转成json
context.Response.Write(JSONObj);

}

 

前端：

 

   

 if (selectedLayer === getLayerByTitle('企业')) {
       console.info('点击餐车图层上的点，跳转页面到折线图');
      var IMEI = dic_values['IMEI'];
      //跳转，将feature的属性数据传递到新页面
     //window.location.href = 'Details.aspx?name=' + name;
      window.open('Details.aspx?name=' + IMEI);
}

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

<br><br>//获取url中的参数        function getQueryParams() {            var search = window.location.search;            var params = {};            if (search != "") {                search.slice(1).split("&").forEach(                    function (val) {                        var arr = val.split("=");                        params[arr[0]] = arr[1];                    }                );            }            return params;        } //获取url中的参数        var params = getQueryParams();        var query = decodeURI(params['name']);   $.ajax({                type: "GET",                url: ' Handler2.ashx?ID=' + query,                contentType: "application/json",                data: {},                success: function (res) {                     jsondata = JSON.parse(res);                    console.log('取到设备的温度，电压，电量数据');                    console.log(jsondata)                                         option1.series[0].data = jsondata.Temp;//餐车温度                    option1.xAxis[0].data = jsondata.CollectionTime;                    option2.series[0].data = jsondata.BatteryVoltage;//电池电压                    option2.xAxis[0].data = jsondata.CollectionTime;                    option3.series[0].data = jsondata.BatterySOC;//电池电量                    option3.xAxis[0].data = jsondata.CollectionTime;//采集时间                    myChart1.setOption(option1);                    myChart2.setOption(option2);                    myChart3.setOption(option3);                },              });

　　

---恢复内容结束---