private void Search() { try { var opar = new BEArticle(); var sortindex = gdvSearch.SortedColumns[0].VisibleIndex; if (sortindex == 0) opar.ALF_CODI_ARTI = txtParameter.Text.Trim(); else opar.ALF_ARTI = txtParameter.Text.Trim(); opar.COD_COMP = xfMain.SgIns.SESSION_COMP; opar.COD_ALMA = rowsel.COD_ALMA; var obr = new BRArticle(); var olst = obr.Get_PSGN_SPLS_SVMC_ARTI_ALMA(opar); gdcSearch.DataSource = olst; gdvSearch.MoveFirst(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, WhMessage.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// Retorna artículos según el filtro. /// </summary> public List<BEArticle> Get_PSGN_SPLS_SVMC_ARTI(BEArticle opar) { using (var odr = oda.Get_PSGN_SPLS_SVMC_ARTI(opar)) { var olst = new List<BEArticle>(); ((IList)olst).LoadFromReader<BEArticle>(odr); Dispose(false); return (olst); } }
private void Get_RowSelecion() { try { if (gdvSearch.RowCount == 0) throw new ArgumentException(WhMessage.MsgZeroRows); rowsel = (BEArticle)gdvSearch.GetRow(gdvSearch.FocusedRowHandle); DialogResult = DialogResult.OK; } catch (Exception ex) { XtraMessageBox.Show(ex.Message, WhMessage.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// Mantenimiento de Artículos. /// Inserta, Modifica y Elimina /// </summary> public void Set_PSWH_SPMT_SVMC_ARTI(BEArticle obar) { oda.Set_PSWH_SPMT_SVMC_ARTI(obar); Dispose(false); }
public xfSearchWarehouseArticle() { InitializeComponent(); rowsel = new BEArticle(); }
private void Set_Article(BEArticle arti) { ClearControls(); txtCOD_ARTI.Text = Convert.ToString(arti.COD_ARTI); txtALF_CODI_ARTI.Text = arti.ALF_CODI_ARTI; txtALF_ARTI.Text = arti.ALF_ARTI; mmeALF_DESC.Text = arti.ALF_DESC; lkeCOD_TIPO_ARTI.EditValue = arti.COD_TIPO_ARTI; lkeCOD_MODE_ARTI.EditValue = arti.COD_MODE_ARTI; txtNUM_STOC_MINI.Text = Convert.ToString(arti.NUM_STOC_MINI); if (arti.IMG_FOTO != null) pteIMG_FOTO.Image = ByteArrayToImage(arti.IMG_FOTO); }
public void Set_Save() { MessageBoxIcon msgIcon = MessageBoxIcon.Warning; try { var obar = new BEArticle(); if (!string.IsNullOrWhiteSpace(txtCOD_ARTI.Text)) obar.COD_ARTI = Convert.ToInt32(txtCOD_ARTI.Text); obar.ALF_CODI_ARTI = txtALF_CODI_ARTI.Text.Trim(); obar.ALF_ARTI = txtALF_ARTI.Text.Trim(); obar.ALF_DESC = mmeALF_DESC.Text.Trim(); obar.COD_TIPO_ARTI = Convert.ToInt32(lkeCOD_TIPO_ARTI.EditValue); obar.COD_MODE_ARTI = Convert.ToInt32(lkeCOD_MODE_ARTI.EditValue); obar.NUM_STOC_MINI = Convert.ToInt32(txtNUM_STOC_MINI.Text); if (pteIMG_FOTO.Image != null) obar.IMG_FOTO = ImageToByteArray(pteIMG_FOTO.Image); obar.IND_MNTN = 1; if (!string.IsNullOrWhiteSpace(txtCOD_ARTI.Text)) obar.IND_MNTN = 2; obar.COD_USUA_CREA = SESSION_USER; obar.COD_USUA_MODI = SESSION_USER; obar.COD_COMP = SESSION_COMP; var context = new ValidationContext(obar, null, null); var errors = new List<ValidationResult>(); if (!Validator.TryValidateObject(obar, context, errors, true)) { foreach (ValidationResult result in errors) { msgIcon = MessageBoxIcon.Warning; throw new ArgumentException(result.ErrorMessage); } } else { var obr = new BRArticle(); obr.Set_PSWH_SPMT_SVMC_ARTI(obar); if (!string.IsNullOrWhiteSpace(obar.MSG_MNTN)) { msgIcon = MessageBoxIcon.Error; throw new ArgumentException(obar.MSG_MNTN); } StateControls(true); txtCOD_ARTI.Text = obar.COD_ARTI.ToString(); XtraMessageBox.Show(WhMessage.MsgSuccessfully, WhMessage.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, WhMessage.MsgInsCaption, MessageBoxButtons.OK, msgIcon); } }
/// <summary> /// Retorna los artículos según el filtro. /// </summary> public IDataReader Get_PSGN_SPLS_SVMC_ARTI(BEArticle opar) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("PSGN_SPLS_SVMC_ARTI", opar.ALF_CODI_ARTI, opar.ALF_ARTI, opar.COD_COMP); ocmd.CommandTimeout = 2000; var odr = odb.ExecuteReader(ocmd); Dispose(false); return (odr); } finally { ocn.Close(); } }
/// <summary> /// Mantenimiento de Artículos. /// Inserta, Modifica y Elimina /// </summary> public void Set_PSWH_SPMT_SVMC_ARTI(BEArticle obar) { if (ocn.State == ConnectionState.Closed) ocn.Open(); using (var obts = ocn.BeginTransaction()) { try { using (var ocmd = odb.GetStoredProcCommand("PSWH_SPMT_SVMC_ARTI", obar.COD_ARTI, obar.COD_TIPO_ARTI, obar.COD_MODE_ARTI, obar.ALF_ARTI, obar.ALF_CODI_ARTI, obar.ALF_DESC, obar.NUM_STOC_MINI, obar.IMG_FOTO, obar.COD_COMP, obar.COD_USUA_CREA, obar.COD_USUA_MODI, obar.IND_MNTN)) { ocmd.CommandTimeout = 2000; odb.ExecuteNonQuery(ocmd, obts); obar.COD_ARTI = Convert.ToInt32(odb.GetParameterValue(ocmd, "@COD_ARTI")); obts.Commit(); } } catch (Exception ex) { obts.Rollback(); obar.MSG_MNTN = ex.Message; } finally { ocn.Close(); } } }