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