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