/// <summary> /// Reporte Artículos por Compra. /// </summary> public List<BEDocument> Get_PPRP_SPLS_COM3(BEDocument obj) { using (var odr = oda.Get_PPRP_SPLS_COM3(obj)) { var olst = new List<BEDocument>(); ((IList)olst).LoadFromReader<BEDocument>(odr); Dispose(false); return (olst); } }
/// <summary> /// Retorna los gastos de nacionalización según la guía de compra seleccionada. /// </summary> public List<BEDocumentExpenses> Get_PSCP_SPLS_SCPC_GANA(BEDocument obj) { using (var odr = oda.Get_PSCP_SPLS_SCPC_GANA(obj)) { var olst = new List<BEDocumentExpenses>(); ((IList)olst).LoadFromReader<BEDocumentExpenses>(odr); Dispose(false); return (olst); } }
/// <summary> /// Reporte Registro de Compras Importadas. /// </summary> public IDataReader Get_PPRP_SPLS_COM2(BEDocument obj) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("PPRP_SPLS_COM2", obj.FEC_REGI_INIC, obj.FEC_REGI_FINA, obj.COD_SUCU); ocmd.CommandTimeout = 2000; var odr = odb.ExecuteReader(ocmd); Dispose(false); return (odr); } finally { ocn.Close(); } }
/// <summary> /// Retorna los gastos de nacionalización según la guía de compra seleccionada. /// </summary> public IDataReader Get_PSCP_SPLS_SCPC_GANA(BEDocument obj) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("PSCP_SPLS_SCPC_GANA", obj.COD_DOCU); ocmd.CommandTimeout = 2000; var odr = odb.ExecuteReader(ocmd); Dispose(false); return (odr); } finally { ocn.Close(); } }
private void Set_Invoice(BEDocument row) { ClearControls(); txtCOD_DOCU.Text = row.COD_DOCU.ToString(); rdgIND_TIPO_COMP.EditValue = row.IND_TIPO_COMP; bteCOD_SOCI_NEGO.Properties.Buttons[0].Caption = row.COD_SOCI_NEGO.ToString(); bteCOD_SOCI_NEGO.Text = row.ALF_SOCI_NEGO; txtALF_NUM_SERI.Text = row.ALF_NUM_SERI; txtALF_NUM_CORR.Text = row.ALF_NUM_CORR; lkeCOD_COND_PAGO.EditValue = row.COD_COND_PAGO; lkeCOD_ALMA.EditValue = row.COD_ALMA; lkeCOD_MONE.EditValue = row.COD_MONE; txtNUM_TIPO_CAMB.EditValue = row.NUM_TIPO_CAMB; lkeIND_ESTA.EditValue = row.IND_ESTA; dteFEC_REGI.EditValue = row.FEC_REGI; dteFEC_ENTR.EditValue = row.FEC_ENTR; dteFEC_DOCU.EditValue = row.FEC_DOCU; dteFEC_PAGO.EditValue = row.FEC_PAGO; txtALF_NUM_RUCC.Text = row.ALF_NUM_RUCC; mmeALF_DIRE_FISC.Text = row.ALF_DIRE_FISC; mmeALF_DIRE_ENTR.Text = row.ALF_DIRE_ENTR; mmeALF_COME.Text = row.ALF_COME; var obj = new BEDocument() { COD_DOCU = row.COD_DOCU }; var obr = new BRPurchase(); var olst = obr.Get_PSCP_SPLS_SCPD_OINV(obj); gdcLines.DataSource = olst; gdvLines.RefreshData(); txtNUM_SUBB_TOTA.EditValue = row.NUM_SUBB_TOTA; txtNUM_DESC.EditValue = row.NUM_DESC; txtNUM_IGVV.EditValue = row.NUM_IGVV; txtNUM_TOTA.EditValue = row.NUM_TOTA; var SIMB = (BESVMC_MONE)lkeCOD_MONE.GetSelectedDataRow(); var molt = new BRNumLetter(); lblTotalLetter.Text = molt.Convertir(row.NUM_TOTA.ToString(), true, SIMB.ALF_MONE_SIMB); StateControls(true); txtCOD_DOCU.Focus(); }
private void Set_DocumentBase() { ClearControls(); StateControls(false); rdgIND_TIPO_COMP.EditValue = docb.IND_TIPO_COMP; bteCOD_SOCI_NEGO.Properties.Buttons[0].Caption = docb.COD_SOCI_NEGO.ToString(); bteCOD_SOCI_NEGO.Text = docb.ALF_SOCI_NEGO; lkeCOD_COND_PAGO.EditValue = docb.COD_COND_PAGO; lkeCOD_ALMA.EditValue = docb.COD_ALMA; lkeCOD_MONE.EditValue = docb.COD_MONE; txtNUM_TIPO_CAMB.EditValue = docb.NUM_TIPO_CAMB; lkeIND_ESTA.EditValue = docb.IND_ESTA; dteFEC_REGI.EditValue = docb.FEC_REGI; dteFEC_ENTR.EditValue = docb.FEC_ENTR; dteFEC_DOCU.EditValue = docb.FEC_DOCU; dteFEC_PAGO.EditValue = docb.FEC_PAGO; txtALF_NUM_RUCC.Text = docb.ALF_NUM_RUCC; mmeALF_DIRE_FISC.Text = docb.ALF_DIRE_FISC; mmeALF_DIRE_ENTR.Text = docb.ALF_DIRE_ENTR; mmeALF_COME.Text = docb.ALF_COME; var obj = new BEDocument() { COD_DOCU = docb.COD_DOCU }; var obr = new BRPurchase(); var olst = obr.Get_PSCP_SPLS_SCPD_GUIA(obj); olst.ForEach(item => { item.TIP_DOCU_BASE = 2; item.COD_DOCU_BASE = item.COD_DOCU; item.NUM_LINE_BASE = item.NUM_LINE; item.COD_ARTI_BASE = item.COD_ARTI; }); gdcLines.DataSource = olst; gdvLines.RefreshData(); txtNUM_SUBB_TOTA.EditValue = docb.NUM_SUBB_TOTA; txtNUM_DESC.EditValue = docb.NUM_DESC; txtNUM_IGVV.EditValue = docb.NUM_IGVV; txtNUM_TOTA.EditValue = docb.NUM_TOTA; var SIMB = (BESVMC_MONE)lkeCOD_MONE.GetSelectedDataRow(); var molt = new BRNumLetter(); lblTotalLetter.Text = molt.Convertir(docb.NUM_TOTA.ToString(), true, SIMB.ALF_MONE_SIMB); }
private void HandleSendCopyToDeliveryClick(object sender, ItemClickEventArgs e) { try { ddbCopy.HideDropDown(); if (string.IsNullOrEmpty(txtCOD_DOCU.Text)) throw new ArgumentException(_Message.MsgSelectDoc); if (lkeIND_ESTA.EditValue.ToString() != "AB") throw new ArgumentException(string.Format("{0}{1}.", _Message.MsgNotCopy, lkeIND_ESTA.Text.ToLower())); var odoc = new BEDocument() { COD_DOCU = Convert.ToInt32(txtCOD_DOCU.Text), IND_ESTA = lkeIND_ESTA.EditValue.ToString(), COD_SUCU = SESSION_COMP, IND_TIPO_COMP = rdgIND_TIPO_COMP.EditValue.ToString(), COD_SOCI_NEGO = Convert.ToInt32(bteCOD_SOCI_NEGO.Properties.Buttons[0].Caption), ALF_SOCI_NEGO = bteCOD_SOCI_NEGO.Text, ALF_NUM_RUCC = txtALF_NUM_RUCC.Text, ALF_DIRE_FISC = mmeALF_DIRE_FISC.Text.Trim(), ALF_DIRE_ENTR = mmeALF_DIRE_ENTR.Text.Trim(), COD_MONE = (int?)lkeCOD_MONE.EditValue, NUM_TIPO_CAMB = (decimal?)txtNUM_TIPO_CAMB.EditValue, COD_COND_PAGO = (int?)lkeCOD_COND_PAGO.EditValue, COD_ALMA = (int?)lkeCOD_ALMA.EditValue, FEC_REGI = (DateTime?)dteFEC_REGI.EditValue, FEC_ENTR = (DateTime?)dteFEC_ENTR.EditValue, FEC_DOCU = (DateTime?)dteFEC_DOCU.EditValue, FEC_PAGO = (DateTime?)dteFEC_PAGO.EditValue, ALF_COME = mmeALF_COME.Text.Trim(), NUM_SUBB_TOTA = Convert.ToDecimal(txtNUM_SUBB_TOTA.EditValue), NUM_DESC = Convert.ToDecimal(txtNUM_DESC.EditValue), NUM_IGVV = Convert.ToDecimal(txtNUM_IGVV.EditValue), NUM_TOTA = Convert.ToDecimal(txtNUM_TOTA.EditValue) }; xfCreditNote.SgIns.docb = odoc; xfCreditNote.SgIns.MdiParent = MdiParent; xfCreditNote.SgIns.Activate(); xfCreditNote.SgIns.FORM_SUBO = "bbiSupplierCreditNote"; xfCreditNote.SgIns.Show(); xfCreditNote.SgIns.BringToFront(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, _Message.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Set_Save() { MessageBoxIcon msgIcon = MessageBoxIcon.Warning; try { if (string.IsNullOrWhiteSpace(txtALF_NUM_SERI.Text)) throw new ArgumentException(_Message.MsgReqALF_NUM_SERI); if (string.IsNullOrWhiteSpace(txtALF_NUM_CORR.Text)) throw new ArgumentException(_Message.MsgReqALF_NUM_CORR); if (string.IsNullOrWhiteSpace(bteCOD_SOCI_NEGO.Properties.Buttons[0].Caption)) throw new ArgumentException(_Message.MsgReqCOD_SOCI_NEGO); var odoc = new BEDocument() { COD_DOCU = (!string.IsNullOrWhiteSpace(txtCOD_DOCU.Text)) ? Convert.ToInt32(txtCOD_DOCU.Text) : (int?)null, ALF_NUM_SERI = txtALF_NUM_SERI.Text.Trim(), ALF_NUM_CORR = txtALF_NUM_CORR.Text.Trim(), IND_ESTA = lkeIND_ESTA.EditValue.ToString(), COD_SUCU = SESSION_COMP, IND_TIPO_COMP = rdgIND_TIPO_COMP.EditValue.ToString(), COD_SOCI_NEGO = Convert.ToInt32(bteCOD_SOCI_NEGO.Properties.Buttons[0].Caption), ALF_SOCI_NEGO = bteCOD_SOCI_NEGO.Text, ALF_NUM_RUCC = txtALF_NUM_RUCC.Text, ALF_DIRE_FISC = mmeALF_DIRE_FISC.Text.Trim(), ALF_DIRE_ENTR = mmeALF_DIRE_ENTR.Text.Trim(), COD_MONE = (int?)lkeCOD_MONE.EditValue, NUM_TIPO_CAMB = (decimal?)txtNUM_TIPO_CAMB.EditValue, COD_COND_PAGO = (int?)lkeCOD_COND_PAGO.EditValue, COD_ALMA = (int?)lkeCOD_ALMA.EditValue, FEC_REGI = (DateTime?)dteFEC_REGI.EditValue, FEC_ENTR = (DateTime?)dteFEC_ENTR.EditValue, FEC_DOCU = (DateTime?)dteFEC_DOCU.EditValue, FEC_PAGO = (DateTime?)dteFEC_PAGO.EditValue, ALF_COME = mmeALF_COME.Text.Trim(), NUM_SUBB_TOTA = Convert.ToDecimal(txtNUM_SUBB_TOTA.EditValue), NUM_DESC = Convert.ToDecimal(txtNUM_DESC.EditValue), NUM_IGVV = Convert.ToDecimal(txtNUM_IGVV.EditValue), NUM_TOTA = Convert.ToDecimal(txtNUM_TOTA.EditValue), COD_USUA_CREA = SESSION_USER, COD_USUA_MODI = SESSION_USER, IND_MNTN = (!string.IsNullOrWhiteSpace(txtCOD_DOCU.Text)) ? 2 : 1 }; var context = new ValidationContext(odoc, null, null); var errors = new List<ValidationResult>(); if (!Validator.TryValidateObject(odoc, context, errors, true)) { foreach (ValidationResult result in errors) { msgIcon = MessageBoxIcon.Warning; throw new ArgumentException(result.ErrorMessage); } } gdvLines.CloseEditor(); gdvLines.RefreshData(); var lines = (List<BEDocumentLines>)gdvLines.DataSource; if (lines.Count == 0) { msgIcon = MessageBoxIcon.Warning; throw new ArgumentException(_Message.MsgManyRows); } var i = 1; lines.ForEach(item => { context = new ValidationContext(item, null, null); errors = new List<ValidationResult>(); if (!Validator.TryValidateObject(item, context, errors, true)) { foreach (ValidationResult result in errors) { msgIcon = MessageBoxIcon.Warning; throw new ArgumentException(string.Format("{0}\nFila: {1}", result.ErrorMessage, i)); } } i++; }); var obr = new BRPurchase(); obr.Set_PSCP_SPMT_SCPC_OINV(odoc, lines); if (!string.IsNullOrWhiteSpace(odoc.MSG_MNTN)) { msgIcon = MessageBoxIcon.Error; throw new ArgumentException(odoc.MSG_MNTN); } txtCOD_DOCU.Text = odoc.COD_DOCU.ToString(); gdvLines.RefreshData(); StateControls(true); xfDelivery.SgIns.lkeIND_ESTA.EditValue = "CE"; XtraMessageBox.Show(_Message.MsgSuccessfully, _Message.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, _Message.MsgInsCaption, MessageBoxButtons.OK, msgIcon); } }
public void Set_Export() { try { if (string.IsNullOrWhiteSpace(txtCOD_ORCO.Text)) throw new ArgumentException(_Message.MsgSelectOC); var oc = new xrPurchaseOrder(); var odoc = new BEDocument() { ALF_DOCU_REFE = txtALF_DOCU_REFE.Text.Trim(), ALF_SOCI_NEGO = bteCOD_SOCI_NEGO.Text, ALF_DIRE_ENTR = mmeALF_DIRE_ENTR.Text.Trim(), ALF_COND_PAGO = lkeCOD_COND_PAGO.Text, FEC_REGI = (DateTime?)dteFEC_REGI.EditValue, ALF_COME = mmeALF_COME.Text, NUM_SUBB_TOTA = Convert.ToDecimal(txtNUM_SUBB_TOTA.EditValue), NUM_DESC = Convert.ToDecimal(txtNUM_DESC.EditValue), NUM_IGVV = Convert.ToDecimal(txtNUM_IGVV.EditValue), NUM_TOTA = Convert.ToDecimal(txtNUM_TOTA.EditValue) }; oc.bdsDocument.DataSource = odoc; oc.bdsDocumentLines.DataSource = (List<BEDocumentLines>)gdvLines.DataSource; var SIMB = (BESVMC_MONE)lkeCOD_MONE.GetSelectedDataRow(); var tfs = (SIMB.ALF_MONE_SIMB == "USD") ? "{0:USD 0.00}" : "{0:c2}"; oc.lblNUM_SUBB_TOTA.DataBindings["Text"].FormatString = tfs; oc.lblNUM_DESC.DataBindings["Text"].FormatString = tfs; oc.lblNUM_IGVV.DataBindings["Text"].FormatString = tfs; oc.lblNUM_TOTA.DataBindings["Text"].FormatString = tfs; oc.tlcNUM_PREC_UNIT.DataBindings["Text"].FormatString = tfs; oc.tlcNUM_DESC.DataBindings["Text"].FormatString = tfs; oc.tlcNUM_PREC_DESC.DataBindings["Text"].FormatString = tfs; oc.tlcNUM_IMPO.DataBindings["Text"].FormatString = tfs; using (var printTool = new ReportPrintTool(oc)) { printTool.ShowPreviewDialog(); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, _Message.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Search() { try { var opar = new BEDocument(); opar.ALF_SOCI_NEGO = txtALF_SOCI_NEGO.Text.Trim(); opar.FEC_REGI_INIC = (DateTime?)dteFEC_REGI_INIC.EditValue; opar.FEC_REGI_FINA = (DateTime?)dteFEC_REGI_FINA.EditValue; opar.ALF_DOCU_REFE = txtALF_DOCU_REFE.Text; opar.IND_ESTA = (lkeIND_ESTA.EditValue != null) ? lkeIND_ESTA.EditValue.ToString() : null; opar.COD_SUCU = SESSION_COMP; var obr = new BRPurchase(); var olst = obr.Get_PSCP_SPLS_SCPC_GUIA(opar); gdcSearch.DataSource = olst; gdvSearch.MoveFirst(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, _Message.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void Get_Search() { try { if (string.IsNullOrWhiteSpace(dteFEC_DESD.Text)) throw new ArgumentException("Fecha inicial incorrecta."); if (string.IsNullOrWhiteSpace(dteFEC_HAST.Text)) throw new ArgumentException("Fecha final incorrecta"); if (DateTime.Compare(dteFEC_DESD.DateTime, dteFEC_HAST.DateTime) > 0) throw new ArgumentException("Rango de fechas incorrecto."); var obj = new BEDocument() { FEC_REGI_INIC = dteFEC_DESD.DateTime, FEC_REGI_FINA = dteFEC_HAST.DateTime, COD_SUCU = SESSION_COMP }; var obr = new BRReportPurchase(); var olst = obr.Get_PPRP_SPLS_COM4(obj); gdcReport.DataSource = olst; } catch (Exception ex) { XtraMessageBox.Show(ex.Message, _Message.MsgInsCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// Retorna las guías de compra según filtro. /// </summary> public IDataReader Get_PSCP_SPLS_SCPC_GUIA(BEDocument obj) { try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand("PSCP_SPLS_SCPC_GUIA", obj.ALF_SOCI_NEGO, obj.ALF_DOCU_REFE, obj.FEC_REGI_INIC, obj.FEC_REGI_FINA, obj.IND_ESTA, obj.COD_SUCU); ocmd.CommandTimeout = 2000; var odr = odb.ExecuteReader(ocmd); Dispose(false); return (odr); } finally { ocn.Close(); } }
//! NOTA DE CREDITO PROVEEDOR /// <summary> /// Mantenimiento de nota de crédito proveedor. /// Inserta, Modifica /// </summary> public void Set_PSCP_SPMT_SCPC_ORPC(BEDocument odoc, List<BEDocumentLines> lines) { if (ocn.State == ConnectionState.Closed) ocn.Open(); using (var obts = ocn.BeginTransaction()) { try { using (var ocmd = odb.GetStoredProcCommand("PSCP_SPMT_SCPC_ORPC", odoc.COD_DOCU, odoc.ALF_NUM_SERI, odoc.ALF_NUM_CORR, odoc.IND_ESTA, odoc.COD_SUCU, odoc.IND_TIPO_COMP, odoc.COD_SOCI_NEGO, odoc.ALF_SOCI_NEGO, odoc.ALF_NUM_RUCC, odoc.ALF_CONT, odoc.ALF_DIRE_FISC, odoc.ALF_DIRE_ENTR, odoc.COD_MONE, odoc.NUM_TIPO_CAMB, odoc.COD_COND_PAGO, odoc.COD_ALMA, odoc.FEC_REGI, odoc.FEC_ENTR, odoc.FEC_DOCU, odoc.FEC_PAGO, odoc.ALF_COME, odoc.NUM_SUBB_TOTA, odoc.NUM_DESC, odoc.NUM_IGVV, odoc.NUM_ISCC, odoc.NUM_TOTA, odoc.COD_USUA_CREA, odoc.COD_USUA_MODI, odoc.IND_MNTN)) { ocmd.CommandTimeout = 2000; odb.ExecuteNonQuery(ocmd, obts); odoc.COD_DOCU = Convert.ToInt32(odb.GetParameterValue(ocmd, "@COD_DOCU")); DbCommand cmdo; var index = 1; lines.ForEach(line => { line.COD_DOCU = odoc.COD_DOCU; line.NUM_LINE = index; cmdo = odb.GetStoredProcCommand("PSCP_SPMT_SCPD_ORPC", line.COD_DOCU, line.TIP_DOCU_BASE, line.COD_DOCU_BASE, line.NUM_LINE_BASE, line.COD_ARTI_BASE, line.NUM_LINE, line.COD_ARTI, line.ALF_ARTI, line.NUM_CANT, line.NUM_CANT_ABIE, line.NUM_PREC_UNIT_ORIG, line.NUM_PREC_UNIT, line.NUM_PORC_DESC, line.NUM_DESC, line.NUM_PREC_DESC, line.NUM_IMPO, odoc.COD_USUA_MODI); cmdo.CommandTimeout = 2000; odb.ExecuteNonQuery(cmdo, obts); index += 1; }); obts.Commit(); } } catch (Exception ex) { obts.Rollback(); odoc.MSG_MNTN = ex.Message; } finally { ocn.Close(); } } }
//! NOTA DE CREDITO PROVEEDOR /// <summary> /// Mantenimiento de notas de crédito proveedor. /// Inserta, Modifica /// </summary> public void Set_PSCP_SPMT_SCPC_ORPC(BEDocument odoc, List<BEDocumentLines> lines) { oda.Set_PSCP_SPMT_SCPC_ORPC(odoc, lines); Dispose(false); }
//! GUIA DE COMPRA /// <summary> /// Mantenimiento de guías de compra. /// Inserta, Modifica /// </summary> public void Set_PSCP_SPMT_SCPC_GUIA(BEDocument odoc, List<BEDocumentLines> lines, List<BEDocumentExpenses> expenses) { oda.Set_PSCP_SPMT_SCPC_GUIA(odoc, lines, expenses); Dispose(false); }
private void sbtExpen_Click(object sender, EventArgs e) { var obj = new BEDocument() { COD_DOCU = (string.IsNullOrWhiteSpace(txtCOD_DOCU.Text)) ? (int?)null : Convert.ToInt32(txtCOD_DOCU.Text) }; var obr = new BRPurchase(); var olgn1 = obr.Get_PSCP_SPLS_SCPC_GANA(obj); if (olgn1.Count > 0) olgn = olgn1; var oxf = new xfExpNationalization() { olgn = olgn, SESSION_COMP = SESSION_COMP }; if (oxf.ShowDialog() == System.Windows.Forms.DialogResult.OK) olgn = oxf.olgn; }