using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Security.Cryptography;
public partial class Local_GetLine1Data : System.Web.UI.Page
{
//SELECT TOP 264 [TagName],[TagValue] FROM [JiaLi].[dbo].[Line1] order by ID desc
protected void Page_Load(object sender, EventArgs e)
{
//数据库+Json
MyJson.JsonNode_Object json = new MyJson.JsonNode_Object();
using (SqlConnection myconn = dbhelper.Instance().getMySqlCon())
{
SqlCommand mySqlCommand = dbhelper.Instance().getSqlCommand("SELECT TOP 264 [TagName],[TagValue] FROM [JiaLi].[dbo].[Line1] order by ID desc", myconn);
myconn.Open();
SqlDataReader reader = mySqlCommand.ExecuteReader();
json.asDict()["nameList"] = new MyJson.JsonNode_Array();
while (reader.Read())
{
if (reader.HasRows)
{
MyJson.JsonNode_Object rowsJson = new MyJson.JsonNode_Object();
//rowsJson.asDict()["name"] = new MyJson.JsonNode_ValueString(reader["name"].ToString());
rowsJson.asDict()["TagName"] = new MyJson.JsonNode_ValueString(reader["TagName"].ToString());
rowsJson.asDict()["TagValue"] = new MyJson.JsonNode_ValueString(reader["TagValue"].ToString());
//rowsJson.asDict()["order_no"] = new MyJson.JsonNode_ValueString(reader["order_no"].ToString());
//rowsJson.asDict()["title"] = new MyJson.JsonNode_ValueString(reader["title"].ToString());
//rowsJson.asDict()["mark"] = new MyJson.JsonNode_ValueString(reader["mark"].ToString());
//rowsJson.asDict()["temp"] = new MyJson.JsonNode_ValueString(reader["temp"].ToString());
json.asDict()["nameList"].AsList().Add(rowsJson);
}
}
reader.Close();
myconn.Close();
}
json.asDict()["state"] = new MyJson.JsonNode_ValueNumber(1);
Response.Write(json.ToString());
}
}