MergeListadosCommand.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using sage.ew.db;
using sage.ew.interficies;

namespace Sage.ES.S50.Addons
{
    internal class MergeListadosCommand : Command
    {
        public MergeListadosCommand(IAddonsManager addons) : base(addons)
        {
            Name = "MergeListados";
        }

        protected override void CommandModulo(IModulo modulo, params object[] parameters)
        {
            if (DB._SQLExisteTablaBBDD(modulo._NombreConexion, "LISTADOS"))
            {
                string lcSql = "Select nombre from " + DB.SQLDatabase(modulo._AliasDB, "listados") + " WHERE TIPO = " + parameters[2].ToString(); // 3";
                DataTable ldtTemp = parameters[0] as DataTable;
                DataTable ldtResultado = parameters[1] as DataTable;
                if (DB.SQLExec(lcSql, ref ldtTemp ))
                    ldtResultado.Merge(ldtTemp);
            }

        }

        protected override ExpectedParameters GetExpectedParameters()
        {
            return new ExpectedParameters(new Type[] { typeof(DataTable), typeof(DataTable), typeof(int) });
        }
    }
}