public List <TempRTvalues> GetRtvalues()
{
//List<TempRTvalues> RtList;
List <TempRTvalues> RtList = new List <TempRTvalues>();
TempRTvalues value;
for (int i = 0; i < MachinePark.Count; i++)
{
if (MachinePark[i].RtValues != null)
{
value = new TempRTvalues
{
Machine = MachinePark[i].Machine_name,
Frequency = MachinePark[i].RtValues.Frequency,
DCvolage = MachinePark[i].RtValues.DCvolage,
MotorCurent = MachinePark[i].RtValues.MotorCurent,
MotorRPM = MachinePark[i].RtValues.MotorRPM,
MotorTorquyProc = MachinePark[i].RtValues.MotorTorquyProc,
TStamp = MachinePark[i].RtValues.TimeStamp
};
RtList.Add(value);
}
;
}
return(RtList);
}
public List <TempRTvalues> GetRTvalues()
{
TempRTvalues temp;
if (!isOpen)
{
Open_Datebase();
}
List <TempRTvalues> RTvalues = new List <TempRTvalues> {
};
sqlstatment = Connection.CreateCommand();
sqlstatment.CommandText = "SELECT * FROM `values_realtime`";
try
{
MySqlDataReader reder = sqlstatment.ExecuteReader();
while (reder.Read())
{
temp = new TempRTvalues
{
Machine = reder["Machine"].ToString(),
Frequency = (int)reder["Frequency"],
MotorCurent = (int)reder["MotorCurent"],
MotorTorquyProc = (int)reder["MotorTorquyProc"],
DCvolage = (int)reder["DCvolage"],
MotorRPM = (int)reder["MotorRPM"],
TStamp = (DateTime)reder["TStamp"]
};
RTvalues.Add(temp);
}
}
catch (Exception)
{
return(null);
}
Close_Datebase();
return(RTvalues);
}
