コード例 #1
0
        public bool ValidarMembresia(MasterTwo conexion, string[] parametros)
        {
            blMaster    bl          = new blMaster();
            Transaction transaction = Helper.InitTransaction();

            return(true);
            //List<object> parametros = new List<object>();
            //return bl.ListarMasterTen("", parametros, out transaction);
        }
コード例 #2
0
        public string AprobarOperacionesTesoreria(string Op, string Bd, string Clave)
        {
            Usuario       user        = (Usuario)System.Web.HttpContext.Current.Session[Constant.nameUser];
            blMaster      bl          = new blMaster();
            Transaction   transaction = Helper.InitTransaction();
            List <object> parametros  = new List <object>();

            parametros.Add("CtasCtes");
            parametros.Add(Convert.ToInt32(Op));
            parametros.Add(user.Alias);
            parametros.Add(Clave);
            if (Bd == "sil")
            {
                /*
                 * bl.EjecutarTransaccion("REC_Sil..VBG01076_VALUSUA", parametros, out transaction);
                 */
                bl.EjecutarTransaccion("Silvestre_Peru_SAC..VBG01076_VALUSUA", parametros, out transaction);
            }
            else if (Bd == "neo")
            {
                bl.EjecutarTransaccion("NeoAgrum_SAC..VBG01076_VALUSUA", parametros, out transaction);
            }
            else if (Bd == "ina")
            {
                bl.EjecutarTransaccion("Inatec_Peru_SAC..VBG01076_VALUSUA", parametros, out transaction);
            }

            if (transaction.type == TypeTransaction.OK)
            {
                return(Helper.InvokeTextHTML
                       (
                           "$('#inPopupOp').html(\"\");" +
                           "$('#inPopupArea').val(\"\");" +
                           "$('#inPopupMonto').val(\"\");" +
                           "$('#inPopupConcepto').val(\"\");" +
                           "$('#inPopupOp').val(\"\");" +
                           "$('#inPopupBd').val(\"\");" +
                           "ListarOperaciones();" +
                           "$('#confirmaraprobarModal').modal(\"hide\");" +
                           "showSuccess('Se realizó la 2da aprobación de la Op');"
                       ));
            }
            else
            {
                return(Helper.InvokeErrorHTML(transaction.message));
            }
            //return Common.InvokeErrorHTML(Op + " " + Bd + " " + Clave);
        }
コード例 #3
0
        public MasterCollection ListarOperacionesTesoreriaEV(string bd, string orden, string fechaini, string fechafin, int check1, int check2)
        {
            blMaster      bl          = new blMaster();
            Transaction   transaction = Helper.InitTransaction();
            List <object> parametros  = new List <object>();

            parametros.Add(orden == string.Empty ? -1 : Convert.ToInt32(orden));
            parametros.Add(fechaini == string.Empty ? null : fechaini);
            parametros.Add(fechafin == string.Empty ? null : fechafin);
            parametros.Add(check1);
            parametros.Add(check2);
            List <Master> ocol = new List <Master>();

            if (bd == "all")
            {
                /*
                 * ocol.AddRange(bl.ListarMaster("REC_Sil..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                 */
                ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);

                return(new MasterCollection(ocol, transaction));
            }
            else if (bd == "sil")
            {
                /*return bl.ListarMaster("REC_Sil..VBG00385_GESTIONCHECK", parametros, out transaction);*/
                return(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
            }
            else if (bd == "neo")
            {
                return(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
            }
            else if (bd == "ina")
            {
                return(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
            }
            else
            {
                return(new MasterCollection(new List <Master>(), transaction));
            }
        }
コード例 #4
0
        public MasterCollection ListarOperacionesTesoreriaALL(string bd, string documento, string orden, string fechaini, string fechafin, int check1, int check2)
        {
            blMaster      bl          = new blMaster();
            Transaction   transaction = Helper.InitTransaction();
            List <object> parametros  = new List <object>();

            parametros.Add(orden == string.Empty ? -1 : Convert.ToInt32(orden));
            parametros.Add(fechaini == string.Empty ? null : fechaini);
            parametros.Add(fechafin == string.Empty ? null : fechafin);
            parametros.Add(check1);
            parametros.Add(check2);
            List <Master> ocol = new List <Master>();

            switch (bd)
            {
            case "all":
                switch (documento)
                {
                case "all":
                    ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    return(new MasterCollection(ocol, transaction));

                case "solegr":
                    ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    return(new MasterCollection(ocol, transaction));

                case "egrvar":
                    ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    return(new MasterCollection(ocol, transaction));

                default:
                    return(new MasterCollection(new List <Master>(), transaction));
                }

            case "sil":
                switch (documento)
                {
                case "all":
                    ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    return(new MasterCollection(ocol, transaction));

                case "solegr":
                    return(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction));

                case "egrvar":
                    return(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));

                default:
                    return(new MasterCollection(new List <Master>(), transaction));
                }

            case "neo":
                switch (documento)
                {
                case "all":
                    ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    return(new MasterCollection(ocol, transaction));

                case "solegr":
                    return(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction));

                case "egrvar":
                    return(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));

                default:
                    return(new MasterCollection(new List <Master>(), transaction));
                }

            case "ina":
                switch (documento)
                {
                case "all":
                    ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
                    ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
                    return(new MasterCollection(ocol, transaction));

                case "solegr":
                    return(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction));

                case "egrvar":
                    return(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));

                default:
                    return(new MasterCollection(new List <Master>(), transaction));
                }

            default:
                return(new MasterCollection(new List <Master>(), transaction));
            }
        }