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