/// <summary>
/// 保存会员历史信息(在每次创建会员及更新会员信息时产生一条历史信息)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int SaveHistoryOfMemberUpdate(HistoryOfMemberUpdate model)
{
int id = -1;
if (model != null)
{
var conf = new Configuration().Configure();
ISession session = NHibernateHelper.GetSession();
//配置NHibernate
//在Configuration中添加HbmMapping
conf.AddDeserializedMapping(NHibernateHelper.GetEntityMapping<HistoryOfMemberUpdate>(), "HistoryOfMemberUpdateXML");
//配置数据库架构元数据
SchemaMetadataUpdater.QuoteTableAndColumns(conf);
//建立SessionFactory
var factory = conf.BuildSessionFactory();
//打开Session做持久化数据
using (session = factory.OpenSession())
{
using (var tx = session.BeginTransaction())
{
id = (int)session.Save(model);
tx.Commit();
}
}
}
return id;
}
/// <summary>
/// 会员激活
/// </summary>
/// <param name="MemberID"></param>
/// <param name="VerifictionCode"></param>
/// <param name="Msg"></param>
/// <returns></returns>
public bool ActivatMember(int MemberID, string VerifictionCode,ref string Msg)
{
IList<Member> list = MemberOP.GetAllMemberByID(MemberID);
if (list.Count > 0)
{
if (list[0].VerifictionCodeLimit < DateTime.Now)
{
Msg = "验证码有效期已过，请重新发送验证码";
return false;
}
else
{
if (list[0].VerifictionCode.Trim().Equals(VerifictionCode.Trim()))
{
//修改用户状态为正常
list[0].Status = 0;
list[0].Integral = 100;
list[0].UpdateTime = DateTime.Now;
bool isSuccess = MemberOP.UpdateMember(list[0]);
//添加用户历史信息
if (isSuccess)
{
#region 会员历史信息
HistoryOfMemberUpdate modelHis = new HistoryOfMemberUpdate();
modelHis.CreatTime = DateTime.Now;
modelHis.MemberId = list[0].Id;
modelHis.OpenId = list[0].OpenId;
modelHis.Nickname = list[0].Nickname;
modelHis.Question1 = list[0].Question1;
modelHis.Question2 = list[0].Question2;
modelHis.Question3 = list[0].Question3;
modelHis.Anwser1 = list[0].Anwser1;
modelHis.Anwser2 = list[0].Anwser2;
modelHis.Anwser3 = list[0].Anwser3;
modelHis.Email = list[0].Email;
modelHis.Phone = list[0].Phone;
modelHis.LoginPWD = list[0].LoginPWD;
modelHis.Type = list[0].Type;
modelHis.Photo = list[0].Photo;
modelHis.PhotoURL = list[0].PhotoURL;
modelHis.Gender = list[0].Gender;
modelHis.Birthday = list[0].Birthday;
modelHis.Birthplace = list[0].Birthplace;
modelHis.Education = list[0].Education;
modelHis.Job = list[0].Job;
modelHis.Address = list[0].Address;
modelHis.LoginTimes = list[0].LoginTimes;
modelHis.LastLoginDateTime = list[0].LastLoginDateTime;
modelHis.CurrentLoginDateTime = list[0].CurrentLoginDateTime;
modelHis.Integral = list[0].Integral;
modelHis.Status = list[0].Status;
#endregion
if (MemberOP.SaveHistoryOfMemberUpdate(modelHis) == -1)
{
Msg = "保存会员历史信息发生错误";
return false;
}
else
{
return true;
}
}
else
{
Msg = "保存会员信息发生错误";
return false;
}
}
else
{
Msg = "验证码错误";
return false;
}
}
}
else
{
Msg = "没有找到本会员信息";
return false;
}
}
/// <summary>
/// 会员登录
/// </summary>
/// <param name="Member"></param>
/// <param name="Msg"></param>
/// <returns></returns>
public bool LoginMember(Member modelMember,ref string Msg)
{
bool isSuccess = false;
try
{
IList<Member> list = MemberOP.GetMemberByOpenID(modelMember.OpenId);
if (list.Count > 0)
{
list[0].LoginTimes += 1;
list[0].Nickname = modelMember.Nickname;
//如果最后登录时间不是今天（也就是今天第一次登录）积分+10
if (list[0].LastLoginDateTime.Value.Date != DateTime.Now.Date && list[0].LastLoginDateTime <DateTime.Now)
{
list[0].Integral += 10;
}
list[0].LastLoginDateTime = list[0].CurrentLoginDateTime;
list[0].CurrentLoginDateTime = DateTime.Now;
list[0].UpdateTime = DateTime.Now;
list[0].PhotoURL = modelMember.PhotoURL;
isSuccess=MemberOP.UpdateMember(list[0]);
}
else
{
Member model = new Member();
HistoryOfMemberUpdate modelHis = new HistoryOfMemberUpdate();
model.OpenId = modelMember.OpenId;
model.Nickname = modelMember.Nickname;
model.LastLoginDateTime = DateTime.Now;
model.CurrentLoginDateTime = DateTime.Now;
model.LoginTimes = 1;
model.Integral = 100;
model.Status = 0;
model.UpdateTime = DateTime.Now;
model.CreatTime = DateTime.Now;
model.PhotoURL = modelMember.PhotoURL;
modelHis.MemberId = MemberOP.SaveMember(model);
if (modelHis.MemberId != -1)
{
modelHis.CreatTime = DateTime.Now;
#region 会员历史信息
modelHis.OpenId = model.OpenId;
modelHis.Nickname = model.Nickname;
modelHis.Question1 = model.Question1;
modelHis.Question2 = model.Question2;
modelHis.Question3 = model.Question3;
modelHis.Anwser1 = model.Anwser1;
modelHis.Anwser2 = model.Anwser2;
modelHis.Anwser3 = model.Anwser3;
modelHis.Email = model.Email;
modelHis.Phone = model.Phone;
modelHis.LoginPWD = model.LoginPWD;
modelHis.Type = model.Type;
modelHis.Photo = model.Photo;
modelHis.PhotoURL = model.PhotoURL;
modelHis.Gender = model.Gender;
modelHis.Birthday = model.Birthday;
modelHis.Birthplace = model.Birthplace;
modelHis.Education = model.Education;
modelHis.Job = model.Job;
modelHis.Address = model.Address;
modelHis.LoginTimes = model.LoginTimes;
modelHis.LastLoginDateTime = model.LastLoginDateTime;
modelHis.CurrentLoginDateTime = model.CurrentLoginDateTime;
modelHis.Integral = model.Integral;
modelHis.Status = model.Status;
#endregion
MemberOP.SaveHistoryOfMemberUpdate(modelHis);
isSuccess = true;
}
}
}
catch (Exception ex)
{
Msg = ex.Message;
isSuccess = false;
}
return isSuccess;
}
/// <summary>
/// 绑定旧邮箱
/// </summary>
/// <param name="Email"></param>
/// <param name="PassWord"></param>
/// <param name="ID"></param>
/// <param name="Msg"></param>
/// <returns></returns>
public bool BindOldEmail(string Email, string PassWord, int ID, ref string Msg)
{
bool isSuccess = false;
IList<Member> listEmail = MemberOP.GetNormalMemberByEmail(Email);
if (listEmail.Count < 1)
{
Msg = "账号不存在";
return false;
}
else
{
if (!listEmail[0].LoginPWD.Trim().Equals(Comm.GlobalMethod.EncryptPWD(PassWord)))
{
Msg = "账号或密码错误";
return false;
}
if (!string.IsNullOrEmpty(listEmail[0].OpenId))
{
Msg = "此账号已与QQ账号绑定";
return false;
}
IList<Member> listQQ = MemberOP.GetAllMemberByID(ID);
if (listQQ.Count > 0)
{
listEmail[0].OpenId = listQQ[0].OpenId;
listEmail[0].Nickname = listQQ[0].Nickname;
listEmail[0].UpdateTime = DateTime.Now;
isSuccess = MemberOP.UpdateMember(listEmail[0]);
Msg = listEmail[0].LoginTimes.ToString();
if (isSuccess)
{
//删除listQQ记录
isSuccess = MemberOP.DeleteMember(listQQ[0]);
//删除listQQ历史记录
//添加listEmail历史记录
#region 会员历史信息
HistoryOfMemberUpdate modelHis = new HistoryOfMemberUpdate();
modelHis.CreatTime = DateTime.Now;
modelHis.MemberId = listEmail[0].Id;
modelHis.OpenId = listEmail[0].OpenId;
modelHis.Nickname = listEmail[0].Nickname;
modelHis.Question1 = listEmail[0].Question1;
modelHis.Question2 = listEmail[0].Question2;
modelHis.Question3 = listEmail[0].Question3;
modelHis.Anwser1 = listEmail[0].Anwser1;
modelHis.Anwser2 = listEmail[0].Anwser2;
modelHis.Anwser3 = listEmail[0].Anwser3;
modelHis.Email = listEmail[0].Email;
modelHis.Phone = listEmail[0].Phone;
modelHis.LoginPWD = listEmail[0].LoginPWD;
modelHis.Type = listEmail[0].Type;
modelHis.Photo = listEmail[0].Photo;
modelHis.PhotoURL = listEmail[0].PhotoURL;
modelHis.Gender = listEmail[0].Gender;
modelHis.Birthday = listEmail[0].Birthday;
modelHis.Birthplace = listEmail[0].Birthplace;
modelHis.Education = listEmail[0].Education;
modelHis.Job = listEmail[0].Job;
modelHis.Address = listEmail[0].Address;
modelHis.LoginTimes = listEmail[0].LoginTimes;
modelHis.LastLoginDateTime = listEmail[0].LastLoginDateTime;
modelHis.CurrentLoginDateTime = listEmail[0].CurrentLoginDateTime;
modelHis.Integral = listEmail[0].Integral;
modelHis.Status = listEmail[0].Status;
#endregion
if (MemberOP.SaveHistoryOfMemberUpdate(modelHis) == -1)
{
Msg = "保存会员历史信息发生错误";
return false;
}
else
{
return true;
}
}
return isSuccess;
}
else
{
Msg = "会员不存在";
return false;
}
}
}