articleentity.cs

该项目中对 SQLHelper 类进行了简单封装

/* 
 * ArticleEntity.cs @Microsoft Visual Studio 2008 <.NET Framework 3.5>
 * AfritXia
 * 2008-01-28
 * 
 * Copyright(c) http://www.AfritXia.NET/
 * 
 */

using System;
using System.Data.Linq.Mapping;

namespace NET.AfritXia.MyHome.DBTask.SQLServer2005.Entity
{
	/// <summary>
	/// 文章实体类
	/// </summary>
	[Table(Name = "myhome_Article")]
	public class ArticleEntity
	{
		/// <summary>
		/// 文章 ID
		/// </summary>
		[Column(Name = "ArticleUID", IsPrimaryKey = true, IsDbGenerated = true)]
		public int UniqueID
		{
			set;
			get;
		}

		/// <summary>
		/// 文章标题
		/// </summary>
		[Column(Name = "Title")]
		public string Title
		{
			set;
			get;
		}

		/// <summary>
		/// 文章摘要
		/// </summary>
		[Column(Name = "Summary")]
		public string Summary
		{
			set;
			get;
		}

		/// <summary>
		/// 发送人名称
		/// </summary>
		[Column(Name = "PostUser")]
		public string PostUser
		{
			set;
			get;
		}

		/// <summary>
		/// 文本内容
		/// </summary>
		[Column(Name = "TextContent")]
		public string TextContent
		{
			set;
			get;
		}

		/// <summary>
		/// 发送时间
		/// </summary>
		[Column(Name = "PostTime")]
		public DateTime PostTime
		{
			set;
			get;
		}

		/// <summary>
		/// 最后更新时间
		/// </summary>
		[Column(Name = "UpdateTime")]
		public DateTime UpdateTime
		{
			set;
			get;
		}

		/// <summary>
		/// 点击次数
		/// </summary>
		[Column(Name = "Clicked")]
		public int Clicked
		{
			set;
			get;
		}

		/// <summary>
		/// 评论次数
		/// </summary>
		[Column(Name = "__CommentCount")]
		public int CommentCount
		{
			set;
			get;
		}

		/// <summary>
		/// 更新旧实体
		/// </summary>
		/// <param name="oldEntity"></param>
		public void UpdateTo(ArticleEntity oldEntity)
		{
			if (oldEntity == null)
				return;

			// 标题
			oldEntity.Title = this.Title;
			// 摘要
			oldEntity.Summary = this.Summary;
			// 内容
			oldEntity.TextContent = this.TextContent;
			// 更新时间
			oldEntity.UpdateTime = this.UpdateTime;
		}
	}
}