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); ec._Pri_Xpag_Rea_Ced = String.Format(moneda, _Pri_Xpag_Rea_Ced); ec._Pri_Xcob_Rea_Ace = String.Format(moneda, _Pri_Xcob_Rea_Ace); ec._Sin_Xcob_Rea_Ced = String.Format(moneda, _Sin_Xcob_Rea_Ced); ec._Sin_Xpag_Rea_Ace = String.Format(moneda, _Sin_Xpag_Rea_Ace); ec._Otr_Cta_Xpag_Rea_Ace = String.Format(moneda, _Otr_Cta_Xpag_Rea_Ace); ec._Dscto_Comis_Rea = String.Format(moneda, _Dscto_Comis_Rea); ec._Saldo_Deudor = String.Format(moneda, _Saldo_Deudor); ec._Saldo_Acreedor = String.Format(moneda, _Saldo_Acreedor); list.Add(ec); return(list); }
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)); }