public static HashSet <ForumThread> GetThread(string cmdText)
{
HashSet <ForumThread> thread = new HashSet <ForumThread>();
using (IDataReader reader = DataHelper.ExecuteReader(CommandType.Text, cmdText, null))
{
while (reader.Read())
{
ForumThread tmp = ForumThread.CreateFromReader(reader);
tmp.RootMessage = builder.BuildRootMessage(reader);
thread.Add(tmp);
}
}
return(thread);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static HashSet <ForumThread> GetAllForumThread(Guid forumId, int startIndex, int count)
{
HashSet <ForumThread> thread = new HashSet <ForumThread>();
string feild = " fbs_ForumThread.ThreadID, fbs_ForumThread.ForumID, fbs_ForumThread.RootMessageID, fbs_ForumThread.RewardPoints, fbs_ForumThread.ModifiedDate, fbs_ForumThread.CreationDate, fbs_ForumThread.ClickCount, fbs_ForumThread.MessageCount, fbs_ForumThread.MessageSubject, fbs_ForumThread.UserID, fbs_ForumThread.UserName, fbs_Message.MessageID, fbs_Message.ParentMessageID, fbs_Message.AccountID, fbs_Message.Subject, fbs_Message.Body";
//string feild = "*";
string sql = "SELECT TOP " + count + "* FROM (SELECT ROW_NUMBER() OVER (ORDER BY fbs_ForumThread.ModifiedDate DESC) AS RowNumber," + feild + " FROM fbs_ForumThread inner join fbs_Message on fbs_ForumThread.RootMessageID=fbs_Message.MessageID AND fbs_Message.ThreadID=fbs_ForumThread.ThreadID WHERE fbs_ForumThread.ForumID='" + forumId + "') A WHERE RowNumber > " + startIndex;
//string sql = "select * from fbs_ForumThread inner join fbs_Message on fbs_ForumThread.RootMessageID=fbs_Message.MessageID";
using (IDataReader reader = DataHelper.ExecuteReader(CommandType.Text, sql))
{
while (reader.Read())
{
ForumThread tmp = ForumThread.CreateFromReader(reader);
tmp.RootMessage = builder.BuildRootMessage(reader);
//tmp.RootMessage.ForumThread = tmp;
thread.Add(tmp);
}
}
return(thread);
}
