protected void UpdateSnsUser(IDbConnection conn, IDbTransaction trans, SnsUser user) { if (SnsUserHelper.Exists(conn, trans, user.Id)) { var sql = "update T_SnsUsers set Introduction=@Introduction,FriendValidate=@FriendValidate,AllowComment=@AllowComment where UserId=@Id"; conn.Execute(sql, user, trans); } else { var sql = "insert into T_SnsUsers(UserId,Introduction,FriendValidate,AllowComment) values(@Id,@Introduction,@FriendValidate,@AllowComment)"; conn.Execute(sql, user, trans); } UpdateUser(conn, trans, user); }
public Result UpdateAvatar(string id, string avatar) { return(connection.Transaction("修改", (conn, trans) => { var param = new { Avatar = avatar, Id = id }; if (SnsUserHelper.Exists(conn, trans, id)) { var sql = "update T_SnsUsers set Avatar=@Avatar where UserId=@Id"; conn.Execute(sql, param, trans); } else { var sql = "insert into T_SnsUsers(UserId,Avatar) values(@Id,@Avatar)"; conn.Execute(sql, param, trans); } })); }