public List <Balanza> convertirTabBalanza(Int64 idEmpresa)
{
List <Balanza> lstBalanza = new List <Balanza>();
List <ScSaldoConCc> lstSaldoCC = new List <ScSaldoConCc>();
lstSaldoCC = obtenerSalContCC(idEmpresa);
foreach (ScSaldoConCc saldoCC in lstSaldoCC)
{
Balanza balanza = new Balanza();
balanza.year = saldoCC.year;
balanza.cta = saldoCC.cta.ToString();
balanza.scta = saldoCC.scta.ToString();
balanza.sscta = saldoCC.sscta.ToString();
balanza.salini = saldoCC.salini;
balanza.enecargos = saldoCC.enecargos;
balanza.eneabonos = saldoCC.eneabonos;
balanza.febabonos = saldoCC.febabonos;
balanza.febcargos = saldoCC.febcargos;
balanza.marabonos = saldoCC.marabonos;
balanza.marcargos = saldoCC.marcargos;
balanza.abrabonos = saldoCC.abrabonos;
balanza.abrcargos = saldoCC.abrcargos;
balanza.mayabonos = saldoCC.mayabonos;
balanza.maycargos = saldoCC.maycargos;
balanza.junabonos = saldoCC.junabonos;
balanza.juncargos = saldoCC.juncargos;
balanza.julabonos = saldoCC.julabonos;
balanza.julcargos = saldoCC.julcargos;
balanza.agoabonos = saldoCC.agoabonos;
balanza.agocargos = saldoCC.agocargos;
balanza.sepabonos = saldoCC.sepabonos;
balanza.sepcargos = saldoCC.sepcargos;
balanza.octabonos = saldoCC.octabonos;
balanza.octcargos = saldoCC.octcargos;
balanza.novabonos = saldoCC.novabonos;
balanza.novcargos = saldoCC.novcargos;
balanza.dicabonos = saldoCC.dicabonos;
balanza.diccargos = saldoCC.diccargos;
//balanza.TEXT_DESCRIPCION = "";
//balanza.TEXT_DESCRIPCION2 = "";
balanza.cierre_abonos = saldoCC.cierreabonos;
balanza.cierre_cargos = saldoCC.cierrecargos;
balanza.acta = saldoCC.acta;
balanza.cc = saldoCC.cc;
lstBalanza.Add(balanza);
}
return(lstBalanza);
}
public List <Balanza> lstBalanzaETL(int id_compania)
{
List <Balanza> lstBalanza = new List <Balanza>();
DataTable dt = new DataTable();
dt = cadena_conexion_extrac(id_compania);
foreach (DataRow r in dt.Rows)
{
Balanza balanza = new Balanza();
balanza.id = Convert.ToInt32(r["INT_IDBALANZA"]);
balanza.cta = r["VARCHAR_CTA"].ToString();
balanza.scta = r["VARCHAR_SCTA"].ToString();
balanza.sscta = r["VARCHAR_SSCTA"].ToString();
balanza.year = Convert.ToInt32(r["INT_YEAR"]);
balanza.salini = Convert.ToDouble(r["DECI_SALINI"]);
balanza.enecargos = Convert.ToDouble(r["DECI_ENECARGOS"]);
balanza.eneabonos = Convert.ToDouble(r["DECI_ENEABONOS"]);
balanza.febcargos = Convert.ToDouble(r["DECI_FEBCARGOS"]);
balanza.febabonos = Convert.ToDouble(r["DECI_FEBABONOS"]);
balanza.marcargos = Convert.ToDouble(r["DECI_MARCARGOS"]);
balanza.marabonos = Convert.ToDouble(r["DECI_MARABONOS"]);
balanza.abrcargos = Convert.ToDouble(r["DECI_ABRCARGOS"]);
balanza.abrabonos = Convert.ToDouble(r["DECI_ABRABONOS"]);
balanza.maycargos = Convert.ToDouble(r["DECI_ABRABONOS"]);
balanza.mayabonos = Convert.ToDouble(r["DECI_MAYABONOS"]);
balanza.juncargos = Convert.ToDouble(r["DECI_JUNCARGOS"]);
balanza.junabonos = Convert.ToDouble(r["DECI_JUNABONOS"]);
balanza.julcargos = Convert.ToDouble(r["DECI_JULCARGOS"]);
balanza.julabonos = Convert.ToDouble(r["DECI_JULABONOS"]);
balanza.agocargos = Convert.ToDouble(r["DECI_AGOCARGOS"]);
balanza.agoabonos = Convert.ToDouble(r["DECI_AGOABONOS"]);
balanza.sepcargos = Convert.ToDouble(r["DECI_AGOABONOS"]);
balanza.sepabonos = Convert.ToDouble(r["DECI_SEPABONOS"]);
balanza.octcargos = Convert.ToDouble(r["DECI_OCTCARGOS"]);
balanza.octabonos = Convert.ToDouble(r["DECI_OCTABONOS"]);
balanza.novcargos = Convert.ToDouble(r["DECI_NOVCARGOS"]);
balanza.novabonos = Convert.ToDouble(r["DECI_NOVABONOS"]);
balanza.diccargos = Convert.ToDouble(r["DECI_DICCARGOS"]);
balanza.dicabonos = Convert.ToDouble(r["DECI_DICABONOS"]);
balanza.cc = Convert.ToString(r["INT_CC"]);
balanza.incluir_suma = Convert.ToInt32(r["DECI_INCLUIR_SUMA"]);
lstBalanza.Add(balanza);
}
return(lstBalanza);
}