论坛App_Code BusinessLogicLayer（3）

最新推荐文章于 2025-03-27 21:47:16 发布

原创最新推荐文章于 2025-03-27 21:47:16 发布 · 497 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个用户类User的设计实现，该类包括用户的各项属性如ID、登录名等，并提供了加载数据、添加用户及检查用户是否存在的方法。

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 方法
    }
}