public List<BESVTD_COTI> Get_SVPR_DETA(BESVTD_COTI oBe) { if (HttpContext.Current.Session["COD_COMP"] == null) return new List<BESVTD_COTI>(); var oBr = new BRSVTD_COTI(); oBe.COD_TIPO_DOCU = 1; var oList = oBr.Get_SVPR_COTI_DETA_LIST(oBe); return oList; }
/// <summary> /// OBTENER EL RESULTADO DE CUALQUIER CONSULTA /// </summary> /// <param name="oBe"></param> /// <returns></returns> public List<BESVTD_COTI> Get_SVPR_COTI_GROU_DETA_LIST(BESVTD_COTI oBe) { try { using (IDataReader oDr = oDa.Get_SVPR_COTI_GROU_DETA_LIST(oBe)) { List<BESVTD_COTI> oList = new List<BESVTD_COTI>(); IList iList = oList; ((IList)iList).LoadFromReader<BESVTD_COTI>(oDr); Dispose(false); return (oList); } } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
public IDataReader Get_SVPR_COTI_DETA_LIST(BESVTD_COTI oBe) { var ALF_NOMB_PROC = ""; if (oBe.COD_TIPO_DOCU == 1) ALF_NOMB_PROC = "SVPR_COTI_DETA_LIST"; else if (oBe.COD_TIPO_DOCU == 2) ALF_NOMB_PROC = "SVPR_OVEN_DETA_LIST"; else if (oBe.COD_TIPO_DOCU == 3) ALF_NOMB_PROC = "SVPR_GREM_DETA_LIST"; else if (oBe.COD_TIPO_DOCU == 4) ALF_NOMB_PROC = "SVPR_DVEN_DETA_LIST"; else if (oBe.COD_TIPO_DOCU == 5) ALF_NOMB_PROC = "SVPR_NCRE_DETA_LIST"; try { if (ocn.State == ConnectionState.Closed) ocn.Open(); var ocmd = odb.GetStoredProcCommand(ALF_NOMB_PROC, oBe.COD_COTI, oBe.COD_ARTI, oBe.ALF_ARTI, oBe.NUM_PREC_UNIT, oBe.NUM_PORC_DESC, oBe.NUM_DESC, oBe.NUM_CANT, oBe.NUM_STOC_REAL, oBe.NUM_STOC_VIRT, oBe.NUM_IMPO, 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(); } }
/// <summary> /// INVOCAR EL CUADRO DE BUSQUEDA PARA LA NOTA DE CREDITO /// </summary> public void SearchSalesCreditNote() { ClearControl(); using (var oForm = new xfSearchQuote(5, SESSION_COMP)) { if (oForm.ShowDialog() == DialogResult.OK) { LoadBranch(oForm.oBe.COD_SOCI_NEGO); txtCOD_SOCI_NEGO.Text = oForm.oBe.COD_SOCI_NEGO.ToString(); beALF_NOMB.Text = oForm.oBe.ALF_NOMB; txtALF_DIRE_FISC.Text = oForm.oBe.ALF_DIRE; txtALF_TELE.Text = ""; txtALF_FAXX.Text = ""; txtALF_CONT.Text = oForm.oBe.ALF_CONT; lueCOD_SUCU.EditValue = oForm.oBe.COD_SUCU; txtNUM_DESC.Text = oForm.oBe.NUM_DESC.ToString("#,##0.00"); txtALF_NUME_FACT.Text = oForm.oBe.ALF_NUME_DOCU; beALF_GUIA_REMI_STOR.Text = oForm.oBe.ALF_NUME_DOCU; COD_DVEN = oForm.oBe.COD_DVEN; txtNUM_NCRE.Text = oForm.oBe.COD_NCRE.ToString(); deFEC_REGI.EditValue = oForm.oBe.FEC_REGI; deFEC_DOCU.EditValue = oForm.oBe.FEC_DOCU; deFEC_VENC.EditValue = oForm.oBe.FEC_PAGO; txtALF_ESTA.Text = oForm.oBe.ALF_ESTA; lueCOD_MONE.EditValue = oForm.oBe.COD_MONE; lueALF_SERI.EditValue = oForm.oBe.ALF_SERI; txtNUM_CORR.Text = oForm.oBe.NUM_CORR.ToString("0000000"); lueCOD_ALMA.EditValue = oForm.oBe.COD_ALMA; txtALF_NUME_IDEN.Text = oForm.oBe.ALF_NUME_IDEN; chkIGV.Checked = oForm.oBe.IND_IMPU; chkIND_LIQU.Checked = oForm.oBe.IND_LIQU; meALF_OBSE.Text = oForm.oBe.ALF_OBSE; lblALF_SONN.Text = oForm.oBe.ALF_TOTA; txtNUM_SUBT.Text = oForm.oBe.NUM_SUBT.ToString("#,##0.00"); txtNUM_IGVV.Text = oForm.oBe.NUM_IGVV.ToString("#,##0.00"); txtNUM_TOTA.Text = oForm.oBe.NUM_TOTA.ToString("#,##0.00"); var oBeSu = new BESVMD_SOCI_NEGO_SUCU(); var oBrSu = new BRSVMD_SOCI_NEGO_SUCU(); oBeSu.NUM_ACCI = 5; oBeSu.COD_SOCI_NEGO = oForm.oBe.COD_SOCI_NEGO; var oListTC = oBrSu.Get_SVPR_SOCI_NEGO_SUCU_LIST(oBeSu); lueCOD_SUCU.Properties.DataSource = oListTC; lueCOD_SUCU.Properties.Columns.Clear(); lueCOD_SUCU.Properties.Columns.Add(new LookUpColumnInfo("ALF_SUCU", 100, "Sucursal")); lueCOD_SUCU.Properties.DisplayMember = "ALF_SUCU"; lueCOD_SUCU.Properties.ValueMember = "COD_SOCI_NEGO_SUCU"; lueCOD_SUCU.EditValue = oForm.oBe.COD_SUCU; var oBe = new BESVTD_COTI(); var oBr = new BRSVTD_COTI(); oBe.COD_COTI = oForm.oBe.COD_DVEN; oBe.NUM_ACCI = 5; oBe.COD_TIPO_DOCU = 4; var oList = oBr.Get_SVPR_COTI_DETA_LIST(oBe); oList.ForEach(obj => { oListArti.Add(obj); }); gdvArticles.RefreshData(); var oBeG = new BESVTD_COTI_GROU(); var oBrG = new BRSVTD_COTI_GROU(); oBeG.COD_COTI = oForm.oBe.COD_DVEN; oBeG.NUM_ACCI = 5; oBeG.COD_TIPO_DOCU = 4; var oListG = oBrG.Get_SVPR_COTI_GROU_LIST(oBeG); oListG.ForEach(obj => { oListGroup.Add(obj); }); gdvGroups.RefreshData(); var oBeDG = new BESVTD_COTI(); var oBrDG = new BRSVTD_COTI_GROU_DETA(); oBeDG.COD_COTI = oForm.oBe.COD_DVEN; oBeDG.NUM_ACCI = 5; oBeDG.COD_TIPO_DOCU = 4; var oListDG = oBrDG.Get_SVPR_COTI_GROU_DETA_LIST(oBeDG); oListDG.ForEach(obj => { oListArtiGroup.Add(obj); }); ListArticleCompletedUpdate(); gdvArticlesCompleted.RefreshData(); gdvArticlesGroup.RefreshData(); } } }
/// <summary> /// PRESENTAR LA ORDEN DE VENTA CON LA INFORMACION PROVENIENTE DE LA COTIZACION /// </summary> /// <param name="COD_COTI"></param> public void SearchInvoice(int COD_DVENp) { ClearControl(); StateControl(false); beALF_NOMB.Enabled = false; lueCOD_SUCU.Properties.ReadOnly = true; lueCOD_MONE.Properties.ReadOnly = true; lueCOD_ALMA.Properties.ReadOnly = true; txtNUM_DESC.Properties.ReadOnly = true; gcaNUM_CANT.OptionsColumn.AllowEdit = false; gcaNUM_CANT.OptionsColumn.AllowFocus = false; gcaNUM_CANT.OptionsColumn.ReadOnly = true; var oBe = new BESVTC_COTI(); var oBr = new BRSVTC_COTI(); oBe.ALF_NUME_IDEN = COD_DVENp.ToString(); oBe.COD_TIPO_DOCU = 4; oBe.COD_COMP = SESSION_COMP; oBe.NUM_ACCI = 9; var oListDV = oBr.Get_SVPR_COTI_BUSC(oBe); LoadBranch(oListDV[0].COD_SOCI_NEGO); txtCOD_SOCI_NEGO.Text = oListDV[0].COD_SOCI_NEGO.ToString(); beALF_NOMB.Text = oListDV[0].ALF_NOMB; txtALF_DIRE_FISC.Text = oListDV[0].ALF_DIRE; txtALF_TELE.Text = ""; txtALF_FAXX.Text = ""; txtALF_CONT.Text = oListDV[0].ALF_CONT; lueCOD_SUCU.EditValue = oListDV[0].COD_SUCU; txtNUM_DESC.Text = oListDV[0].NUM_DESC.ToString("#,##0.00"); txtALF_NUME_FACT.Text = oListDV[0].ALF_NUME_SUNA; beALF_GUIA_REMI_STOR.Text = oListDV[0].ALF_NUME_DOCU; COD_DVEN = oListDV[0].COD_DVEN; txtNUM_NCRE.Text = string.Empty; deFEC_REGI.EditValue = DateTime.Today; deFEC_DOCU.EditValue = DateTime.Today; deFEC_VENC.EditValue = DateTime.Today; txtALF_ESTA.Text = oListDV[0].ALF_ESTA; lueCOD_MONE.EditValue = oListDV[0].COD_MONE; lueCOD_ALMA.EditValue = oListDV[0].COD_ALMA; txtALF_NUME_IDEN.Text = oListDV[0].ALF_NUME_IDEN; chkIGV.Checked = oListDV[0].IND_IMPU; chkIND_LIQU.Checked = oListDV[0].IND_LIQU; meALF_OBSE.Text = oListDV[0].ALF_OBSE; lblALF_SONN.Text = oListDV[0].ALF_TOTA; txtNUM_SUBT.Text = oListDV[0].NUM_SUBT.ToString("#,##0.00"); txtNUM_IGVV.Text = oListDV[0].NUM_IGVV.ToString("#,##0.00"); txtNUM_TOTA.Text = oListDV[0].NUM_TOTA.ToString("#,##0.00"); var oBeSu = new BESVMD_SOCI_NEGO_SUCU(); var oBrSu = new BRSVMD_SOCI_NEGO_SUCU(); oBeSu.NUM_ACCI = 5; oBeSu.COD_SOCI_NEGO = oListDV[0].COD_SOCI_NEGO; var oListTC = oBrSu.Get_SVPR_SOCI_NEGO_SUCU_LIST(oBeSu); lueCOD_SUCU.Properties.DataSource = oListTC; lueCOD_SUCU.Properties.Columns.Clear(); lueCOD_SUCU.Properties.Columns.Add(new LookUpColumnInfo("ALF_SUCU", 100, "Sucursal")); lueCOD_SUCU.Properties.DisplayMember = "ALF_SUCU"; lueCOD_SUCU.Properties.ValueMember = "COD_SOCI_NEGO_SUCU"; lueCOD_SUCU.EditValue = oListDV[0].COD_SUCU; var oBeD = new BESVTD_COTI(); var oBrD = new BRSVTD_COTI(); oBeD.COD_COTI = oListDV[0].COD_DVEN; oBeD.NUM_ACCI = 5; oBeD.COD_TIPO_DOCU = 4; var oList = oBrD.Get_SVPR_COTI_DETA_LIST(oBeD); oList.ForEach(obj => { oListArti.Add(obj); }); gdvArticles.RefreshData(); var oBeG = new BESVTD_COTI_GROU(); var oBrG = new BRSVTD_COTI_GROU(); oBeG.COD_COTI = oListDV[0].COD_DVEN; oBeG.NUM_ACCI = 5; oBeG.COD_TIPO_DOCU = 4; var oListG = oBrG.Get_SVPR_COTI_GROU_LIST(oBeG); oListG.ForEach(obj => { oListGroup.Add(obj); }); gdvGroups.RefreshData(); var oBeDG = new BESVTD_COTI(); var oBrDG = new BRSVTD_COTI_GROU_DETA(); oBeDG.COD_COTI = oListDV[0].COD_DVEN; oBeDG.NUM_ACCI = 5; oBeDG.COD_TIPO_DOCU = 4; var oListDG = oBrDG.Get_SVPR_COTI_GROU_DETA_LIST(oBeDG); oListDG.ForEach(obj => { oListArtiGroup.Add(obj); }); ListArticleCompletedUpdate(); gdvArticlesCompleted.RefreshData(); gdvArticlesGroup.RefreshData(); }
public void SearchDetailReferralGuide(int COD_GREM) { var oBeC = new BESVTD_COTI(); var oBrC = new BRSVTD_COTI(); oBeC.COD_COTI = COD_GREM; oBeC.NUM_ACCI = 5; oBeC.COD_TIPO_DOCU = 3; var oListC = oBrC.Get_SVPR_COTI_DETA_LIST(oBeC); oListC.ForEach(obj => { //if (oListArti.Count(objA => objA.COD_ARTI == obj.COD_ARTI) > 0) //{ // var NUM_CANT = oListArti.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_CANT; // var NUM_IMPO = oListArti.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_IMPO; // oListArti.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_CANT = NUM_CANT + obj.NUM_CANT; // oListArti.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_IMPO = NUM_IMPO + obj.NUM_IMPO; //} //else //{ oListArti.Add(obj); //} }); gdvArticles.RefreshData(); ListArticleCompletedUpdate(); gdvArticlesCompleted.RefreshData(); txtNUM_SUBT.Text = (oListArtiCompleted.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)); }
/// <summary> /// AL REALIZAR CLIC AL BOTON DE QUITAR ARTICULO AL DETALLE DEL GRUPO /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void sbREMOVE_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtNUM_CANT_REMO.Text)) throw new ArgumentException("Ingrese correctamente la cantidad que desea quitar"); if (Convert.ToInt32(txtNUM_CANT_REMO.Text) <= 0) throw new ArgumentException("Ingrese correctamente la cantidad que desea quitar"); if (gdvArticlesGroup.RowCount > 0) { if (gdvArticlesGroup.FocusedRowHandle >= 0) { var oBeA = new BESVTD_COTI(); var oBe = (BESVTD_COTI)gdvArticlesGroup.GetRow(gdvArticlesGroup.FocusedRowHandle); oBeA.COD_ARTI = oBe.COD_ARTI; oBeA.ALF_CODI_ARTI = oBe.ALF_CODI_ARTI; oBeA.ALF_ARTI = oBe.ALF_ARTI; oBeA.NUM_PREC_UNIT = oBe.NUM_PREC_UNIT; oBeA.NUM_PORC_DESC = oBe.NUM_PORC_DESC; oBeA.NUM_DESC = oBe.NUM_DESC; oBeA.NUM_CANT = oBe.NUM_CANT; oBeA.NUM_CANT_DESP = oBe.NUM_CANT_DESP; oBeA.NUM_STOC_REAL = oBe.NUM_STOC_REAL; oBeA.NUM_STOC_VIRT = oBe.NUM_STOC_VIRT; oBeA.NUM_CANT_REAL_DISP = oBe.NUM_CANT_REAL_DISP; oBeA.NUM_CANT_REAL_COMP_PEDI = oBe.NUM_CANT_REAL_COMP_PEDI; oBeA.NUM_STOC_COMP = oBe.NUM_STOC_COMP; oBeA.NUM_STOC_VIRT_COMP = oBe.NUM_STOC_VIRT_COMP; oBeA.NUM_CANT_VIRT_DISP = oBe.NUM_CANT_VIRT_DISP; oBeA.NUM_CANT_VIRT_COMP_PEDI = oBe.NUM_CANT_VIRT_COMP_PEDI; if (oBeA.NUM_CANT < Convert.ToInt32(txtNUM_CANT_REMO.Text)) throw new ArgumentException("No existe la cantidad suficiente"); oBeA.COD_COTI_GROU = ((BESVTD_COTI_GROU)gdvGroups.GetRow(gdvGroups.FocusedRowHandle)).COD_COTI_GROU; ((BESVTD_COTI)gdvArticlesGroup.GetRow(gdvArticlesGroup.FocusedRowHandle)).NUM_CANT = oBeA.NUM_CANT - Convert.ToInt32(txtNUM_CANT_REMO.Text); if (((BESVTD_COTI)gdvArticlesGroup.GetRow(gdvArticlesGroup.FocusedRowHandle)).NUM_CANT == 0) { oListArtiGroup.Remove(oBe); } oBeA.NUM_CANT = Convert.ToInt32(txtNUM_CANT_REMO.Text); oBeA.NUM_IMPO = oBeA.NUM_CANT * (oBeA.NUM_PREC_UNIT - oBeA.NUM_DESC); oBe.NUM_IMPO = oBe.NUM_CANT * (oBe.NUM_PREC_UNIT - oBe.NUM_DESC); txtNUM_CANT_ADDD.Text = oBe.NUM_CANT.ToString(); //if (oListArti.Count(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU) > 0) //{ // oListArti.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_CANT = oListArti.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_CANT + oBeA.NUM_CANT; // oListArti.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_IMPO = oListArti.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_IMPO + oBeA.NUM_IMPO; //} //else //{ oListArti.Add(oBeA); //} ListArticleCompletedUpdate(); gdvArticlesCompleted.RefreshData(); gdvArticlesGroup.RefreshData(); gdvArticles.RefreshData(); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// AGREGAR ARTICULO /// </summary> public void AddArticle() { try { using (var oForm = new xfSearchArticleSales(SESSION_COMP)) { if (oForm.ShowDialog() == DialogResult.OK) { //if (oForm.oBe.ALF_CODI_ARTI.ToUpper().Equals("SERVICIO")) // throw new ArgumentException("Solo se puede agregar servicio"); 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; oBe.NUM_PREC_UNIT = oForm.oBe.NUM_PREC; oBe.NUM_PORC_DESC = oForm.oBe.NUM_DESC; oBe.NUM_DESC = oBe.NUM_PREC_UNIT * oForm.oBe.NUM_DESC; oBe.NUM_CANT = 1; oBe.NUM_IMPO = oBe.NUM_CANT * (oBe.NUM_PREC_UNIT - (oBe.NUM_PREC_UNIT * oForm.oBe.NUM_DESC)); oListArti.Add(oBe); ListArticleCompletedUpdate(); gdvArticlesCompleted.RefreshData(); 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); } }
/// <summary> /// ACTUALIZAR LA LISTA DE ARTICULOS COMPLETA /// </summary> private void ListArticleCompletedUpdate() { var oListTemporal = new List<BESVTD_COTI>(); oListArti.ForEach(obj => { var oBeAdd = new BESVTD_COTI(); oBeAdd.COD_ARTI = obj.COD_ARTI; oBeAdd.ALF_ARTI = obj.ALF_ARTI; oBeAdd.ALF_CODI_ARTI = obj.ALF_CODI_ARTI; oBeAdd.NUM_PREC_UNIT = obj.NUM_PREC_UNIT; oBeAdd.NUM_PORC_DESC = obj.NUM_PORC_DESC; oBeAdd.NUM_DESC = obj.NUM_DESC; oBeAdd.NUM_CANT = obj.NUM_CANT; oBeAdd.NUM_IMPO = obj.NUM_IMPO; oBeAdd.NUM_CANT_DESP = obj.NUM_CANT_DESP; oBeAdd.NUM_STOC_REAL = obj.NUM_STOC_REAL; oBeAdd.NUM_STOC_VIRT = obj.NUM_STOC_VIRT; oBeAdd.NUM_CANT_REAL_DISP = obj.NUM_CANT_REAL_DISP; oBeAdd.NUM_CANT_REAL_COMP_PEDI = obj.NUM_CANT_REAL_COMP_PEDI; oBeAdd.NUM_STOC_COMP = obj.NUM_STOC_COMP; oBeAdd.NUM_STOC_VIRT_COMP = obj.NUM_STOC_VIRT_COMP; oBeAdd.NUM_CANT_VIRT_DISP = obj.NUM_CANT_VIRT_DISP; oBeAdd.NUM_CANT_VIRT_COMP_PEDI = obj.NUM_CANT_VIRT_COMP_PEDI; oListTemporal.Add(oBeAdd); }); oListArtiGroup.ForEach(obj => { var oBeAdd = new BESVTD_COTI(); oBeAdd.COD_ARTI = obj.COD_ARTI; oBeAdd.ALF_ARTI = obj.ALF_ARTI; oBeAdd.ALF_CODI_ARTI = obj.ALF_CODI_ARTI; oBeAdd.NUM_PREC_UNIT = obj.NUM_PREC_UNIT; oBeAdd.NUM_PORC_DESC = obj.NUM_PORC_DESC; oBeAdd.NUM_DESC = obj.NUM_DESC; oBeAdd.NUM_CANT = obj.NUM_CANT; oBeAdd.NUM_IMPO = obj.NUM_IMPO; oBeAdd.NUM_CANT_DESP = obj.NUM_CANT_DESP; oBeAdd.NUM_STOC_REAL = obj.NUM_STOC_REAL; oBeAdd.NUM_STOC_VIRT = obj.NUM_STOC_VIRT; oBeAdd.NUM_CANT_REAL_DISP = obj.NUM_CANT_REAL_DISP; oBeAdd.NUM_CANT_REAL_COMP_PEDI = obj.NUM_CANT_REAL_COMP_PEDI; oBeAdd.NUM_STOC_COMP = obj.NUM_STOC_COMP; oBeAdd.NUM_STOC_VIRT_COMP = obj.NUM_STOC_VIRT_COMP; oBeAdd.NUM_CANT_VIRT_DISP = obj.NUM_CANT_VIRT_DISP; oBeAdd.NUM_CANT_VIRT_COMP_PEDI = obj.NUM_CANT_VIRT_COMP_PEDI; oListTemporal.Add(oBeAdd); }); oListArtiCompleted.Clear(); oListTemporal.ForEach(obj => { //if (oListArtiCompleted.Count(objI => objI.COD_ARTI == obj.COD_ARTI) > 0) //{ // var NUM_CANT = oListArtiCompleted.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_CANT; // var NUM_IMPO = oListArtiCompleted.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_IMPO; // oListArtiCompleted.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_CANT = NUM_CANT + obj.NUM_CANT; // oListArtiCompleted.Find(objIi => objIi.COD_ARTI == obj.COD_ARTI).NUM_IMPO = NUM_IMPO + obj.NUM_IMPO; //} //else //{ oListArtiCompleted.Add(obj); //} }); }
private void sbADD_Click(object sender, EventArgs e) { try { if (gdvGroups.RowCount == 0) throw new ArgumentException("No existen kit definidos"); if (gdvArticles.RowCount > 0) { if (gdvArticles.FocusedRowHandle >= 0) { var oBeA = new BESVTD_COTI(); var oBe = (BESVTD_COTI)gdvArticles.GetRow(gdvArticles.FocusedRowHandle); oBeA.COD_ARTI = oBe.COD_ARTI; oBeA.ALF_CODI_ARTI = oBe.ALF_CODI_ARTI; oBeA.ALF_ARTI = oBe.ALF_ARTI; oBeA.NUM_PREC_UNIT = oBe.NUM_PREC_UNIT; oBeA.NUM_PORC_DESC = oBe.NUM_PORC_DESC; oBeA.NUM_DESC = oBe.NUM_DESC; oBeA.NUM_CANT = oBe.NUM_CANT; if (oBeA.NUM_CANT < Convert.ToInt32(txtNUM_CANT_ADDD.Text)) throw new ArgumentException("No existe la cantidad suficiente"); oBeA.COD_COTI_GROU = ((BESVTD_COTI_GROU)gdvGroups.GetRow(gdvGroups.FocusedRowHandle)).COD_COTI_GROU; ((BESVTD_COTI)gdvArticles.GetRow(gdvArticles.FocusedRowHandle)).NUM_CANT = oBeA.NUM_CANT - Convert.ToInt32(txtNUM_CANT_ADDD.Text); if (((BESVTD_COTI)gdvArticles.GetRow(gdvArticles.FocusedRowHandle)).NUM_CANT == 0) { oListArti.Remove(oBe); } oBeA.NUM_CANT = Convert.ToInt32(txtNUM_CANT_ADDD.Text); oBeA.NUM_IMPO = oBeA.NUM_CANT * (oBeA.NUM_PREC_UNIT - oBeA.NUM_DESC); oBe.NUM_IMPO = oBe.NUM_CANT * (oBe.NUM_PREC_UNIT - oBe.NUM_DESC); txtNUM_CANT_ADDD.Text = oBe.NUM_CANT.ToString(); //if (oListArtiGroup.Count(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU) > 0) //{ // oListArtiGroup.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_CANT = oListArtiGroup.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_CANT + oBeA.NUM_CANT; // oListArtiGroup.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_IMPO = oListArtiGroup.Find(obj => obj.COD_ARTI == oBeA.COD_ARTI && obj.COD_COTI_GROU == oBeA.COD_COTI_GROU).NUM_IMPO + oBeA.NUM_IMPO; //} //else //{ oListArtiGroup.Add(oBeA); //} gdvArticlesGroup.RefreshData(); gdvArticles.RefreshData(); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void SearchQuote() { ClearControl(); using (var oForm = new xfSearchQuote(1,SESSION_COMP)) { if (oForm.ShowDialog() == DialogResult.OK) { LoadBranch(oForm.oBe.COD_SOCI_NEGO); txtCOD_SOCI_NEGO.Text = oForm.oBe.COD_SOCI_NEGO.ToString(); beALF_NOMB.Text = oForm.oBe.ALF_NOMB; txtALF_DIRE_FISC.Text = oForm.oBe.ALF_DIRE; txtALF_TELE.Text = ""; txtALF_FAXX.Text = ""; txtALF_CONT.Text = oForm.oBe.ALF_CONT; lueCOD_SUCU.EditValue = oForm.oBe.COD_SUCU; txtNUM_DESC.Text = oForm.oBe.NUM_DESC.ToString("#,##0.00"); txtNUM_COTI.Text = oForm.oBe.COD_COTI.ToString(); deFEC_REGI.EditValue = oForm.oBe.FEC_REGI; deFEC_DOCU.EditValue = oForm.oBe.FEC_DOCU; deFEC_VENC.EditValue = oForm.oBe.FEC_VENC; txtALF_ESTA.Text = oForm.oBe.ALF_ESTA; lueCOD_MONE.EditValue = oForm.oBe.COD_MONE; lueCOD_PROY.EditValue = oForm.oBe.COD_PROY; ALF_EJEC_COME = oForm.oBe.ALF_EJEC_COME; txtALF_ATEN.Text = oForm.oBe.ALF_ATEN; lkeCOD_MOTI.EditValue = oForm.oBe.COD_MOTI; mmoALF_COND_COME.Text = oForm.oBe.ALF_COND_COME; lueCOD_EJEC_COME.EditValue = oForm.oBe.COD_EJEC_COME; chkIGV.Checked = oForm.oBe.IND_IMPU; meALF_OBSE.Text = oForm.oBe.ALF_OBSE; lblALF_SONN.Text = oForm.oBe.ALF_TOTA; txtNUM_SUBT.Text = oForm.oBe.NUM_SUBT.ToString("#,##0.00"); txtNUM_IGVV.Text = oForm.oBe.NUM_IGVV.ToString("#,##0.00"); txtNUM_TOTA.Text = oForm.oBe.NUM_TOTA.ToString("#,##0.00"); var oBe = new BESVTD_COTI(); var oBr = new BRSVTD_COTI(); oBe.COD_COTI = oForm.oBe.COD_COTI; oBe.NUM_ACCI = 5; oBe.COD_TIPO_DOCU = 1; var oList = oBr.Get_SVPR_COTI_DETA_LIST(oBe); oList.ForEach(obj => { oListArti.Add(obj); }); gdvArticles.RefreshData(); var oBeG = new BESVTD_COTI_GROU(); var oBrG = new BRSVTD_COTI_GROU(); oBeG.COD_COTI = oForm.oBe.COD_COTI; oBeG.NUM_ACCI = 5; oBeG.COD_TIPO_DOCU = 1; var oListG = oBrG.Get_SVPR_COTI_GROU_LIST(oBeG); oListG.ForEach(obj => { oListGroup.Add(obj); }); gdvGroups.RefreshData(); var oBeDG = new BESVTD_COTI(); var oBrDG = new BRSVTD_COTI_GROU_DETA(); oBeDG.COD_COTI = oForm.oBe.COD_COTI; oBeDG.NUM_ACCI = 5; oBeDG.COD_TIPO_DOCU = 1; var oListDG = oBrDG.Get_SVPR_COTI_GROU_DETA_LIST(oBeDG); oListDG.ForEach(obj => { oListArtiGroup.Add(obj); }); gdvArticlesGroup.RefreshData(); var oBeTC = new BESVMD_SOCI_NEGO_SUCU(); var oBrTC = new BRSVMD_SOCI_NEGO_SUCU(); oBeTC.NUM_ACCI = 5; oBeTC.COD_SOCI_NEGO = oForm.oBe.COD_SOCI_NEGO; var oListTC = oBrTC.Get_SVPR_SOCI_NEGO_SUCU_LIST(oBeTC); lueCOD_SUCU.Properties.DataSource = oListTC; lueCOD_SUCU.Properties.Columns.Clear(); lueCOD_SUCU.Properties.Columns.Add(new LookUpColumnInfo("ALF_SUCU", 100, "Sucursal")); lueCOD_SUCU.Properties.DisplayMember = "ALF_SUCU"; lueCOD_SUCU.Properties.ValueMember = "COD_SOCI_NEGO_SUCU"; lueCOD_SUCU.EditValue = oForm.oBe.COD_SUCU; } } }
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); } }
/// <summary> /// PRESENTAR LA ORDEN DE VENTA CON LA INFORMACION PROVENIENTE DE LA COTIZACION /// </summary> /// <param name="COD_COTI"></param> public void SearchSalesOrder(int COD_COTI) { ClearControl(); StateControl(false); var oBe = new BESVTC_COTI(); var oBr = new BRSVTC_COTI(); oBe.ALF_NUME_IDEN = COD_COTI.ToString(); oBe.COD_COMP = SESSION_COMP; oBe.COD_TIPO_DOCU = 1; oBe.NUM_ACCI = 6; var oList = oBr.Get_SVPR_COTI_BUSC(oBe); LoadBranch(oList[0].COD_SOCI_NEGO); txtCOD_SOCI_NEGO.Text = oList[0].COD_SOCI_NEGO.ToString(); beALF_NOMB.Text = oList[0].ALF_NOMB; txtALF_DIRE_FISC.Text = oList[0].ALF_DIRE; txtALF_TELE.Text = ""; txtALF_FAXX.Text = ""; txtALF_CONT.Text = oList[0].ALF_CONT; lueCOD_SUCU.EditValue = oList[0].COD_SUCU; txtNUM_DESC.Text = oList[0].NUM_DESC.ToString("#,##0.00"); txtCOD_COTI.Text = oList[0].COD_COTI.ToString(); deFEC_REGI.EditValue = DateTime.Today; deFEC_DOCU.EditValue = DateTime.Today; deFEC_VENC.EditValue = DateTime.Today.AddDays(oList[0].NUM_DIAS); lueCOD_MONE.EditValue = oList[0].COD_MONE; lkeCOD_MOTI.EditValue = oList[0].COD_MOTI; chkIGV.Checked = oList[0].IND_IMPU; meALF_OBSE.Text = oList[0].ALF_OBSE; lblALF_SONN.Text = oList[0].ALF_TOTA; txtNUM_SUBT.Text = oList[0].NUM_SUBT.ToString("#,##0.00"); txtNUM_IGVV.Text = oList[0].NUM_IGVV.ToString("#,##0.00"); txtNUM_TOTA.Text = oList[0].NUM_TOTA.ToString("#,##0.00"); var oBeSu = new BESVMD_SOCI_NEGO_SUCU(); var oBrSu = new BRSVMD_SOCI_NEGO_SUCU(); oBeSu.NUM_ACCI = 5; oBeSu.COD_SOCI_NEGO = oList[0].COD_SOCI_NEGO; var oListSu = oBrSu.Get_SVPR_SOCI_NEGO_SUCU_LIST(oBeSu); lueCOD_SUCU.Properties.DataSource = oListSu; lueCOD_SUCU.Properties.Columns.Clear(); lueCOD_SUCU.Properties.Columns.Add(new LookUpColumnInfo("ALF_SUCU", 100, "Sucursal")); lueCOD_SUCU.Properties.DisplayMember = "ALF_SUCU"; lueCOD_SUCU.Properties.ValueMember = "COD_SOCI_NEGO_SUCU"; lueCOD_SUCU.EditValue = oList[0].COD_SUCU; var oBeC = new BESVTD_COTI(); var oBrC = new BRSVTD_COTI(); oBeC.COD_COTI = oList[0].COD_COTI; oBeC.NUM_ACCI = 5; oBeC.COD_TIPO_DOCU = 1; var oListC = oBrC.Get_SVPR_COTI_DETA_LIST(oBeC); oListC.ForEach(obj => { oListArti.Add(obj); }); gdvArticles.RefreshData(); var oBeG = new BESVTD_COTI_GROU(); var oBrG = new BRSVTD_COTI_GROU(); oBeG.COD_COTI = oList[0].COD_COTI; oBeG.NUM_ACCI = 5; oBeG.COD_TIPO_DOCU = 1; var oListG = oBrG.Get_SVPR_COTI_GROU_LIST(oBeG); oListG.ForEach(obj => { oListGroup.Add(obj); }); gdvGroups.RefreshData(); var oBeDG = new BESVTD_COTI(); var oBrDG = new BRSVTD_COTI_GROU_DETA(); oBeDG.COD_COTI = oList[0].COD_COTI; oBeDG.NUM_ACCI = 5; oBeDG.COD_TIPO_DOCU = 1; var oListDG = oBrDG.Get_SVPR_COTI_GROU_DETA_LIST(oBeDG); oListDG.ForEach(obj => { oListArtiGroup.Add(obj); }); ListArticleCompletedUpdate(); gdvArticlesCompleted.RefreshData(); gdvArticlesGroup.RefreshData(); }
/// <summary> /// GUARDAR /// </summary> public void Save() { if (lueCOD_ALMA.Properties.ReadOnly) return; try { gdvArticles.CloseEditor(); gdvArticles.RefreshData(); gdvGroups.CloseEditor(); gdvGroups.RefreshData(); gdvArticlesCompleted.CloseEditor(); gdvArticlesCompleted.RefreshData(); if (string.IsNullOrEmpty(txtCOD_SOCI_NEGO.Text)) throw new ArgumentException("Seleccione un cliente"); if (lueCOD_SUCU.EditValue==null) throw new ArgumentException("Seleccione la sucursal"); if (oListArti.Count == 0 && oListArtiGroup.Count==0) throw new ArgumentException("Agregar articulos a la lista"); if (lueCOD_MONE.EditValue == null) throw new ArgumentException("Seleccione la moneda"); if (lueCOD_ALMA.EditValue == null) throw new ArgumentException("Seleccione almacén"); var oBe = new BESVTC_COTI(); var oBr = new BRSVTC_COTI(); if (string.IsNullOrEmpty(txtNUM_OVEN.Text)) { oBe.NUM_ACCI = 1; } else { oBe.NUM_ACCI = 2; oBe.COD_OVEN=Convert.ToInt32(txtNUM_OVEN.Text); oBe.COD_DOCU_SECU = oBe.COD_OVEN; } oBe.COD_SOCI_NEGO = Convert.ToInt32(txtCOD_SOCI_NEGO.Text); oBe.ALF_NOMB = beALF_NOMB.Text; oBe.ALF_DIRE = txtALF_DIRE_FISC.Text; oBe.ALF_CONT = txtALF_CONT.Text; oBe.COD_SUCU=Convert.ToInt32(lueCOD_SUCU.EditValue); oBe.COD_MONE = Convert.ToInt32(lueCOD_MONE.EditValue); oBe.COD_ALMA = Convert.ToInt32(lueCOD_ALMA.EditValue); oBe.NUM_DESC = Convert.ToDecimal(txtNUM_DESC.Text.Replace("%","")); oBe.FEC_DOCU = deFEC_DOCU.DateTime; oBe.FEC_VENC = deFEC_VENC.DateTime; oBe.FEC_ENTR = deFEC_ENTR.DateTime; oBe.LST_COTI = oListArti; oBe.LST_COTI_DETA = oListArtiCompleted; oBe.LST_COTI_GROU = oListGroup; oBe.LST_COTI_ARTI_GROU = oListArtiGroup; oBe.NUM_SUBT = decimal.Parse(txtNUM_SUBT.Text); oBe.NUM_IGVV = decimal.Parse(txtNUM_IGVV.Text); oBe.NUM_TOTA = decimal.Parse(txtNUM_TOTA.Text); oBe.ALF_OBSE = meALF_OBSE.Text; oBe.ALF_TOTA = lblALF_SONN.Text; oBe.COD_TIPO_DOCU = 2; oBe.COD_DOCU_INIC=Convert.ToInt32(txtCOD_COTI.Text); oBe.COD_MOTI = Convert.ToInt32(lkeCOD_MOTI.EditValue); oBe.IND_IMPU = chkIGV.Checked; oBe.COD_USUA_CREA = SESSION_USER; oBe.COD_USUA_MODI = SESSION_USER; oBe.COD_COMP = SESSION_COMP; oBe.IND_FACT = chkIND_FACT.Checked; oBr.Set_SVPR_COTI(oBe); txtNUM_OVEN.Text = oBe.COD_DOCU_SECU.ToString(); XtraMessageBox.Show("Operación realizada con exito!!!!", "Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information); StateControl(true); var oBe_ = new BESVTD_COTI(); var oBr_ = new BRSVTD_COTI(); oBe_.COD_COTI = Convert.ToInt32(txtNUM_OVEN.Text); oBe_.NUM_ACCI = 9; oBe_.COD_TIPO_DOCU = 2; var oList = oBr_.Get_SVPR_COTI_DETA_LIST(oBe_); oListArtiCompleted.Clear(); oList.ForEach(obj => { oListArtiCompleted.Add(obj); }); gdvArticlesCompleted.RefreshData(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message,"Sistema",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
/// <summary> /// INVOCAR EL CUADRO DE BUSQUEDA PARA LA NOTA DE CREDITO /// </summary> public void SearchSalesCreditNote() { ClearControl(); using (var oForm = new xfSearchQuote(6, SESSION_COMP)) { if (oForm.ShowDialog() == DialogResult.OK) { txtCOD_SOCI_NEGO.Text = oForm.oBe.COD_SOCI_NEGO.ToString(); beALF_NOMB.Text = oForm.oBe.ALF_NOMB; txtALF_DIRE_FISC.Text = oForm.oBe.ALF_DIRE; txtALF_TELE.Text = ""; txtALF_FAXX.Text = ""; txtALF_CONT.Text = oForm.oBe.ALF_CONT; txtNUM_DESC.Text = oForm.oBe.NUM_DESC.ToString("#,##0.00"); COD_DVEN = oForm.oBe.COD_DVEN; txtNUM_NCRE.Text = oForm.oBe.COD_NCRE.ToString(); deFEC_REGI.EditValue = oForm.oBe.FEC_REGI; deFEC_DOCU.EditValue = oForm.oBe.FEC_DOCU; deFEC_VENC.EditValue = oForm.oBe.FEC_PAGO; txtALF_ESTA.Text = oForm.oBe.ALF_ESTA; lueCOD_MONE.EditValue = oForm.oBe.COD_MONE; lueALF_SERI.EditValue = oForm.oBe.ALF_SERI; txtNUM_CORR.Text = oForm.oBe.NUM_CORR.ToString("0000000"); txtALF_NUME_IDEN.Text = oForm.oBe.ALF_NUME_IDEN; chkIGV.Checked = oForm.oBe.IND_IMPU; meALF_OBSE.Text = oForm.oBe.ALF_OBSE; lblALF_SONN.Text = oForm.oBe.ALF_TOTA; txtNUM_SUBT.Text = oForm.oBe.NUM_SUBT.ToString("#,##0.00"); txtNUM_IGVV.Text = oForm.oBe.NUM_IGVV.ToString("#,##0.00"); txtNUM_TOTA.Text = oForm.oBe.NUM_TOTA.ToString("#,##0.00"); var oBe = new BESVTD_COTI(); var oBr = new BRSVTD_COTI(); oBe.COD_COTI = oForm.oBe.COD_DVEN; oBe.NUM_ACCI = 5; oBe.COD_TIPO_DOCU = 4; var oList = oBr.Get_SVPR_COTI_DETA_LIST(oBe); } } }