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