示例#1
0
        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;
        }
示例#2
0
        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;
        }