Measurement Studio for .NET Languages
Plotting multiple line graphs with legend
Allright, let's try this!
I am using Entity Framework and Linq to SQL to access the database. There are three main databases, that are dependent on each other as the following image shows:
So in the normal use-case, there would be six "MeasurementCycles" for one "TrackMeasurement", and 12-14 "MeasurementValues" per "MeasurementCycle". These "MeasurementValues" are plotted and linked in one linegraph for each MeasurementCycle.
With Entity Framework, the classes for the databases are implemented as follows (I blurred the picture to save some code here):
public partial class TrackMeasurement
{
{
MeasurementCycles = new HashSet<MeasurementCycle>();
MeasurementPDRefs = new HashSet<MeasurementPDRef>();
}
public int ID { get; set; }
[Required]
[StringLength(50)]
public string Strecke { get; set; }
public int Messstelle { get; set; }
public float Außentemperatur { get; set; }
[...]
} public partial class MeasurementCycle
{
{
MeasurementValues = new HashSet<MeasurementValue>();
}
public int ID { get; set; }
public int TMeasID { get; set; }
public int Leiter { get; set; }
public float Frequenz { get; set; }
[...]
}public partial class MeasurementValue
{
public int ID { get; set; }
public int CycleID { get; set; }
public int ParameterID { get; set; }
public double Z_abs { get; set; }
public double Z_arg { get; set; }
public double tan_delta { get; set; }
public double U_rms { get; set; }
public double I_rms { get; set; }
[...]
}I have three ListViews with GridViews to display the three datatables (only one here, the other ones are similar):
<ListView SelectionChanged="lvTrackMeasurement_SelectionChanged" Name="lvTrackMeasurement" Grid.Row="1">
<ListView.View>
<GridView>
<GridViewColumn Header="ID" DisplayMemberBinding="{Binding ID}"/>
<GridViewColumn Header="Strecke" DisplayMemberBinding="{Binding Strecke}"/>
<GridViewColumn Header="Messstelle" DisplayMemberBinding="{Binding Messstelle}"/>
<GridViewColumn Header="Außentemperatur" DisplayMemberBinding="{Binding Außentemperatur}"/>
[...]Setting the ItemsSource property of the ListViews makes them show the datatables:
List<TrackMeasurement> allTrackMeasurements = new List<TrackMeasurement>();
ObservableCollection<MeasurementCycle> selectedMeasurementCycles = new ObservableCollection<MeasurementCycle>();
ObservableCollection<MeasurementValue> selectedMeasurementValues = new ObservableCollection<MeasurementValue>();
public MainWindow() { InitializeComponent(); using (var db = new IDSdbModel()) { allTrackMeasurements = db.TrackMeasurements.ToList(); } lvTrackMeasurement.ItemsSource = allTrackMeasurements; lvMeasurementCycles.ItemsSource = availableMeasurementCycles; lvMeasurementValues.ItemsSource = selectedMeasurementValues; tandGraph.DataSource = plotData; }
Everytime I change the selection of the first table ("TrackMeasurement"), the other tables are changed accordingly, and the selected "MeasurementCycles" are plotted automatically:
private void lvTrackMeasurement_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (var db = new IDSdbModel())
{
//Completely refill tables
selectedMeasurementCycles.Clear();
availableMeasurementCycles.Clear();
foreach (TrackMeasurement currentTrackMeasurement in lvTrackMeasurement.SelectedItems)
{
foreach (MeasurementCycle mc in db.MeasurementCycles.Where(mc => mc.TMeasID == currentTrackMeasurement.ID).ToList())
{
availableMeasurementCycles.Add(mc);
}
}
lvMeasurementCycles.SelectAll();
}
}
private void lvMeasurementCycles_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (var db = new IDSdbModel())
{
tandGraph.Plots.Clear();
plotData.Clear();
selectedMeasurementValues.Clear();
selectedMeasurementCycles.Clear();
//What was chosen?
foreach (MeasurementCycle currentMeasurementCycle in lvMeasurementCycles.SelectedItems)
{
Point[] singlePlot = new Point[currentMeasurementCycle.MeasurementValues.Count()];
int count = 0;
foreach (MeasurementValue mv in currentMeasurementCycle.MeasurementValues)
{
selectedMeasurementValues.Add(mv);
singlePlot[count] = new Point(mv.U_rms, mv.tan_delta);
count++;
}
plotData.Add(singlePlot);
NationalInstruments.Controls.Primitives.IPlotObserver plotObs = tandGraph.AllPlots[tandGraph.AllPlots.Count() - 1];
plotObs.Label = ("ID: " + currentMeasurementCycle.ID.ToString());
}
}
}So the plotted lines change, if either I select other "TrackMeasurements" or change the selected "MeasurementCycles" of the selected "TrackMeasurements". As I did with the ItemsSource of the ListViews and their Bindings on the Attributenames of the classes they are bound to, I thought it might be possible (that was what I meant in the last post) to have some kind of class, which includes all the stuff I would need for one linegraph (Point[], MeasurementValue, LineRenderer, etc...) and bind these (somehow...??!) to the graph.
I hope you can understand what I mean... Do you need more information?
Thanks so much!!
