tcmsresource.cs

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

using System;

namespace _lib
{
	/// <summary>
	/// TCmsResource 的摘要说明。
	/// </summary>
	public class TCmsResource : TData
	{
		const string CTableName = "t_resource";
		const string CKeyName   = "resource_id";

		private string FUploadPath = System.Configuration.ConfigurationSettings.AppSettings["UploadPath"];
		private string FResourceID;
		private string FResourceAID;
		private string FResourceUID;
		private int FResourceSort;
		private DateTime FResourceTime;
		private string FResourceName;
		private string FResourceDesc;
		private string FResourceFilename;
		private string FResourceURL;

		public TCmsResource()
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
		}

		public TCmsResource(string ID)
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			FKeyValue  = ID;
		}

		/// <summary>
		/// （静态）根据编号在数据库中删除记录。
		/// </summary>
		public static void DeleteByID(string ID)
		{
			TData.DeleteByID(ID, CTableName, CKeyName);
		}

		/// <summary>
		/// （静态）使用文章编号，查询与之相关的资源编号。
		/// </summary>
		public static string GetResourceID(string AID)
		{
			string strSql= "select top 1 resource_id from "+CTableName+" where resource_aid='"+AID+"'";
			TSqlDB oDB= new TSqlDB(strSql);
			string Result=null;
			if (!oDB.EOF)
			{
				Result = oDB["resource_id"].ToString();
			}
			oDB.Free();
			return Result;
		}

		/// <summary>
		/// 在数据库中检索记录（已重写）。
		/// </summary>
		public override void Select()
		{
			string strSql= GetSelectString();
			TSqlDB oDB= new TSqlDB(strSql);
			if (!oDB.EOF)
			{
				FResourceID       = oDB["resource_id"].ToString();
				FResourceAID      = oDB["resource_aid"].ToString();
				FResourceUID      = oDB["resource_uid"].ToString();
				FResourceSort     = oDB["resource_sort"].ToInt();
				FResourceTime     = oDB["resource_time"].ToDateTime();
				FResourceName     = oDB["resource_name"].ToString();
				FResourceDesc     = oDB["resource_desc"].ToString();
				FResourceFilename = oDB["resource_filename"].ToString();
				FResourceURL      = oDB["resource_url"].ToString();
			}
			oDB.Free();
		}

		/// <summary>
		/// 在数据库中插入记录。
		/// </summary>
		public void Insert()
		{
			string ExSql = "newid(), '"+FResourceAID+"', '"+FResourceUID+"', null, getdate(), '"+FResourceName+"', '"+FResourceDesc+"', '"+FResourceFilename+"', '"+FResourceURL+"'";
			base.Insert(ExSql);
		}

		/// <summary>
		/// 在数据库中更新记录。
		/// </summary>
		public void Update()
		{
			string ExSql = "resource_time=getdate(), resource_name='"+FResourceName+"', resource_desc='"+FResourceDesc+"', resource_filename='"+FResourceFilename+"', resource_url='"+FResourceURL+"'";
			base.Update(ExSql);
		}

		public string UploadPath
		{
			get
			{
				return "./"+FUploadPath;
			}
		}

		public string ResourceAID
		{
			get
			{
				return FResourceAID;
			}
			set
			{
				FResourceAID= value;
			}
		}

		public string ResourceUID
		{
			get
			{
				return FResourceUID;
			}
			set
			{
				FResourceUID= value;
			}
		}

		public string ResourceName
		{
			get
			{
				return FResourceName;
			}
			set
			{
				FResourceName= value;
			}
		}

		public string ResourceDesc
		{
			get
			{
				return FResourceDesc;
			}
			set
			{
				FResourceDesc= value;
			}
		}

		public string ResourceFilename
		{
			get
			{
				return FResourceFilename;
			}
			set
			{
				FResourceFilename= value;
			}
		}

		public string ResourceURL
		{
			get
			{
				return FResourceURL;
			}
			set
			{
				FResourceURL= value;
			}
		}
	}

	/// <summary>
	/// TCmsResourceRset 的摘要说明。
	/// </summary>
	public class TCmsResourceRset : TDataRset
	{
		const string CTableName = "t_resource";
		const string CKeyName   = "resource_id";

		public TCmsResourceRset()
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			Load();
		}

		public TCmsResourceRset(string ArticleID)
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			SqlWhere   = "resource_aid='"+ArticleID+"'";
			Load();
		}
	}
}