GetNombrePantallaListadosCommand.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 GetNombrePantallaListadosCommand : Command
    {
        private string ret = string.Empty;
        public GetNombrePantallaListadosCommand(IAddonsManager addons) : base(addons)
        {
            Name = "GetNombrePantallaListados";
        }

        protected override void CommandModulo(IModulo modulo, params object[] parameters)
        {
            if (DB._SQLExisteTablaBBDD(modulo._NombreConexion, "LISTADOS"))
            {
                string lcClase = parameters[0].ToString();
                string lcAliasDb = modulo._AliasDB;
                string lcSql = $@"SELECT * FROM { DB.SQLDatabase(lcAliasDb, "listados") } 
                     WHERE clase = { DB.SQLString(lcClase) }";

                DataTable ldtResult = new DataTable();
                if (DB.SQLExec(lcSql, ref ldtResult) &&
                    ldtResult.Rows.Count > 0)
                {
                    // Revisar el nom en funció de les variables
                    ret = ldtResult.Rows[0]["pantalla"].ToString().Trim();
                }
            }
        }
        protected override ExpectedParameters GetExpectedParameters()
        {
            return new ExpectedParameters(new Type[] { typeof(string) });
        }

        protected override object Return(params object[] parameters)
        {
            return ret;
        }
        protected override bool Exit()
        {
            return !string.IsNullOrEmpty(ret);
        }
    }
}