/// <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)); }