private void sbSearch_Click(object sender, EventArgs e)
{
var oBeS = new BESVMC_ARTI();
var oBrS = new BRSVMC_ARTI();
oBeS.ALF_ARTI = txtALF_REFE.Text;
oBeS.ALF_CODI_ARTI = txtALF_CODI.Text;
oBeS.COD_COMP = SESSION_COMP;
oBeS.NUM_ACCI = 6;
var oList = oBrS.Get_SVPR_ARTI_LIST(oBeS);
gdcResults.DataSource = oList;
}
/// <summary>
/// OBTENER EL RESULTADO DE CUALQUIER CONSULTA
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List<BESVMC_ARTI> Get_SVPR_ARTI_LIST(BESVMC_ARTI oBe)
{
try
{
using (IDataReader oDr = oDa.Get_SVPR_ARTI_LIST(oBe))
{
List<BESVMC_ARTI> oList = new List<BESVMC_ARTI>();
IList iList = oList;
((IList)iList).LoadFromReader<BESVMC_ARTI>(oDr);
Dispose(false);
return (oList);
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
private void Accept()
{
try
{
if (gdvResults.RowCount <= 0)
throw new ArgumentException("No existen registros en la lista");
if (gdvResults.FocusedRowHandle >= 0)
{
oBe = (BESVMC_ARTI)gdvResults.GetRow(gdvResults.FocusedRowHandle);
DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public IDataReader Get_SVPR_ARTI_LIST(BESVMC_ARTI oBe)
{
try
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
var ocmd = odb.GetStoredProcCommand("SVPR_ARTI_BUSC",
oBe.ALF_CODI_ARTI,
oBe.ALF_ARTI,
oBe.COD_COMP,
oBe.NUM_ACCI
);
ocmd.CommandTimeout = 2000;
var odr = odb.ExecuteReader(ocmd);
Dispose(false);
return (odr);
}
finally
{
ocn.Close();
}
}
public xfSearchArticleSales(int COMP)
{
InitializeComponent();
oBe = new BESVMC_ARTI();
SESSION_COMP = COMP;
}
