/// <summary>
/// 获得帖子列表
/// </summary>
/// <param name="count">数量</param>
/// <param name="views">最小浏览量</param>
/// <param name="fid">板块ID</param>
/// <param name="timetype">期限类型,一天、一周、一月、不限制</param>
/// <param name="ordertype">排序类型,时间倒序、浏览量倒序、最后回复倒序</param>
/// <param name="isdigest">是否精华</param>
/// <param name="cachetime">缓存的有效期(单位:分钟)</param>
/// <returns></returns>
public static DataTable GetTopicList(int count, int fid, TopicOrderType ordertype, bool digest, int cachetime, bool onlyimg, string fidlist, int tabid, TopicTimeType timetype)
{
//防止恶意行为
cachetime = cachetime == 0 ? 1 : cachetime;
count = count > 50 ? 50 : (count < 1 ? 1 : count);
Discuz.Cache.DNTCache cache = Discuz.Cache.DNTCache.GetCacheService();
DataTable dt = cache.RetrieveObject("/Forum/ForumHostList-" + tabid) as DataTable;
if (dt == null)
{
if (fidlist == "")
{
fidlist = Forums.GetVisibleForum();
}
if (Focuses.GetFieldName(ordertype) == "digest")
{
digest = true;
}
dt = Discuz.Data.Topics.GetTopicList(count, -1, fid, "", Focuses.GetStartDate(timetype), Focuses.GetFieldName(ordertype), fidlist, digest, onlyimg);
cache.AddObject("/Forum/ForumHostList-" + tabid, dt, cachetime);
}
return(dt);
}
/// <summary>
/// 转换热门图片为数组
/// </summary>
/// <param name="topNumber">获取的数量</param>
/// <param name="orderBy">排序方式</param>
/// <param name="cachetime">缓存时间</param>
/// <returns></returns>
public static string HotImagesArray(ForumHotItemInfo forumHotItemInfo)
{
string imagesItemTemplate = "<li><a href=\"{0}\" target=\"_blank\"><img src=\"{1}\" alt=\"{2}\"/></a></li>";
string imagesPageTemplate = "<a href=\"#\" rel=\"{0}\">{0}</a>";
StringBuilder hotImagesLi = new StringBuilder();
StringBuilder hotImagePage = new StringBuilder();
//如果没有缩略图目录，则去生成
if (!Directory.Exists(Utils.GetMapPath(BaseConfigs.GetForumPath + "cache/rotatethumbnail/")))
{
Utils.CreateDir(Utils.GetMapPath(BaseConfigs.GetForumPath + "cache/rotatethumbnail/"));
}
//如果版块idlist设置为空，则默认读取所有可见板块的idlist
string forumList = string.IsNullOrEmpty(forumHotItemInfo.Forumlist) ? Forums.GetVisibleForum() : forumHotItemInfo.Forumlist;
int i = 1;
foreach (DataRow dr in HotImages(forumHotItemInfo.Dataitemcount, forumHotItemInfo.Cachetimeout, forumHotItemInfo.Sorttype, forumHotItemInfo.Id, forumList, forumHotItemInfo.Enabled).Rows)
{
int tid = TypeConverter.ObjectToInt(dr["tid"]);
string fileName = dr["filename"].ToString().Trim();
string title = dr["title"].ToString().Trim();
title = Utils.JsonCharFilter(title).Replace("'", "\\'");
if (fileName.StartsWith("http://"))
{
DeleteCacheImageFile();
Thumbnail.MakeRemoteThumbnailImage(fileName, Utils.GetMapPath(BaseConfigs.GetForumPath + "cache/rotatethumbnail/r_" + Utils.GetFilename(fileName)), 360, 240);
hotImagesLi.AppendFormat(imagesItemTemplate, Urls.ShowTopicAspxRewrite(tid, 0), "cache/rotatethumbnail/r_" + Utils.GetFilename(fileName), title);
}
else
{
//图片文件名称
string fullFileName = BaseConfigs.GetForumPath + "upload/" + fileName.Replace('\\', '/').Trim();
//图片缩略后的名称
string thumbnailFileName = "cache/rotatethumbnail/r_" + Utils.GetFilename(fullFileName);
if (!File.Exists(Utils.GetMapPath(BaseConfigs.GetForumPath + thumbnailFileName)) && File.Exists(Utils.GetMapPath(fullFileName)))
{
DeleteCacheImageFile();
Thumbnail.MakeThumbnailImage(Utils.GetMapPath(fullFileName), Utils.GetMapPath(BaseConfigs.GetForumPath + thumbnailFileName), 360, 240);
}
hotImagesLi.AppendFormat(imagesItemTemplate, Urls.ShowTopicAspxRewrite(tid, 0), "cache/rotatethumbnail/r_" + Utils.GetFilename(fullFileName), title);
}
hotImagePage.AppendFormat(imagesPageTemplate, i);
i++;
}
return("<div class=\"image_reel\"><ul>" + hotImagesLi.ToString() + "</ul></div><div class=\"paging\"><span></span>" + hotImagePage.ToString() + "</div>");
}
/// <summary>
/// 转换热门图片为数组
/// </summary>
/// <param name="topNumber">获取的数量</param>
/// <param name="orderBy">排序方式</param>
/// <param name="cachetime">缓存时间</param>
/// <returns></returns>
public static string HotImagesArray(ForumHotItemInfo forumHotItemInfo)
{
string imagesItemTemplate = "title:\"{0}\",img:\"{1}\",url:\"{2}\"";
StringBuilder hotImagesArray = new StringBuilder();
//如果没有缩略图目录，则去生成
if (!Directory.Exists(Utils.GetMapPath(BaseConfigs.GetForumPath + "cache/rotatethumbnail/")))
{
Utils.CreateDir(Utils.GetMapPath(BaseConfigs.GetForumPath + "cache/rotatethumbnail/"));
}
//如果版块idlist设置为空，则默认读取所有可见板块的idlist
string forumList = string.IsNullOrEmpty(forumHotItemInfo.Forumlist) ? Forums.GetVisibleForum() : forumHotItemInfo.Forumlist;
foreach (DataRow dr in HotImages(forumHotItemInfo.Dataitemcount, forumHotItemInfo.Cachetimeout, forumHotItemInfo.Sorttype, forumHotItemInfo.Id, forumList, forumHotItemInfo.Enabled).Rows)
{
int tid = TypeConverter.ObjectToInt(dr["tid"]);
string fileName = dr["filename"].ToString().Trim();
string title = dr["title"].ToString().Trim();
title = Utils.JsonCharFilter(title).Replace("'", "\\'");
if (fileName.StartsWith("http://"))
{
DeleteCacheImageFile();
Thumbnail.MakeRemoteThumbnailImage(fileName, Utils.GetMapPath(BaseConfigs.GetForumPath + "cache/rotatethumbnail/r_" + Utils.GetFilename(fileName)), 360, 240);
hotImagesArray.Append("{");
hotImagesArray.AppendFormat(imagesItemTemplate, title, "cache/rotatethumbnail/r_" + Utils.GetFilename(fileName), Urls.ShowTopicAspxRewrite(tid, 0));
hotImagesArray.Append("},");
continue;
}
//图片文件名称
string fullFileName = BaseConfigs.GetForumPath + "upload/" + fileName.Replace('\\', '/').Trim();
//图片缩略后的名称
string thumbnailFileName = "cache/rotatethumbnail/r_" + Utils.GetFilename(fullFileName);
if (!File.Exists(Utils.GetMapPath(BaseConfigs.GetForumPath + thumbnailFileName)) && File.Exists(Utils.GetMapPath(fullFileName)))
{
DeleteCacheImageFile();
Thumbnail.MakeThumbnailImage(Utils.GetMapPath(fullFileName), Utils.GetMapPath(BaseConfigs.GetForumPath + thumbnailFileName), 360, 240);
}
hotImagesArray.Append("{");
hotImagesArray.AppendFormat(imagesItemTemplate, title, "cache/rotatethumbnail/r_" + Utils.GetFilename(fullFileName), Urls.ShowTopicAspxRewrite(tid, 0));
hotImagesArray.Append("},");
}
return("[" + hotImagesArray.ToString().TrimEnd(',') + "]");
}
/// <summary>
/// 获得帖子列表
/// </summary>
/// <param name="count">数量</param>
/// <param name="views">最小浏览量</param>
/// <param name="fid">板块ID</param>
/// <param name="timetype">期限类型,一天、一周、一月、不限制</param>
/// <param name="ordertype">排序类型,时间倒序、浏览量倒序、最后回复倒序</param>
/// <param name="isdigest">是否精华</param>
/// <param name="cachetime">缓存的有效期(单位:分钟)</param>
/// <returns></returns>
public static DataTable GetTopicList(int count, int views, int fid, string typeIdList, TopicTimeType timetype, TopicOrderType ordertype, bool isdigest, int cachetime, bool onlyimg, string fidlist)
{
//防止恶意行为
if (cachetime == 0)
{
cachetime = 1;
}
if (count > 50)
{
count = 50;
}
if (count < 1)
{
count = 1;
}
string cacheKey = string.Format("/Forum/TopicList-{0}-{1}-{2}-{3}-{4}-{5}-{6}-{7}", count, views, fid, timetype, ordertype, isdigest, onlyimg, typeIdList.Replace(',', 'd'));
Discuz.Cache.DNTCache cache = Discuz.Cache.DNTCache.GetCacheService();
DataTable dt = cache.RetrieveObject(cacheKey) as DataTable;
if (dt == null)
{
if (fidlist == "")
{
fidlist = Forums.GetVisibleForum();
}
//dt = Discuz.Data.Topics.GetTopicList(count, views, fid, typeIdList, GetStartDate(timetype), GetFieldName(ordertype), Forums.GetVisibleForum(), isdigest, onlyimg);
dt = Discuz.Data.Topics.GetTopicList(count, views, fid, typeIdList, GetStartDate(timetype), GetFieldName(ordertype), fidlist, isdigest, onlyimg);
//声明新的缓存策略接口
//Discuz.Cache.ICacheStrategy ics = new ForumCacheStrategy();
//ics.TimeOut = cachetime * 60;
//cache.LoadCacheStrategy(ics);
cache.AddObject(cacheKey, dt, cachetime * 60);
//cache.LoadDefaultCacheStrategy();
}
return(dt);
}
/// <summary>
/// 更新指定版块的最新发帖数信息
/// </summary>
/// <param name="foruminfo"></param>
public static void UpdateLastPost(ForumInfo foruminfo)
{
PostInfo postinfo = new PostInfo();
int tid = Discuz.Data.Topics.GetLastPostTid(foruminfo, Forums.GetVisibleForum());
if (tid > 0)
{
postinfo = Discuz.Data.Posts.GetLastPostByTid(tid, PostTables.GetPostTableName(tid));
}
else
{
postinfo.Pid = postinfo.Tid = 0;
postinfo.Title = postinfo.Topictitle = "从未";
postinfo.Postdatetime = "1900-1-1";
postinfo.Poster = "";
postinfo.Posterid = 0;
}
Discuz.Data.Forums.UpdateForumLastPost(foruminfo, postinfo);
if (foruminfo.Layer > 1)
{
UpdateParentForumLastPost(foruminfo, postinfo);
}
}
/// <summary>
/// 获得帖子列表
/// </summary>
/// <param name="count">数量</param>
/// <param name="views">最小浏览量</param>
/// <param name="fid">板块ID</param>
/// <param name="timetype">期限类型,一天、一周、一月、不限制</param>
/// <param name="ordertype">排序类型,时间倒序、浏览量倒序、最后回复倒序</param>
/// <param name="isdigest">是否精华</param>
/// <param name="cachetime">缓存的有效期(单位:分钟)</param>
/// <returns></returns>
public static DataTable GetTopicList(ForumHotItemInfo forumHotItemInfo)
{
//防止恶意行为
forumHotItemInfo.Cachetimeout = forumHotItemInfo.Cachetimeout == 0 ? 1 : forumHotItemInfo.Cachetimeout;
forumHotItemInfo.Dataitemcount = forumHotItemInfo.Dataitemcount > 50 ? 50 : (forumHotItemInfo.Dataitemcount < 1 ? 1 : forumHotItemInfo.Dataitemcount);
DataTable dt = new DataTable();
if (forumHotItemInfo.Cachetimeout > 0)
{
dt = DNTCache.GetCacheService().RetrieveObject("/Forum/ForumHostList-" + forumHotItemInfo.Id) as DataTable;
}
if (dt == null)
{
//如果版块idlist设置为空，则默认读取所有可见板块的idlist
string forumList = string.IsNullOrEmpty(forumHotItemInfo.Forumlist) ? Forums.GetVisibleForum() : forumHotItemInfo.Forumlist;
string orderFieldName = Focuses.GetFieldName((TopicOrderType)Enum.Parse(typeof(TopicOrderType), forumHotItemInfo.Sorttype));
dt = Discuz.Data.Topics.GetTopicList(forumHotItemInfo.Dataitemcount, -1, 0, "",
Focuses.GetStartDate((TopicTimeType)Enum.Parse(typeof(TopicTimeType), forumHotItemInfo.Datatimetype)),
orderFieldName, forumList, orderFieldName == "digest", false);
if (forumHotItemInfo.Cachetimeout > 0)
{
DNTCache.GetCacheService().AddObject("/Forum/ForumHostList-" + forumHotItemInfo.Id, dt, forumHotItemInfo.Cachetimeout);
}
}
return(dt);
}
/// <summary>
/// 获得帖子列表
/// </summary>
/// <param name="count">数量</param>
/// <param name="views">最小浏览量</param>
/// <param name="fid">板块ID</param>
/// <param name="timetype">期限类型,一天、一周、一月、不限制</param>
/// <param name="ordertype">排序类型,时间倒序、浏览量倒序、最后回复倒序</param>
/// <param name="isdigest">是否精华</param>
/// <param name="cachetime">缓存的有效期(单位:分钟)</param>
/// <returns></returns>
public static DataTable GetTopicList(int count, int views, int fid, TopicTimeType timetype, TopicOrderType ordertype, bool isdigest, int cachetime, bool onlyimg)
{
//防止恶意行为
if (cachetime == 0)
{
cachetime = 1;
}
if (count > 50)
{
count = 50;
}
if (count < 1)
{
count = 1;
}
string cacheKey = "/TopicList-{0}-{1}-{2}-{3}-{4}-{5}-{6}";
cacheKey = string.Format(cacheKey,
count,
views,
fid,
timetype,
ordertype,
isdigest,
onlyimg
);
Discuz.Cache.DNTCache cache = Discuz.Cache.DNTCache.GetCacheService();
DataTable dt = cache.RetrieveObject(cacheKey) as DataTable;
if (dt == null)
{
dt = DatabaseProvider.GetInstance().GetFocusTopicList(count, views, fid, GetStartDate(timetype), GetFieldName(ordertype), Forums.GetVisibleForum(), isdigest, onlyimg);
//声明新的缓存策略接口
Discuz.Cache.ICacheStrategy ics = new ForumCacheStrategy();
ics.TimeOut = cachetime;
cache.LoadCacheStrategy(ics);
cache.AddObject(cacheKey, dt);
cache.LoadDefaultCacheStrategy();
}
return(dt);
}
