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 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 Get_Load()
{
stcControl.AppearanceReadOnly.BackColor = Color.FromArgb(255, 227, 239, 255);
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
InitializeCopy();
dteFEC_REGI.EditValue = DateTime.Now;
dteFEC_DOCU.EditValue = DateTime.Now;
dteFEC_ENTR.EditValue = DateTime.Now;
var obr = new BRPurchase();
var olcp = obr.Get_PSGN_SPLS_SVMC_COND_PAGO(SESSION_COMP);
var olmo = obr.Get_PSGN_SPLS_SVMC_MONE(SESSION_COMP);
lkeCOD_COND_PAGO.Properties.DataSource = olcp;
lkeCOD_COND_PAGO.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_COND_PAGO", "Condición de Pago", 20);
lkeCOD_COND_PAGO.Properties.Columns.Add(lkci);
lkeCOD_COND_PAGO.Properties.DisplayMember = "ALF_COND_PAGO";
lkeCOD_COND_PAGO.Properties.ValueMember = "COD_COND_PAGO";
lkeCOD_MONE.Properties.DataSource = olmo;
lkeCOD_MONE.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MONE", "Moneda", 20);
lkeCOD_MONE.Properties.Columns.Add(lkci);
lkeCOD_MONE.Properties.DisplayMember = "ALF_MONE";
lkeCOD_MONE.Properties.ValueMember = "COD_MONE";
lkeCOD_MONE.ItemIndex = 0;
var olstt = new List<BEStatus>();
olstt.Add(new BEStatus() { COD_ESTA = "AB", ALF_ESTA = "Abierto" });
olstt.Add(new BEStatus() { COD_ESTA = "CE", ALF_ESTA = "Cerrado" });
olstt.Add(new BEStatus() { COD_ESTA = "AN", ALF_ESTA = "Anulado" });
lkeIND_ESTA.Properties.DataSource = olstt;
lkeIND_ESTA.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_ESTA", "Estado", 20);
lkeIND_ESTA.Properties.Columns.Add(lkci);
lkeIND_ESTA.Properties.DisplayMember = "ALF_ESTA";
lkeIND_ESTA.Properties.ValueMember = "COD_ESTA";
lkeIND_ESTA.ItemIndex = 0;
var obral = new BRWarehouse();
var olsal = obral.Get_PSGN_SPLS_SVMC_ALMA(SESSION_COMP);
lkeCOD_ALMA.Properties.DataSource = olsal;
lkeCOD_ALMA.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_ALMA", "Almacén", 20);
lkeCOD_ALMA.Properties.Columns.Add(lkci);
lkeCOD_ALMA.Properties.DisplayMember = "ALF_ALMA";
lkeCOD_ALMA.Properties.ValueMember = "COD_ALMA";
gdcLines.DataSource = new List<BEDocumentLines>();
SetChangeMaskMoney(0);
StateControls(true);
if (docb != null)
Set_DocumentBase();
}
private void lkeCOD_MONE_EditValueChanged(object sender, EventArgs e)
{
if (lkeCOD_MONE.ItemIndex == 1)
{
txtNUM_TIPO_CAMB.EditValue = null;
txtNUM_TIPO_CAMB.Properties.ReadOnly = true;
}
else
{
var obr = new BRPurchase();
var TIPO_CAMB = obr.Get_PSGN_SPLS_SVMC_TIPO_CAMB(SESSION_COMP, 1);
txtNUM_TIPO_CAMB.EditValue = TIPO_CAMB;
txtNUM_TIPO_CAMB.Properties.ReadOnly = (string.IsNullOrWhiteSpace(txtCOD_DOCU.Text)) ? false : true; ;
txtNUM_TIPO_CAMB.Focus();
txtNUM_TIPO_CAMB.SelectAll();
}
SetChangeMaskMoney(lkeCOD_MONE.ItemIndex);
}
private void Get_DataAdd()
{
var obr = new BRPurchase();
txtALF_DOCU_REFE.Text = obr.Get_PSCP_SPLS_ORCO_NURE(SESSION_COMP);
var obrg = new BRSVMC_COMP();
var objc = new BESVMC_COMP() { COD_COMP = SESSION_COMP, NUM_ACCI = 5 };
var ocmp = obrg.Get_SVPR_COMP_LIST(objc);
mmeALF_DIRE_ENTR.Text = ocmp[0].ALF_DIRE_ENTR;
}
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);
}
}
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 lueCOD_MONE_EditValueChanged(object sender, EventArgs e)
{
if (lueCOD_MONE.EditValue != null)
{
if (!string.IsNullOrEmpty(txtNUM_TOTA.Text))
ALF_TOTA(Convert.ToDecimal(txtNUM_TOTA.Text));
var obr = new BRPurchase();
var TIPO_CAMB = obr.Get_PSGN_SPLS_SVMC_TIPO_CAMB(SESSION_COMP, 1);
if (lueCOD_MONE.EditValue.ToString().Equals("2"))
{
var lines = (List<BESVTD_COTI>)gdvArticles.DataSource;
if (lines == null) return;
lines.ForEach(item =>
{
item.NUM_PREC_UNIT = Math.Round(item.NUM_PREC_UNIT / TIPO_CAMB, 2);
item.NUM_DESC = Math.Round((item.NUM_PREC_UNIT * item.NUM_PORC_DESC) / 100, 2);
item.NUM_IMPO = item.NUM_CANT * (item.NUM_PREC_UNIT - item.NUM_DESC);
});
}
else
{
var lines = (List<BESVTD_COTI>)gdvArticles.DataSource;
if (lines == null) return;
lines.ForEach(item =>
{
item.NUM_PREC_UNIT = Math.Round(item.NUM_PREC_UNIT * TIPO_CAMB, 2);
item.NUM_DESC = Math.Round((item.NUM_PREC_UNIT * item.NUM_PORC_DESC) / 100, 2);
item.NUM_IMPO = item.NUM_CANT * (item.NUM_PREC_UNIT - item.NUM_DESC);
});
}
gdvArticles.RefreshData();
txtNUM_SUBT.Text = (oListArti.Sum(obj => obj.NUM_IMPO) + oListArtiGroup.Sum(obj => obj.NUM_IMPO)).ToString("#,##0.00");
txtNUM_IGVV.Text = (Convert.ToDecimal(txtNUM_SUBT.Text) * (chkIGV.Checked ? SESSION_PORC_IMPU : Convert.ToDecimal("0.00"))).ToString("#,##0.00");
txtNUM_TOTA.Text = (Convert.ToDecimal(txtNUM_SUBT.Text) + Convert.ToDecimal(txtNUM_IGVV.Text)).ToString("#,##0.00");
ALF_TOTA(Convert.ToDecimal(txtNUM_TOTA.Text));
}
}
public void AddArticle()
{
try
{
var obr = new BRPurchase();
var TIPO_CAMB = obr.Get_PSGN_SPLS_SVMC_TIPO_CAMB(SESSION_COMP, 1);
using(var oForm = new xfSearchArticleSales(SESSION_COMP))
{
if (oForm.ShowDialog() == DialogResult.OK)
{
var oBe = new BESVTD_COTI();
oBe.COD_ARTI = oForm.oBe.COD_ARTI;
oBe.ALF_CODI_ARTI = oForm.oBe.ALF_CODI_ARTI;
oBe.ALF_ARTI = oForm.oBe.ALF_ARTI;
if (lueCOD_MONE.EditValue.ToString().Equals("2"))
{
oBe.NUM_PREC_UNIT = oForm.oBe.NUM_PREC;
}
else
{
oBe.NUM_PREC_UNIT = Math.Round(oForm.oBe.NUM_PREC*TIPO_CAMB,2);
}
oBe.NUM_PORC_DESC = Convert.ToDecimal(txtNUM_DESC.Text.Replace("%", ""));
oBe.NUM_DESC = oBe.NUM_PREC_UNIT * decimal.Round((oBe.NUM_PORC_DESC/decimal.Parse("100.00")),2);
oBe.NUM_CANT = 1;
oBe.NUM_IMPO = oBe.NUM_CANT * (oBe.NUM_PREC_UNIT - (oBe.NUM_PREC_UNIT * decimal.Round((oBe.NUM_PORC_DESC / decimal.Parse("100.00")), 2)));
oListArti.Add(oBe);
gdvArticles.RefreshData();
txtNUM_SUBT.Text = (oListArti.Sum(obj => obj.NUM_IMPO) + oListArtiGroup.Sum(obj => obj.NUM_IMPO)).ToString("#,##0.00");
txtNUM_IGVV.Text = (Convert.ToDecimal(txtNUM_SUBT.Text) * (chkIGV.Checked?SESSION_PORC_IMPU:Convert.ToDecimal("0.00"))).ToString("#,##0.00");
txtNUM_TOTA.Text = (Convert.ToDecimal(txtNUM_SUBT.Text) + Convert.ToDecimal(txtNUM_IGVV.Text)).ToString("#,##0.00");
ALF_TOTA(Convert.ToDecimal(txtNUM_TOTA.Text));
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message,"Sistema",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
private void xfExpNationalization_Load(object sender, EventArgs e)
{
var obr = new BRPurchase();
var olst = obr.Get_PSCP_SPLS_SVMC_CNGN(SESSION_COMP);
rilConcept.DataSource = olst;
rilConcept.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_CONC_GANA", "Concepto", 20);
rilConcept.Columns.Add(lkci);
rilConcept.DisplayMember = "ALF_CONC_GANA";
rilConcept.ValueMember = "COD_CONC_GANA";
var olmo = obr.Get_PSGN_SPLS_SVMC_MONE(SESSION_COMP);
rilCOD_MONE.DataSource = olmo;
rilCOD_MONE.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MONE_SIMB", "Moneda", 20);
rilCOD_MONE.Columns.Add(lkci);
rilCOD_MONE.DisplayMember = "ALF_MONE_SIMB";
rilCOD_MONE.ValueMember = "COD_MONE";
if (olgn != null)
gdcExpens.DataSource = olgn;
}
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;
}
