public HttpResponseMessage GetCrowdInfo(int status = -1)
{
//查询项目表所有的数据
var sech = new CrowdSearchCondition
{
OrderBy = EnumCrowdSearchOrderBy.OrderById,
Statuss = status
};
var list = _crowdService.GetCrowdsByCondition(sech).Select(p => new
{
//项目表
p.Ttitle,
p.Id,
p.Status,
p.Intro,
p.Starttime,
p.Endtime,
p.Uptime,
p.Upuser,
p.Adduser,
p.Addtime,
p.crowdUrl
}).ToList().Select(a => new
{
//返回数据
Id = a.Id,
Ttitle = a.Ttitle,
Intro = a.Intro,
Endtime = a.Endtime,
Starttime = a.Starttime,
Status = a.Status,
ImgList = _partImageService.GetPartImageByCrowdId(a.Id),//查询众筹对应的图片
// Dislist = _discountService.GetDiscountByCrowdId(a.Id),//查询众筹人数
////已参与众筹人数
//crowdNum = _participationService.GetParticipationCountByCrowdId(a.Id),
////众筹最低优惠对应的人数
//crowdMaxNum = _discountService.GetDiscountMaxCountByCrowdId(a.Id),
crowdUrl = a.crowdUrl,
//Addtime=a.Addtime.ToString("yyyy-MM-dd") ,
Addtime = a.Addtime.ToString("yyyy-MM-dd"),
i = 0
});
//.Where(p => p.crowdMaxNum != 0);
return PageHelper.toJson(new { list });
}
public ActionResult crowd()
{
//查询项目表所有的数据
var sech = new CrowdSearchCondition
{
OrderBy = EnumCrowdSearchOrderBy.OrderById,
//Statuss = new[] { status }
};
var list = _crowdService.GetCrowdsByCondition(sech).Select(p => new
{
//项目表
p.Ttitle,
p.Id,
p.Status,
p.Intro,
p.Starttime,
p.Endtime,
p.Uptime,
p.Upuser,
p.Adduser,
p.Addtime
}).ToList().Select(a => new CrowdModel
{
//返回数据
Id = a.Id,
Ttitle = a.Ttitle,
Intro = a.Intro,
Endtime = a.Endtime,
Starttime = a.Starttime,
Status = a.Status,
ImgList = _partImageService.GetPartImageByCrowdId(a.Id),
Dislist = _discountService.GetDiscountByCrowdId(a.Id),
//已参与众筹人数
crowdNum = _participationService.GetParticipationCountByCrowdId(a.Id),
//众筹最低优惠对应的人数
crowdMaxNum = _discountService.GetDiscountMaxCountByCrowdId(a.Id),
}).Where (p=>p.crowdMaxNum !=0);
return View(list);
}
public IQueryable<CrowdEntity> GetCrowdsByCondition(CrowdSearchCondition condition)
{
var query = _crowdRepository.Table;
try
{
if (condition.StarttimeBegin.HasValue)
{
query = query.Where(q => q.Starttime>= condition.StarttimeBegin.Value);
}
if (condition.Id >0)
{
query = query.Where(q => q.Id ==condition .Id );
}
if (condition.StarttimeEnd.HasValue)
{
query = query.Where(q => q.Starttime < condition.StarttimeEnd.Value);
}
if (condition.EndtimeBegin.HasValue)
{
query = query.Where(q => q.Endtime>= condition.EndtimeBegin.Value);
}
if (condition.EndtimeEnd.HasValue)
{
query = query.Where(q => q.Endtime < condition.EndtimeEnd.Value);
}
if (condition.AddtimeBegin.HasValue)
{
query = query.Where(q => q.Addtime>= condition.AddtimeBegin.Value);
}
if (condition.AddtimeEnd.HasValue)
{
query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value);
}
if (condition.UptimeBegin.HasValue)
{
query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value);
}
if (condition.UptimeEnd.HasValue)
{
query = query.Where(q => q.Uptime < condition.UptimeEnd.Value);
}
if (!string.IsNullOrEmpty(condition.Ttitle))
{
query = query.Where(q => q.Ttitle.Contains(condition.Ttitle));
}
if (!string.IsNullOrEmpty(condition.Intro))
{
query = query.Where(q => q.Intro.Contains(condition.Intro));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.Statuss>=0)
{
query = query.Where(q => condition.Statuss==q.Status);
}
if (condition.Addusers != null && condition.Addusers.Any())
{
query = query.Where(q => condition.Addusers.Contains(q.Adduser));
}
if (condition.Upusers != null && condition.Upusers.Any())
{
query = query.Where(q => condition.Upusers.Contains(q.Upuser));
}
if(condition.OrderBy.HasValue)
{
switch (condition.OrderBy.Value)
{
case EnumCrowdSearchOrderBy.OrderById:
query = condition.IsDescending?query.OrderByDescending(q=>q.Id):query.OrderBy(q=>q.Id);
break;
}
}
else
{
query = query.OrderBy(q=>q.Id);
}
if (condition.Page.HasValue && condition.PageCount.HasValue)
{
query = query.Skip((condition.Page.Value - 1)*condition.PageCount.Value).Take(condition.PageCount.Value);
}
return query;
}
catch(Exception e)
{
_log.Error(e,"数据库操作出错");
return null;
}
}
public int GetCrowdCount (CrowdSearchCondition condition)
{
var query = _crowdRepository.Table;
try
{
if (condition.StarttimeBegin.HasValue)
{
query = query.Where(q => q.Starttime>= condition.StarttimeBegin.Value);
}
if (condition.StarttimeEnd.HasValue)
{
query = query.Where(q => q.Starttime < condition.StarttimeEnd.Value);
}
if (condition.EndtimeBegin.HasValue)
{
query = query.Where(q => q.Endtime>= condition.EndtimeBegin.Value);
}
if (condition.EndtimeEnd.HasValue)
{
query = query.Where(q => q.Endtime < condition.EndtimeEnd.Value);
}
if (condition.AddtimeBegin.HasValue)
{
query = query.Where(q => q.Addtime>= condition.AddtimeBegin.Value);
}
if (condition.AddtimeEnd.HasValue)
{
query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value);
}
if (condition.UptimeBegin.HasValue)
{
query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value);
}
if (condition.UptimeEnd.HasValue)
{
query = query.Where(q => q.Uptime < condition.UptimeEnd.Value);
}
if (!string.IsNullOrEmpty(condition.Ttitle))
{
query = query.Where(q => q.Ttitle.Contains(condition.Ttitle));
}
if (!string.IsNullOrEmpty(condition.Intro))
{
query = query.Where(q => q.Intro.Contains(condition.Intro));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.Statuss>=0)
{
query = query.Where(q => condition.Statuss==q.Status);
}
if (condition.Addusers != null && condition.Addusers.Any())
{
query = query.Where(q => condition.Addusers.Contains(q.Adduser));
}
if (condition.Upusers != null && condition.Upusers.Any())
{
query = query.Where(q => condition.Upusers.Contains(q.Upuser));
}
return query.Count();
}
catch(Exception e)
{
_log.Error(e,"数据库操作出错");
return -1;
}
}