blogproxy.cs

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

using System;
using System.Data;
using WesternByte.MyBlog.Blog;
using WesternByte.MyBlog.Article;
using WesternByte.MyBlog.Essay;
using WesternByte.MyBlog.FeedBack;
using WesternByte.MyBlog.Category;
using WesternByte.MyBlog.Href;
using WesternByte.MyBlog.Picture;
using System.IO;

namespace WesternByte.MyBlog
{
	/// <summary>
	/// BlogProxy 的摘要说明。
	/// </summary>
	public class BlogProxy
	{
		protected BlogDAO bDAO = new BlogDAO(); //博客类
		protected ArticleDAO aDAO = new ArticleDAO(); //文章类
		protected EssayDAO eDAO = new EssayDAO(); //随笔类
		protected FeedBackDAO fDAO = new FeedBackDAO(); //评论类
		protected CategoryDAO cDAO = new CategoryDAO(); //分类类
		protected HrefDAO hDAO = new HrefDAO(); //链接类
		protected PictureDAO pDAO = new PictureDAO(); //照片类

		/*属性*/
		public string path;
		public BlogVO BlogVO = new BlogVO();
		public ArticleVO ArticleVO = new ArticleVO();
		public EssayVO EssayVO = new EssayVO();
		public FeedBackVO FeedBackVO = new FeedBackVO();
		public CategoryVO CategoryVO = new CategoryVO();
		public HrefVO HrefVO = new HrefVO();
		public PictureVO PictureVO = new PictureVO();

		/*构造函数*/
		public BlogProxy(){

		}

		public BlogProxy(string webpath){
			this.path = webpath;
		}

		#region 博客信息操作

		//选取某个博客信息
		public BlogVO LoadBlog(int BlogID){
			BlogVO bVO = bDAO.Load(BlogID);
			return bVO;
		}

		//博客登录
		public int RetrieveBlog(string username,string password)
		{
			int flag = bDAO.Check(username,password);
			return flag;
		}

		//新博客注册
		public int AddBlog(BlogVO bVO){
			int flag = bDAO.Insert(bVO);
			if(flag>0)
			{
				DirectoryInfo dif = new DirectoryInfo(path+"\\Images\\Pictures\\" + flag);
				dif.Create();
			}
			return flag;
		}

		//修改博客信息
		public int EditBlog(BlogVO bVO){
			int flag = bDAO.Update(bVO);
			return flag;
		}

		//修改博客密码
		public int EditBlogPwd(string password,int BlogID){
			int flag = bDAO.UpdatePwd(password,BlogID);
			return flag;
		}

		//删除博客信息
		public int RemoveBlog(int BlogID){
			int flag = bDAO.Delete(BlogID);
			if(flag>0){
				flag += RemoveCategoryB(BlogID);
				flag += RemoveArticleB(BlogID);
				flag += RemoveEssayB(BlogID);
				flag += RemoveFeedBackB(BlogID);
				flag += RemoveHrefB(BlogID);
				flag += RemovePictureB(BlogID);
			}
			if(flag>0)
			{
				DirectoryInfo dif = new DirectoryInfo(path+"\\Images\\Pictures\\" + BlogID);
				dif.Delete(true);
			}
			return flag;
		}

		//增加随笔数
		private int AddEssayNum(int BlogID){
			int flag = bDAO.InsertEssay(BlogID);
			return flag;
		}

		//减少随笔数
		private int ReduceEssayNum(int BlogID,int num){
			int flag = bDAO.DeleteEssay(BlogID,num);
			return flag;
		}

		//增加文章数
		private int AddArticleNum(int BlogID){
			int flag = bDAO.InsertArticle(BlogID);
			return flag;
		}

		//减少文章数
		private int ReduceArticleNum(int BlogID,int num){
			int flag = bDAO.DeleteArticle(BlogID,num);
			return flag;
		}

		//增加评论数
		private int AddFeedBackNum(int BlogID){
			int flag = bDAO.InsertFeedBack(BlogID);
			return flag;
		}

		//减少评论数
		private int ReduceFeedBackNum(int BlogID,int num){
			int flag = bDAO.DeleteFeedBack(BlogID,num);
			return flag;
		}

		//选取博客列表信息
		public DataSet LoadBlogList(){
			DataSet ds = bDAO.LoadList();
			return ds;
		}

		//选取博客排行列表信息
		public DataSet LoadTopBlogList(int num){
			DataSet ds = bDAO.LoadTopList(num);
			return ds;
		}

		//选取随笔总数
		public int LoadBlogCount(){
			int flag = bDAO.LoadCount();
			return flag;
		}
		#endregion

		#region 分类信息操作

		//选取某个分类信息
		public CategoryVO LoadCategory(int CategoryID)
		{
			CategoryVO cVO = cDAO.Load(CategoryID);
			return cVO;
		}

		//添加分类信息
		public int AddCategory(CategoryVO cVO){
			int flag = cDAO.Insert(cVO);
			if(cVO.Category == "p"){
				if(flag>0){
					DirectoryInfo dif = new DirectoryInfo(path+"\\Images\\Pictures\\" + cVO.BlogID + "\\" + flag);
					dif.Create();
				}
			}
			return flag;
		}

