public static void OnRowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
try
{
/* Silvina 20100726 - Tarea 799 */
string sentencia = StatementSQLForReplicationFactory.GetSqlStatementString(e.Command, _replication.Sentence);
/* Fin Silvina */
if (_replication.IdTipoDeSentencia == null || _replication.IdTipoDeSentencia.Equals(string.Empty))
{
_replication.IdTipoDeSentencia = e.StatementType.ToString().ToUpper();
}
/* Silvina 20100726 - Tarea 799 */
if (_replication.IdTipoDeSentencia == "UPDATE")
{
Array aux = _replication.Sentence.ToString().Split(';');
long idRecursoActual = Convert.ToInt32(e.Row[0]);
string idHerramienta = sy_HerramientasRecursosIdiomas.GetByIdRecurso(idRecursoActual).IdHerramienta.ToString();
Array aux2 = sentencia.Split(',');
string idRecurso = "declare @idR bigint;(SELECT @idR = r.IdRecurso FROM sy_HerramientasRecursosIdiomas ri left join sy_Recursos r on ri.IdRecurso = r.IdRecurso WHERE IdHerramienta=" + idHerramienta + " AND IdTipoRecurso=1)";
aux2.SetValue("Exec Pr_sy_Recursos_Update @IdRecurso = @idR", 0);
aux2.SetValue("@OldIdRecurso = @idR", 6);
sentencia = mz.erp.systemframework.Util.PackString(new ArrayList(aux2), ",") + ";";
_replication.Sentence.Append(idRecurso);
_replication.Sentence.Append(sentencia);
}
/* Fin Silvina */
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static void OnRowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
StatementSQLForReplicationFactory.GetSqlStatement(e.Command, Replicacion.Sentence);
if (Replicacion.IdTipoDeSentencia == null || Replicacion.IdTipoDeSentencia.Equals(string.Empty))
{
Replicacion.IdTipoDeSentencia = e.StatementType.ToString().ToUpper();
}
}
public static void OnRowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
try
{
StatementSQLForReplicationFactory.GetSqlStatement(e.Command, _replication.Sentence);
if (_replication.IdTipoDeSentencia == null || _replication.IdTipoDeSentencia.Equals(string.Empty))
_replication.IdTipoDeSentencia = e.StatementType.ToString().ToUpper();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
