温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:替某公司写的一个小论坛(供新人参考)
当前文件:
lingdaBBS/App_Code/DataLogicLayer/LoginUser.cs[7K,2009-6-12 11:47:01],打开代码结构图
lingdaBBS/App_Code/DataLogicLayer/LoginUser.cs[7K,2009-6-12 11:47:01],打开代码结构图1using System; 2
using System.Data; 3
using System.Configuration; 4
using DataBaseLayer; 5
6
namespace 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







}