blogproxy.cs

ASP.net网站开发四“酷”全书：新闻、论坛、电子商城、博客_源码

			DataSet ds = eDAO.LoadMonth(BlogID);
			return ds;
		}

		//选取浏览数最多的随笔列表
		public DataSet LoadTopViewList(int num)
		{
			DataSet ds = eDAO.LoadTopViewList(num);
			return ds;
		}

		//选取评论数最多的随笔列表
		public DataSet LoadTopFeedBackList(int num)
		{
			DataSet ds = eDAO.LoadTopFeedBackList(num);
			return ds;
		}

		//选取随笔发表日期
		public int[] LoadEssayDayArray(int BlogID,int intYear,int intMonth)
		{
			int[] intArray = eDAO.LoadDayArray(BlogID,intYear,intMonth);
			return intArray;
		}

		//选取随笔列表信息
		public DataView LoadEssayList(int BlogID){
			DataView dv = eDAO.LoadList(BlogID);
			return dv;
		}
		#endregion

		#region 文章信息操作

		//选取某个文章信息
		public ArticleVO LoadArticle(int ArticleID)
		{
			ArticleVO aVO = aDAO.Load(ArticleID);
			return aVO;
		}

		//添加文章
		public int AddArticle(ArticleVO aVO){
			int flag = aDAO.Insert(aVO);
			if(flag>0){
				flag += AddArticleNum(aVO.BlogID);
			}
			return flag;
		}

		//修改文章信息
		public int EditArticle(ArticleVO aVO){
			int flag = aDAO.Update(aVO);
			return flag;
		}

		//阅读文章信息
		public int ViewArticle(int ArticleID){
			int flag = aDAO.View(ArticleID);
			return flag;
		}

		//增加文章评论信息
		private int AddArticleFeedNum(int ArticleID){
			int flag = aDAO.FeedBack(ArticleID);
			return flag;
		}

		//减少文章评论信息
		private int ReduceArticleFeedNum(int ArticleID){
			int flag = aDAO.DFeedBack(ArticleID);
			return flag;
		}

		//删除文章信息
		public int RemoveArticle(int ArticleID){
			ArticleVO aVO = LoadArticle(ArticleID);
			int flag = aDAO.Delete(ArticleID);
			if(flag>0){
				flag += ReduceArticleNum(aVO.BlogID,1);
				flag += fDAO.Delete(ArticleID,"a");
				flag += ReduceFeedBackNum(aVO.BlogID,LoadFeedBackCount(aVO.BlogID,aVO.CategoryID,ArticleID,"a",""));
			}
			return flag;
		}

		//删除某分类下的文章信息
		private int RemoveArticleC(int CategoryID)
		{
			int flag = aDAO.DeleteC(CategoryID);
			return flag;
		}

		//删除某Blog下的文章信息
		private int RemoveArticleB(int BlogID)
		{
			int flag = aDAO.DeleteB(BlogID);
			return flag;
		}

		//选取文章列表信息
		public DataSet LoadArticleList(int BlogID,int CategoryID,int startPage,int pageSize,string key,string time)
		{
			DataSet ds = aDAO.LoadList(BlogID,CategoryID,startPage,pageSize,key,time);
			return ds;
		}

		//选取文章总数
		public int LoadArticleCount(int BlogID,int CategoryID,string key,string time){
			int flag = aDAO.LoadCount(BlogID,CategoryID,key,time);
			return flag;
		}

		//选取文章日期
		public DataSet LoadArticleMonth(int BlogID){
			DataSet ds = aDAO.LoadMonth(BlogID);
			return ds;
		}
		#endregion

		#region 评论信息操作

		//选取某个评论信息
		public FeedBackVO LoadFeedBack(int FeedBackID)
		{
			FeedBackVO fVO = fDAO.Load(FeedBackID);
			return fVO;
		}

		//添加评论
		public int AddFeedBack(FeedBackVO fVO){
			int flag = fDAO.Insert(fVO);
			if(flag>0){
				switch(fVO.Category){
					case "e":
						flag += AddEssayFeedNum(fVO.ContentID);
						break;
					case "a":
						flag += AddArticleFeedNum(fVO.ContentID);
						break;
				}
				flag += AddFeedBackNum(fVO.BlogID);
			}
			return flag;
		}

		//删除评论信息
		public int RemoveFeedBack(int FeedBackID){
			FeedBackVO fVO = LoadFeedBack(FeedBackID);
			int flag = fDAO.Delete(FeedBackID);
			if(flag>0){
				switch(fVO.Category){
					case "e":
						flag += ReduceEssayFeedNum(fVO.ContentID);
						break;
					case "a":
						flag += ReduceArticleFeedNum(fVO.ContentID);
						break;
				}
				flag += ReduceFeedBackNum(fVO.BlogID,1);
			}
			return flag;
		}

		//删除某条信息的评论信息
		private int RemoveFeedBack(int ContentID,string Category){
			int flag = fDAO.Delete(ContentID,Category);
			return flag;
		}

		//删除某分类下的评论信息
		private int RemoveFeedBackC(int CategoryID)
		{
			
			int flag = fDAO.DeleteC(CategoryID);
			return flag;
		}

		//删除评论信息
		private int RemoveFeedBackB(int BlogID)
		{
			int flag = fDAO.DeleteB(BlogID);
			return flag;
		}

		//选取评论列表信息
		public DataSet LoadFeedBackList(int BlogID,int ContentID,string Category,string key){
			DataSet ds = fDAO.LoadList(BlogID,ContentID,Category,key);
			return ds;
		}

		//选取评论列表信息
		public DataSet LoadFeedBackList(int BlogID,int startPage,int pageSize){
			DataSet ds = fDAO.LoadList(BlogID,startPage,pageSize);
			return ds;
		}

		//选取评论总数
		public int LoadFeedBackCount(int BlogID)
		{
			int flag = fDAO.LoadCount(BlogID);
			return flag;
		}

		//选取评论总数
		public int LoadFeedBackCount(int BlogID,int CategoryID,int ContentID,string Category,string key)
		{
			int flag = fDAO.LoadCount(BlogID,CategoryID,ContentID,Category,key);
			return flag;
		}
		#endregion

		#region 链接信息操作

		//选取某个链接信息
		public HrefVO LoadHref(int HrefID)
		{
			HrefVO hVO = hDAO.Load(HrefID);
			return hVO;
		}

		//添加链接
		public int AddHref(HrefVO hVO){
			int flag = hDAO.Insert(hVO);
			return flag;
		}

		//修改链接信息
		public int EditHref(HrefVO hVO){
			int flag = hDAO.Update(hVO);
			return flag;
		}

		//删除链接信息
		public int RemoveHref(int HrefID){
			int flag = hDAO.Delete(HrefID);
			return flag;
		}

		//删除某分类下的链接信息
		private int RemoveHrefC(int CategoryID)
		{
			int flag = hDAO.DeleteC(CategoryID);
			return flag;
		}

		//删除某Blog下的链接信息
		private int RemoveHrefB(int BlogID)
		{
			int flag = hDAO.DeleteB(BlogID);
			return flag;
		}

		//选取链接列表信息
		public DataSet LoadHrefList(int BlogID,int CategoryID)
		{
			DataSet ds = hDAO.LoadList(BlogID,CategoryID);
			return ds;
		}

		//选取链接列表信息
		public DataView LoadHrefList(int BlogID){
			DataView dv = hDAO.LoadList(BlogID);
			return dv;
		}

		//选取链接列表信息
		public DataSet LoadHrefList(int BlogID,int CategoryID,int startPage,int pageSize){
			DataSet ds = hDAO.LoadList(BlogID,CategoryID,startPage,pageSize);
			return ds;
		}

		//选取链接总数信息
		public int LoadHrefCount(int BlogID,int CategoryID){
			int flag = hDAO.LoadCount(BlogID,CategoryID);
			return flag;
		}
		#endregion

		#region 照片信息操作

		//选取某个照片信息
		public PictureVO LoadPicture(int PictureID)
		{
			PictureVO pVO = pDAO.Load(PictureID);
			return pVO;
		}

		//添加片信息
		public int AddPicture(PictureVO pVO){
			int flag = pDAO.Insert(pVO);
			return flag;
		}

		//修改照片信息
		public int EditPicture(PictureVO pVO){
			int flag = pDAO.Update(pVO);
			return flag;
		}

		//删除照片信息
		public int RemovePicture(int PictureID){
			int flag = pDAO.Delete(PictureID);
			return flag;
		}

		//删除某个分类下的照片信息
		private int RemovePictureC(int CategoryID)
		{
			int flag = pDAO.DeleteC(CategoryID);
			return flag;
		}

		//删除某个Blog下的照片信息
		private int RemovePictureB(int BlogID)
		{
			int flag = pDAO.DeleteB(BlogID);
			return flag;
		}

		//选取照片列表信息
		public DataSet LoadPictureList(int BlogID,int CategoryID,int startPage,int pageSize)
		{
			DataSet ds = pDAO.LoadList(BlogID,CategoryID,startPage,pageSize);
			return ds;
		}

		//选取照片总数信息
		public int LoadPictureCount(int BlogID,int CategoryID)
		{
			int flag = pDAO.LoadCount(BlogID,CategoryID);
			return flag;
		}
		#endregion
	}
}