private void LlenarCombos()
        {
            try
            {
                LlenarTipoCuenta();
                String      Table_Id    = "00070";
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };

                General.General.LlenarCombobox(cbovalorFormaPagoID, "Table_Name", "Table_Value", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00074";
                General.General.LlenarCombobox(cbovalorTipoDesemID, "Table_Name", "Table_Value", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id  = "00035"; //Moneda
                cboIdMoneda_tt.DataSource    = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
                cboIdMoneda_tt.DisplayMember = "Table_Name";
                cboIdMoneda_tt.ValueMember   = "Table_Id";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void listInstrumentoInversion()
        {
            TableBaseBE        oTableBaseBE    = new TableBaseBE();
            List <TableBaseBE> listTableBaseBE = new List <TableBaseBE>();

            if (tipoBusqueda == TipoBusqueda.inversion)
            {
                oTableBaseBE.Table_Parent_Id = GetTablasGenerales.instrumentoInversion;
            }
            else
            {
                oTableBaseBE.Table_Parent_Id = GetTablasGenerales.tipoAdeudos;
            }

            oTableBaseBE.OPCION = 1;
            listTableBaseBE     = oTableBaseBL.ProcesarTableBase(oTableBaseBE);
            listTableBaseBE.Insert(0, new TableBaseBE()
            {
                Table_Id = "", Table_Name = "-TODOS-"
            });
            this.Invoke((MethodInvoker) delegate
            {
                cboTipoInversion.ValueMember   = "Table_Id";
                cboTipoInversion.DisplayMember = "Table_Name";
                cboTipoInversion.DataSource    = listTableBaseBE;
                cboTipoInversion.SelectedIndex = 0;
            });
        }
        private void ValidarPermisos(ref bool bPermitir)
        {
            bPermitir = false;
            try
            {
                TableBaseBE oEntity = new TableBaseBE()
                {
                    OPCION   = 1,
                    USUARIO  = General.General.GetUsuario,
                    Table_Id = System.Configuration.ConfigurationManager.AppSettings["UsuariosGC"].ToString()
                };
                DataSet ds = new TableBaseBL().ProcesarTableBase(oEntity);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    string[] ArrayUsuarios = ds.Tables[0].Rows[0]["Table_Value"].ToString().Split('/');

                    foreach (string item in ArrayUsuarios)
                    {
                        if (item.Trim().Equals(General.General.GetUsuario.Trim()))
                        {
                            bPermitir = true;
                            break;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void LlenarCombos()
        {
            try
            {
                String      Table_Id    = "00323"; // Facultades
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };
                General.General.LlenarCombobox(cboIdFacultad_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00035"; //Moneda
                General.General.LlenarCombobox(cboIdMoneda_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                SolicitudRepresentanteBE oEntity = new SolicitudRepresentanteBE();
                oEntity.OPCION      = 1;
                oEntity.USUARIO     = General.General.GetCodigoUsuario;
                oEntity.IdSolicitud = Codigo;
                oEntity.IdTipo_tt   = _IdTipo_tt;
                DataSet ds  = new SolicitudRepresentanteBL().ProcesarSolicitudRepresentante(oEntity);
                DataSet ds1 = new SolicitudRepresentanteBL().ProcesarSolicitudRepresentante(oEntity);

                General.General.LlenarCombobox(cboIdRepresentanteF1, "vNombreRepresentante", "IdRepresentante", ds.Tables[0]);
                General.General.LlenarCombobox(cboIdRepresentanteF2, "vNombreRepresentante", "IdRepresentante", ds1.Tables[0]);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #5
0
        private void validaActivacionMenu()
        {
            if (validaUsuarioActivacionMenu())
            {
                TableBaseBL oTableBaseBL = new TableBaseBL();
                TableBaseBE oTableBaseBE = new TableBaseBE();
                string      indActivador = string.Empty;
                //DataSet ds = null;
                List <TableBaseBE> lstTableBaseBE = new List <TableBaseBE>();

                oTableBaseBE.Table_Id = AppSettings.activadorMenuDinamico;
                oTableBaseBE.OPCION   = 1;
                lstTableBaseBE        = oTableBaseBL.ProcesarTableBase(oTableBaseBE);
                indActivador          = lstTableBaseBE[0].Table_Value; //ds.Tables[0].Rows[0]["Table_Value"].ToString();

                if (indActivador == "1")
                {
                    //mnuDinamico.Visible = false;
                    mnuDinamico.Items.Clear();
                    mnuDinamico.Visible = true;
                    loadMenu();
                }
                else
                {
                    mnuDinamico.Visible = true;
                }
            }
            else
            {
                mnuDinamico.Visible = true;
            }
        }
        private void listEstadoInversion()
        {
            TableBaseBE        oTableBaseBE    = new TableBaseBE();
            List <TableBaseBE> listTableBaseBE = new List <TableBaseBE>();

            oTableBaseBE.Table_Parent_Id = GetTablasGenerales.estadosInversion;
            oTableBaseBE.OPCION          = 1;

            listTableBaseBE = oTableBaseBL.ProcesarTableBase(oTableBaseBE);
            listTableBaseBE.Insert(0, new TableBaseBE()
            {
                Table_Id = "", Table_Name = "-TODOS-"
            });

            this.Invoke((MethodInvoker) delegate
            {
                cboEstado.ValueMember   = "Table_Id";
                cboEstado.DisplayMember = "Table_Name";
                cboEstado.DataSource    = listTableBaseBE.Where(x =>
                                                                x.Table_Id != Util.EstadoInversion.Vigente &&
                                                                x.Table_Id != Util.EstadoInversion.Rescidido &&
                                                                x.Table_Id != Util.EstadoInversion.Renovado &&
                                                                x.Table_Id != Util.EstadoInversion.Cancelado
                                                                ).ToList();
                //cboEstado.SelectedValue = EstadoInversion.Aplicada;
                cboEstado.SelectedIndex = 0;
                if (frmParentName == "frmConfirmacionInversion" || frmParentName == "frmRescisionInversion")
                {
                    cboEstado.Enabled = false;
                }
            });
        }
        private void listEstadoAdeudo()
        {
            TableBaseBE oTableBaseBE = new TableBaseBE();
            List<TableBaseBE> listTableBaseBE = new List<TableBaseBE>();
            oTableBaseBE.Table_Parent_Id = GetTablasGenerales.estadosInversion;
            oTableBaseBE.OPCION = 1;

            listTableBaseBE = oTableBaseBL.ProcesarTableBase(oTableBaseBE);
            listTableBaseBE.Insert(0, new TableBaseBE() { Table_Id = "", Table_Name = "-TODOS-" });

            this.Invoke((MethodInvoker)delegate
            {
                cboEstado.ValueMember = "Table_Id";
                cboEstado.DisplayMember = "Table_Name";
                cboEstado.DataSource = listTableBaseBE.Where(x =>
                    x.Table_Id == Util.EstadoInversion.Registrado
                    || x.Table_Id == Util.EstadoInversion.Aplicada
                    || x.Table_Id == ""
                ).ToList();
                cboEstado.SelectedValue = EstadoInversion.Registrado;
                if (frmParentName == "frmConfirmacionRenovacionAdeudo" || frmParentName == "frmRenovacionAdeudo")
                {
                    cboEstado.Enabled = false;
                }
            });
        }
Beispiel #8
0
        private void LlenarCombos()
        {
            try
            {
                String      Table_Id    = "00009"; // Cargos
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };
                General.General.LlenarCombobox(cboIdCargo_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);
                General.General.LlenarCombobox(cboIdCargoApoderado_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);
                General.General.LlenarCombobox(cboIdCargoApoderado1_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00134"; // Tipos de Documentos
                General.General.LlenarCombobox(cboIdTipoDocumento_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                General.General.LlenarCombobox(cboIdTipoDocumentoApoderado_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);
                General.General.LlenarCombobox(cboIdTipoDocumentoApoderado1_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);
                General.General.LlenarCombobox(cboIdTipoDocumentoConyuge_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00436"; //Estado Civil
                General.General.LlenarCombobox(cboIdEstadoCivil_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #9
0
        private void LlenarCombos()
        {
            try
            {
                String      Table_Id    = "00213"; //MESES
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };

                cboMes.DataSource    = new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0];
                cboMes.DisplayMember = "Table_Name";
                cboMes.ValueMember   = "Table_Value";

                cboMes.SelectedValue = DateTime.Now.Month.ToString().PadLeft(2, '0');

                DataSet dsMesCurso = new GestionComercialBL().ProcesarGestionComercial(0, 0, "", "", 0, 6);

                if (dsMesCurso.Tables[0].Rows.Count > 0)
                {
                    txtAño.Text          = dsMesCurso.Tables[0].Rows[0]["Year"].ToString();
                    cboMes.SelectedValue = dsMesCurso.Tables[0].Rows[0]["Mes"].ToString();
                }

                DataSet dsGestor = new GestionComercialBL().ProcesarGestionComercial(0, 0, "", "", 0, 3);
                General.General.LlenarCombobox(cboEjecutivo, "nombreCompleto", "gestorID", dsGestor.Tables[0], true);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void CargarDatos()
        {
            try
            {
                DataSet     dsTableBase = new DataSet();
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION   = 4,
                    USUARIO  = General.General.GetCodigoUsuario,
                    Table_Id = txtTable_Id.Text,
                };

                dsTableBase = TableBaseBL.ProcesarTableBase(TableBaseBE);

                if (dsTableBase.Tables[0].Rows.Count > 0)
                {
                    txtTable_Name.Text = dsTableBase.Tables[0].Rows[0]["Table_Name"].ToString();
                }
                else
                {
                    MessageBox.Show("Esta Tabla no Existe", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #11
0
        private void LlenarCombos()
        {
            try
            {
                String      Table_Id    = "00287"; // Tipo Solicitud
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };
                General.General.LlenarCombobox(cboIdTipoSolicitud_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00246"; // Areas
                General.General.LlenarCombobox(cboIdArea_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                //TableBaseBE.Table_Parent_Id = "00416"; // Tipo Linea Pagadora
                //General.General.LlenarCombobox(cboIdTipoLinea_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00035 "; // Moneda
                General.General.LlenarCombobox(cboIdMoneda_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void LlenarCombos()
        {
            try
            {
                //General.General.LlenarCombobox(cboIdPagadora, "vcPagadora", "IdPagadora", _dsPagadoras.Tables[0], false);

                String      Table_Id    = "00001"; //SECTORES
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };

                General.General.LlenarCombobox(cboidsector_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                //TableBaseBE.Table_Parent_Id = "00042"; //TIPO LINEA
                //General.General.LlenarCombobox(cboIdTipoLin_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00234"; //TIPO SERVICIO
                General.General.LlenarCombobox(cboIdTipoSer_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00035"; //MONEDA
                General.General.LlenarCombobox(cboIdMoneda_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                TableBaseBE.Table_Parent_Id = "00009"; //CARGO
                General.General.LlenarCombobox(cboidcargo_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #13
0
        private bool validaUsuarioActivacionMenu()
        {
            TableBaseBL oTableBaseBL = new TableBaseBL();
            TableBaseBE oTableBaseBE = new TableBaseBE();
            string      indActivador = string.Empty;
            //DataSet ds = null;
            List <TableBaseBE> lstTableBase = new List <TableBaseBE>();

            oTableBaseBE.Table_Parent_Id = AppSettings.listaUsuariosMenuDinamico;
            oTableBaseBE.OPCION          = 1;
            lstTableBase = oTableBaseBL.ProcesarTableBase(oTableBaseBE);

            if (lstTableBase.Count > 0)
            {
                foreach (TableBaseBE tableBase in lstTableBase)
                {
                    if (tableBase.Table_Value == General.GetCodigoUsuario.Trim())
                    {
                        return(true);
                    }
                }
            }

            return(false);
        }
        private void btnAceptar_Click(object sender, EventArgs e)
        {
            try
            {
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    USUARIO         = General.General.GetCodigoUsuario,
                    OPCION          = 2,
                    Table_Id        = txtTable_Id.Text,
                    Table_Parent_Id = txtTable_Parent_Id.Text,
                    Table_Name      = txtTable_Name.Text,
                    Table_Order     = txtTable_Order.Text,
                    Table_Value     = txtTable_Value.Text,
                };

                DataSet dsTableBase = new DataSet();
                dsTableBase = TableBaseBL.ProcesarTableBase(TableBaseBE);

                //MessageBox.Show("Se Proceso Correctamente", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.Dispose();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #15
0
        public static TableBaseBE ObtenerTableBase(IDataReader dr)
        {
            TableBaseBE oTableBaseBE = new TableBaseBE();

            if (!dr.IsDBNull(dr.GetOrdinal("Table_Id")))
            {
                oTableBaseBE.Table_Id = dr.GetString(dr.GetOrdinal("Table_Id"));
            }

            if (!dr.IsDBNull(dr.GetOrdinal("Table_Parent_Id")))
            {
                oTableBaseBE.Table_Parent_Id = dr.GetString(dr.GetOrdinal("Table_Parent_Id"));
            }

            if (!dr.IsDBNull(dr.GetOrdinal("Table_Name")))
            {
                oTableBaseBE.Table_Name = dr.GetString(dr.GetOrdinal("Table_Name"));
            }

            if (!dr.IsDBNull(dr.GetOrdinal("Table_Order")))
            {
                oTableBaseBE.Table_Order = dr.GetString(dr.GetOrdinal("Table_Order"));
            }

            if (!dr.IsDBNull(dr.GetOrdinal("Table_Value")))
            {
                oTableBaseBE.Table_Value = dr.GetString(dr.GetOrdinal("Table_Value"));
            }

            return(oTableBaseBE);
        }
Beispiel #16
0
        private void LlenarCombos()
        {
            String      Table_Id    = "00009";
            TableBaseBE TableBaseBE = new TableBaseBE()
            {
                OPCION          = 1,
                USUARIO         = General.General.GetCodigoUsuario,
                Table_Parent_Id = Table_Id
            };

            General.General.LlenarCombobox(cboIdCargo_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);
        }
        private void frmSocioLineaGarantia_Load(object sender, EventArgs e)
        {
            String Table_Id = "00067";

            TableBaseBE TableBaseBE = new TableBaseBE
            {
                OPCION          = 1,
                USUARIO         = General.General.GetCodigoUsuario,
                Table_Parent_Id = Table_Id
            };

            General.General.LlenarCombobox(cboIdTipo_Documento_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);
        }
Beispiel #18
0
        private void CargarDatos()
        {
            try
            {
                DataSet         dsPagadoraLinea = new DataSet();
                PagadoraLineaBE PagadoraLineaBE = new PagadoraLineaBE()
                {
                    OPCION     = 1,
                    USUARIO    = General.General.GetCodigoUsuario,
                    IdPagadora = IdPagadora
                };

                dsPagadoraLinea = PagadoraLineaBL.ProcesarPagadoraLinea(PagadoraLineaBE);

                if (dsPagadoraLinea.Tables[0].Rows.Count > 0)
                {
                    cboIdMoneda_tt.SelectedValue = dsPagadoraLinea.Tables[0].Rows[0]["IdMoneda_tt"];
                    txtnLinea.Text      = Convert.ToDecimal(dsPagadoraLinea.Tables[0].Rows[0]["nLinea"]).ToString("N2");
                    txtnNuevaLinea.Text = Convert.ToDecimal(dsPagadoraLinea.Tables[0].Rows[0]["nLinea"]).ToString("N2");
                    cboIdNivelAutonomia_tt.SelectedValue = dsPagadoraLinea.Tables[0].Rows[0]["IdNivelAutonomia_tt"];
                    dtFechaAprobacion.Value     = Convert.ToDateTime(dsPagadoraLinea.Tables[0].Rows[0]["dtFechaAprobacion"]);
                    cboIdMedio_tt.SelectedValue = dsPagadoraLinea.Tables[0].Rows[0]["IdMedio_tt"];
                    txtiPlazo.Text           = dsPagadoraLinea.Tables[0].Rows[0]["iPlazo"].ToString();
                    txtvcObservaciones.Text  = dsPagadoraLinea.Tables[0].Rows[0]["vcObservaciones"].ToString();
                    dtFechaVencimiento.Value = Convert.ToDateTime(dsPagadoraLinea.Tables[0].Rows[0]["dtFechaVencimiento"]);
                    txtTipoCambio.Text       = Convert.ToDecimal(dsPagadoraLinea.Tables[0].Rows[0]["nTipoCambio"]).ToString("0.00");
                    cboIdMoneda_tt_SelectedIndexChanged(new object(), new EventArgs());
                }
                else
                {
                    //Obtener el tipo de cambio del dia
                    DataSet     dsTC        = new DataSet();
                    TableBaseBE TableBaseBE = new TableBaseBE()
                    {
                        OPCION  = 6,
                        USUARIO = General.General.GetUsuario,
                    };
                    dsTC = TableBaseBL.ProcesarTableBase(TableBaseBE);

                    if (dsTC.Tables[0].Rows.Count > 0)
                    {
                        txtTipoCambio.Text = Convert.ToDecimal(dsTC.Tables[0].Rows[0]["nTipoCambio"]).ToString("0.00");
                    }
                }
                txtiPlazo.Text = "365";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #19
0
        private void btnProcesar_Click(object sender, EventArgs e)
        {
            try
            {
                General.msgHelper.Wait("Procesando, espere un momento ...");
                string      Flg_RptMonedaLinea = "1";
                TableBaseBE oEntity            = new TableBaseBE();
                oEntity.OPCION   = 1;
                oEntity.Table_Id = ConfigurationManager.AppSettings["TT_RptCCDMonedaLinea"].ToString();
                DataSet ds = new TableBaseBL().ProcesarTableBase(oEntity);

                if (ds.Tables.Count > 0)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        Flg_RptMonedaLinea = ds.Tables[0].Rows[0]["Table_Value"].ToString();
                    }
                }

                DataSet dsGestionAvance        = new DataSet();
                DataSet dsGestionAvanceResumen = new DataSet();
                using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                {
                    SqlCommand cmd1 = new SqlCommand("dbo.Rpt_CreditosVigentesxProducto", con);
                    cmd1.CommandTimeout = 0;
                    cmd1.CommandType    = CommandType.StoredProcedure;
                    cmd1.Parameters.AddWithValue("@Opcion", 1);
                    cmd1.Parameters.AddWithValue("@gFechaOp", General.General.gFechaOp);
                    SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                    daCab.Fill(dsGestionAvance, "dsCreditosVigentes");
                    con.Close();
                }

                Crystal.crRpt_CreditosVigentesxProductoX ocrLoteLiquidacion       = new Crystal.crRpt_CreditosVigentesxProductoX();
                Reportes.frmVisorLoteLiquidacion         ofrmVisorLoteLiquidacion = new Reportes.frmVisorLoteLiquidacion();
                ofrmVisorLoteLiquidacion.crvVisorLoteLiq.ReportSource = ocrLoteLiquidacion;
                ocrLoteLiquidacion.SetDataSource(dsGestionAvance);
                ocrLoteLiquidacion.SetParameterValue("Usuario", General.General.GetUsuario);
                ocrLoteLiquidacion.SetParameterValue("Flg_RptMonedaLinea", Flg_RptMonedaLinea);
                ocrLoteLiquidacion.SetParameterValue("gFechaOp", General.General.gFechaOp);
                ofrmVisorLoteLiquidacion.WindowState = FormWindowState.Maximized;
                ofrmVisorLoteLiquidacion.ShowDialog();
                General.msgHelper.Wait();
            }
            catch (Exception ex)
            {
                General.msgHelper.Wait();
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #20
0
        private void LlenarCombos()
        {
            string      Table_Id    = "00035";
            TableBaseBE TableBaseBE = new TableBaseBE()
            {
                OPCION          = 1,
                USUARIO         = General.General.GetCodigoUsuario,
                Table_Parent_Id = Table_Id
            };

            cboIdMoneda_tt.DataSource    = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
            cboIdMoneda_tt.DisplayMember = "Table_Name";
            cboIdMoneda_tt.ValueMember   = "Table_Id";
            cboIdMoneda_tt_SelectedIndexChanged(new object(), new EventArgs());
        }
Beispiel #21
0
        private void CargaTablaDetalle()
        {
            DataSet     ds          = new DataSet();
            TableBaseBE TableBaseBE = new TableBaseBE()
            {
                OPCION          = 5,
                USUARIO         = General.General.GetUsuario,
                Table_Parent_Id = dgvTablasPadre.CurrentRow.Cells["Table_Id"].Value.ToString(),
                Table_Name      = txtDetalle.Text
            };

            ds = TableBaseBL.ProcesarTableBase(TableBaseBE);
            dgvTablasHijos.DataSource = ds.Tables[0];
            lblregdet.Text            = ds.Tables[0].Rows.Count.ToString() + " registro(s)";
        }
        private void LlenarCombos()
        {
            String      Table_Id    = "00009";
            TableBaseBE TableBaseBE = new TableBaseBE()
            {
                OPCION          = 1,
                USUARIO         = General.General.GetCodigoUsuario,
                Table_Parent_Id = Table_Id
            };

            General.General.LlenarCombobox(cboIdCargo_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            //cboIdCargo_tt.DataSource = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
            //cboIdCargo_tt.DisplayMember = "Table_Name";
            //cboIdCargo_tt.ValueMember = "Table_Id";
        }
Beispiel #23
0
        private void listInstrumentoInversion()
        {
            TableBaseBE        oTableBaseBE    = new TableBaseBE();
            List <TableBaseBE> listTableBaseBE = new List <TableBaseBE>();

            oTableBaseBE.Table_Parent_Id = GetTablasGenerales.instrumentoInversion;
            oTableBaseBE.OPCION          = 1;

            listTableBaseBE = oTableBaseBL.ProcesarTableBase(oTableBaseBE);
            this.Invoke((MethodInvoker) delegate
            {
                cboTipoInversion.ValueMember   = "Table_Id";
                cboTipoInversion.DisplayMember = "Table_Name";
                cboTipoInversion.DataSource    = listTableBaseBE;
            });
        }
        private void listTipoCuentaBancaria()
        {
            TableBaseBE        oTableBaseBE    = new TableBaseBE();
            List <TableBaseBE> listTableBaseBE = new List <TableBaseBE>();

            oTableBaseBE.Table_Parent_Id = GetTablasGenerales.TipoCuentaBancaria;
            oTableBaseBE.OPCION          = 1;
            listTableBaseBE = oTableBaseBL.ProcesarTableBase(oTableBaseBE);

            this.Invoke((MethodInvoker) delegate
            {
                cboTipoCuenta.ValueMember   = "Table_Id";
                cboTipoCuenta.DisplayMember = "Table_Name";
                cboTipoCuenta.DataSource    = listTableBaseBE;
            });
        }
Beispiel #25
0
        private void LlenarCombos()
        {
            DocumentoBE DocumentoBE = new DocumentoBE()
            {
                OPCION  = 1,
                USUARIO = General.General.GetCodigoUsuario
            };

            General.General.LlenarCombobox(cboIdDocumento, "vDocumento", "IdDocumento", DocumentoBL.ProcesarDocumento(DocumentoBE).Tables[0]);
            //cboIdDocumento.DataSource = DocumentoBL.ProcesarDocumento(DocumentoBE).Tables[0];
            //cboIdDocumento.DisplayMember = "vDocumento";
            //cboIdDocumento.ValueMember = "IdDocumento";

            String      Table_Id    = "00012";
            TableBaseBE TableBaseBE = new TableBaseBE()
            {
                OPCION          = 1,
                USUARIO         = General.General.GetCodigoUsuario,
                Table_Parent_Id = Table_Id
            };

            General.General.LlenarCombobox(cboIdFormaPago_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            TableBaseBE.Table_Parent_Id = "00433"; //Tipo Confirmacion
            General.General.LlenarCombobox(cboIdTipoConfirmacion_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            TableBaseBE.Table_Parent_Id = "00999"; //Tipo Transferencia Titularidad
            General.General.LlenarCombobox(cboIdTipoTransferencia_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            TableBaseBE.Table_Parent_Id = "01003"; //Tipo Carta/Documentos Pagadora
            General.General.LlenarCombobox(cboIdTipoCartaP_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            TableBaseBE.Table_Parent_Id = "01003"; //Tipo Carta/Documentos Pagadora
            General.General.LlenarCombobox(cboIdTipoCartaE_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            TableBaseBE.Table_Parent_Id = "01057"; //Frecuencia
            General.General.LlenarCombobox(cboIdFrecuencia_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            TableBaseBE.Table_Parent_Id = "01060"; //Días de Pago Frecuencia
            General.General.LlenarCombobox(cboIdDiasPagoFrecuencia_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

            //cboIdFormaPago_tt.DataSource = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
            //cboIdFormaPago_tt.DisplayMember = "Table_Name";
            //cboIdFormaPago_tt.ValueMember = "Table_Id";
        }
 private void LlenarCombos()
 {
     try
     {
         String      Table_Id    = "00035";
         TableBaseBE TableBaseBE = new TableBaseBE()
         {
             OPCION          = 1,
             USUARIO         = General.General.GetCodigoUsuario,
             Table_Parent_Id = Table_Id
         };
         General.General.LlenarCombobox(cboIdMoneda_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
        private void CargarCombos()
        {
            try
            {
                String      Table_Id    = "00035";
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };
                General.General.LlenarCombobox(cboIdMoneda_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);

                DataTable dt = new DataTable();
                dt.Columns.Add("Value");
                dt.Columns.Add("Descripcion");

                DataRow dr = dt.NewRow();
                dr                = dt.NewRow();
                dr["Value"]       = "";
                dr["Descripcion"] = "-- Seleccione --";
                dt.Rows.InsertAt(dr, 0);

                DataRow dr1 = dt.NewRow();
                dr1["Value"]       = "DNI";
                dr1["Descripcion"] = "DNI";
                dt.Rows.InsertAt(dr1, 0);

                DataRow dr2 = dt.NewRow();
                dr2                = dt.NewRow();
                dr2["Value"]       = "Ruc";
                dr2["Descripcion"] = "Ruc";
                dt.Rows.InsertAt(dr2, 0);

                cboTipoDocumento.DataSource    = dt;
                cboTipoDocumento.DisplayMember = "Descripcion";
                cboTipoDocumento.ValueMember   = "Value";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #28
0
        private void LlenarCombos()
        {
            try
            {
                String      Table_Id    = "00035";
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };

                cboIdMoneda_tt.DataSource    = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
                cboIdMoneda_tt.DisplayMember = "Table_Name";
                cboIdMoneda_tt.ValueMember   = "Table_Id";
                cboIdMoneda_tt_SelectedIndexChanged(new object(), new EventArgs());

                TableBaseBE.Table_Parent_Id = "00023";

                General.General.LlenarCombobox(cboIdNivelAutonomia_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);
                //cboIdNivelAutonomia_tt.DataSource = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
                //cboIdNivelAutonomia_tt.DisplayMember = "Table_Name";
                //cboIdNivelAutonomia_tt.ValueMember = "Table_Id";

                TableBaseBE.Table_Parent_Id = "00027";
                General.General.LlenarCombobox(cboIdMedio_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                //cboIdMedio_tt.DataSource = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
                //cboIdMedio_tt.DisplayMember = "Table_Name";
                //cboIdMedio_tt.ValueMember = "Table_Id";

                TableBaseBE.Table_Parent_Id = "00039";
                General.General.LlenarCombobox(cboIdAnalistaCredito_tt, "Table_Name", "Table_Id", TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0]);

                //cboIdAnalistaCredito_tt.DataSource = TableBaseBL.ProcesarTableBase(TableBaseBE).Tables[0];
                //cboIdAnalistaCredito_tt.DisplayMember = "Table_Name";
                //cboIdAnalistaCredito_tt.ValueMember = "Table_Id";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Beispiel #29
0
        private void LlenarCombos()
        {
            try
            {
                DataSet dsGestor = new GestionComercialBL().ProcesarGestionComercial(0, 0, "", "", 0, 3);
                General.General.LlenarCombobox(cboEjecutivo, "nombreCompleto", "gestorID", dsGestor.Tables[0], true);

                String      Table_Id    = "00030"; //Estado de Lineas
                TableBaseBE TableBaseBE = new TableBaseBE()
                {
                    OPCION          = 1,
                    USUARIO         = General.General.GetCodigoUsuario,
                    Table_Parent_Id = Table_Id
                };

                DataTable dt = new DataTable();
                dt = new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0];

                DataRow dr;
                dr = dt.NewRow();
                dr["Table_Name"] = "Activa";
                dr["Table_Id"]   = "00031";
                dt.Rows.InsertAt(dr, 0);
                DataRow dr1;
                dr1 = dt.NewRow();
                dr1["Table_Name"] = "Inactiva";
                dr1["Table_Id"]   = "00451";
                dt.Rows.InsertAt(dr1, 1);
                DataRow dr2;
                dr2 = dt.NewRow();
                dr2["Table_Name"] = "Anulada";
                dr2["Table_Id"]   = "00034";
                dt.Rows.InsertAt(dr2, 6);

                //cboIdEstadoLinea_tt.Items.Add({Table_Name = "xx", }

                General.General.LlenarCombobox(cboIdEstadoLinea_tt, "Table_Name", "Table_Id", dt);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
 private void LlenarCombos()
 {
     try
     {
         String      Table_Id    = "00301"; // Tipo CheckList
         TableBaseBE TableBaseBE = new TableBaseBE()
         {
             OPCION          = 7,
             USUARIO         = General.General.GetCodigoUsuario,
             Table_Parent_Id = Table_Id,
             Table_Id        = _IdTipoSolicitud_tt
         };
         General.General.LlenarCombobox(cboIdDocumento_tt, "Table_Name", "Table_Id", new TableBaseBL().ProcesarTableBase(TableBaseBE).Tables[0]);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }