public UserIntegralGroupModel GetUserHistroyIntegralGroup(long userId) { UserIntegralGroupModel userIntegralGroupModel = new UserIntegralGroupModel(); int?nullable = ( from a in context.MemberIntegralRecord where a.MemberId == userId && (int)a.TypeId == 6 select a).Sum <MemberIntegralRecord>((MemberIntegralRecord a) => (int?)a.Integral); userIntegralGroupModel.BindWxIntegral = nullable.GetValueOrDefault(); int?nullable1 = ( from a in context.MemberIntegralRecord where a.MemberId == userId && (int)a.TypeId == 7 select a).Sum <MemberIntegralRecord>((MemberIntegralRecord a) => (int?)a.Integral); userIntegralGroupModel.CommentIntegral = nullable1.GetValueOrDefault(); int?nullable2 = ( from a in context.MemberIntegralRecord where a.MemberId == userId && (int)a.TypeId == 1 select a).Sum <MemberIntegralRecord>((MemberIntegralRecord a) => (int?)a.Integral); userIntegralGroupModel.ConsumptionIntegral = nullable2.GetValueOrDefault(); int?nullable3 = ( from a in context.MemberIntegralRecord where a.MemberId == userId && (int)a.TypeId == 5 select a).Sum <MemberIntegralRecord>((MemberIntegralRecord a) => (int?)a.Integral); userIntegralGroupModel.LoginIntegral = nullable3.GetValueOrDefault(); int?nullable4 = ( from a in context.MemberIntegralRecord where a.MemberId == userId && (int)a.TypeId == 9 select a).Sum <MemberIntegralRecord>((MemberIntegralRecord a) => (int?)a.Integral); userIntegralGroupModel.RegIntegral = nullable4.GetValueOrDefault(); return(userIntegralGroupModel); }
public UserIntegralGroupModel GetUserHistroyIntegralGroup(long userId) { UserIntegralGroupModel model = new UserIntegralGroupModel(); model.BindWxIntegral = Context.MemberIntegralRecord.Where(a => a.MemberId == userId && a.TypeId == Himall.Model.MemberIntegral.IntegralType.BindWX).Sum(a => (int?)a.Integral).GetValueOrDefault();; model.CommentIntegral = Context.MemberIntegralRecord.Where(a => a.MemberId == userId && a.TypeId == Himall.Model.MemberIntegral.IntegralType.Comment).Sum(a => (int?)a.Integral).GetValueOrDefault(); model.ConsumptionIntegral = Context.MemberIntegralRecord.Where(a => a.MemberId == userId && a.TypeId == Himall.Model.MemberIntegral.IntegralType.Consumption).Sum(a => (int?)a.Integral).GetValueOrDefault(); model.LoginIntegral = Context.MemberIntegralRecord.Where(a => a.MemberId == userId && a.TypeId == Himall.Model.MemberIntegral.IntegralType.Login).Sum(a => (int?)a.Integral).GetValueOrDefault(); model.RegIntegral = Context.MemberIntegralRecord.Where(a => a.MemberId == userId && a.TypeId == Himall.Model.MemberIntegral.IntegralType.Reg).Sum(a => (int?)a.Integral).GetValueOrDefault(); model.SignIn = Context.MemberIntegralRecord.Where(a => a.MemberId == userId && a.TypeId == Himall.Model.MemberIntegral.IntegralType.SignIn).Sum(a => (int?)a.Integral).GetValueOrDefault(); model.InviteIntegral = Context.MemberIntegralRecord.Where(a => a.MemberId == userId && a.TypeId == Himall.Model.MemberIntegral.IntegralType.InvitationMemberRegiste).Sum(a => (int?)a.Integral).GetValueOrDefault(); return(model); }
public ActionResult IntegralRule() { UserIntegralGroupModel userHistroyIntegralGroup = ServiceHelper.Create <IMemberIntegralService>().GetUserHistroyIntegralGroup(base.CurrentUser.Id); return(View(userHistroyIntegralGroup)); }