论坛App_Code BusinessLogicLayer（3）

User.cs

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

using MyBBS.DataAccessLayer;
using MyBBS.DataAccessHelper;

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

        private int _userID;  //用户ID
        private string _loginName; //用户登录名
        private string _userName; //用户姓名
        private string _password; //用户密码
        private string _address; //用户地址
        private string _homepage; //用户主页
        private string _email;  //用户Email

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

        #endregion 私有成员

        #region 属性

        public int UserID
        {
            set
            {
                this._userID = value;
            }
            get
            {
                return this._userID;
            }
        }
        public string LoginName
        {
            set
            {
                this._loginName = value;
            }
            get
            {
                return this._loginName;
            }
        }
        public string UserName
        {
            set
            {
                this._userName = value;
            }
            get
            {
                return this._userName;
            }
        }
        public string Password
        {
            set
            {
                this._password = value;
            }
            get
            {
                return this._password;
            }
        }
        public string Address
        {
            set
            {
                this._address = value;
            }
            get
            {
                return this._address;
            }
        }
        public string Homepage
        {
            set
            {
                this._homepage = value;
            }
            get
            {
                return this._homepage;
            }
        }
        public string Email
        {
            set
            {
                this._email = value;
            }
            get
            {
                return this._email;
            }
        }
        public bool Exist
        {
            get
            {
                return this._exist;
            }
        }

        #endregion 属性

        #region 方法

        /// <summary>
        /// 根据参数userID，获取用户详细信息
        /// </summary>
        /// <param name="loginName">用户登录名</param>
        public void LoadData(string loginName)
        {
            Database db = new Database();  //实例化一个Database类

            string sql = "";
            sql = "Select * from [User] where LoginName = "
                + SqlStringFormat.GetQuotedString(loginName);

            DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询用户数据

            //根据查询得到的数据，对成员赋值
            if (dr != null)
            {
                this._userID = GetSafeData.ValidateDataRow_N(dr, "UserID");
                this._loginName = GetSafeData.ValidateDataRow_S(dr, "loginName");
                this._userName = GetSafeData.ValidateDataRow_S(dr, "UserName");
                this._password = GetSafeData.ValidateDataRow_S(dr, "PassWord");
                this._address = GetSafeData.ValidateDataRow_S(dr, "Address");
                this._homepage = GetSafeData.ValidateDataRow_S(dr, "HomePage");
                this._email = GetSafeData.ValidateDataRow_S(dr, "Email");

                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("[User]", userInfo); //利用Database类的GetDataRow方法查询用户数据
        }

        /// <summary>
        /// 判断是否存在登录名为loginName的用户
        /// </summary>
        /// <param name="loginName">用户登录名</param>
        /// <returns>如果存在，返回true；否则，返回false</returns>
        public static bool HasUser(string loginName)
        {
            Database db = new Database();

            string sql = "";
            sql = "Select * from [User] where [LoginName] = "
                + SqlStringFormat.GetQuotedString(loginName);

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