articlebussiness.cs

ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基础知识

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// 关于发文的业务层操作
/// </summary>
public class ArticleBussiness
{
 BBSTableTableAdapters.ArticleTableAdapter articleTable;
 public ArticleBussiness()
 {
  articleTable = new BBSTableTableAdapters.ArticleTableAdapter();
 }
 /// <summary>
 /// 根据ID获取文章内容
 /// </summary>
 public void GetContentByID(ref ArticleEntity art)
 {
  DataTable dtContent = articleTable.GetPostContentByID(art.PostID);
  if (dtContent.Rows.Count != 0)
  {
   art.ItemID = Convert.ToInt32(dtContent.Rows[0]["ItemID"]);
   art.UserName = Convert.ToString(dtContent.Rows[0]["UserName"]);
   art.Title = Convert.ToString(dtContent.Rows[0]["Title"]);
   art.Content = Convert.ToString(dtContent.Rows[0]["Content"]);
   if (!Convert.IsDBNull(dtContent.Rows[0]["AttachmentID"]))
    art.AttachmenID = Convert.ToInt32(dtContent.Rows[0]["AttachmentID"]);
   art.PostTime = Convert.ToDateTime(dtContent.Rows[0]["PostTime"]);
   if (!Convert.IsDBNull(dtContent.Rows[0]["LastModified"]))
    art.LastModified = Convert.ToDateTime(dtContent.Rows[0]["LastModified"]);
  }
 }
 /// <summary>
 /// 添加主题
 /// </summary>
 /// <param name="art">文章实体</param>
 public void AddPost(ref ArticleEntity art)
 {
  object postID=articleTable.AddPost(art.ItemID, art.UserName, art.Title, art.Content, art.AttachmenID);
  if (postID != null)
   art.PostID = Convert.ToInt32(postID);
 }
 /// <summary>
 /// 删除主题或者回复
 /// </summary>
 /// <param name="art">文章实体</param>
 public void DeletePost(ArticleEntity art)
 {
  if (art.AttachmenID != -1)
  {
   AttachmentBussiness attBuss = new AttachmentBussiness();
   AttachmentEntity att = new AttachmentEntity();
   att.AttachmentID = art.AttachmenID;
   att.PhysicalPath = art.PhysicalPath;
   attBuss.DeleteAttachmentByID(att);
  }
  articleTable.DeletePost(art.PostID);
 }
 /// <summary>
 /// 根据ID修改主题或者回复
 /// </summary>
 /// <param name="art">文章实体</param>
 public void ModifyAritcle(ArticleEntity art)
 {
  articleTable.ModifyArticleByID(art.Title, art.Content, art.PostID);
 }
 /// <summary>
 /// 添加回复
 /// </summary>
 /// <param name="art">文章实体</param>
 public void AddRepost(ArticleEntity art)
 {
  articleTable.AddRePost(art.ItemID, art.UserName, art.Title, art.Content, art.PostRePostID);
 }
 /// <summary>
 /// 根据栏目ID获取主题列表
 /// </summary>
 /// <param name="item">栏目实体</param>
 /// <returns>主题列表</returns>
 public DataTable GetPostByItemID(int pItemID)
 {
  return articleTable.GetArticleByItemID(pItemID);
 }
 /// <summary>
 /// 根据主题ID获取文章及回复列表
 /// </summary>
 /// <param name="art">文章实体</param>
 public DataTable GetArticleByPostID(int pPostID)
 {
  return articleTable.GetArticleByPostID(pPostID);
 }

}