/// <summary>
/// 加载评论
/// </summary>
/// <param name="dic"></param>
public static void LoadCommentsByStoryID(Dictionary <Guid, HashSet <BlogComment> > dic, Guid id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM fbs_Comment ");
strSql.Append(" WHERE StoryID=@in_StoryID");
DbParameter[] cmdParms = new DbParameter[] {
DataHelper.CreateInDbParameter("@in_StoryID", DbType.Guid, id)
};
HashSet <BlogComment> targets = new HashSet <BlogComment>();
using (DbDataReader dr = DataHelper.ExecuteReader(CommandType.Text, strSql.ToString(), cmdParms))
{
while (dr.Read())
{
targets.Add(BlogComment.CreateFromReader(dr));
}
}
if (!dic.ContainsKey(id))
{
dic.Add(id, new HashSet <BlogComment>());
}
dic[id] = targets;
}
