转换为IQueryable结果集



我们返回completedFilters.Select(GetFilterDetailDril)

我们在GetFilterDetailDril中有非常复杂的逻辑,它调用了很多函数。在没有调用函数的情况下,不可能将所有这些都写在行select中——问题是我们希望稍后导出它,并且我们应该知道它将是可查询的。但是,如果我们调用函数,c就不能再使其可查询了。有解决方案吗?

这就是我退回的

return filtersInDevelopment.Select(GetFilterDetailDrillDownModel)

这是的功能

private FilterDevDetailDrillDownModel GetFilterDetailDrillDownModel(ALFilters alFilters)
{
alFilters = (alFilters.IsSample == 1 && alFilters.DestFilters.FirstOrDefault() != null) 
? alFilters.DestFilters.FirstOrDefault() : alFilters;
var alFiltersDevelopment = alFilters.AlFiltersDevelopment.FirstOrDefault();
if (alFiltersDevelopment != null)
{
var repository = new FilterRepository();
var adt = alFiltersDevelopment.Adt ?? repository.GetAdt(alFilters);
var edt = alFiltersDevelopment.Edt ?? repository.GetEdt(alFilters);
var filterActiveMilestone = alFilters.FilterActiveMilestone;
var milestoneTargetDate = (filterActiveMilestone != null)
? filterActiveMilestone.TargetDate
: repository.GetFilterActiveMilestoneTargetDate(alFilters);
var firstDevMilestone = alFilters.FilterMilestones.FirstOrDefault(
x => x.MilestoneTypeId == FilterConst.START_DEVELOPMENT_MILESTONE);
var startDevTime = (firstDevMilestone != null)
? firstDevMilestone.MilestoneDate
: (DateTime?) null;
string milestoneNmae = (filterActiveMilestone != null)
? filterActiveMilestone.dic_MilestoneTypes.NameForReport
: string.Empty;
double remainingMilestoneTime = (milestoneTargetDate.HasValue)
? milestoneTargetDate.Value.Subtract(DateTime.Now).Days
: 0;
double delayedTime = (edt != null && adt != null)
? adt.Value.Subtract(edt.Value).Days
: 0 ;
var site = db.dic_AL_Sites.Find(alFilters.SiteId);
return new FilterDevDetailDrillDownModel
{
FilterId = alFilters.ID,
Filter = alFilters.FilterCode,
StartDevDate = startDevTime,
MilelstoneName = milestoneNmae,
RemainingMilestoneTime = remainingMilestoneTime,
MilestoneEstimatedFinishDate = milestoneTargetDate,
EstimatedDevelopmentTime = alFiltersDevelopment.Edt,
DelayedTime = delayedTime,
Site = (site != null) ? site.Site_Name : string.Empty
};
}
return null;
}

很多逻辑。。。我想要可查询的返回,但这是不可查询的。此筛选器不可开发。Select(GetFilterDetailDrillDownModel)是可枚举的,不可能查看查询:(

实现IEnumerable<T>接口的类型可以通过调用AsQueryable<T>扩展方法转换为IQueryable<T>

http://msdn.microsoft.com/en-us/library/bb507003(v=vs.110).aspx

还有一个非通用的等价物:

http://msdn.microsoft.com/en-us/library/bb353734(v=vs.110).aspx

最新更新