using System;

namespace _lib
{
	public enum EUserRank : short	// 用戶級別值
	{
		Administrator  = 0,
		User           = 1,
		Upper_Bound    = 2,
	}

	/// <summary>
	/// TCmsUser 的摘要說明。
	/// </summary>
	public class TCmsUser : TData
	{
		const string CTableName = "t_user";
		const string CKeyName   = "user_id";

		private string FUserID;
		private int FUserSort;
		private DateTime FUserTime;
		private string FUsername;
		private string FUserPwd;
		private string FUserRealName;
		private string FUserTel;
		private string FUserEmail;
		private int FUserStatus;

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

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

		public TCmsUser(System.Web.UI.Page page)
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			FKeyValue  = (string)page.Session["uid"];
		}

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

		/// <summary>
		/// 在數(shù)據(jù)庫中檢索記錄（已重寫）。
		/// </summary>
		public override void Select()
		{
			string strSql= GetSelectString();
			TSqlDB oDB= new TSqlDB(strSql);
			if (!oDB.EOF)
			{
				FUserID       = oDB["user_id"      ].ToString();
				FUserSort     = oDB["user_sort"    ].ToInt();
				FUserTime     = oDB["user_time"    ].ToDateTime();
				FUsername     = oDB["user_name"    ].ToString();
				FUserPwd      = oDB["user_pwd"     ].ToString();
				FUserRealName = oDB["user_realname"].ToString();
				FUserTel      = oDB["user_tel"     ].ToString();
				FUserEmail    = oDB["user_email"   ].ToString();
				FUserStatus   = oDB["user_status"  ].ToInt();
			}
			oDB.Free();
		}

		/// <summary>
		/// 在數(shù)據(jù)庫中插入記錄。
		/// </summary>
		public void Insert()
		{
			string ExSql = "newid(), null, getdate(), '"+FUsername+"', '"+FUserPwd+"', '"+FUserRealName+"', '"+FUserTel+"', '"+FUserEmail+"', 1, 0";
			base.Insert(ExSql);
		}

		/// <summary>
		/// 在數(shù)據(jù)庫中更新記錄。
		/// </summary>
		public void Update()
		{
			string ExSql = "user_time=getdate(), user_name='"+FUsername+"', user_pwd='"+FUserPwd+"', user_realname='"+FUserRealName+"', user_tel='"+FUserTel+"', user_email='"+FUserEmail+"', user_status="+FUserStatus;
			base.Update(ExSql);
		}

		public bool isNull	// 各項屬性是否為空
		{
			get
			{
				return (FKeyValue==null) || (FKeyValue=="");
			}
		}

		public string Username
		{
			get
			{
				return FUsername;
			}
			set
			{
				FUsername= value;
			}
		}

		public string UserPwd
		{
			get
			{
				return FUserPwd;
			}
			set
			{
				FUserPwd= value;
			}
		}

		public string UserRealName
		{
			get
			{
				return FUserRealName;
			}
			set
			{
				FUserRealName= value;
			}
		}

		public string UserTel
		{
			get
			{
				return FUserTel;
			}
			set
			{
				FUserTel= value;
			}
		}

		public string UserEmail
		{
			get
			{
				return FUserEmail;
			}
			set
			{
				FUserEmail= value;
			}
		}

		#region 根據(jù)用戶名和密碼檢查用戶身份
		/// <summary>
		/// （靜態(tài)）私有：根據(jù)用戶名和密碼檢查用戶身份
		/// 用戶名和密碼正確則返回UID，否則返回“”
		/// </summary>
		private static string CheckLoginReturnUID(string username, string userpwd)
		{
			username= username.Trim();
			userpwd = userpwd.Trim();

			string Result= "";
			bool isValid= false;

			// 驗證數(shù)據(jù)庫用戶，并取ID
			string strSql= "select user_id from t_user where user_name='"+username+"' and user_pwd='"+userpwd+"'";
			TSqlDB oUser= new TSqlDB(strSql);
			isValid= !oUser.EOF;
			if (isValid)
				Result= oUser["user_id"].ToString();
			oUser.Free();

			// 返回結果
			return Result;
		}

		/// <summary>
		/// （靜態(tài)）根據(jù)用戶名和密碼檢查用戶身份
		/// 用戶名和密碼正確則返回“真”，否則返回“假”
		/// </summary>
		public static bool CheckLogin(string username, string userpwd)
		{
			bool Result= false;
			string UserID= CheckLoginReturnUID(username, userpwd);
			Result= UserID.Length>0;

			// 返回結果
			return Result;
		}

		/// <summary>
		/// （靜態(tài)）根據(jù)用戶名和密碼檢查用戶身份
		/// 用戶名和密碼正確則返回“真”，否則返回“假”，并將UID保存在Session中
		/// </summary>
		public static bool CheckLogin(string username, string userpwd, System.Web.UI.Page page)
		{
			bool Result= false;
			string UserID= CheckLoginReturnUID(username, userpwd);
			Result= UserID.Length>0;

			// 保存Session
			if (Result)
				page.Session["uid"]= UserID;

			// 返回結果
			return Result;
		}
		#endregion

		/// <summary>
		///（靜態(tài)）檢查用戶是否是合法用戶
		/// </summary>
		public static void CheckUser(System.Web.UI.Page page)
		{
			bool Result = false;

			TCmsUser oUser = new TCmsUser(page);
			Result = !oUser.isNull;

			if (!Result)
				page.Server.Transfer("login.aspx");
		}

		/// <summary>
		///（靜態(tài)）檢查用戶是否是管理員
		/// </summary>
		public static void CheckAdmin(System.Web.UI.Page page)
		{
			bool Result = false;

			if ((page.Session["uid"]!=null)&&(page.Session["uid"].ToString().Length>0))
			{
				// 驗證數(shù)據(jù)庫用戶
				string strSql= "select user_id from t_user where user_rank=0 and user_id='"+(string)page.Session["uid"]+"'";
				TSqlDB oUser= new TSqlDB(strSql);
				Result= !oUser.EOF;
				oUser.Free();
			}

			if (!Result)
				page.Server.Transfer("login.aspx");
		}
	}

	/// <summary>
	/// TCmsArticleRset 的摘要說明。
	/// </summary>
	public class TCmsUserRset : TDataRset
	{
		const string CTableName = "t_user";
		const string CKeyName   = "user_id";

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