/// <summary> /// OBTENER EL RESULTADO DE CUALQUIER CONSULTA /// </summary> /// <param name="oBe"></param> /// <returns></returns> public List<BESVMC_MAIN_MENU> Get_SVPR_MAIN_LIST(BESVMC_MAIN_MENU oBe) { try { using (IDataReader oDr = oDa.Get_SVPR_MAIN_LIST(oBe)) { List<BESVMC_MAIN_MENU> oList = new List<BESVMC_MAIN_MENU>(); IList iList = oList; ((IList)iList).LoadFromReader<BESVMC_MAIN_MENU>(oDr); Dispose(false); return (oList); } } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
public IDataReader Get_SVPR_MAIN_LIST(BESVMC_MAIN_MENU oBe) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("SVPR_MAIN_LIST", oBe.COD_MAIN, oBe.ALF_NOMB, oBe.ALF_DESC, 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 xfProfiles_Load(object sender, EventArgs e) { SESSION_USER = ((xfMain)MdiParent).SESSION_USER; SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF; SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP; ControlState(true); var oBe = new BESVMC_PERF(); var oBr = new BRSVMC_PERF(); var oBeMm = new BESVMC_MAIN_MENU(); var oBrMm = new BRSVMC_MAIN(); oBe.NUM_ACCI = 4; oBe.COD_COMP = SESSION_COMP; var oList = oBr.Get_SVPR_PERF_LIST(oBe); gdcProfile.DataSource = oList; oBeMm.NUM_ACCI = 4; var oListMm = oBrMm.Get_SVPR_MAIN_LIST(oBeMm); gdcMain.DataSource = oListMm; }