private void ReadTotals() { gridData = CsvFileReader.ReadAll(csvPath + csvTotalsFile, System.Text.Encoding.GetEncoding("gbk")); for (int i = 0; i < gridData.Count; i++) { for (int j = 0; j < gridData[i].Count; j++) { var value = gridData[i][j]; if (i == 0) { columnIds.Add(value); } if (j % gridData.Count == 0) { rowIds.Add(value); } if (IsNumeric(value)) { Totals.Add(int.Parse(value)); } } } }
/// <inheritdoc/> public void AddChild(Base child) { if (child is DataConnectionBase) { Connections.Add(child as DataConnectionBase); } else if (child is DataSourceBase) { DataSources.Add(child as DataSourceBase); } else if (child is Relation) { Relations.Add(child as Relation); } else if (child is Parameter) { Parameters.Add(child as Parameter); } else if (child is Total) { Totals.Add(child as Total); } else if (child is CubeSourceBase) { CubeSources.Add(child as CubeSourceBase); } }
public void EvaluateTotals() { if (!SubTotals.Any()) // SubTotals need to be evaluated beforehand { EvaluateSubTotals(); } Totals.Clear(); for (var index = 0; index <= _diffMonths; index++) { var period = _from.AddMonths(index); var ordersInMonth = _orders.Where(IsInMonth(period.Month)); Totals.Add(ordersInMonth.Sum(order => order.OrderTotal)); } }