		//修改分类信息
		public int EditCategory(CategoryVO cVO){
			int flag = cDAO.Update(cVO);
			return flag;
		}

		//删除分类信息
		public int RemoveCategory(int CategoryID){
			CategoryVO cVO = LoadCategory(CategoryID);
			int flag = cDAO.Delete(CategoryID);
			if(flag>0){
				int count = 0;
				switch(cVO.Category){
					case "h":
						flag += RemoveHrefC(CategoryID);
						break;
					case "p":
						flag += RemovePictureC(CategoryID);
						if(flag>0)
						{
							DirectoryInfo dif = new DirectoryInfo(path+"\\Images\\Pictures\\" + cVO.BlogID + "\\" + cVO.CategoryID);
							dif.Delete(true);
						}
						break;
					case "a":
						count = LoadArticleCount(0,CategoryID,"","");
						flag += ReduceArticleNum(cVO.BlogID,count);
						flag += RemoveArticleC(CategoryID);
						count = LoadFeedBackCount(0,CategoryID,0,"a","");
						flag += ReduceFeedBackNum(cVO.BlogID,count);
						flag += RemoveFeedBackC(CategoryID);
						break;
					case "e":
						count = LoadEssayCount(0,CategoryID,"","");
						flag += ReduceEssayNum(cVO.BlogID,count);
						flag += RemoveEssayC(CategoryID);
						count = LoadFeedBackCount(0,CategoryID,0,"e","");
						flag += ReduceEssayNum(cVO.BlogID,count);
						flag += RemoveEssayC(CategoryID);
						break;
				}
			}
			return flag;
		}

		//删除某Blog下的分类信息
		private int RemoveCategoryB(int BlogID){
			int flag = cDAO.DeleteB(BlogID);
			return flag;
		}

		//选取分类列表信息
		public DataSet LoadCategoryList(int BlogID,string Category){
			DataSet ds = cDAO.LoadList(BlogID,Category);
			return ds;
		}

		//选取分类列表信息（用于分布列表显示）
		public DataSet LoadCategoryList(int BlogID,string Category,int startPage,int pageSize)
		{
			DataSet ds = cDAO.LoadList(BlogID,Category,startPage,pageSize);
			return ds;
		}

		//选取分类总数信息
		public int LoadCategoryCount(int BlogID,string Category){
			int flag = cDAO.LoadCount(BlogID,Category);
			return flag;
		}
		#endregion

		#region 随笔信息操作

		//选取某个随笔信息
		public EssayVO LoadEssay(int EssayID)
		{
			EssayVO eVO = eDAO.Load(EssayID);
			return eVO;
		}

		//添加随笔
		public int AddEssay(EssayVO eVO){
			int flag = eDAO.Insert(eVO);
			if(flag>0){
				flag += AddEssayNum(eVO.BlogID);
			}
			return flag;
		}

		//修改随笔信息
		public int EditEssay(EssayVO eVO){
			int flag = eDAO.Update(eVO);
			return flag;
		}

		//阅读随笔信息
		public int ViewEssay(int EssayID){
			int flag = eDAO.View(EssayID);
			return flag;
		}

		//增加评论随笔数
		private int AddEssayFeedNum(int EssayID){
			int flag = eDAO.FeedBack(EssayID);
			return flag;
		}

		//减少评论随笔数
		private int ReduceEssayFeedNum(int EssayID){
			int flag = eDAO.DFeedBack(EssayID);
			return flag;
		}

		//删除随笔信息
		public int RemoveEssay(int EssayID){
			EssayVO eVO = LoadEssay(EssayID);
			int flag = eDAO.Delete(EssayID);
			if(flag>0){
				flag += ReduceEssayNum(eVO.BlogID,1);
				flag += RemoveFeedBack(EssayID,"e");
				flag += ReduceFeedBackNum(eVO.BlogID,LoadFeedBackCount(eVO.BlogID,eVO.CategoryID,EssayID,"e",""));
			}
			return flag;
		}

		//删除某分类下的随笔信息
		private int RemoveEssayC(int CategoryID)
		{
			int flag = eDAO.DeleteC(CategoryID);
			return flag;
		}

		//删除某Blog下的随笔信息
		private int RemoveEssayB(int BlogID)
		{
			int flag = eDAO.DeleteB(BlogID);
			return flag;
		}

		//选取随笔列表信息
		public DataSet LoadEssayList(int BlogID,int CategoryID,int startPage,int pageSize,string key,string time){
			DataSet ds = eDAO.LoadList(BlogID,CategoryID,startPage,pageSize,key,time);
			return ds;
		}

		//选取随笔总数
		public int LoadEssayCount(int BlogID,int CategoryID,string key,string time){
			int flag = eDAO.LoadCount(BlogID,CategoryID,key,time);
			return flag;
		}

		//选取最新随笔列表
		public DataSet LoadTopEssayList(int num){
			DataSet ds = eDAO.LoadTopList(num);
			return ds;
		}

		//选取随笔日期
		public DataSet LoadEssayMonth(int BlogID)
		{