#region Unanswered topics if (unansweredOnly) { whereClause.Append(" AND TotalReplies = 0 AND IsLocked = 0"); } #endregion
#region Active topics // 热门贴子 if (activeTopics) { whereClause.Append(" AND TotalReplies > 2 AND IsLocked = 0 AND TotalViews > 50"); } #endregion
#region 收藏 // 尽显示收藏的主题 if (favoriteOnly) { whereClause.Append(" AND T.ThreadID = Fav.ThreadID AND Fav.UserID = "); whereClause.Append(userID); } #endregion
#region Users filter if (userFilter != ThreadUsersFilter.All) {
if ((userFilter == ThreadUsersFilter.HideTopicsParticipatedIn) || (userFilter == ThreadUsersFilter.HideTopicsNotParticipatedIn)) {
whereClause.Append(" AND "); whereClause.Append(userID);
if (userFilter == ThreadUsersFilter.HideTopicsNotParticipatedIn) whereClause.Append(" NOT");
whereClause.Append(" IN (SELECT UserID FROM " + this.databaseOwner + ".forums_Posts P WHERE P.ThreadID = T.ThreadID)");
} else {
if (userFilter == ThreadUsersFilter.HideTopicsByNonAnonymousUsers) whereClause.Append(" AND 0 NOT"); else whereClause.Append(" AND 0");
whereClause.Append("IN (SELECT UserID FROM " + this.databaseOwner + ".forums_Posts P WHERE ThreadID = T.ThreadID AND P.UserID = 0)"); } } #endregion
#region Thread Status if (threadStatus != ThreadStatus.NotSet) { switch (threadStatus) { case ThreadStatus.Open: whereClause.Append(" AND ThreadStatus = 0"); break;
case ThreadStatus.Closed: whereClause.Append(" AND ThreadStatus = 0"); break;
case ThreadStatus.Resolved: whereClause.Append(" AND ThreadStatus = 0"); break;
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
