public List<eComprobanteVC> GetSelectTotalComprobante(eComprobanteVC o, String orderBy)
{
dSqlComprobanteVC dc = new dSqlComprobanteVC();
var dataList = dc.GetSelectComprobante(o, 0, 1000, orderBy, out total, out moneda,"FORM");
List<eComprobanteVC> list = new List<eComprobanteVC>();
eComprobanteVC ec = new eComprobanteVC();
Decimal _Otr_Cta_Xcob_Rea_Ced = 0.00m;
Decimal _Pri_Xpag_Rea_Ced = 0.00m;
Decimal _Pri_Xcob_Rea_Ace = 0.00m;
Decimal _Sin_Xcob_Rea_Ced = 0.00m;
Decimal _Sin_Xpag_Rea_Ace = 0.00m;
Decimal _Otr_Cta_Xpag_Rea_Ace = 0.00m;
Decimal _Dscto_Comis_Rea = 0.00m;
Decimal _Saldo_Deudor = 0.00m;
Decimal _Saldo_Acreedor = 0.00m;
for (int i = 0; i < dataList.Count; i++) {
_Otr_Cta_Xcob_Rea_Ced += Convert.ToDecimal(dataList[i]._Otr_Cta_Xcob_Rea_Ced);
_Pri_Xpag_Rea_Ced += Convert.ToDecimal(dataList[i]._Pri_Xpag_Rea_Ced);
_Pri_Xcob_Rea_Ace += Convert.ToDecimal(dataList[i]._Pri_Xcob_Rea_Ace);
_Sin_Xcob_Rea_Ced += Convert.ToDecimal(dataList[i]._Sin_Xcob_Rea_Ced);
_Sin_Xpag_Rea_Ace += Convert.ToDecimal(dataList[i]._Sin_Xpag_Rea_Ace);
_Otr_Cta_Xpag_Rea_Ace += Convert.ToDecimal(dataList[i]._Otr_Cta_Xpag_Rea_Ace);
_Dscto_Comis_Rea += Convert.ToDecimal(dataList[i]._Dscto_Comis_Rea);
_Saldo_Deudor += Convert.ToDecimal(dataList[i]._Saldo_Deudor);
_Saldo_Acreedor += Convert.ToDecimal(dataList[i]._Saldo_Acreedor);
}
ec._Otr_Cta_Xcob_Rea_Ced = String.Format(moneda, _Otr_Cta_Xcob_Rea_Ced).Substring(3);
ec._Pri_Xpag_Rea_Ced = String.Format(moneda,_Pri_Xpag_Rea_Ced).Substring(3);
ec._Pri_Xcob_Rea_Ace = String.Format(moneda,_Pri_Xcob_Rea_Ace).Substring(3);
ec._Sin_Xcob_Rea_Ced = String.Format(moneda,_Sin_Xcob_Rea_Ced).Substring(3);
ec._Sin_Xpag_Rea_Ace = String.Format(moneda,_Sin_Xpag_Rea_Ace).Substring(3);
ec._Otr_Cta_Xpag_Rea_Ace = String.Format(moneda,_Otr_Cta_Xpag_Rea_Ace).Substring(3);
ec._Dscto_Comis_Rea = String.Format(moneda,_Dscto_Comis_Rea).Substring(3);
ec._Saldo_Deudor = String.Format(moneda,_Saldo_Deudor).Substring(3);
ec._Saldo_Acreedor = String.Format(moneda,_Saldo_Acreedor).Substring(3);
list.Add(ec);
return list;
}
public DataTable GetSelectComprobanteExport(eComprobanteVC o, int start, int size, String orderBy, out int total)
{
dSqlComprobanteVC dc = new dSqlComprobanteVC();
return dc.GetSelectComprobanteExport(o,start,size,orderBy,out total);
}
public List<eComprobanteVC> GetSelectComprobante(eComprobanteVC o, int start, int size, String orderBy, out int total,String excel)
{
dSqlComprobanteVC dc = new dSqlComprobanteVC();
return dc.GetSelectComprobante(o, start, size, orderBy, out total, out moneda,excel);
}