protected void Page_Load(object sender, EventArgs e)
{
string dateFrom = Request.Form["dateFrom"];
string dateTo = Request.Form["dateTo"];
string devName = Request.Form["devId"];
string strsql = null;
convertDate(dateFrom);
convertDate(dateTo);
DataTable dt = null;
DataTable dt2 = sql.ReturnTable("SELECT Dev_List.id,Dev_List.dev_name,Dev_List.dev_phase,Group_List.group_name FROM Dev_List,Group_List WHERE Dev_List.group_id=Group_List.id AND Dev_List.dev_name='" + devName + "'");
string dev_id = "";
if (null != dt2 && 0 < dt2.Rows.Count)
{
dev_id = dt2.Rows[0][0].ToString();
strsql = "select action_time,action_num,i_num,tem,hum from ActionMsg where action_time between #" + dateFrom + "# AND #" + dateTo + "# AND dev_id = " + dev_id + " ORDER BY ActionMsg.action_time ASC";
dt = sql.ReturnTable(strsql);
}
string json1 = CreateJsonParameters(dt);
string json2 = CreateJsonParameters2(dt2);
string json = "{\"data\":" + json1 + ",\"devinfo\":" + json2 + "}";
Response.ContentType = "application/json";
Response.Write(json);
Response.Flush();
if (dt != null)
{
dt.Dispose();
}
Response.End();
}
