📄 member.cs
字号:
using System;
using System.Data;
using System.Data.SqlClient;
namespace Wrox.WebModules.Forums.Business
{
/// <summary>
/// Summary description for Category.
/// </summary>
public sealed class Member : Wrox.WebModules.Business.BizObject
{
private Configuration.ModuleSettings settings;
private int memberID;
private int userID;
private string name;
private string email;
private bool showEmail;
private string signature;
private string avatarUrl;
private string homepage;
private DateTime addedDate;
// constructors
public Member()
{
settings = Configuration.ModuleConfig.GetSettings();
ResetProperties();
}
public Member(int existingMemberID)
{
settings = Configuration.ModuleConfig.GetSettings();
memberID = existingMemberID;
LoadFromID();
}
public Member(Member existingMember)
{
settings = Configuration.ModuleConfig.GetSettings();
memberID = existingMember.ID;
LoadFromID();
}
// retrieve the values for the properties
private void LoadFromID()
{
Data.Members members = new Data.Members(settings.ConnectionString);
Data.MemberDetails details = members.GetDetails(memberID);
memberID = details.MemberID;
userID = details.UserID;
name = details.Name;
email = details.Email;
showEmail = details.ShowEmail;
signature = details.Signature;
avatarUrl = details.AvatarUrl;
homepage = details.Homepage;
addedDate = details.AddedDate;
}
public int LoadFromID(int existingMemberID)
{
memberID = existingMemberID;
LoadFromID();
return memberID;
}
// load the member info from the specified userID
public int LoadFromUser(int memberUserID)
{
Data.Members members = new Data.Members(settings.ConnectionString);
memberID = members.GetMemberID(memberUserID);
if (memberID == -1)
ResetProperties();
else
LoadFromID();
return memberID;
}
// reset the properties
private void ResetProperties()
{
memberID = -1;
userID = -1;
name = "";
email = "";
showEmail = false;
signature = "";
avatarUrl = "";
homepage = "";
addedDate = new DateTime();
}
// create a new record
public int Create(int memberUserID, string memberName, bool memberShowEmail,
string memberSignature, string memberAvatarUrl, string memberHomepage)
{
Data.Members members = new Data.Members(settings.ConnectionString);
memberID = members.Add(memberUserID, memberName, memberShowEmail, memberSignature,
memberAvatarUrl, memberHomepage);
LoadFromID();
return memberID;
}
// update the record represented by this object
public bool Update()
{
Data.Members members = new Data.Members(settings.ConnectionString);
return members.Update(memberID, name, showEmail, signature, avatarUrl, homepage);
}
// delete the record represented by this object
public bool Delete()
{
Data.Members members = new Data.Members(settings.ConnectionString);
bool ret = members.Delete(memberID);
ResetProperties();
return ret;
}
// return the members
public static DataSet GetMembers()
{
Configuration.ModuleSettings settings = Configuration.ModuleConfig.GetSettings();
Data.Members members = new Data.Members(settings.ConnectionString);
return members.GetMembers();
}
// PROPERTIES DEFINED BELOW
public int ID
{
get { return memberID; }
}
public int UserID
{
get { return userID; }
}
public string Name
{
get { return name; }
set { name = value; }
}
public string Email
{
get { return email; }
set { email = value; }
}
public string Signature
{
get { return signature; }
set { signature = value; }
}
public string AvatarUrl
{
get { return avatarUrl; }
set { avatarUrl = value; }
}
public string Homepage
{
get { return homepage; }
set { homepage = value; }
}
public bool ShowEmail
{
get { return showEmail; }
set { showEmail = value; }
}
public DateTime AddedDate
{
get { return addedDate; }
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -