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