public async System.Threading.Tasks.Task <IActionResult> AddAliasAsync([FromBody] AddAliasRequestDto requestDto)
{
var biz = new AliasBiz();
var res = await biz.InsertOrUpdateAsync(requestDto);
return(res ? Success() : Failed(ErrorCode.DataBaseError, "网络错误，更新别名失败"));
}
/// <summary>
/// 插入别名记录 ，若存在则删除再插入
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <bool> InsertOrUpdateAsync(AddAliasRequestDto requestDto)
{
using (var conn = MySqlHelper.GetConnection())
{
var sql = @"INSERT INTO t_utility_alias ( alias_guid, user_guid, target_guid, alias_name, created_by, last_updated_by )
VALUES
( REPLACE(UUID(),'-',''), @UserGuid, @TargetGuid,@AliasName,@UserGuid,@UserGuid )
ON DUPLICATE KEY UPDATE alias_name = @AliasName,last_updated_date=NOW();" ;
var res = await conn.ExecuteAsync(sql, requestDto);
return(res > 0);
}
}