public ActionResult SystemIncomeStatic(SystemIncomeStaticModel model) { var query = from si in db.SystemIncomeHistory select si; if (model.ComeType != 0) { switch (model.ComeType) { case 1: query = query.Where(p => p.ComeFrom == "充值奖励"); break; case 2: query = query.Where(p => p.ComeFrom == "红包服务费"); break; } } if (model.Time != null) { if (model.Time.Start.HasValue) { query = query.Where(p => p.CreateAt >= model.Time.Start.Value); } if (model.Time.End.HasValue) { query = query.Where(p => p.CreateAt <= model.Time.End.Value); } } model.IncomeList = query.ToList(); model.TotalIncomeValue = model.IncomeList.Sum(p => p.IncomeValue); return(View(model)); }
public ActionResult SystemIncomeStatic() { SystemIncomeStaticModel model = new SystemIncomeStaticModel(); model.IncomeList = db.SystemIncomeHistory.ToList(); model.TotalIncomeValue = model.IncomeList.Sum(p => p.IncomeValue); return(View(model)); }