static void Main(string[] args)
{
Console.WriteLine(@"Hello World!");
Console.ReadLine();
try
{
string dateTimeStr = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string deviceTypeStr = "004";
string sareaIdStr = "145";
string spotIdStr = "001";
string deviceIdStr = "002";
float alarmValue = 11.2F;
string alarmMsgStr = "凤城服务区 服务大厅 温度异常(低于下限)";
//string insertStr = @"INSERT INTO " + "temperature_alarm_record"
// + @"(date_time, sarea_id, spot_id, device_type, device_id, alarm_message, value_01"
// + @") VALUES('" + dateTimeStr + @"'," + "888" + @", " + "123" + @", '"
// + @"004" + @"', '" + @"001" + @"', '" + @"中文字符串" + @"', " + "17" + @")";
string insertStr = @"INSERT INTO " + "temperature_alarm_record"
+ @"(date_time, sarea_id, spot_id, device_type, device_id, alarm_message, value_01"
+ @") VALUES('" + dateTimeStr + @"','" + sareaIdStr + @"', '" + spotIdStr + @"', '"
+ deviceTypeStr + @"', '" + deviceIdStr + @"', '" + alarmMsgStr + @"', " + alarmValue.ToString() + @")";
DBConnectMySQL mysql_object = new DBConnectMySQL();
mysql_object.ExecuteMySqlCommand(insertStr);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Console.WriteLine(@"End!");
Console.ReadLine();
return;
string requestStr = @"http://10.62.72.116/nvc-cgi/admin/vca.cgi?action=list&group=VCA.Ch0.Ct0.count";
int idx = requestStr.LastIndexOf("=");
if (-1 == idx)
{
return;
}
string findKey = requestStr.Substring(idx + 1).Trim() + "=";
string rdStr = "";
string reportStr = "";
HttpWebRequest hwreq = null;
WebResponse hwrsp = null;
Stream rspStream = null;
StreamReader sr = null;
try
{
hwreq = (HttpWebRequest)WebRequest.Create(requestStr);
hwrsp = hwreq.GetResponse();
rspStream = hwrsp.GetResponseStream();
sr = new StreamReader(rspStream);
while (null != (rdStr = sr.ReadLine()))
{
// Console.WriteLine(rdStr);
if (-1 != (idx = rdStr.IndexOf(findKey)))
{
string subStr = rdStr.Substring(idx + findKey.Length).Trim();
int value;
if (int.TryParse(subStr, out value))
{
reportStr = ", " + subStr;
Console.WriteLine("reportStr = \"" + reportStr + "\"");
break;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
if (null != hwrsp)
{
hwrsp.Close();
}
if (null != rspStream)
{
rspStream.Close();
}
if (null != sr)
{
sr.Close();
}
}
//string resultStr = GetReportString(outStr, requestStr);
//Console.WriteLine(resultStr);
Console.ReadLine();
}
static void Main(string[] args)
{
Console.WriteLine(@"Hello World!");
Console.ReadLine();
try
{
string dateTimeStr = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string deviceTypeStr = "004";
string sareaIdStr = "145";
string spotIdStr = "001";
string deviceIdStr = "002";
float alarmValue = 11.2F;
string alarmMsgStr = "凤城服务区 服务大厅 温度异常(低于下限)";
//string insertStr = @"INSERT INTO " + "temperature_alarm_record"
// + @"(date_time, sarea_id, spot_id, device_type, device_id, alarm_message, value_01"
// + @") VALUES('" + dateTimeStr + @"'," + "888" + @", " + "123" + @", '"
// + @"004" + @"', '" + @"001" + @"', '" + @"中文字符串" + @"', " + "17" + @")";
string insertStr = @"INSERT INTO " + "temperature_alarm_record"
+ @"(date_time, sarea_id, spot_id, device_type, device_id, alarm_message, value_01"
+ @") VALUES('" + dateTimeStr + @"','" + sareaIdStr + @"', '" + spotIdStr + @"', '"
+ deviceTypeStr + @"', '" + deviceIdStr + @"', '" + alarmMsgStr + @"', " + alarmValue.ToString() + @")";
DBConnectMySQL mysql_object = new DBConnectMySQL();
mysql_object.ExecuteMySqlCommand(insertStr);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Console.WriteLine(@"End!");
Console.ReadLine();
return;
string requestStr = @"http://10.62.72.116/nvc-cgi/admin/vca.cgi?action=list&group=VCA.Ch0.Ct0.count";
int idx = requestStr.LastIndexOf("=");
if (-1 == idx)
{
return;
}
string findKey = requestStr.Substring(idx + 1).Trim() + "=";
string rdStr = "";
string reportStr = "";
HttpWebRequest hwreq = null;
WebResponse hwrsp = null;
Stream rspStream = null;
StreamReader sr = null;
try
{
hwreq = (HttpWebRequest)WebRequest.Create(requestStr);
hwrsp = hwreq.GetResponse();
rspStream = hwrsp.GetResponseStream();
sr = new StreamReader(rspStream);
while ( null != (rdStr = sr.ReadLine()) )
{
// Console.WriteLine(rdStr);
if ( -1 != (idx = rdStr.IndexOf(findKey)) )
{
string subStr = rdStr.Substring(idx + findKey.Length).Trim();
int value;
if (int.TryParse(subStr, out value))
{
reportStr = ", " + subStr;
Console.WriteLine("reportStr = \"" + reportStr + "\"");
break;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
if (null != hwrsp)
{
hwrsp.Close();
}
if (null != rspStream)
{
rspStream.Close();
}
if (null != sr)
{
sr.Close();
}
}
//string resultStr = GetReportString(outStr, requestStr);
//Console.WriteLine(resultStr);
Console.ReadLine();
}