public static void test3() { MyAccessDriver a = new MyAccessDriver("C:/Users/tzhou9/Desktop/Adpater Practice/Data/db1_0804_2015_010100.mdb"); string strCom = "Select * from FRURawData1026"; OleDbDataReader reader = a.ExecuteSQL(strCom); List<MyMeasurement> measurements = new List<MyMeasurement>(); while (reader.Read()) { DateTime sampleDateTime = DateTime.Parse(reader["Sample_Date&Time"].ToString()); double measurementValue = Convert.ToDouble(reader["FinalFreq"]); MyMeasurement newMeasurement = new MyMeasurement(); newMeasurement.sampleTime = new GSF.Ticks(sampleDateTime); newMeasurement.pointID = 97; newMeasurement.value = (float)measurementValue; measurements.Add(newMeasurement); } LocalOutputAdapter local = new LocalOutputAdapter(); local.MyProcessMeasurements(measurements); Console.WriteLine("finish"); }
public static void test() { MyAccessDriver a = new MyAccessDriver("C:/Users/tzhou9/Desktop/Adpater Practice/Data/db1_0804_2015_010100.mdb"); string strCom = "Select * from FRURawData1026 where Index < 40000 and Index > 30000"; OleDbDataReader reader = a.ExecuteSQL(strCom); List<IMeasurement> measurements = new List<IMeasurement>(); while (reader.Read()) { DateTime sampleDateTime = DateTime.Parse(reader["Sample_Date&Time"].ToString()); double measurementValue = Convert.ToDouble(reader["FinalFreq"]); IMeasurement newMeasurement = new Measurement(); newMeasurement.Timestamp = new GSF.Ticks(sampleDateTime); measurements.Add(newMeasurement); //newMeasurement.AdjustedValue = measurementValue; //newMeasurement.Key = MeasurementKey.LookUpBySignalID(Guid.Parse("895ef95e-46a4-11e5-a8c0-b8ca3ab306c3")); //MessageBox.Show(MeasurementKey.LookUpBySignalID(Guid.Parse("895ef95e-46a4-11e5-a8c0-b8ca3ab306c3")).ID.ToString()); } LocalOutputAdapter local = new LocalOutputAdapter(); local.Run(measurements.ToArray()); Console.WriteLine("finish"); }
public MyOutputAdapter() { historian = new LocalOutputAdapter(); BuildMeasurementMap(); historian.MyInitialize(); }