public JsonResult GetMemberIntegralDetail(int page, int?userId, Himall.Entities.MemberIntegralInfo.IntegralType?type, DateTime?startDate, DateTime?endDate, int rows)
{
var query = new IntegralRecordQuery()
{
StartDate = startDate, EndDate = endDate, IntegralType = type, UserId = userId, PageNo = page, PageSize = rows
};
var result = _iMemberIntegralService.GetIntegralRecordList(query);
var list = result.Models.Select(item =>
{
var actions = _iMemberIntegralService.GetIntegralRecordAction(item.Id);
return(new
{
Id = item.Id,
UserName = item.UserName,
RecordDate = item.RecordDate.ToString("yyyy-MM-dd HH:mm:ss"),
Integral = item.Integral,
Type = item.TypeId.ToDescription(),
Remark = GetRemarkFromIntegralType(item.TypeId, actions, item.ReMark)
});
});
var model = new { rows = list, total = result.Total };
return(Json(model));
}
/// <summary>
/// 获取用户积分明细
/// </summary>
/// <param name="id">用户编号</param>
/// <param name="type"></param>
/// <param name="pageSize"></param>
/// <param name="pageNo"></param>
/// <returns></returns>
public QueryPageModel <UserCenterGetIntegralRecordModel> GetIntegralRecord(MemberIntegral.IntegralType?type = null, int page = 1, int pagesize = 10)
{
CheckUserLogin();
var id = CurrentUser.Id;
//处理当前用户与id的判断
var _iMemberIntegralService = ServiceHelper.Create <IMemberIntegralService>();
Himall.Model.MemberIntegral.IntegralType?integralType = type;
var query = new IntegralRecordQuery()
{
IntegralType = integralType, UserId = id, PageNo = page, PageSize = pagesize
};
var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query);
var list = result.Models.ToList().Select(item => new UserCenterGetIntegralRecordModel
{
Id = item.Id,
RecordDate = item.RecordDate,
Integral = item.Integral,
TypeId = item.TypeId,
ShowType = item.TypeId.ToDescription(),
ReMark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark)
});
QueryPageModel <UserCenterGetIntegralRecordModel> pageresult = new QueryPageModel <UserCenterGetIntegralRecordModel>();
pageresult.Total = result.Total;
pageresult.Models = list.ToList();
return(pageresult);
}
public JsonResult <Result <dynamic> > GetIntegralRecordList(string openId, int pageNo = 1, int pageSize = 10)
{
CheckUserLogin();
IntegralRecordQuery query = new IntegralRecordQuery
{
UserId = CurrentUserId,
PageNo = pageNo,
PageSize = pageSize
};
var list = MemberIntegralApplication.GetIntegralRecordList(query);
if (list.Models != null)
{
var recordlist = list.Models.Select(a =>
{
var actions = ServiceProvider.Instance <IMemberIntegralService> .Create.GetIntegralRecordAction(a.Id);
return(new
{
Id = a.Id,
MemberId = a.MemberId,
UserName = a.UserName,
TypeName = (a.TypeId == MemberIntegralInfo.IntegralType.WeiActivity) ? a.ReMark : a.TypeId.ToDescription(),
Integral = a.Integral,
RecordDate = ((DateTime)a.RecordDate).ToString("yyyy-MM-dd HH:mm:ss"),
ReMark = GetRemarkFromIntegralType(a.TypeId, actions, a.ReMark)
});
});
return(JsonResult <dynamic>(recordlist));
}
return(JsonResult <dynamic>(new int[0]));
}
public JsonResult GetMemberIntegralDetail(int page, int?userId, MemberIntegral.IntegralType?type, DateTime?startDate, DateTime?endDate, int rows)
{
long?nullable;
IntegralRecordQuery integralRecordQuery = new IntegralRecordQuery()
{
StartDate = startDate,
EndDate = endDate,
IntegralType = type
};
IntegralRecordQuery integralRecordQuery1 = integralRecordQuery;
int?nullable1 = userId;
if (nullable1.HasValue)
{
nullable = new long?(nullable1.GetValueOrDefault());
}
else
{
nullable = null;
}
integralRecordQuery1.UserId = nullable;
integralRecordQuery.PageNo = page;
integralRecordQuery.PageSize = rows;
PageModel <MemberIntegralRecord> integralRecordList = ServiceHelper.Create <IMemberIntegralService>().GetIntegralRecordList(integralRecordQuery);
var list =
from item in integralRecordList.Models.ToList()
select new { Id = item.Id, UserName = item.UserName, RecordDate = item.RecordDate.Value.ToString("yyyy-MM-dd HH:mm:ss"), Integral = item.Integral, Type = item.TypeId.ToDescription(), Remark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark) };
return(Json(new { rows = list, total = integralRecordList.Total }));
}
/// <summary>
/// 获取用户积分明细
/// </summary>
/// <param name="id">用户编号</param>
/// <param name="type"></param>
/// <param name="pageSize"></param>
/// <param name="pageNo"></param>
/// <returns></returns>
public object GetIntegralRecord(Himall.Entities.MemberIntegralInfo.IntegralType?type = null, int page = 1, int pagesize = 10)
{
CheckUserLogin();
//处理当前用户与id的判断
var _iMemberIntegralService = ServiceApplication.Create <IMemberIntegralService>();
var query = new IntegralRecordQuery()
{
IntegralType = type, UserId = CurrentUser.Id, PageNo = page, PageSize = pagesize
};
var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query);
var list = result.Models.Select(item => {
var actions = _iMemberIntegralService.GetIntegralRecordAction(item.Id);
return(new UserCenterGetIntegralRecordModel
{
Id = item.Id,
RecordDate = item.RecordDate,
Integral = item.Integral,
TypeId = item.TypeId,
ShowType = (item.TypeId == MemberIntegralInfo.IntegralType.WeiActivity) ? item.ReMark : item.TypeId.ToDescription(),
ReMark = GetRemarkFromIntegralType(item.TypeId, actions, item.ReMark)
});
});
dynamic pageresult = SuccessResult();
pageresult.total = result.Total;
pageresult.data = list.ToList();
return(pageresult);
}
public QueryPageModel <MemberIntegralRecordInfo> GetIntegralRecordList(IntegralRecordQuery query)
{
//int total = 0;
//IQueryable<MemberIntegralRecord> list = Context.MemberIntegralRecord.AsQueryable();
var list = DbFactory.Default.Get <MemberIntegralRecordInfo>();
if (query.UserId.HasValue)
{
list.Where(item => item.MemberId == query.UserId.Value);
}
if (query.StartDate.HasValue)
{
list.Where(item => query.StartDate <= item.RecordDate);
}
if (query.IntegralType.HasValue)
{
list.Where(item => item.TypeId == query.IntegralType.Value);
}
if (query.EndDate.HasValue)
{
list.Where(item => query.EndDate >= item.RecordDate);
}
//list = list.GetPage(d => d.OrderByDescending(o => o.Id), out total, query.PageNo, query.PageSize);
var model = list.OrderByDescending(o => o.Id).ToPagedList(query.PageNo, query.PageSize);
QueryPageModel <MemberIntegralRecordInfo> pageModel = new QueryPageModel <MemberIntegralRecordInfo>()
{
Models = model, Total = model.TotalRecordCount
};
return(pageModel);
}
public ActionResult Index(int?type, int pageSize = 10, int pageNo = 1)
{
int num;
int num1;
MemberIntegralExchangeRules integralChangeRule = ServiceHelper.Create <IMemberIntegralService>().GetIntegralChangeRule();
dynamic viewBag = base.ViewBag;
num = (integralChangeRule == null ? 0 : integralChangeRule.IntegralPerMoney);
viewBag.IntegralPerMoney = num;
MemberIntegral memberIntegral = ServiceHelper.Create <IMemberIntegralService>().GetMemberIntegral(base.CurrentUser.Id);
dynamic obj = base.ViewBag;
num1 = (memberIntegral == null ? 0 : memberIntegral.AvailableIntegrals);
obj.Integral = num1;
MemberIntegral.IntegralType?nullable = null;
if (type.HasValue)
{
nullable = new MemberIntegral.IntegralType?((MemberIntegral.IntegralType)type.Value);
}
IntegralRecordQuery integralRecordQuery = new IntegralRecordQuery()
{
IntegralType = nullable,
UserId = new long?(base.CurrentUser.Id),
PageNo = pageNo,
PageSize = pageSize
};
PageModel <MemberIntegralRecord> integralRecordList = ServiceHelper.Create <IMemberIntegralService>().GetIntegralRecordList(integralRecordQuery);
IEnumerable <MemberIntegralRecord> list =
from item in integralRecordList.Models.ToList()
select new MemberIntegralRecord()
{
Id = item.Id,
UserName = item.UserName,
RecordDate = item.RecordDate,
Integral = item.Integral,
TypeId = item.TypeId,
ReMark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark)
};
PagingInfo pagingInfo = new PagingInfo()
{
CurrentPage = pageNo,
ItemsPerPage = pageSize,
TotalItems = integralRecordList.Total
};
ViewBag.pageInfo = pagingInfo;
return(View(list));
}
// GET: Web/UserIntegral
public ActionResult Index(int?type, int pageSize = 10, int pageNo = 1)
{
var model = _iMemberIntegralService.GetIntegralChangeRule();
ViewBag.IntegralPerMoney = model == null ? 0 : model.IntegralPerMoney;
ViewBag.Integral = MemberIntegralApplication.GetAvailableIntegral(CurrentUser.Id);
Mall.Entities.MemberIntegralInfo.IntegralType?integralType = null;
if (type.HasValue)
{
integralType = (Mall.Entities.MemberIntegralInfo.IntegralType)type.Value;
}
var query = new IntegralRecordQuery()
{
IntegralType = integralType, UserId = CurrentUser.Id, PageNo = pageNo, PageSize = pageSize
};
var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query);
var list = result.Models.Select(item => {
var actions = _iMemberIntegralService.GetIntegralRecordAction(item.Id);
return(new MemberIntegralRecordInfo
{
Id = item.Id,
UserName = item.UserName,
RecordDate = item.RecordDate,
Integral = item.Integral,
TypeId = item.TypeId,
ReMark = GetRemarkFromIntegralType(item.TypeId, actions, item.ReMark)
});
});
PagingInfo info = new PagingInfo
{
CurrentPage = pageNo,
ItemsPerPage = pageSize,
TotalItems = result.Total
};
ViewBag.pageInfo = info;
ViewBag.Keyword = string.IsNullOrWhiteSpace(SiteSettings.SearchKeyword) ? SiteSettings.Keyword : SiteSettings.SearchKeyword;
ViewBag.Keywords = SiteSettings.HotKeyWords;
return(View(list));
}
public PageModel <MemberIntegralRecord> GetIntegralRecordList(IntegralRecordQuery query)
{
int num = 0;
IQueryable <MemberIntegralRecord> memberId = context.MemberIntegralRecord.AsQueryable <MemberIntegralRecord>();
if (query.UserId.HasValue)
{
memberId =
from item in memberId
where item.MemberId == query.UserId.Value
select item;
}
if (query.StartDate.HasValue)
{
memberId =
from item in memberId
where query.StartDate <= item.RecordDate
select item;
}
if (query.IntegralType.HasValue)
{
memberId =
from item in memberId
where (int)item.TypeId == (int)query.IntegralType.Value
select item;
}
if (query.EndDate.HasValue)
{
memberId =
from item in memberId
where query.EndDate >= item.RecordDate
select item;
}
memberId = memberId.GetPage(out num, query.PageNo, query.PageSize, null);
return(new PageModel <MemberIntegralRecord>()
{
Models = memberId,
Total = num
});
}
// GET: Web/UserIntegral
public ActionResult Index(int?type, int pageSize = 10, int pageNo = 1)
{
var model = _iMemberIntegralService.GetIntegralChangeRule();
ViewBag.IntegralPerMoney = model == null ? 0 : model.IntegralPerMoney;
var memberIntegral = _iMemberIntegralService.GetMemberIntegral(CurrentUser.Id);
ViewBag.Integral = memberIntegral == null ? 0 : memberIntegral.AvailableIntegrals;
Himall.Model.MemberIntegral.IntegralType?integralType = null;
if (type.HasValue)
{
integralType = (Himall.Model.MemberIntegral.IntegralType)type.Value;
}
var query = new IntegralRecordQuery()
{
IntegralType = integralType, UserId = CurrentUser.Id, PageNo = pageNo, PageSize = pageSize
};
var result = _iMemberIntegralService.GetIntegralRecordListForWeb(query);
var list = result.Models.ToList().Select(item => new MemberIntegralRecord
{
Id = item.Id,
UserName = item.UserName,
RecordDate = item.RecordDate,
Integral = item.Integral,
TypeId = item.TypeId,
ReMark = GetRemarkFromIntegralType(item.TypeId, item.Himall_MemberIntegralRecordAction, item.ReMark)
});
PagingInfo info = new PagingInfo
{
CurrentPage = pageNo,
ItemsPerPage = pageSize,
TotalItems = result.Total
};
ViewBag.pageInfo = info;
return(View(list));
}
/// <summary>
/// 获取单个用户的积分记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static QueryPageModel <MemberIntegralRecordInfo> GetIntegralRecordList(IntegralRecordQuery query)
{
return(_iMemberIntegralService.GetIntegralRecordList(query));
}
/// <summary>
/// 获取单个用户的积分记录,前台使用
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static ObsoletePageModel <MemberIntegralRecord> GetIntegralRecordListForWeb(IntegralRecordQuery query)
{
return(_iMemberIntegralService.GetIntegralRecordListForWeb(query));
}
