Creating reports and dashboards | Stimulsoft community forum

Code: Select all

// CSV aus Variable "InputCsv" lesen
string csv = "";
var v = this.Dictionary.Variables["InputCsv"];
if (v != null) { csv = v.ValueObject as string; if (csv == null) csv = v.Value; }
csv = (csv ?? "").Replace("\r", "");
string[] lines = csv.Split('\n');
if (lines.Length < 2) { this.RegBusinessObject("Energie", new object[0]); return; }

// Header -> Indizes für Datum, MK, TP
int iD = -1, iMK = -1, iTP = -1;
string[] head = lines[0].Split(';');
for (int i = 0; i < head.Length; i++) {
string n = head[i].Trim().Trim('"');
    if (n == "Datum") iD = i; else if (n == "MK") iMK = i; else if (n == "TP") iTP = i;
}
if (iD < 0 || iMK < 0 || iTP < 0) { this.RegBusinessObject("Energie", new object[0]); return; }

// Summieren pro Datum
var de = new System.Globalization.CultureInfo("de-DE");
var map = new System.Collections.Generic.Dictionary<System.DateTime, decimal[]>(); // [0]=MK, [1]=TP

for (int r = 1; r < lines.Length; r++) {
string line = lines[r];
    if (string.IsNullOrWhiteSpace(line)) continue;
string[] c = line.Split(';');
int need = iD; if (iMK > need) need = iMK; if (iTP > need) need = iTP;
    if (c.Length <= need) continue;

    // Datum
System.DateTime d;
    if (!System.DateTime.TryParse(c[iD].Trim().Trim('"'), de, System.Globalization.DateTimeStyles.None, out d))
        continue;

    // MK
decimal mk = 0m;
string sMK = c[iMK].Trim().Trim('"');
bool ok = decimal.TryParse(sMK, System.Globalization.NumberStyles.Number, de, out mk);
    if (!ok) ok = decimal.TryParse(sMK, System.Globalization.NumberStyles.Number,
                                   System.Globalization.CultureInfo.InvariantCulture, out mk);

    // TP
decimal tp = 0m;
string sTP = c[iTP].Trim().Trim('"');
    ok = decimal.TryParse(sTP, System.Globalization.NumberStyles.Number, de, out tp);
    if (!ok) decimal.TryParse(sTP, System.Globalization.NumberStyles.Number,
                              System.Globalization.CultureInfo.InvariantCulture, out tp);

decimal[] arr;
if (!map.TryGetValue(d, out arr)) { arr = new decimal[2]; map[d] = arr; }
    arr[0] += mk;  // MK
    arr[1] += tp;  // TP
}

// In BO-Form bringen
object[] agg = new object[map.Count];
int j = 0;
foreach (System.Collections.Generic.KeyValuePair<System.DateTime, decimal[]> kv in map)
    agg[j++] = new { Datum = kv.Key, MK = kv.Value[0], TP = kv.Value[1] };

// Registrieren (BI-Designer). In Plano ggf. bo.BusinessObject = agg; verwenden.
this.RegBusinessObject("Energie", agg);