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); }