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>
		/// （靜態(tài)）根據(jù)編號在數(shù)據(jù)庫中刪除記錄。
		/// </summary>
		public static void DeleteByID(string ID)
		{
			TData.DeleteByID(ID, CTableName, CKeyName);
		}

		/// <summary>
		/// （靜態(tài)）使用文章編號，查詢與之相關(guān)的資源編號。
		/// </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>
		/// 在數(shù)據(jù)庫中檢索記錄（已重寫）。
		/// </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>
		/// 在數(shù)據(jù)庫中插入記錄。
		/// </summary>
		public void Insert()
		{
			string ExSql = "newid(), '"+FResourceAID+"', '"+FResourceUID+"', null, getdate(), '"+FResourceName+"', '"+FResourceDesc+"', '"+FResourceFilename+"', '"+FResourceURL+"'";
			base.Insert(ExSql);
		}

		/// <summary>
		/// 在數(shù)據(jù)庫中更新記錄。
		/// </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();
		}
	}
}