/// <summary>
/// 获取回帖的管理列表
/// </summary>
/// <param name="tenantTypeId">租户类型Id</param>
/// <param name="query">帖子查询条件</param>
/// <param name="pageSize">每页多少条数据</param>
/// <param name="pageIndex">页码</param>
/// <returns>帖子分页集合</returns>
public PagingDataSet <BarPost> Gets(string tenantTypeId, BarPostQuery query, int pageSize, int pageIndex)
{
//当SubjectKeyword、StartDate、EndDate为null时，进行缓存
//当SectionId不为null时，使用分区版本，分区名为：SectionId，否则使用全局版本
//缓存周期：对象集合，需要维护即时性
//使用用户选择器设置query.UserId参数
//排序：发布时间（倒序）
var sql = Sql.Builder;
sql.Select("*")
.From("spb_BarPosts")
.Where("TenantTypeId = @0", tenantTypeId);
if (query.UserId != null && query.UserId > 0)
{
sql.Where("UserId = @0", query.UserId);
}
if (query.SectionId != null && query.SectionId > 0)
{
sql.Where("SectionId = @0", query.SectionId);
}
if (query.AuditStatus != null)
{
sql.Where("AuditStatus = @0", query.AuditStatus);
}
if (!string.IsNullOrEmpty(query.PostKeyword))
{
sql.Where("Body like @0", "%" + StringUtility.StripSQLInjection(query.PostKeyword) + "%");
}
if (query.StartDate != null)
{
sql.Where("DateCreated >= @0", query.StartDate);
}
if (query.EndDate != null)
{
sql.Where("DateCreated < @0", query.EndDate.Value.AddDays(1));
}
sql.OrderBy("PostId desc");
return(GetPagingEntities(pageSize, pageIndex, sql));
}
/// <summary>
/// 获取回帖的管理列表
/// </summary>
/// <param name="tenantTypeId">租户类型Id</param>
/// <param name="query">帖子查询条件</param>
/// <param name="pageSize">每页多少条数据</param>
/// <param name="pageIndex">页码</param>
/// <returns>帖子分页集合</returns>
public PagingDataSet <BarPost> Gets(string tenantTypeId, BarPostQuery query, int pageSize, int pageIndex)
{
return(barPostRepository.Gets(tenantTypeId, query, pageSize, pageIndex));
}
