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