public JsonResult List(WeiActivityQuery query)
{
query.Type = WeiActivityType.ScratchCard;
var result = WeiActivityApplication.Get(query);
return(Json(result));
}
public static QueryPageModel <WeiActivityModel> Get(WeiActivityQuery query)
{
QueryPageModel <Entities.WeiActivityInfoInfo> weiInfo = Service.Get(query);
var datas = weiInfo.Models.ToList().Select(m => new WeiActivityModel()
{
Id = m.Id,
activityTitle = m.ActivityTitle,
activityType = (WeiActivityType)m.ActivityType,
activityDetails = m.ActivityDetails,
activityUrl = HimallIO.GetImagePath(m.ActivityUrl),
beginTime = m.BeginTime,
endTime = m.EndTime,
participationType = (WeiParticipateType)m.ParticipationType,
participationCount = Convert.ToInt32(m.ParticipationCount),
consumePoint = m.ConsumePoint,
codeUrl = m.CodeUrl,
addDate = m.AddDate,
totalNumber = GetWinNumber(m.Id, "ALL"),
winNumber = GetWinNumber(m.Id, "True")
}).ToList();
QueryPageModel <WeiActivityModel> t = new QueryPageModel <WeiActivityModel>();
t.Models = datas;
t.Total = weiInfo.Total;
return(t);
}
public QueryPageModel <WeiActivityInfoInfo> Get(WeiActivityQuery query)
{
var db = DbFactory.Default.Get <WeiActivityInfoInfo>();
if (!string.IsNullOrWhiteSpace(query.Name))
{
db.Where(p => p.ActivityTitle.Contains(query.Name));
}
if (query.IsIntegralActivity.HasValue)
{
if (query.IsIntegralActivity.Value)
{
db.Where(d => d.ConsumePoint > 0);
}
else
{
db.Where(d => d.ConsumePoint == 0);
}
}
if (!query.IsShowAll)
{
db.Where(d => d.BeginTime < DateTime.Now && d.EndTime > DateTime.Now);//取有效期内活动
}
db.Where(p => p.ActivityType == (int)query.Type);
db.Select();
switch (query.Sort.ToLower())
{
//case "totalnumber": break;
//case "winnumber":
//var winNumber = DbFactory.Default.Get<WeiActivityWinInfoInfo>()
// .Where(p => p.IsWin == true)
// .GroupBy(p => p.UserId)
// .Having<WeiActivityInfoInfo>((w, a) => w.ActivityId == a.Id)
// .Select(p => p.ExCount(false)).Continue();
//db.Select(p => new { winNumber = winNumber.ExResolve<long>() });
//if (query.IsAsc) db.OrderBy(p => "winNumber");
//else db.OrderByDescending(p => "winNumber");
//break;
default:
db.OrderByDescending(o => o.AddDate);
break;
}
var data = db.ToPagedList(query.PageNo, query.PageSize);
return(new QueryPageModel <WeiActivityInfoInfo>()
{
Models = data,
Total = data.TotalRecordCount
});
}
public JsonResult GetRouletteList(string name, int page = 1, int rows = 10)
{
var query = new WeiActivityQuery {
Name = name,
Type = WeiActivityType.Roulette,
IsIntegralActivity = true,
IsShowAll = false,
PageNo = page,
PageSize = rows
};
var result = WeiActivityApplication.Get(query);
return(Json(new { rows = result.Models, total = result.Total }));
}
public JsonResult GetScratchCardList(string name, int page = 1, int rows = 10)
{
var query = new WeiActivityQuery
{
Name = name,
Type = WeiActivityType.ScratchCard,
IsIntegralActivity = true,
IsShowAll = false,
PageNo = page,
PageSize = rows
};
var result = WeiActivityApplication.Get(query);
return(Json(new { rows = result.Models, total = result.Total }, JsonRequestBehavior.AllowGet));
}
