PermitirCrearTareaProgramadaCommand.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 PermitirCrearTareaProgramadaCommand : Command
    {
        bool lRet = false;
        bool salir = false;
        public PermitirCrearTareaProgramadaCommand(IAddonsManager addons) : base(addons)
        {
            Name = "PermitirCrearTareaProgramada";
        }

        protected override void CommandModulo(IModulo modulo, params object[] parameters)
        {
            string lcConexion = modulo._NombreConexion;
            string lcNombre = modulo._Nombre;
            string tcPantalla = parameters[0].ToString();
            DataTable ldtResult = parameters[1] as DataTable;
            if (DB._SQLExisteTablaBBDD(lcConexion, "LISTADOS"))
            {
                // Preparamos la consulta
                string lcSql = $@"SELECT * 
                                FROM { DB.SQLDatabase(lcNombre, "listados")} 
                                WHERE pantalla = {DB.SQLString(tcPantalla.Trim().ToUpper())}";

                bool llOk = DB.SQLExec(lcSql, ref ldtResult);
                if (llOk && ldtResult != null && ldtResult.Rows.Count > 0)
                {
                    lRet = ldtResult.Columns.Contains("tarea") ?
                        Convert.ToBoolean(ldtResult.Rows[0]["tarea"]) : false;
                    salir = true;
                }
            }
        }

        protected override ExpectedParameters GetExpectedParameters()
        {
            return new ExpectedParameters(new Type[] { typeof(string), typeof(DataTable) });
        }
        protected override bool Exit()
        {
            return salir;
        }
        protected override object Return(params object[] parameters)
        {
            return lRet;
        }
    }
}