user.cs

一个试题库设计

/**********************************************************
 * 说明：用户类User
 * 作者：
 * 创建日期：
 *********************************************************/
using System;
using System.Collections;
using System.Data;

using TQMS.DataAccessLayer;
using TQMS.DataAccessHelper;

namespace TQMS.BusinessLogicLayer
{
	/// <summary>
	/// User 的摘要说明。
	/// </summary>
	public class User
	{
		#region 私有成员

		private int _userID;		//用户ID
		private string _userName;	//用户登录名
		private string _trueName;	//用户姓名
		private string _password;	//用户密码
		private string _email;	//用户地址
        private string _userType;


		private bool _exist;		//是否存在标志

		#endregion 私有成员

		#region 属性
		
		public int UserID
		{
			set
			{
				this._userID=value;
			}
			get
			{
				return this._userID;
			}
		}
		public string UserName
		{
			set
			{
				this._userName=value;
			}
			get
			{
				return this._userName;
			}
		}
		public string TrueName
		{
			set
			{
				this._trueName=value;
			}
			get
			{
				return this._trueName;
			}
		}
		public string Password
		{
			set
			{
				this._password=value;
			}
			get
			{
				return this._password;
			}
		}
		public string Email
		{
			set
			{
				this._email=value;
			}
			get
			{
				return this._email;
			}
		}
       
        public string UserType
        {
            set
            {
                this._userType = value;
            }
            get
            {
                return this._userType;
            }
        }
		public bool Exist
		{
			get
			{
				return this._exist;
			}
		}


		#endregion 属性

		#region 方法
		
		/// <summary>
		/// 根据参数loginName，获取用户详细信息
		/// </summary>
		/// <param name="loginName">用户登录名</param>
        public void LoadData(string userName)
        {
            Database db = new Database();		//实例化一个Database类
            string sql = "";
            sql = "Select * from [TQ_UserInfo] where TQ_UserName = "
                + SqlStringConstructor.GetQuotedString(userName);
            DataRow dr = db.GetDataRow(sql);	//利用Database类的GetDataRow方法查询用户数据
            //根据查询得到的数据，对成员赋值
            if (dr != null)
            {
                this._userID = GetSafeData.ValidateDataRow_N(dr, "TQ_UserID");
                this._userName = GetSafeData.ValidateDataRow_S(dr, "TQ_UserName");
                this._trueName = GetSafeData.ValidateDataRow_S(dr, "TQ_TureName");
                this._password = GetSafeData.ValidateDataRow_S(dr, "TQ_UserPwd");
                this._email = GetSafeData.ValidateDataRow_S(dr, "TQ_Email");
                this._userType = GetSafeData.ValidateDataRow_S(dr, "TQ_UserType");
                this._exist = true;
            }
            else
            {
                this._exist = false;
            }
        }


		/// <summary>
		/// 根据参数loginName，获取用户详细信息
		/// </summary>
		/// <param name="userId">用户ID</param>
        public void LoadData(int userID)
        {
            Database db = new Database();		//实例化一个Database类
            string sql = "";
            sql = "Select * from [TQ_UserInfo] where TQ_UserID = " + UserID.ToString();
            DataRow dr = db.GetDataRow(sql);	//利用Database类的GetDataRow方法查询用户数据
            //根据查询得到的数据，对成员赋值
            if (dr != null)
            {
                this._userID = GetSafeData.ValidateDataRow_N(dr, "TQ_UserID");
                this._userName = GetSafeData.ValidateDataRow_S(dr, "TQ_UserName");
                this._trueName = GetSafeData.ValidateDataRow_S(dr, "TQ_TureName");
                this._password = GetSafeData.ValidateDataRow_S(dr, "TQ_UserPwd");
                this._email = GetSafeData.ValidateDataRow_S(dr, "TQ_Email");
                this._userType = GetSafeData.ValidateDataRow_S(dr, "TQ_UserType");
                this._exist = true;
            }
            else
            {
                this._exist = false;
            }
        }

		/// <summary>
		/// 向数据库添加一个用户
		/// </summary>
		/// <param name="htUserInfo">用户信息哈希表</param>
		public void Add(Hashtable userInfo)
		{
			Database db=new Database();		//实例化一个Database类
			db.Insert("[TQ_UserInfo]",userInfo );	//利用Database类的GetDataRow方法查询用户数据
		}


        /// <summary>
        /// 删除用户数据
        /// </summary>
        /// <param name="loginName">用户登录名</param>
        public static bool Delete(int userID)
        {
            Database db = new Database();		//实例化一个Database类
            string sql = "Delete from [TQ_UserInfo] Where [TQ_UserID]= " + userID;
            if (db.ExecuteSQL(sql) > 0) 
                return true;
            else
                return false;
            

        }
		/// <summary>
		/// 判断是否存在登录名为loginName的用户
		/// </summary>
		/// <param name="loginName">用户登录名</param>
		/// <returns>如果存在，返回true；否则，返回false</returns>
		public static bool HasUser(string userName)
		{
			Database db=new Database();
			
			string sql="";
			sql="Select * from [TQ_UserInfo] where [TQ_UserName] = "
				+SqlStringConstructor.GetQuotedString(userName);

			DataRow row=db.GetDataRow(sql);
			if(row!=null)
				return true;
			else
				return false;
		}

        /// <summary>
        /// 查询用户
        /// </summary>
        /// <param name="queryItems"></param>
        /// <returns></returns>
        public static DataTable QueryUsers(Hashtable queryItems)
        {
            string where = SqlStringConstructor.GetConditionClause(queryItems);
            string sql = "Select * From [TQ_UserInfo]" + where;
            

         
            Database db = new Database();
            return db.GetDataTable(sql);
        }
		
		#endregion 方法
	}
}