每次传入的DataTable大概有17w组数据。界面会卡主半天。从其他界面切换回去时也会卡3~4秒。求优化方法最好是秒出
private static DispatcherOperationCallback exitFrameCallback = new DispatcherOperationCallback(ExitFrame);
public static void DoEvents()
{
DispatcherFrame nestedFrame = new DispatcherFrame();
DispatcherOperation exitOperation = Dispatcher.CurrentDispatcher.BeginInvoke(DispatcherPriority.Background, exitFrameCallback, nestedFrame);
Dispatcher.PushFrame(nestedFrame);
if (exitOperation.Status !=
DispatcherOperationStatus.Completed)
{
exitOperation.Abort();
}
}
private static Object ExitFrame(Object state)
{
DispatcherFrame frame = state as
DispatcherFrame;
frame.Continue = false;
return null;
}
#region 折线图
private void CreateChartSpline(string name, DataTable table)
{
zhexiantu.Children.Clear();
//创建一个图标
Chart chart = new Chart();
//设置动画效果
chart.AnimationEnabled = false;
//设置图标的宽度和高度
//chart.Width = 580;
//chart.Height = 380;
//chart.Margin = new Thickness(100, 5, 10, 5);
//是否启用打印和保持图片
chart.ToolBarEnabled = true;
//设置图标的属性
chart.ScrollingEnabled = false;//是否启用或禁用滚动
chart.View3D = false;//3D效果显示
//创建一个标题的对象
Title title = new Title();
//设置标题的名称
title.Text = name;
title.Padding = new Thickness(0, 10, 5, 0);
//向图标添加标题
chart.Titles.Add(title);
//初始化一个新的Axis
Axis xaxis = new Axis();
//设置Axis的属性
//图表的X轴坐标按什么来分类，如时分秒
xaxis.IntervalType = IntervalTypes.Hours;
//图表的X轴坐标间隔如2,3,20等，单位为xAxis.IntervalType设置的时分秒。
xaxis.Interval = 5;
//设置X轴的时间显示格式为7-10 11：20
xaxis.ValueFormatString = "MM-dd HH时";
//给图标添加Axis
chart.AxesX.Add(xaxis);
Axis yAxis = new Axis();
//设置图标中Y轴的最小值永远为0
yAxis.AxisMinimum = 0;
//设置图表中Y轴的后缀
yAxis.Suffix = "mg/m3";
chart.AxesY.Add(yAxis);
// 创建一个新的数据线。
DataSeries dataSeries = new DataSeries();
DataSeries dataSeries2 = new DataSeries();
DataSeries dataSeries3 = new DataSeries();
// 设置数据线的格式。
dataSeries.LegendText = "二氧化硫标杆值";
dataSeries2.LegendText = "氮氧化物标杆值";
dataSeries3.LegendText = "颗粒标杆值";
dataSeries.RenderAs = RenderAs.QuickLine;//折线图
dataSeries2.RenderAs = RenderAs.QuickLine;
dataSeries3.RenderAs = RenderAs.QuickLine;
dataSeries.XValueType = ChartValueTypes.DateTime;
dataSeries2.XValueType = ChartValueTypes.DateTime;
dataSeries3.XValueType = ChartValueTypes.DateTime;
// 设置数据点
DataPoint dataPoint;
DataPoint dataPoint2;
DataPoint dataPoint3;
for (int i = 0; i < table.Rows.Count; i++)
{
// 创建一个数据点的实例。
dataPoint = new DataPoint();
dataPoint2 = new DataPoint();
dataPoint3 = new DataPoint();
// 设置X轴点
dataPoint.XValue = table.Rows[i][0];
dataPoint2.XValue = table.Rows[i][0];
dataPoint3.XValue = table.Rows[i][0];
//设置Y轴点
if ((table.Rows[i][6].ToString()) == "") { dataPoint.YValue = 0; }
else
{
dataPoint.YValue = double.Parse((table.Rows[i][6]).ToString());
}
if ((table.Rows[i][9].ToString()) == "") { dataPoint2.YValue = 0; }
else
{
dataPoint2.YValue = double.Parse((table.Rows[i][9]).ToString());
}
if ((table.Rows[i][3].ToString()) == "") { dataPoint3.YValue = 0; }
else
{
dataPoint3.YValue = double.Parse((table.Rows[i][3]).ToString());
}
//添加数据点
dataSeries.DataPoints.Add(dataPoint);
dataSeries2.DataPoints.Add(dataPoint2);
dataSeries3.DataPoints.Add(dataPoint3);
DoEvents();
}
// 添加数据线到数据序列。
chart.Series.Add(dataSeries);
chart.Series.Add(dataSeries2);
chart.Series.Add(dataSeries3);
//将生产的图表增加到Grid，然后通过Grid添加到上层Grid.
Grid gr = new Grid();
gr.Children.Add(chart);
zhexiantu.Children.Add(gr);
}
#endregion
------解决思路----------------------
别人肯定是不会把17W一下子全画出来的。
------解决思路----------------------
他处理肯定是10天每天取几条做为线的支点去画的，而不是17W条全取。
------解决思路----------------------
那你就要取每天的均值或取每天的 中间数 比如1天1000条，那取10条 就取 下标能被 100 整除的记录数就可以了