/// <summary>
/// REALIZAR OPERACIONES DE MANTENIMIENTO
/// </summary>
/// <param name="oBe"></param>
public void Set_SVPR_SERI_CORR(BESVMC_SERI_CORR oBe)
{
try
{
oDa.Set_SVPR_SERI_CORR(oBe);
Dispose(false);
}
catch(Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
/// <summary>
/// OBTENER EL RESULTADO DE CUALQUIER CONSULTA
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List<BESVMC_SERI_CORR> Get_SVPR_SERI_CORR_LIST(BESVMC_SERI_CORR oBe)
{
try
{
using (IDataReader oDr = oDa.Get_SVPR_SERI_CORR_LIST(oBe))
{
List<BESVMC_SERI_CORR> oList = new List<BESVMC_SERI_CORR>();
IList iList = oList;
((IList)iList).LoadFromReader<BESVMC_SERI_CORR>(oDr);
Dispose(false);
return (oList);
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
/// <summary>
/// LIMPIAR LOS CONTROLES
/// </summary>
private void ClearControl()
{
txtCOD_SOCI_NEGO.Text = "";
beALF_NOMB.Text = "";
txtALF_DIRE_FISC.Text = "";
txtALF_TELE.Text = "";
txtALF_FAXX.Text = "";
txtALF_CONT.Text = "";
lueCOD_SUCU.EditValue = null;
lueCOD_MONE.EditValue = null;
lueCOD_ALMA.EditValue = null;
txtNUM_DESC.Text = "0%";
txtNUM_NCRE.Text = "";
deFEC_REGI.DateTime = DateTime.Today;
deFEC_DOCU.DateTime = DateTime.Today;
deFEC_VENC.DateTime = DateTime.Today;
txtALF_ESTA.Text = "";
oListArti.Clear();
oListArtiCompleted.Clear();
oListGroup.Clear();
oListArtiGroup.Clear();
gdvArticles.RefreshData();
gdvArticlesCompleted.RefreshData();
gdvGroups.RefreshData();
gdvArticlesGroup.RefreshData();
txtNUM_CANT_ADDD.Text = "0";
txtNUM_CANT_REMO.Text = "0";
meALF_OBSE.Text = "";
txtNUM_SUBT.Text = "";
txtNUM_IGVV.Text = "";
txtNUM_TOTA.Text = "";
lblALF_SONN.Text = "";
lueALF_SERI.EditValue = null;
txtNUM_CORR.Text = "";
beALF_GUIA_REMI_STOR.Text = "";
txtALF_NUME_FACT.Text = "";
txtALF_NUME_IDEN.Text = "";
COD_DVEN = 0;
//SERIES
var oBeSe = new BESVMC_SERI_CORR();
var oBrSe = new BRSVMC_SERI_CORR();
oBeSe.NUM_ACCI = 5;
oBeSe.COD_TIPO_DOCU = 3;
oBeSe.COD_COMP = SESSION_COMP;
var oListSe = oBrSe.Get_SVPR_SERI_CORR_LIST(oBeSe);
lueALF_SERI.Properties.DataSource = oListSe;
lueALF_SERI.Properties.Columns.Clear();
lueALF_SERI.Properties.Columns.Add(new LookUpColumnInfo("ALF_SERI", 100, "Serie"));
lueALF_SERI.Properties.DisplayMember = "ALF_SERI";
lueALF_SERI.Properties.ValueMember = "ALF_SERI";
chkIGV.Checked = true;
}
public void Set_SVPR_SERI_CORR(BESVMC_SERI_CORR oBe)
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
using (var obts = ocn.BeginTransaction())
{
try
{
using (var ocmd = odb.GetStoredProcCommand("SVPR_SERI_CORR",
oBe.COD_TIPO_DOCU,
oBe.ALF_SERI,
oBe.NUM_CORR,
oBe.COD_COMP,
oBe.COD_USUA_CREA,
oBe.COD_USUA_MODI,
oBe.NUM_ACCI))
{
ocmd.CommandTimeout = 2000;
odb.ExecuteNonQuery(ocmd, obts);
obts.Commit();
}
}
catch (Exception ex)
{
obts.Rollback();
throw new ArgumentException(ex.Message);
}
finally
{
ocn.Close();
}
}
}
public IDataReader Get_SVPR_SERI_CORR_LIST(BESVMC_SERI_CORR oBe)
{
try
{
if (ocn.State == ConnectionState.Closed) ocn.Open();
var ocmd = odb.GetStoredProcCommand("SVPR_SERI_CORR_LIST",
oBe.COD_TIPO_DOCU,
oBe.ALF_SERI,
oBe.NUM_CORR,
oBe.COD_COMP,
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 ClearControl()
{
deFEC_DOCU.EditValue = DateTime.Today;
deFEC_VENC.EditValue = DateTime.Today;
deFEC_REGI.EditValue = DateTime.Today;
deFEC_NEGO.EditValue = DateTime.Today;
beALF_NOMB.Text = "";
txtALF_DIRE_FISC.Text = "";
txtALF_FAXX.Text = "";
txtALF_TELE.Text = "";
txtALF_CONT.Text = "";
txtALF_ESTA.Text = "";
txtALF_NUME_IDEN.Text = "";
lueALF_SERI.EditValue = null;
txtNUM_CORR.Text = "";
txtNUM_DESC.Text = "0.00";
txtNUM_NCRE.Text = "";
txtNUM_SUBT.Text = "";
txtNUM_IGVV.Text = "";
txtNUM_TOTA.Text = "";
meALF_OBSE.Text = "";
oListInvoice.Clear();
gdvInvoices.RefreshData();
//SERIES
var oBeSe = new BESVMC_SERI_CORR();
var oBrSe = new BRSVMC_SERI_CORR();
oBeSe.NUM_ACCI = 5;
oBeSe.COD_TIPO_DOCU = 3;
oBeSe.COD_COMP = SESSION_COMP;
var oListSe = oBrSe.Get_SVPR_SERI_CORR_LIST(oBeSe);
lueALF_SERI.Properties.DataSource = oListSe;
lueALF_SERI.Properties.Columns.Clear();
lueALF_SERI.Properties.Columns.Add(new LookUpColumnInfo("ALF_SERI", 100, "Serie"));
lueALF_SERI.Properties.DisplayMember = "ALF_SERI";
lueALF_SERI.Properties.ValueMember = "ALF_SERI";
}
private void xfCurrency_Load(object sender, EventArgs e)
{
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
StateControl(true);
var oBeTC = new BESVMC_TIPO_DOCU();
var oBrTC = new BRSVMC_TIPO_DOCU();
oBeTC.NUM_ACCI = 4;
oBeTC.COD_COMP = SESSION_COMP;
var oListTC = oBrTC.Get_SVPR_TIPO_DOCU_LIST(oBeTC);
lueCOD_TIPO_DOCU.Properties.DataSource = oListTC;
lueCOD_TIPO_DOCU.Properties.Columns.Clear();
lueCOD_TIPO_DOCU.Properties.Columns.Add(new LookUpColumnInfo("ALF_TIPO_DOCU", 100, "Tipo documento"));
lueCOD_TIPO_DOCU.Properties.DisplayMember = "ALF_TIPO_DOCU";
lueCOD_TIPO_DOCU.Properties.ValueMember = "COD_TIPO_DOCU";
var oBeC = new BESVMC_SERI_CORR();
var oBrC = new BRSVMC_SERI_CORR();
oBeC.NUM_ACCI = 4;
oBeC.COD_COMP = SESSION_COMP;
var oListC = oBrC.Get_SVPR_SERI_CORR_LIST(oBeC);
gdcSeries.DataSource = oListC;
}
public void Save()
{
if (txtNUM_CORR.Properties.ReadOnly) return;
try
{
if (lueCOD_TIPO_DOCU.EditValue == null)
throw new ArgumentException("Seleccione el tipo de documento");
if (string.IsNullOrEmpty(txtALF_SERI.Text))
throw new ArgumentException("Ingresar la serie");
if (string.IsNullOrEmpty(txtNUM_CORR.Text))
throw new ArgumentException("Ingresar el correlativo");
var oBe = new BESVMC_SERI_CORR();
var oBr = new BRSVMC_SERI_CORR();
if (FORM_ESTA==1)
{
oBe.NUM_ACCI = 1;
}
else
{
oBe.NUM_ACCI = 2;
oBe.COD_TIPO_DOCU = Convert.ToInt32(lueCOD_TIPO_DOCU.EditValue);
}
oBe.COD_TIPO_DOCU = Convert.ToInt32(lueCOD_TIPO_DOCU.EditValue);
oBe.ALF_SERI = txtALF_SERI.Text;
oBe.NUM_CORR = Convert.ToInt32(txtNUM_CORR.Text);
oBe.COD_USUA_CREA = SESSION_USER;
oBe.COD_USUA_MODI = SESSION_USER;
oBe.COD_COMP = SESSION_COMP;
oBr.Set_SVPR_SERI_CORR(oBe);
lueCOD_TIPO_DOCU.EditValue = oBe.COD_TIPO_DOCU.ToString();
var oBeC = new BESVMC_SERI_CORR();
var oBrC = new BRSVMC_SERI_CORR();
oBeC.NUM_ACCI = 4;
oBeC.COD_COMP = SESSION_COMP;
var oListC = oBrC.Get_SVPR_SERI_CORR_LIST(oBeC);
gdcSeries.DataSource = oListC;
StateControl(true);
XtraMessageBox.Show("Operación realizada con exito!!!", "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
