当前文件： myBBS/App_Code/BusinessLogicLayer/User.cs[4K，2009-6-12 11:48:08]，打开代码结构图

		            
  1/**//**********************************************************
  2 * 说明：用户类User
  3 * 作者：
  4 * 创建日期：
  5 *********************************************************/
  6using System;
  7using System.Collections;
  8using System.Data;
  9
 10using MyBBS.DataAccessLayer;
 11using MyBBS.DataAccessHelper;
 12
 13namespace MyBBS.BusinessLogicLayer
 14...{
 15    /**//// <summary>
 16    /// User 的摘要说明。
 17    /// </summary>
 18    public class User
 19    ...{
 20        私有成员#region 私有成员
 21
 22        private int _userID;        //用户ID
 23        private string _loginName;    //用户登录名
 24        private string _userName;    //用户姓名
 25        private string _password;    //用户密码
 26        private string _address;    //用户地址
 27        private string _homepage;    //用户主页
 28        private string _email;        //用户Email
 29
 30        private bool _exist;        //是否存在标志
 31
 32        #endregion 私有成员
 33
 34        属性#region 属性
 35
 36        public int UserID
 37        ...{
 38            set
 39            ...{
 40                this._userID = value;
 41            }
 42            get
 43            ...{
 44                return this._userID;
 45            }
 46        }
 47        public string LoginName
 48        ...{
 49            set
 50            ...{
 51                this._loginName = value;
 52            }
 53            get
 54            ...{
 55                return this._loginName;
 56            }
 57        }
 58        public string UserName
 59        ...{
 60            set
 61            ...{
 62                this._userName = value;
 63            }
 64            get
 65            ...{
 66                return this._userName;
 67            }
 68        }
 69        public string Password
 70        ...{
 71            set
 72            ...{
 73                this._password = value;
 74            }
 75            get
 76            ...{
 77                return this._password;
 78            }
 79        }
 80        public string Address
 81        ...{
 82            set
 83            ...{
 84                this._address = value;
 85            }
 86            get
 87            ...{
 88                return this._address;
 89            }
 90        }
 91        public string Homepage
 92        ...{
 93            set
 94            ...{
 95                this._homepage = value;
 96            }
 97            get
 98            ...{
 99                return this._homepage;
100            }
101        }
102        public string Email
103        ...{
104            set
105            ...{
106                this._email = value;
107            }
108            get
109            ...{
110                return this._email;
111            }
112        }
113        public bool Exist
114        ...{
115            get
116            ...{
117                return this._exist;
118            }
119        }
120
121        #endregion 属性
122
123        方法#region 方法
124
125        /**//// <summary>
126        /// 根据参数userID，获取用户详细信息
127        /// </summary>
128        /// <param name="loginName">用户登录名</param>
129        public void LoadData(string loginName)
130        ...{
131            Database db = new Database();        //实例化一个Database类
132
133            string sql = "";
134            sql = "Select * from [User] where LoginName = "
135                + SqlStringFormat.GetQuotedString(loginName);
136
137            DataRow dr = db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询用户数据
138
139            //根据查询得到的数据，对成员赋值
140            if (dr != null)
141            ...{
142                this._userID = GetSafeData.ValidateDataRow_N(dr, "UserID");
143                this._loginName = GetSafeData.ValidateDataRow_S(dr, "loginName");
144                this._userName = GetSafeData.ValidateDataRow_S(dr, "UserName");
145                this._password = GetSafeData.ValidateDataRow_S(dr, "PassWord");
146                this._address = GetSafeData.ValidateDataRow_S(dr, "Address");
147                this._homepage = GetSafeData.ValidateDataRow_S(dr, "HomePage");
148                this._email = GetSafeData.ValidateDataRow_S(dr, "Email");
149
150                this._exist = true;
151            }
152            else
153            ...{
154                this._exist = false;
155            }
156        }
157
158        /**//// <summary>
159        /// 向数据库添加一个用户
160        /// </summary>
161        /// <param name="htUserInfo">用户信息哈希表</param>
162        public void Add(Hashtable userInfo)
163        ...{
164            Database db = new Database();        //实例化一个Database类
165            db.Insert("[User]", userInfo);    //利用Database类的GetDataRow方法查询用户数据
166        }
167
168        /**//// <summary>
169        /// 判断是否存在登录名为loginName的用户
170        /// </summary>
171        /// <param name="loginName">用户登录名</param>
172        /// <returns>如果存在，返回true；否则，返回false</returns>
173        public static bool HasUser(string loginName)
174        ...{
175            Database db = new Database();
176
177            string sql = "";
178            sql = "Select * from [User] where [LoginName] = "
179                + SqlStringFormat.GetQuotedString(loginName);
180
181            DataRow row = db.GetDataRow(sql);
182            if (row != null)
183                return true;
184            else
185                return false;
186        }
187        #endregion 方法
188    }
189}
190