8,493
社区成员




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()
};