1
using System;
2using System.Data;
3using System.Configuration;
4using DataBaseLayer;
5
6namespace DataLogicLayer
7
...{
8
public class LoginUser
9
...{
10 私有成员#region 私有成员
11 private int _UserID; //主键，用户ID
12 private string _UserName; //用户名
13 private string _UserPwd; //密码
14 private string _UserEmail; //EMAIL
15 private string _UserAge; //年龄
16 private string _UserSex; //性别
17 private string _UserQuestion; //密码提示问题
18 private string _UserAnswer; //答案
19 private DateTime _UserRegisterTime; //注册时间
20 private DateTime _UserLastLoginTime; //最后登录时间
21 private int _UserTitleCount; //发表主题总数
22 private int _UserReplyCount; //回复总数
23 private bool _IsOnline; //用户是否在线
24 private string _UserQQ; //QQ号
25
#endregion 私有成员
26
27 属性#region 属性
28 public int UserID
29 ...{
30 get ...{ return _UserID; }
31 set ...{ _UserID = value; }
32 }
33 public string UserName
34 ...{
35 get ...{ return _UserName; }
36 set ...{ _UserName = value; }
37 }
38 public string UserPwd
39 ...{
40 get ...{ return _UserPwd; }
41 set ...{ _UserPwd = value; }
42 }
43 public string UserEmail
44 ...{
45 get ...{ return _UserEmail; }
46 set ...{ _UserEmail = value; }
47 }
48
49 public string UserAge
50 ...{
51 get ...{ return _UserAge; }
52 set ...{ _UserAge = value; }
53 }
54
55 public string UserSex
56 ...{
57 get ...{ return _UserSex; }
58 set ...{ _UserSex = value; }
59 }
60
61 public string UserQuestion
62 ...{
63 get ...{ return _UserQuestion; }
64 set ...{ _UserQuestion = value; }
65 }
66
67 public string UserAnswer
68 ...{
69 get ...{ return _UserAnswer; }
70 set ...{ _UserAnswer = value; }
71 }
72 public DateTime UserRegisterTime
73 ...{
74 get ...{ return _UserRegisterTime; }
75 set ...{ _UserRegisterTime = value; }
76 }
77 public DateTime UserLastLoginTime
78 ...{
79 get ...{ return _UserLastLoginTime; }
80 set ...{ _UserLastLoginTime = value; }
81 }
82 public int UserTitleCount
83 ...{
84 get ...{ return _UserTitleCount; }
85 set ...{ _UserTitleCount = value; }
86 }
87 public int UserReplyCount
88 ...{
89 get ...{ return _UserReplyCount; }
90 set ...{ _UserReplyCount = value; }
91 }
92 public bool IsOnline
93 ...{
94 get ...{ return _IsOnline; }
95 set ...{ _IsOnline = value; }
96 }
97 public string UserQQ
98 ...{
99 get ...{ return _UserQQ; }
100 set ...{ _UserQQ = value; }
101 }
102 #endregion 属性
103
104 方法#region 方法
105 //注册一个新的用户
106 public bool RegisterUser(LoginUser user)
107 ...{
108 string sqlString = "insert into LD_User(UserName,UserPwd,userEmail,UserAge,UserSex,UserRegisterTime,UserQuestion,UserAnswer,UserQQ,UserLastLoginTime) values ('"
109 + user.UserName + "','" + user.UserPwd + "','" +user.UserEmail +"','"+user.UserAge+"','"+user.UserSex+"','"+user.UserRegisterTime+"','"+user.UserQuestion
110 +"','"+user.UserAnswer+"','"+user.UserQQ+"','"+user.UserLastLoginTime+"')";
111 DataBase db = new DataBase();
112 int result = db.ExecuteSQL(sqlString);
113 if (result < 1)
114 return false;
115 return true;
116 }
117 //通过用户名，获得用户ID
118 public string getLoginUserID(string userName)
119 ...{
120 string sqlString = "select [userID] from LD_User where userName='" + userName + "'";
121 DataBase db = new DataBase();
122 DataRow dr = db.GetDataRow(sqlString);
123 if (dr!=null)
124 ...{
125 return dr["UserID"].ToString();
126 }
127 else
128 ...{
129 return null;
130 }
131 }
132
133 //通过用户ID，获得用户名
134 public string getLoginUserName(int userID)
135 ...{
136 string sqlString = "select [userName] from LD_User where userID='"+userID+"'";
137 DataBase db = new DataBase();
138 DataRow dr = db.GetDataRow(sqlString);
139 if (GetSafeData.getStringDataRow(dr, "userID") != null)
140 ...{
141 return GetSafeData.getStringDataRow(dr, "userID");
142 }
143 else
144 ...{
145 return "对不起，您还没有登录";
146 }
147 }
148
149 //验证用户是否存在
150 public bool checkNameByUsed(string userName)
151 ...{
152 string sqlString = "select * from LD_User where UserName='" + userName + "'";
153 DataBase db = new DataBase();
154 //DataRow dr = db.GetDataRow(sqlString);
155
156 int result = db.GetDataTable(sqlString).Rows.Count;
157 if (result > 0)
158 ...{
159 return true;
160 }
161 else
162 ...{
163 return false;
164 }
165
166 }
167
168 //获得最新注册用户名
169 public string getNewUserName()
170 ...{
171 string sqlString = "select top 1 userName from userInfo order by userid desc";
172 DataBase db = new DataBase();
173 DataRow dr = db.GetDataRow(sqlString);
174 return dr["userName"].ToString();
175 }
176
177 //获得用户总数
178 public string getAllLoginUser()
179 ...{
180 string sqlString = "select count(*) from userInfo";
181 DataBase db = new DataBase();
182 DataRow dr = db.GetDataRow(sqlString);
183 return dr[0].ToString();
184 }
185
186 //比较密码是否相同
187 public bool EqualPwd(string userName,string pwd)
188 ...{
189 string sqlStr="select UserPwd from LD_User where UserName='"+userName+"'";
190 DataBase db = new DataBase();
191 DataRow dr = db.GetDataRow(sqlStr);
192 /**/////////////////
193 if(dr["UserPwd"].ToString()==pwd)
194 ...{
195 return true;
196 }
197 else
198 ...{
199 return false;
200 }
201 }
202
203 //更新用户发帖子数
204 public int UpdateTitleCount(LoginUser user)
205 ...{
206 string sqlStr = "update LD_User set UserTitleCount=" + user.UserTitleCount + " where UserID=" + user.UserID;
207 DataBase db = new DataBase();
208 return db.ExecuteSQL(sqlStr);
209 }
210
211 //更新用户回帖表
212 public int UpdateReplyCount(LoginUser user)
213 ...{
214 string sqlStr = "update LD_User set UserReplyCount=" + user.UserReplyCount + " where UserID=" + user.UserID;
215 DataBase db = new DataBase();
216 return db.ExecuteSQL(sqlStr);
217 }
218
219 //获得用户主帖子数
220 public int getUserTitleCount(int UserID)
221 ...{
222 string sqlStr = "select UserTitleCount from LD_User where UserID=" + UserID;
223 DataBase db = new DataBase();
224 return System.Convert.ToInt32(db.GetDataRow(sqlStr)["UserTitleCount"]);
225 }
226
227 //获得用户回帖数
228 public int getUserReplyCount(int UserID)
229 ...{
230 string sqlStr = "select UserReplyCount from LD_User where UserID=" + UserID;
231 DataBase db = new DataBase();
232 return System.Convert.ToInt32(db.GetDataRow(sqlStr)["UserReplyCount"]);
233 }
234 #endregion 方法
235 }
236
237
}
238
lingdaBBS/App_Code/DataLogicLayer/LoginUser.cs[7K，2009-6-12 11:47:01]，打开代码结构图
打包下载该项目完整源码：替某公司写的一个小论坛（供新人参考）