8,497
社区成员
发帖
与我相关
我的任务
分享
var result=from u in db.Table
group u by new
{
u.Name,
u.IsActive
}
into g
select new
{
DaySum =g.Sum(c=>c.Quantity),
MonthSum =(from n in g
where n.Date.AddDays(-yourDate.Day)<n.Date<yourDate
select n.Quantity).Sum(),
YearSum=(from n in g
where n.Date.AddMonths(-yourDate.Month).AddDays(-yourDate.Day)<n.Date<yourDate
select n.Quantity).Sum()
};