public IActionResult List(PublicityInfoRequestPayload payload)
{
using (_dbContext)
{
var query = from p in _dbContext.Promo
//orderby p.ReleaseTime descending
where p.IsDeleted == 0
select new
{
p.PromoUuid,
p.Content,
p.Title,
ReleaseTime = p.ReleaseTime.Value.ToString("yyyy-MM-dd"),
p.IsDeleted,
};
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => x.IsDeleted == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted)));
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:党建宣传活动信息数据", _dbContext);
return(Ok(response));
}
}
public IActionResult List(PublicityInfoRequestPayload payload)
{
var query = from c in _dbContext.PromoTeam
where c.IsDeleted == 0
select new
{
c.Id,
c.TeamCaptain,
//c.TeamChengyuan,
c.PromoTeamUuid,
//c.TeamType,
c.IsDeleted,
c.Cunz,
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.TeamCaptain.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => x.IsDeleted == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted)));
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:党建宣传小队信息数据", _dbContext);
return(Ok(response));
}
