GetInfoFromPantallaListadosCommand.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 GetInfoFromPantallaListadosCommand : Command
    {
        DataRow ret;
        public GetInfoFromPantallaListadosCommand(IAddonsManager addons) : base(addons)
        {
            Name = "GetInfoFromPantallaListados";
        }

        protected override void CommandModulo(IModulo modulo, params object[] parameters)
        {
            string tcPantalla = parameters[0].ToString();
            Func<string, string> _FormatearStringEspecial = parameters[1] as Func<string, string>;
            Func<string, string> _Revisar_Descripcio = parameters[2] as Func<string, string>;
            DataTable ldtResult = new DataTable();
            if (DB._SQLExisteTablaBBDD(modulo._NombreConexion, "LISTADOS"))
            {
                string lcAliasDb = modulo._AliasDB;
                string lcCampoUpdate = DB.SQLExisteCampo(lcAliasDb, "LISTADOS", "UPDATE") ? "CAST([UPDATE] AS varchar(max)) " : "''";
                string lcGroupUpdate = lcCampoUpdate.StartsWith("C") ? "," + lcCampoUpdate : "";

                string lcSql = $@"select top 1 ID,PANTALLA,NOMBRE,NOMBRE as NOMBRE_REAL,CLASE,CLASEPADRE,ADICIONAL,CAST(FORM AS varchar(max)) as FORM
                    , max(TIPO) as TIPO,SELIVA,PERS,PERSMODULO,FIRMA,TAREA,MULTIEJER, {lcCampoUpdate} AS [UPDATE]
                    from {DB.SQLDatabase(lcAliasDb, "listados")}
                    where PANTALLA = {DB.SQLString(tcPantalla)}
                    group by ID,PANTALLA,NOMBRE,CLASE,CLASEPADRE,ADICIONAL,SELIVA,CAST(FORM AS varchar(max)),SELIVA,PERS,PERSMODULO,FIRMA,TAREA,MULTIEJER {lcGroupUpdate}
                    order by ID desc";

                DB.SQLExec(lcSql, ref ldtResult);


                if (ldtResult != null && ldtResult.Rows.Count > 0)
                {
                    // Revisar el nom en funció de les variables
                    ldtResult.Rows[0]["NOMBRE"] = _FormatearStringEspecial(_Revisar_Descripcio(ldtResult.Rows[0]["NOMBRE"].ToString()));    // 91752
                    ret = ldtResult.Rows[0];
                }
            }
        }
        protected override ExpectedParameters GetExpectedParameters()
        {
            return new ExpectedParameters(new Type[] { typeof(string), typeof(Func<string, string>), typeof(Func<string, string>) });
        }
        protected override object Return(params object[] parameters)
        {
            return ret; ;
        }
        protected override bool Exit()
        {
            return ret != null;
        }
    }
}