public DBDocument() { Cabecera = new Header(); Correos = new Correo(); Detracciones = new Detraccion(); Detalles = new List <Detail>(); DocumentosAfectados = new List <DocumentoAfectado>(); Extras = new List <Extra>(); Referencias = new List <Referencia>(); Anticipos = new List <Anticipo>(); RAC = new RBajasCabecera(); RBC = new RBoletasCabecera(); RAD = new List <RBajasDetalle>(); RBD = new List <RBoletasDetalle>(); }
public List <RBoletasDetalle> ordenaResumen() { List <ResumenB> DBList = new List <ResumenB>(); DBList = DBConnection.SP_ObtieneResumenBoletas(); string sa = "", ta = ""; int na = 0, sl = 0; RBoletasDetalle RBL = null; RBC = new RBoletasCabecera(); RBC.TOT_DOC = DBList.Count; RBD = new List <RBoletasDetalle>(); for (int i = 0; i < DBList.Count; ++i) { RBC.DOC_UPD_LIST.Add($"{MS.RucNumber}-{DBList[i].TPODOC}-{DBList[i].SERIE}-{DBList[i].NUMERO.ToString().PadLeft(8,'0')}"); if (i == 0 || RBL == null) { if (RBL == null) { RBL = new RBoletasDetalle(); } sa = DBList[i].SERIE; na = DBList[i].NUMERO - 1; ta = DBList[i].TPODOC; // NUEVO MÉTODO RBL.TPO_CPE = DBList[i].TPODOC; RBL.NUM_INI = DBList[i].NUMERO; RBL.NUM_FIN = DBList[i].NUMERO; RBC.FEC_INI = DateTime.Parse(MS.SummaryDate); RBC.FEC_FIN = DateTime.Parse(MS.SummaryDate); } if (sa == DBList[i].SERIE && (na + 1) == DBList[i].NUMERO && ta == DBList[i].TPODOC) { /* * NUEVO MÉTODO */ RBL.NRO_LIN = RBD.Count + 1; RBL.TPO_CPE = DBList[i].TPODOC; RBL.DOC_SER = DBList[i].SERIE; RBL.NUM_FIN = DBList[i].NUMERO; // IMPORTES RBL.MTO_GRA = RBL.MTO_GRA + DBList[i].GRAVADO; RBL.MTO_EXO = RBL.MTO_EXO + DBList[i].EXONERADO; RBL.MTO_INA = RBL.MTO_INA + DBList[i].INAFECTO; RBL.MTO_OCA = RBL.MTO_OCA + DBList[i].OCARGOS; // IMPUESTOS RBL.IMP_IGV = RBL.IMP_IGV + DBList[i].IGV; RBL.IMP_ISC = RBL.IMP_ISC + DBList[i].ISC; RBL.IMP_OTH = RBL.IMP_OTH + DBList[i].OTH; // TOTAL RBL.MTO_TOT = RBL.MTO_TOT + DBList[i].TOTAL; RBC.MTO_GRA = RBC.MTO_GRA + DBList[i].GRAVADO; RBC.MTO_EXO = RBC.MTO_EXO + DBList[i].EXONERADO; RBC.MTO_INA = RBC.MTO_INA + DBList[i].INAFECTO; RBC.MTO_OCA = RBC.MTO_OCA + DBList[i].OCARGOS; RBC.IMP_IGV = RBC.IMP_IGV + DBList[i].IGV; RBC.IMP_ISC = RBC.IMP_ISC + DBList[i].ISC; RBC.IMP_OTH = RBC.IMP_OTH + DBList[i].OTH; RBC.MTO_TOT = RBC.MTO_TOT + DBList[i].TOTAL; sl++; na = DBList[i].NUMERO; } else { /* * NUEVO MÉTODO */ RBD.Add(RBL); RBL = null; RBL = new RBoletasDetalle(); RBL.NRO_LIN = RBD.Count + 1; RBL.TPO_CPE = DBList[i].TPODOC; RBL.DOC_SER = DBList[i].SERIE; RBL.NUM_INI = DBList[i].NUMERO; RBL.NUM_FIN = DBList[i].NUMERO; // IMPORTES RBL.MTO_GRA = RBL.MTO_GRA + DBList[i].GRAVADO; RBL.MTO_EXO = RBL.MTO_EXO + DBList[i].EXONERADO; RBL.MTO_INA = RBL.MTO_INA + DBList[i].INAFECTO; RBL.MTO_OCA = RBL.MTO_OCA + DBList[i].OCARGOS; // IMPUESTOS RBL.IMP_IGV = RBL.IMP_IGV + DBList[i].IGV; RBL.IMP_ISC = RBL.IMP_ISC + DBList[i].ISC; RBL.IMP_OTH = RBL.IMP_OTH + DBList[i].OTH; // TOTAL RBL.MTO_TOT = RBL.MTO_TOT + DBList[i].TOTAL; RBC.MTO_GRA = RBC.MTO_GRA + DBList[i].GRAVADO; RBC.MTO_EXO = RBC.MTO_EXO + DBList[i].EXONERADO; RBC.MTO_INA = RBC.MTO_INA + DBList[i].INAFECTO; RBC.MTO_OCA = RBC.MTO_OCA + DBList[i].OCARGOS; RBC.IMP_IGV = RBC.IMP_IGV + DBList[i].IGV; RBC.IMP_ISC = RBC.IMP_ISC + DBList[i].ISC; RBC.IMP_OTH = RBC.IMP_OTH + DBList[i].OTH; RBC.MTO_TOT = RBC.MTO_TOT + DBList[i].TOTAL; sl++; sa = DBList[i].SERIE; na = DBList[i].NUMERO; ta = DBList[i].TPODOC; } if (i + 1 == DBList.Count) { RBD.Add(RBL); RBL = null; } } return(RBD); }
public List <RBoletasDetalle> ordenaResumen(string TypeRC) { List <ResumenB> DBList = new List <ResumenB>(); DBList = DBConnection.SP_ObtieneResumenBoletas_2_1(TypeRC); string sa = "", ta = ""; int na = 0, sl = 0; RBoletasDetalle RBL = null; RBC = new RBoletasCabecera(); RBC.TOT_DOC = DBList.Count; RBD = new List <RBoletasDetalle>(); for (int i = 0; i < DBList.Count; i++) { RBC.DOC_UPD_LIST.Add($"{MS.RucNumber}-{DBList[i].TPODOC}-{DBList[i].SERIE}-{DBList[i].NUMERO.ToString().PadLeft(8, '0')}"); RBL = new RBoletasDetalle(); sa = DBList[i].SERIE; na = DBList[i].NUMERO - 1; ta = DBList[i].TPODOC; RBC.FEC_INI = DateTime.Parse(MS.SummaryDate); RBC.FEC_FIN = DateTime.Parse(MS.SummaryDate); RBL.MONEDA = DBList[i].MONEDA; RBL.TPO_CPE = DBList[i].TPODOC; RBL.FEC_EMIS = DBList[i].DESDE; RBL.LineID = i + 1; RBL.DocumentTypeCode = DBList[i].TPODOC; RBL.ID = DBList[i].SERIE + "-" + DBList[i].NUMERO; RBL.CustomerAssignedAccountID = DBList[i].RE_NUMDOC; RBL.AdditionalAccountID = DBList[i].RE_TPODOC; RBL.ConditionCode = DBList[i].STATUS_RC_DOC; RBL.TPO_DOC_AFEC = DBList[i].TPO_DOC_AFEC; RBL.NRO_DOC_AFEC = DBList[i].NRO_DOC_AFEC; RBL.SYSTEM_STATUS = DBList[i].SYSTEM_STATUS; RBL.NUM_CPE = DBList[i].NUM_CPE; RBL.STATUS_RC_DOC = DBList[i].STATUS_RC_DOC; // IMPORTES RBL.MTO_GRA = DBList[i].GRAVADO; RBL.MTO_EXO = DBList[i].EXONERADO; RBL.MTO_INA = DBList[i].INAFECTO; RBL.MTO_OCA = DBList[i].OCARGOS; RBL.MTO_GRAT = DBList[i].GRATUITO; // IMPUESTOS RBL.IMP_IGV = DBList[i].IGV; RBL.IMP_ISC = DBList[i].ISC; RBL.IMP_OTH = DBList[i].OTH; // TOTAL RBL.MTO_TOT = DBList[i].TOTAL; //SUMMARY RBL.SUMMARY = DBList[i].SUMMARY; RBL.VOIDED = DBList[i].VOIDED; RBC.MTO_GRA = DBList[i].GRAVADO; RBC.MTO_EXO = DBList[i].EXONERADO; RBC.MTO_INA = DBList[i].INAFECTO; RBC.MTO_OCA = DBList[i].OCARGOS; RBC.MTO_GRAT = DBList[i].GRATUITO; RBC.IMP_IGV = DBList[i].IGV; RBC.IMP_ISC = DBList[i].ISC; RBC.IMP_OTH = DBList[i].OTH; sl++; na = DBList[i].NUMERO; RBD.Add(RBL); } return(RBD); }