/// <summary>
/// OBTENER EL RESULTADO DE CUALQUIER CONSULTA
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List<BESVMC_PROV> Get_SVPR_PROV_LIST(BESVMC_PROV oBe)
{
try
{
using (IDataReader oDr = oDa.Get_SVPR_PROV_LIST(oBe))
{
List<BESVMC_PROV> oList = new List<BESVMC_PROV>();
IList iList = oList;
((IList)iList).LoadFromReader<BESVMC_PROV>(oDr);
Dispose(false);
return (oList);
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
private void lueCOD_DEPA_EditValueChanged(object sender, EventArgs e)
{
LookUpEdit Obj = (LookUpEdit)sender;
if (Obj.EditValue != null)
{
var oBe = new BESVMC_PROV();
var oBr = new BRSVMC_PROV();
oBe.NUM_ACCI = 5;
oBe.COD_DEPA = Convert.ToString(Obj.EditValue);
var oList = oBr.Get_SVPR_PROV_LIST(oBe);
lueCOD_PROV.Properties.DataSource = oList;
lueCOD_PROV.Properties.Columns.Clear();
lueCOD_PROV.Properties.Columns.Add(new LookUpColumnInfo("ALF_PROV", 100, "Provincia"));
lueCOD_PROV.Properties.DisplayMember = "ALF_PROV";
lueCOD_PROV.Properties.ValueMember = "COD_PROV";
if (lueCOD_PROV.EditValue != null)
{
var oBeP = new BESVMC_DIST();
var oBrP = new BRSVMC_DIST();
oBeP.NUM_ACCI = 5;
oBeP.COD_DEPA = Convert.ToString(lueCOD_DEPA.EditValue);
oBeP.COD_PROV = Convert.ToString(lueCOD_PROV.EditValue);
var oListP = oBrP.Get_SVPR_DIST_LIST(oBeP);
lueCOD_DIST.Properties.DataSource = oListP;
lueCOD_DIST.Properties.Columns.Clear();
lueCOD_DIST.Properties.Columns.Add(new LookUpColumnInfo("ALF_DIST", 100, "Distrito"));
lueCOD_DIST.Properties.DisplayMember = "ALF_DIST";
lueCOD_DIST.Properties.ValueMember = "COD_DIST";
}
else
{
lueCOD_DIST.Properties.DataSource = null;
}
}
else
{
lueCOD_PROV.Properties.DataSource = null;
lueCOD_DIST.Properties.DataSource = null;
}
}
public IDataReader Get_SVPR_PROV_LIST(BESVMC_PROV oBe)
{
try
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
var ocmd = odb.GetStoredProcCommand("SVPR_PROV_LIST",
oBe.COD_DEPA,
oBe.COD_PROV,
oBe.ALF_PROV,
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();
}
}
/// <summary>
/// CARGAR PROVINCIAS EN FUNCION AL DEPARTAMENTO SELECCIONADO
/// </summary>
/// <param name="COD_DEPA"></param>
/// <param name="selector"></param>
private void cargarProvincias(string COD_DEPA)
{
BESVMC_PROV oBeProvinciaOrigen = new BESVMC_PROV();
BRSVMC_PROV oBrProvinciaOrigen = new BRSVMC_PROV();
List<BESVMC_PROV> oListProvinciaOrigen = new List<BESVMC_PROV>();
oBeProvinciaOrigen.COD_DEPA = COD_DEPA;
oBeProvinciaOrigen.NUM_ACCI = 5;
oListProvinciaOrigen = oBrProvinciaOrigen.Get_SVPR_PROV_LIST(oBeProvinciaOrigen);
luePopCOD_PROV.Properties.DataSource = oListProvinciaOrigen;
luePopCOD_PROV.Properties.Columns.Clear();
luePopCOD_PROV.Properties.Columns.Add(new LookUpColumnInfo("ALF_PROV", 100, "Provincia"));
luePopCOD_PROV.Properties.DisplayMember = "ALF_PROV";
luePopCOD_PROV.Properties.ValueMember = "COD_PROV";
if (luePopCOD_PROV.EditValue != null)
cargarDistritos(luePopCOD_PROV.EditValue.ToString(), COD_DEPA);
else
luePopCOD_DIST.Properties.DataSource = null;
}