In my c# code, I put 2 tables into the PropertyBag, like this:
Dictionary<DateTime, long> FishTable = new
Dictionary<DateTime, long>();
Dictionary<DateTime, long> BoatTable = new
Dictionary<DateTime, long>();
foreach (object[] Result in dayResults)
{
DateTime Week;
if (weekly)
Week = (DateTime)Result[0];
else
Week = new DateTime((int)Result[3], (int)Result
[0], 1);
long FishDays = (long)Result[1];
long BoatDays = (long)Result[2];
if (!FishTable.ContainsKey(Week))
FishTable.Add(Week, FishDays);
if (!BoatTable.ContainsKey(Week))
BoatTable.Add(Week, BoatDays);
}
PropertyBag["FishTable"] = FishTable;
PropertyBag["BoatTable"] = BoatTable;
In my BRAIL code, I use them like this:
output ExcelTextCell("Total " + SectionNames[sectKey] +
" Days
Paid","TableTitleColumn",TitleIndex-2)
for Key in Keys:
if SectionNames[sectKey] = "Fish":
if FishTable.ContainsKey(Key):
output
ExcelNumberCell(FishTable[Key],"TableTotalValueColumn")
else:
output
ExcelBlankCell(1,"TableValueColumn")
end
else:
if BoatTable.ContainsKey(Key):
output
ExcelNumberCell(BoatTable[Key],"TableTotalValueColumn")
else:
output
ExcelBlankCell(1,"TableValueColumn")
end
end
end
Now, even when the cell for the tag says 'Total Boat Days' I get the
results from teh Fish Table.
What am I missing? (ExcelNumberCell is just a brail method that
creates the xml for an excel cell.)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
