public async static Task <RoleDbInfo> GetUserDbInfo(this SqlComponent self, int UserId) { string sql = "select * from User_Info where UserId = @UserId"; using (var db = self.GetDBConnection()) { var ret = await db.QueryFirstOrDefaultAsync <UserInfo>(sql, new { UserId }); if (ret == null) { return(new RoleDbInfo()); } else { RoleDbInfo role = RoleDbInfo.Parser.ParseFrom(ret.UserData); return(role); } } }
public async static Task <bool> SaveUserDbInfo(this SqlComponent self, int UserId, RoleDbInfo data) { string sql = "Update User_Info Set UserData=@UserData where UserId = @UserId"; using (var db = self.GetDBConnection()) { var param = new { UserData = data.ToByteArray(), UserId = UserId }; var row = await db.ExecuteAsync(sql, param); if (row == 0) { sql = "Insert User_Info (UserId,UserData)values(@UserId,@UserData)"; row = await db.ExecuteAsync(sql, param); return(row == 1); } else { return(true); } } }