using System;

namespace _lib
{
	/// <summary>
	/// TCmsColumn 的摘要說明。
	/// </summary>
	public class TCmsColumn : TData
	{
		const string CTableName = "t_column";
		const string CKeyName   = "column_id";

		private string FColumnID;
		private string FColumnName;

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

		public override void Select()
		{
			string strSql= GetSelectString();
			TSqlDB oDB= new TSqlDB(strSql);
			if (!oDB.EOF)
			{
				FColumnID      = oDB["column_id"].ToString();
				FColumnName    = oDB["column_name"].ToString();
			}
			oDB.Free();
		}

		public string ColumnName
		{
			get
			{
				return FColumnName;
			}
			set
			{
				FColumnName= value;
			}
		}
	}

	/// <summary>
	/// TCmsColumnRset 的摘要說明。
	/// </summary>
	public class TCmsColumnRset : TDataRset
	{
		const string CTableName = "t_column";
		const string CKeyName   = "column_id";

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

		public TCmsColumnRset(string SqlOrderBy)
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			FSqlOrderBy= SqlOrderBy;
			Load();
		}
	}
}