public void Update(UserTdm user)
{
DbSessionManager.Execute <int>((IDbSession sess) => {
userWorker.Update(sess, user);
return(0);
});
}
public MethodResult <UserTdm> Login(string username, string password)
{
return(DbSessionManager.Execute <MethodResult <UserTdm> >((IDbSession sess) => {
UserTdm u = userWorker.FindByUserName(sess, username);
if (null == u || String.IsNullOrEmpty(password))
{
return MethodResult <UserTdm> .Failed("用户名或密码错误！");
}
if (u.Kind == UserKind.Virtual)
{
return MethodResult <UserTdm> .Failed("账户不存在！");
}
if (u.RowState != RowState.Normal ||
(u.Locked && u.TimeLocked > DateTime.Now))
{
return MethodResult <UserTdm> .Failed("账户已经被锁定，请稍后再试！");
}
password = password.MD5();
if (password == u.Password)
{
userWorker.SetLoginSuccess(sess, u.Id);
return MethodResult <UserTdm> .Successful(u);
}
userWorker.SetLoginFailed(sess, u.Id, u.FailCount > WebApp.PasswordFailCount);
return MethodResult <UserTdm> .Failed("用户名或密码错误！");
}));
}
public SessionalUser(UserTdm u)
{
this.Id = u.Id;
this.UserName = u.UserName;
this.NickName = u.NickName;
this.Email = u.Email;
this.Mobile = u.Mobile;
this.Gender = u.Gender;
this.Slogan = u.Slogan;
this.Avatar = u.Avatar;
}
public void Save(UserTdm user, List <long> roleIds)
{
DbSessionManager.ExecuteWithTrans <int>((IDbSession sess) => {
userWorker.Save(sess, user);
foreach (var i in roleIds)
{
roleWorker.AddToRole(sess, user.Id, i);
}
return(0);
});
}
public void Update(IDbSession sess, UserTdm user)
{
var ss = new SqlUpdate(sess);
ss.Sql = "sys_user_t";
ss.Where = "ng_id=@ng_id";
ss.Set("sz_uname", user.UserName)
.Set("sz_nkname", user.NickName)
.Set("sz_email", user.Email)
.Set("sz_mobile", user.Mobile)
.Set("nt_kind", (int)user.Kind)
.Set("nt_gender", (int)user.Gender)
.Set("sz_slogan", user.Slogan)
.Set("sz_avatar", user.Avatar)
.Set("ng_uper_id", user.UpdaterId)
.AddParam("ng_id", user.Id);
ss.ExecuteNonQuery();
}
public void Save(OAuthTdm tdm)
{
DbSessionManager.ExecuteWithTrans <int>((IDbSession sess) =>
{
UserTdm user = new UserTdm();
user.Id = sess.GetNextSequence("sys_user__id__seq");
user.UserName = "******" + user.Id.ToString();
user.NickName = String.IsNullOrEmpty(tdm.NickName)? user.UserName: tdm.NickName;
user.Password = "******".MD5();
// userId.Avatar = "";
user.Gender = tdm.Gender;
userWorker.Save(sess, user);
tdm.Id = sess.GetNextSequence("sys_oauth__id__seq");
tdm.UserId = user.Id;
oauthWorker.Save(sess, tdm);
roleWorker.AddToRole(sess, user.Id, WebApp.UsersRoleId);
return(0);
});
}
public void Save(IDbSession sess, UserTdm user)
{
if (user.Id == 0)
{
user.Id = sess.GetNextSequence("sys_user__id__seq");
}
SqlInsert ss = new SqlInsert(sess);
ss.Sql = "sys_user_t";
ss.Set("sz_uname", user.UserName)
.Set("sz_nkname", user.NickName)
.Set("sz_pwd", user.Password)
.Set("sz_email", user.Email)
.Set("sz_mobile", user.Mobile)
.Set("nt_kind", (int)user.Kind)
.Set("nt_gender", (int)user.Gender)
.Set("sz_slogan", user.Slogan)
.Set("sz_avatar", user.Avatar)
.Set("ng_ctor_id", user.CreatorId)
.Set("ng_uper_id", user.UpdaterId)
.Set("ng_id", user.Id);
ss.ExecuteNonQuery();
}
