public static void logData(bool sent, string text)
{
String tempstr = "";
DateTime dt = DateTime.Now;
if (text.Length > 10)
{
SensorData sensorData = new SensorData();
String[] strs = text.Split(new char[] { ',' });
string temprature = strs[0];
string humidity = strs[1];
string light = strs[2];
string gas = strs[3];
string fire = strs[4];
string humanstatus = strs[5];
sensorData.TemperatureData = Double.Parse(temprature.Split(new char[] { ':' })[1]);
sensorData.HumidityData = Double.Parse(humidity.Split(new char[] { ':' })[1]);
sensorData.LightData = Double.Parse(light.Split(new char[] { ':' })[1]);
sensorData.GasData = Double.Parse(gas.Split(new char[] { ':' })[1]);
sensorData.FireData = Double.Parse(fire.Split(new char[] { ':' })[1]);
sensorData.HumanStatus = Int16.Parse(humanstatus.Split(new char[] { ':' })[1]);
sensorData.DateTime = dt.ToString();
tempstr = temprature + ";" + humidity + ";" + light + ";" + gas + ";" + fire + ";" + humanstatus;
Console.WriteLine(tempstr);
try
{
publicSQL.DataOperate(sensorData, PublicSQL.MODE_INSERT);
}
catch
{
Console.WriteLine("2DB error");
}
}
}
void Data2mssql()
{
if (error)
{
Console.WriteLine("Something error happened");
connect();
return;
}
try
{
//从电表读取数据,并解析到对象
SmartMeterData.getActive_Energy(MeterDataAccessor.read_active_Energy());
SmartMeterData.getActive_Power(MeterDataAccessor.read_active_Power());
SmartMeterData.getReactive_Power(MeterDataAccessor.read_Reactive_Power());
DateTime datetime = DateTime.Now;
CSmartMeterDataInfo datainfo = SmartMeterData.smartMeterData;
UserfulMeterData userfulMeterData = new UserfulMeterData(datainfo.Total_Active_Power_65, datainfo.Reactive_Power_Total_67, datainfo.Active_Energy_Import_Tariff_1_801, datetime);
publicSQL.DataOperate(userfulMeterData, PublicSQL.MODE_INSERT);
string tempstr = "---GetData:" + "\nTime:" +
userfulMeterData.DateTime + "\nActivePower:" +
String.Format("{0:F}", userfulMeterData.ActivePower) +
"W\tReactivePower:" +
String.Format("{0:F}", userfulMeterData.ReactivePower) +
"Var\nEnergy:" + String.Format("{0:F}", userfulMeterData.ActiveEnergy) + "\n";
Console.WriteLine(tempstr);
}
catch (Exception e)
{
Console.WriteLine("{0}", e.ToString());
connect();
}
}
