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