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