public void Update(OAuthTdm tdm)
{
DbSessionManager.ExecuteWithTrans <int>((IDbSession sess) =>
{
return(oauthWorker.Update(sess, tdm));
});
}
public int Save(IDbSession sess, OAuthTdm tdm)
{
SqlInsert ss = new SqlInsert(sess);
ss.Sql = "sys_oauth_t";
//ss.ConflictTarget = "nt_kind,sz_open_id";
ss.Set("ng_id", tdm.Id)
.Set("nt_kind", (int)tdm.Kind)
.Set("sz_open_id", tdm.OpenId)
.Set("ng_user_id", tdm.UserId)
.Set("sz_nick_name", tdm.NickName)
.Set("nt_gender", (int)tdm.Gender)
.Set("sz_country", tdm.Country)
.Set("sz_province", tdm.Province)
.Set("sz_city", tdm.City)
.Set("sz_language", tdm.Language)
.Set("sz_avatar_uri", tdm.AvatarUri)
.Set("sz_union_id", tdm.UnionId);
return(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);
});
}
