/// <summary>
/// 获取操作对象的Id集合
/// </summary>
/// <param name="tenantTypeId">租户类型Id</param>
///<param name="sortBy">顶踩排序字段</param>
///<param name="pageSize">每页的内容数</param>
///<param name="pageIndex">页码</param>
public PagingEntityIdCollection GetObjectIds(string tenantTypeId, SortBy_Attitude sortBy, int pageSize, int pageIndex)
{
var sql = Sql.Builder;
sql.Select("ObjectId")
.From("tn_Attitudes")
.Where("TenantTypeId = @0", tenantTypeId);
//是否按综合评价取倒序列表
if (sortBy == SortBy_Attitude.Comprehensive_Desc)
{
sql.OrderBy("Comprehensive DESC ");
}
else
{
sql.OrderBy("SupportCount DESC ");
}
PagingEntityIdCollection objectIds = null;
string cacheKey = GetCacheKey_ObjectIds(tenantTypeId, sortBy);
objectIds = cacheService.Get <PagingEntityIdCollection>(cacheKey);
if (objectIds == null)
{
objectIds = CreateDAO().FetchPagingPrimaryKeys(PrimaryMaxRecords, pageSize, pageIndex, "ObjectId", sql);
cacheService.Add(cacheKey, objectIds, CachingExpirationType.ObjectCollection);
}
return(objectIds);
}
/// <summary>
/// 获取操作对象的Id集合
/// </summary>
///<param name="sortBy">顶踩排序字段</param>
///<param name="pageSize">每页的内容数</param>
///<param name="pageIndex">页码</param>
public PagingEntityIdCollection GetPageObjectIds(SortBy_Attitude sortBy, int pageSize, int pageIndex)
{
return attitudeRepository.GetObjectIds(tenantTypeId, sortBy, pageSize, pageIndex);
}
/// <summary>
/// 获取操作对象的Id集合
/// </summary>
///<param name="sortBy">顶踩排序字段</param>
///<param name="pageSize">每页的内容数</param>
///<param name="pageIndex">页码</param>
public PagingEntityIdCollection GetPageObjectIds(SortBy_Attitude sortBy, int pageSize, int pageIndex)
{
return(attitudeRepository.GetObjectIds(tenantTypeId, sortBy, pageSize, pageIndex));
}
/// <summary>
/// 获取操作Id集合的CacheKey
/// </summary>
/// <param name="tenantTypeId"> 租户类型Id</param>
/// <param name="sortBy">排序类型</param>
/// <returns></returns>
private string GetCacheKey_ObjectIds(string tenantTypeId, SortBy_Attitude sortBy)
{
return(string.Format("ObjectIds::TenantTypeId-{0}:SortBy-{1}", tenantTypeId, Convert.ToInt32(sortBy)));
}
