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