/// <summary>
/// 所有评论数
/// </summary>
/// <returns>返回评论数</returns>
public static int commentCount()
{
string sql = "select count(*) from Comments";
return(SQLDBHelper.ExecuteScalar(sql));
}
/// <summary>
/// 根据帖子ID查评论数
/// </summary>
/// <param name="postId">接收帖子ID</param>
/// <returns>返回评论数</returns>
public static int commentCountByPostID(string postId)
{
string sql = "select count(*) from Comments where PostId=" + postId;
return(SQLDBHelper.ExecuteScalar(sql));
}
/// <summary>
/// 所有类型数
/// </summary>
/// <returns>返回数量</returns>
public static int TaxCount()
{
string sql = "select count(*) from Taxonomy";
return(SQLDBHelper.ExecuteScalar(sql));
}
