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