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);
}
}