/// <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)); }