protected void Page_Load(object sender, EventArgs e)
{
string url = Request.Url.ToString();
ArrayList list = new ArrayList();
string str = string.Empty;
if (url.IndexOf("status") != -1)
{
string query = Request.QueryString["status"].ToString();
if (query.ToUpper() == "QUERY")
{
string deviceID = Request.QueryString["device"].ToString();
string day = Request.QueryString["day"].ToString();
string week = Request.QueryString["week"].ToString();
string month = Request.QueryString["month"].ToString();
string year = Request.QueryString["year"].ToString();
string sdate = Request.QueryString["sdate"].ToString();
string edate = Request.QueryString["edate"].ToString();
DataSet ds = SqlHelper.GetDeviceUptimeReport(deviceID, day, week, month, year, sdate, edate);
int count = ds.Tables[0].Rows.Count;
if (deviceID == "D05")
{
for (int i = 0; i < count; i++)
{
DeviceMonitorInfomation report = new DeviceMonitorInfomation();
report.StoreNo = ds.Tables[0].Rows[i]["storeNo"].ToString();
report.StoreRegion = ds.Tables[0].Rows[i]["storeRegion"].ToString();
report.StoreType = ds.Tables[0].Rows[i]["storeType"].ToString();
report.DeviceID = ds.Tables[0].Rows[i]["deviceID"].ToString();
report.DeviceName = ds.Tables[0].Rows[i]["deviceName"].ToString();
report.RecordTime = ds.Tables[0].Rows[i]["recordTime"].ToString();
list.Add(report);
}
}
else
{
for (int i = 0; i < count; i++)
{
DeviceMonitorReport report = new DeviceMonitorReport();
report.StoreNo = ds.Tables[0].Rows[i]["storeNo"].ToString();
report.StoreRegion = ds.Tables[0].Rows[i]["storeRegion"].ToString();
report.StoreType = ds.Tables[0].Rows[i]["storeType"].ToString();
report.DeviceID = ds.Tables[0].Rows[i]["deviceID"].ToString();
report.DeviceName = ds.Tables[0].Rows[i]["deviceName"].ToString();
report.Uptime = ds.Tables[0].Rows[i]["uptime"].ToString();
report.Downtime = ds.Tables[0].Rows[i]["downtime"].ToString();
report.Ratio = ((double)ds.Tables[0].Rows[i]["ratio"] * 100).ToString() + "%";
report.Ping = ds.Tables[0].Rows[i]["ping"].ToString();
list.Add(report);
}
}
}
else if (query.ToUpper() == "DEVICE")
{
DataSet ds = SqlHelper.GetDeviceInformation();
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
DeviceInformation di = new DeviceInformation();
di.DeviceID = ds.Tables[0].Rows[i]["deviceID"].ToString();
di.DeviceName = ds.Tables[0].Rows[i]["deviceName"].ToString();
list.Add(di);
}
}
}
else
{
Response.Write("This is Iwooo Monitor System");
Response.End();
return;
}
JavaScriptSerializer json = new JavaScriptSerializer();
str = json.Serialize(list);
Response.Write(str);
Response.End();
return;
}
protected void Page_Load(object sender, EventArgs e)
{
string url = Request.Url.ToString();
ArrayList list = new ArrayList();
string str = string.Empty;
if (url.IndexOf("status") != -1)
{
string query = Request.QueryString["status"].ToString();
if (query.ToUpper() == "QUERY")
{
string deviceID = Request.QueryString["device"].ToString();
DataSet ds = SqlHelper.GetDeviceCurMonitor(deviceID);
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
DeviceMonitorInfomation report = new DeviceMonitorInfomation();
report.StoreNo = ds.Tables[0].Rows[i]["storeNo"].ToString();
report.StoreRegion = ds.Tables[0].Rows[i]["storeRegion"].ToString();
report.StoreType = ds.Tables[0].Rows[i]["storeType"].ToString();
report.DeviceID = ds.Tables[0].Rows[i]["deviceID"].ToString();
report.DeviceName = ds.Tables[0].Rows[i]["deviceName"].ToString();
report.IP = ds.Tables[0].Rows[i]["ip"].ToString();
report.DeviceNetwork = ds.Tables[0].Rows[i]["deviceNetwork"].ToString();
report.RecordTime = ds.Tables[0].Rows[i]["recordTime"].ToString();
report.Ping = ds.Tables[0].Rows[i]["ping"].ToString();
report.N = ds.Tables[0].Rows[i]["N"].ToString();
list.Add(report);
}
}
else if (query.ToUpper() == "DEVICE")
{
DataSet ds = SqlHelper.GetDeviceInformation();
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
DeviceInformation di = new DeviceInformation();
di.DeviceID = ds.Tables[0].Rows[i]["deviceID"].ToString();
di.DeviceName = ds.Tables[0].Rows[i]["deviceName"].ToString();
list.Add(di);
}
}
}
else
{
Response.Write("This is Iwooo Monitor System");
Response.End();
return;
}
JavaScriptSerializer json = new JavaScriptSerializer();
str = json.Serialize(list);
Response.Write(str);
Response.End();
return;
}
