public static void InsertSensons(OpenHardwareMonitor.Hardware.ISensor s, DateTime dt)
{
if (s.Value == null) return;
int id = QueryHardwareID(s.Name, s.Hardware.Name, s.SensorType.ToString(), s.Identifier.ToString());
if (id < 0)
{
string inshardwaretype = @"insert into HardwareInfo
(ID,SesonName,HardwareName,type,Identifier)
values
(null,@SesonName,@HardwareName,@type,@Identifier)";
SQLiteCommand cmd2 = new SQLiteCommand(inshardwaretype, DBA);
cmd2.Parameters.Add(new SQLiteParameter("@SesonName", DbType.String));
cmd2.Parameters.Add(new SQLiteParameter("@HardwareName", DbType.String));
cmd2.Parameters.Add(new SQLiteParameter("@type", DbType.String));
cmd2.Parameters.Add(new SQLiteParameter("@Identifier", DbType.String));
cmd2.Parameters[0].Value = s.Name;
cmd2.Parameters[1].Value = s.Hardware.Name;
cmd2.Parameters[2].Value = s.SensorType;
cmd2.Parameters[3].Value = s.Identifier.ToString();
cmd2.ExecuteNonQuery();
id = QueryHardwareID(s.Name, s.Hardware.Name, s.SensorType.ToString(), s.Identifier.ToString());
}
string strInsertSql = @"insert into SesonsLogs
(ID,HardwareInfoID,Value,InsertTime)
values
(null,@HardwareInfoID,@Value,@InsertTime)";
SQLiteCommand command = new SQLiteCommand(strInsertSql, DBA);
command.Parameters.Add(new SQLiteParameter("@HardwareInfoID", DbType.Int32));
command.Parameters.Add(new SQLiteParameter("@Value", DbType.Single));
command.Parameters.Add(new SQLiteParameter("@InsertTime", DbType.Int64));
//command.Parameters.Add(new SQLiteParameter("@SesonName", DbType.String));
//command.Parameters.Add(new SQLiteParameter("@HardwareName", DbType.String));
//command.Parameters.Add(new SQLiteParameter("@type", DbType.String));
command.Parameters[0].Value = id;
command.Parameters[1].Value = s.Value == null ? float.NaN: Math.Round((float)s.Value, 2) ;
command.Parameters[2].Value = ConvertDef.ConvertDateTimeInt(dt);
//command.Parameters[1].Value = s.Name;
//command.Parameters[3].Value = s.Hardware.Name;
//command.Parameters[4].Value = s.SensorType;
command.ExecuteNonQuery();
}
public static preJson <TableRes> GetData(int getCount, string Type, string Name)
{
try
{
//Temperature
//CPU Package
string sql = @"select * from
(SELECT t1.ID, t2.Identifier, t2.SesonName, t2.HardwareName, t2.type, t1.Value, t1.InsertTime FROM 'SesonsLogs' t1, 'HardwareInfo' t2
where t1.HardwareInfoID = t2.ID
and t2.type = @TYPE and t2.SesonName = @NAME
order by t1.InsertTime desc
LIMIT 0, @getCount )
order by InsertTime asc";
List <SQLiteParameter> ps = new List <SQLiteParameter>();
ps.Add(new SQLiteParameter("getCount", getCount));
ps.Add(new SQLiteParameter("TYPE", Type));
ps.Add(new SQLiteParameter("NAME", Name));
DataTable dt = DBABase.QueryDBA(sql, ps);
preJson <TableRes> r = new preJson <TableRes>(dt);
r.DataLenght = (UInt64)dt.Rows.Count;
r.StartTime = ConvertDef.GetTime(dt.Rows[0]["InsertTime"].ToString());
string minandmax = ConfigurationSettings.AppSettings[Type + "+" + "*"];
if (!String.IsNullOrWhiteSpace(minandmax))
{
string[] sArray = minandmax.Split(',');
r.ShowMIN = Convert.ToSingle(sArray[0]);
r.ShowMAX = Convert.ToSingle(sArray[1]);
r.ShowUnit = sArray[2];
}
minandmax = ConfigurationSettings.AppSettings[Type + "+" + Name];
if (!String.IsNullOrWhiteSpace(minandmax))
{
string[] sArray = minandmax.Split(',');
r.ShowMIN = Convert.ToSingle(sArray[0]);
r.ShowMAX = Convert.ToSingle(sArray[1]);
r.ShowUnit = sArray[2];
}
return(r);
}
catch { return(null); }
}
public preJson(DataTable dt)
{
this.rows = this.rows = ConvertDef.TableToList <T>(dt).ToArray();
}
