/// <summary> /// CARGAR LOS DISTRITOS EN FUNCION A LA PROVINCIA QUE ESTA SELECCIONADA /// </summary> /// <param name="COD_PROV"></param> /// <param name="COD_DEPA"></param> /// <param name="selector"></param> private void cargarDistritos(string COD_PROV, string COD_DEPA) { BESVMC_DIST oBeDistritoOrigen = new BESVMC_DIST(); BRSVMC_DIST oBrDistritoOrigen = new BRSVMC_DIST(); List<BESVMC_DIST> oListDistritoOrigen = new List<BESVMC_DIST>(); oBeDistritoOrigen.COD_PROV = COD_PROV; oBeDistritoOrigen.COD_DEPA = COD_DEPA; oBeDistritoOrigen.NUM_ACCI = 5; oListDistritoOrigen = oBrDistritoOrigen.Get_SVPR_DIST_LIST(oBeDistritoOrigen); luePopCOD_DIST.Properties.DataSource = oListDistritoOrigen; luePopCOD_DIST.Properties.Columns.Clear(); luePopCOD_DIST.Properties.Columns.Add(new LookUpColumnInfo("ALF_DIST", 100, "Distrito")); luePopCOD_DIST.Properties.DisplayMember = "ALF_DIST"; luePopCOD_DIST.Properties.ValueMember = "COD_DIST"; }
/// <summary> /// OBTENER EL RESULTADO DE CUALQUIER CONSULTA /// </summary> /// <param name="oBe"></param> /// <returns></returns> public List<BESVMC_DIST> Get_SVPR_DIST_LIST(BESVMC_DIST oBe) { try { using (IDataReader oDr = oDa.Get_SVPR_DIST_LIST(oBe)) { List<BESVMC_DIST> oList = new List<BESVMC_DIST>(); IList iList = oList; ((IList)iList).LoadFromReader<BESVMC_DIST>(oDr); Dispose(false); return (oList); } } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
public IDataReader Get_SVPR_DIST_LIST(BESVMC_DIST oBe) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("SVPR_DIST_LIST", oBe.COD_DEPA, oBe.COD_PROV, oBe.COD_DIST, oBe.ALF_DIST, 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_PROV_EditValueChanged(object sender, EventArgs e) { LookUpEdit Obj = (LookUpEdit)sender; if (Obj.EditValue != null) { var oBe = new BESVMC_DIST(); var oBr = new BRSVMC_DIST(); oBe.NUM_ACCI = 5; oBe.COD_DEPA = Convert.ToString(lueCOD_DEPA.EditValue); oBe.COD_PROV = Convert.ToString(lueCOD_PROV.EditValue); var oList = oBr.Get_SVPR_DIST_LIST(oBe); lueCOD_DIST.Properties.DataSource = oList; 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; } }