idbprovider.cs

具有一般blog的相册、文章、作品等功能程序结构也比较清晰采用三层结构开发（利用了SQLHelper.cs（源码））采用了UrlReWrite技术后台采用FTB(FreeTextBox)编辑器

using System;
using System.Data;

namespace liuwei.FrameWork.DB
{
	/// <summary>
	/// IDbProvider 的摘要说明。
	/// </summary>
	public interface IDbProvider
	{
		string ConnectionString
		{
			get;
			set;
		}

		DataTable GetContentList(int bigTypeID,int smallTypeID,int List_count);

		DataTable GetContentListByMonth(int bigTypeID,int smallTypeID,int postYear,int postMonth);

		DataTable GetContentListByYear(int bigTypeID,int smallTypeID,int postYear);

		IDataReader GetContentView(int postID);

		DataTable GetContentType(int bigTypeID);

		DataTable GetSmallTypeInfo(int smallTypeID);

		DataTable GetBigTypeInfo(int bigTypeID);

		DataTable GetCommentTop5(int postID);

		DataTable GetComment(int postID);

		void AddComment(int postID,string CommentTitle,string Comment,string Commenter,string CommenterUrl,string PubIP);

		//管理员
		void GetUser(string userName);

		DataTable GetContentAdmin(int smallTypeID);

		DataTable GetBigTypeList();

		DataTable GetSmallTypeList(int bigTypeID);

		void AddContent(int bigTypeID,int smallTypeID,string title,string intro,string content,bool allowShow,bool allowComment);

		void DelContent(int postID);

		DataTable GetSmallTypeListAll();

		void ModifyContent(int postID,int bigTypeID,int smallTypeID,string title,string intro,string content,bool allowShow,bool allowComment);

		DataTable GetModifyContent(int postID);

		void AddSmallType(int bigTypeID,string smallTypeName);

		void DelSmallType(int smalltypeid);

		void ModifySmallType(int smalltypeid,int bigtypeid,string smalltypename);

		void ModifyUser(string username,string password);

		void DelComment(int commentID);
		
	}
}