public async void QueryHole()
{
await Task.Run(() =>
{
using var db = new DrillContext();
Holerecs = db.Holerec.Where(h => h.SerialNo == Workrec.SerialNo).ToList();
});
MyModel.Title = "Work" + Workrec.SerialNo + "'s Chart";
MyModel.Series.Clear();
for (int i = 0; i < Holerecs.Count; i++)
{
List <DataPoint> DataPoints = new List <DataPoint>();
List <Models.Point> points = new List <Models.Point>();
points = CommonMethods.StringToList(Holerecs[i].Data);
for (int j = 0; j < points.Count; j++)
{
var temppoint = new DataPoint(points[j].x * Global.SystemPara.con_factor_x,
points[j].y * Global.SystemPara.con_factor_y);
DataPoints.Add(temppoint);
}
OxyPlot.Series.LineSeries lineSeries = new OxyPlot.Series.LineSeries();
lineSeries.Points.AddRange(DataPoints);
lineSeries.Color = OxyColor.FromRgb(255, 0, 0);
lineSeries.StrokeThickness = 1;
lineSeries.TrackerFormatString = "{0}\n{1}: {2:0.#}mm\n{3}: {4:0.##}Mpa";
MyModel.Series.Add(lineSeries);
}
if (Holerecs != null)
{
Holerec = Holerecs.FirstOrDefault();
if (Workrec != null)
{
HoleGridSelectChange();
}
}
MyModel.InvalidatePlot(true);
}
public async void QueryWorkBySerialNO()
{
await Task.Run(() =>
{
using var db = new DrillContext();
if (QuerySearialNO != null)
{
Workrecs = db.Workrec.Where(w => w.SerialNo.Contains(QuerySearialNO)).OrderByDescending(w => w.LastTime).ToList();
}
if (Workrecs != null)
{
Workrec = Workrecs.FirstOrDefault();
}
Holerecs.Clear();
foreach (var item in Workrecs)
{
Holerecs.AddRange(db.Holerec.Where(h => h.SerialNo == item.SerialNo).ToList());
}
// QueryHole();
});
}
