public static void FillTSPointsLV(IListView listView, IModel model) { try { listView.Clear(); listView.AddColumn(Localizer.LS(LSID.Name), 140, true, BSDTypes.HorizontalAlignment.Left); listView.AddColumn(Localizer.LS(LSID.Unit), 80, true, BSDTypes.HorizontalAlignment.Left); listView.AddColumn(Localizer.LS(LSID.Min), 80, true, BSDTypes.HorizontalAlignment.Right); listView.AddColumn(Localizer.LS(LSID.Max), 80, true, BSDTypes.HorizontalAlignment.Right); listView.AddColumn(Localizer.LS(LSID.Deviation), 80, true, BSDTypes.HorizontalAlignment.Right); listView.AddColumn("SID", 140, true, BSDTypes.HorizontalAlignment.Left); listView.AddColumn(Localizer.LS(LSID.Value), 80, true, BSDTypes.HorizontalAlignment.Right); TSDatabase tsdb = model.TSDB; var records = tsdb.GetPoints(); foreach (TSPoint rec in records) { var item = listView.AddItem(rec, rec.Name, rec.MeasureUnit, ALCore.GetDecimalStr(rec.Min), ALCore.GetDecimalStr(rec.Max), ALCore.GetDecimalStr(rec.Deviation), rec.SID, string.Empty ); } } catch (Exception ex) { fLogger.WriteError("FillTSPointsLV()", ex); } }
public ALModel(IBrowser browser) { fBrowser = browser; fTSDB = new TSDatabase(); var databasePath = Path.Combine(AppHost.GetAppDataPath(), "ALData.db"); fDB = new SQLiteConnection(databasePath); fDB.CreateTable <Aquarium>(); fDB.CreateTable <Inhabitant>(); fDB.CreateTable <Species>(); fDB.CreateTable <Device>(); fDB.CreateTable <Note>(); fDB.CreateTable <Maintenance>(); fDB.CreateTable <Transfer>(); fDB.CreateTable <Nutrition>(); fDB.CreateTable <Measure>(); fDB.CreateTable <Schedule>(); fDB.CreateTable <Inventory>(); fDB.CreateTable <Snapshot>(); fDB.CreateTable <Brand>(); fDB.CreateTable <Shop>(); fCache = new EntitiesCache(this); }
public static void FillTSValuesLV(IListView listView, IModel model, int pointId) { try { listView.Clear(); listView.AddColumn(Localizer.LS(LSID.Timestamp), 140, true, BSDTypes.HorizontalAlignment.Left); listView.AddColumn(Localizer.LS(LSID.Value), 120, true, BSDTypes.HorizontalAlignment.Right); TSDatabase tsdb = model.TSDB; var records = tsdb.QueryValues(pointId, DateTime.Now.AddDays(-60), DateTime.Now); foreach (TSValue rec in records) { var item = listView.AddItem(rec, ALCore.GetTimeStr(rec.Timestamp), ALCore.GetDecimalStr(rec.Value) ); } } catch (Exception ex) { fLogger.WriteError("FillTSValuesLV()", ex); } }
public override void UpdateContent() { fChart.Clear(); if (fModel == null) { return; } TSDatabase tsdb = fModel.TSDB; var pt = tsdb.GetPoint(fPointId); var vals = new List <ChartPoint>(); var endTime = DateTime.Now; var begTime = endTime.AddHours(-12); var records = tsdb.QueryValues(fPointId, begTime, endTime); foreach (TSValue rec in records) { vals.Add(new ChartPoint(rec.Timestamp, rec.Value)); } fChart.ShowData(pt.Name, "Time", "Value", new ChartSeries("Value", ChartStyle.Point, vals, Color.Green)); }