有个页面，有3张图表，我的绑定数据方法是把3个图表取完后放到一个大对象上，

我开发机器测试很快，但是连接服务器数据库就要好几秒，求高手指点优化方法，

取代码如下：

public static PictureDataModel GetAffairRankDataDay(DateTime firstDay)
{
var lastDay = firstDay.AddDays(1);

var selectedArea = Storage.Areas.FirstOrDefault(p => p.AreaId == Storage.SelectedAreaId);
//获取所有子节点
var childrenAreaId = AreaHelper.GetGrandChild(selectedArea).Select(x => x.AreaId);

//以上数据不操作数据库的

_db = new YmsDb();
var columnData = (from ai in _db.AffairsInfo
join a in _db.Affairs on ai.AffairId equals a.AffairId
where childrenAreaId.Contains(ai.AreaId) &&
ai.LastTransTime > firstDay && ai.LastTransTime < lastDay
group ai by new { a.AffairId, a.AffairName }
into g
select new ChartDataClass
{
Id = g.Key.AffairId,
XValue = g.Key.AffairName,
YValue = (double?)g.Count()
}).OrderByDescending(x => x.YValue).Take(10).ToList();

var pieData = (from ai in _db.AffairsInfo
join a in _db.Affairs on ai.AffairId equals a.AffairId
join w in _db.Window on a.WindowId equals w.WindowId
join l in _db.AffairLine on w.AffairLineId equals l.AffairLineId
where childrenAreaId.Contains(ai.AreaId) &&
ai.LastTransTime > firstDay && ai.LastTransTime < lastDay
group ai by new { l.AffairLineId, l.AffairLineName }
into g
select new ChartDataClass
{
Id = g.Key.AffairLineId,
XValue = g.Key.AffairLineName,
YValue = (double?)g.Count()
}).OrderByDescending(x => x.YValue).Take(10).ToList();

var affairInfoCount = from ai in _db.AffairsInfo.AsEnumerable()
join a in _db.Affairs on ai.AffairId equals a.AffairId

where childrenAreaId.Contains(ai.AreaId) &&
ai.LastTransTime > firstDay && ai.LastTransTime < lastDay && ai.LastTransTime.HasValue
group ai by ai.LastTransTime.Value.Hour
into g
select new { Hour = g.Key, ValueInt = g.Count() };
var lineData = WorkTimer.Select(hour =>
new ChartDataClass
{
XValue = hour + ":00",
YValue = affairInfoCount.Where(p => p.Hour == hour).Select(p => p.ValueInt).Sum()
}).ToList();

var countAllTime = affairInfoCount.Select(p => p.ValueInt).DefaultIfEmpty().Sum();

var countOnWorkTime = (int)lineData.Sum(x => x.YValue.GetValueOrDefault());

var chartDataOtherTime = new ChartDataClass
{
XValue = "其他时段",
YValue = countAllTime - countOnWorkTime
};

lineData.Add(chartDataOtherTime);

var obj = new PictureDataModel();
obj.ColumnData = columnData;
obj.PieData = pieData;
obj.LineData = lineData;
return obj;
}

绑定控件代码如下：

private void BindDataByDay()
{

LoadingBar.IsBusy = true;
Common.RunAsyncTask(
() =>
{
//Storage.SelectedAreaAffairInfo = AffairsInfoHelper.GetAffairInfoByDay(_chooseDate);

//_columnData = AffairsInfoHelper.GetAffairInfoCount();

//_lineData = AffairsInfoHelper.GetAffairInfoCountByDay();

//_pieData = AffairsInfoHelper.GetLineAffairInfoCount();
var obj = AffairsInfoHelper.GetAffairRankDataDay(_chooseDate);
_columnData = obj.ColumnData;
_lineData = obj.LineData;
_pieData = obj.PieData;
},
() =>
{
ChartColumn.ItemsSource = _columnData;

ChartLine.ItemsSource = _lineData;

ChartPie.ItemsSource = _pieData;

LoadingBar.IsBusy = false;
});
}