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); } }
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; } }); }
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); } }
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); } }
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); } }
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); } }
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); }
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]); }
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); } }
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); } }
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()); }
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"; }
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; }); }
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); } }
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); } }
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); } }