private void cargarDepartamentos(int COD_PAIS)
{
BESVMC_DEPA oBeDepartamento = new BESVMC_DEPA();
BRSVMC_DEPA oBrDepartamento = new BRSVMC_DEPA();
List<BESVMC_DEPA> oListDepartamento = new List<BESVMC_DEPA>();
oBeDepartamento.COD_PAIS = COD_PAIS;
oBeDepartamento.NUM_ACCI = 5;
oListDepartamento = oBrDepartamento.Get_SVPR_DEPA_LIST(oBeDepartamento);
luePopCOD_DEPA.Properties.DataSource = oListDepartamento;
luePopCOD_DEPA.Properties.Columns.Clear();
luePopCOD_DEPA.Properties.Columns.Add(new LookUpColumnInfo("ALF_DEPA", 100, "Departamento"));
luePopCOD_DEPA.Properties.DisplayMember = "ALF_DEPA";
luePopCOD_DEPA.Properties.ValueMember = "COD_DEPA";
}
/// <summary>
/// OBTENER EL RESULTADO DE CUALQUIER CONSULTA
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List<BESVMC_DEPA> Get_SVPR_DEPA_LIST(BESVMC_DEPA oBe)
{
try
{
using (IDataReader oDr = oDa.Get_SVPR_DEPA_LIST(oBe))
{
List<BESVMC_DEPA> oList = new List<BESVMC_DEPA>();
IList iList = oList;
((IList)iList).LoadFromReader<BESVMC_DEPA>(oDr);
Dispose(false);
return (oList);
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public IDataReader Get_SVPR_DEPA_LIST(BESVMC_DEPA oBe)
{
try
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
var ocmd = odb.GetStoredProcCommand("SVPR_DEPA_LIST",
oBe.COD_PAIS,
oBe.COD_DEPA,
oBe.ALF_DEPA,
oBe.COD_USUA_CREA,
oBe.COD_USUA_MODI,
oBe.NUM_ACCI
);
ocmd.CommandTimeout = 2000;
var odr = odb.ExecuteReader(ocmd);
Dispose(false);
return (odr);
}
finally
{
ocn.Close();
}
}
private void lueCOD_PAIS_EditValueChanged(object sender, EventArgs e)
{
LookUpEdit Obj = (LookUpEdit)sender;
if (Obj.EditValue != null)
{
var oBe = new BESVMC_DEPA();
var oBr = new BRSVMC_DEPA();
oBe.NUM_ACCI = 5;
oBe.COD_PAIS = Convert.ToInt32(Obj.EditValue);
var oList = oBr.Get_SVPR_DEPA_LIST(oBe);
lueCOD_DEPA.Properties.DataSource = oList;
lueCOD_DEPA.Properties.Columns.Clear();
lueCOD_DEPA.Properties.Columns.Add(new LookUpColumnInfo("ALF_DEPA", 100, "Departamento"));
lueCOD_DEPA.Properties.DisplayMember = "ALF_DEPA";
lueCOD_DEPA.Properties.ValueMember = "COD_DEPA";
}
else
{
lueCOD_DEPA.Properties.DataSource = null;
}
}
