8,497
社区成员
发帖
与我相关
我的任务
分享
public IEnumerable<Models.Projects.Projects> GetList(Func<Models.Projects.Projects, bool> filter)
{
var query = (from t in Db.Projects
select new Models.Projects.Projects
{
ID = t.ID,
ItemCode = t.ItemCode,
ItemName = t.ItemName,
PItemCode = t.PItemCode,
CID = t.CID,
Responsible = t.Responsible,
PlanBeginDate = t.PlanBeginDate,
PlanEndDate = t.PlanEndDate,
ActualBeginDate = t.ActualBeginDate,
ActualEndDate = t.ActualEndDate,
Remark = t.Remark,
Creator = t.Creator,
CreateDate = t.CreateDate,
Version = t.Version,
Progress = (
from t0 in Db.Projects_Progress
where t0.ItemCode == t.ItemCode
select new
{
t0.Progress
}).Sum(p => p.Progress)
});
return query;
}
from t in Db.Projects
select new
{
T=t,
}
ToList 之后即真正计算之后,再转化为其他类型