private ExportColumnCollection CreateColumnCollection()
{
ExportColumnCollection c = new ExportColumnCollection();
string AmountLabel = null;
string UnitsLabel = null;
TerminologyUnit TermUnit = 0;
string PrimaryStratumLabel = null;
string SecondaryStratumLabel = null;
string TertiaryStratumLabel = null;
DataSheet dsterm = this.Project.GetDataSheet(Strings.DATASHEET_TERMINOLOGY_NAME);
string TimestepLabel = TerminologyUtilities.GetTimestepUnits(this.Project);
TerminologyUtilities.GetAmountLabelTerminology(dsterm, ref AmountLabel, ref TermUnit);
TerminologyUtilities.GetStratumLabelTerminology(dsterm, ref PrimaryStratumLabel, ref SecondaryStratumLabel, ref TertiaryStratumLabel);
UnitsLabel = TerminologyUtilities.TerminologyUnitToString(TermUnit);
string AmountTitle = string.Format(CultureInfo.InvariantCulture, "{0} ({1})", AmountLabel, UnitsLabel);
c.Add(new ExportColumn("ScenarioID", "Scenario ID"));
c.Add(new ExportColumn("ScenarioName", "Scenario"));
c.Add(new ExportColumn("Iteration", "Iteration"));
c.Add(new ExportColumn("Timestep", TimestepLabel));
c.Add(new ExportColumn("Stratum", PrimaryStratumLabel));
c.Add(new ExportColumn("SecondaryStratum", SecondaryStratumLabel));
c.Add(new ExportColumn("TertiaryStratum", TertiaryStratumLabel));
c.Add(new ExportColumn("StateClass", "State Class"));
c.Add(new ExportColumn("AgeMin", "Age Min"));
c.Add(new ExportColumn("AgeMax", "Age Max"));
c.Add(new ExportColumn("Amount", AmountTitle));
c["Amount"].DecimalPlaces = 2;
c["Amount"].Alignment = ColumnAlignment.Right;
return(c);
}
private ExportColumnCollection CreateColumnCollection()
{
ExportColumnCollection c = new ExportColumnCollection();
string PrimaryStratumLabel = null;
string SecondaryStratumLabel = null;
string TertiaryStratumLabel = null;
DataSheet dsterm = this.Project.GetDataSheet(Strings.DATASHEET_TERMINOLOGY_NAME);
string TimestepLabel = TerminologyUtilities.GetTimestepUnits(this.Project);
TerminologyUtilities.GetStratumLabelTerminology(
dsterm, ref PrimaryStratumLabel, ref SecondaryStratumLabel, ref TertiaryStratumLabel);
c.Add(new ExportColumn("ScenarioID", "Scenario ID"));
c.Add(new ExportColumn("ScenarioName", "Scenario"));
c.Add(new ExportColumn("Iteration", "Iteration"));
c.Add(new ExportColumn("Timestep", TimestepLabel));
c.Add(new ExportColumn("Stratum", PrimaryStratumLabel));
c.Add(new ExportColumn("SecondaryStratum", SecondaryStratumLabel));
c.Add(new ExportColumn("TertiaryStratum", TertiaryStratumLabel));
c.Add(new ExportColumn("AttributeType", "Attribute"));
c.Add(new ExportColumn("AgeMin", "Age Min"));
c.Add(new ExportColumn("AgeMax", "Age Max"));
c.Add(new ExportColumn("Amount", "Total Value"));
c["Amount"].DecimalPlaces = 2;
c["Amount"].Alignment = ColumnAlignment.Right;
return(c);
}
internal void InternalExport(string location, ExportType exportType, bool showMessage)
{
string AmountLabel = null;
TerminologyUnit TermUnit = 0;
DataSheet dsterm = this.Project.GetDataSheet(Strings.DATASHEET_TERMINOLOGY_NAME);
ExportColumnCollection columns = this.CreateColumnCollection();
TerminologyUtilities.GetAmountLabelTerminology(dsterm, ref AmountLabel, ref TermUnit);
string WorksheetName = string.Format(CultureInfo.InvariantCulture, "{0} by Transition and State", AmountLabel);
if (exportType == ExportType.ExcelFile)
{
this.ExcelExport(location, columns, this.CreateReportQuery(false), WorksheetName);
}
else
{
columns.Remove("ScenarioName");
this.CSVExport(location, columns, this.CreateReportQuery(true));
if (showMessage)
{
FormsUtilities.InformationMessageBox("Data saved to '{0}'.", location);
}
}
}
private ExportColumnCollection CreateColumnCollection()
{
ExportColumnCollection c = new ExportColumnCollection();
DataSheet dsterm = this.Project.GetDataSheet(Constants.DATASHEET_TERMINOLOGY_NAME);
DataSheet dstermSTSim = this.Project.GetDataSheet(Constants.DATASHEET_STSIM_TERMINOLOGY);
string StockUnits = TerminologyUtilities.GetTerminology(dsterm, Constants.STOCK_UNITS_COLUMN_NAME);
string TimestepLabel = TerminologyUtilities.GetTimestepUnits(this.Project);
string PrimaryStratumLabel = null;
string SecondaryStratumLabel = null;
string TertiaryStratumLabel = null;
TerminologyUtilities.GetStratumLabelStrings(dstermSTSim, ref PrimaryStratumLabel, ref SecondaryStratumLabel, ref TertiaryStratumLabel);
string TotalValue = string.Format(CultureInfo.InvariantCulture, "Total Value ({0})", StockUnits);
c.Add(new ExportColumn("ScenarioID", "Scenario ID"));
c.Add(new ExportColumn("ScenarioName", "Scenario"));
c.Add(new ExportColumn("Iteration", "Iteration"));
c.Add(new ExportColumn("Timestep", TimestepLabel));
c.Add(new ExportColumn("Stratum", PrimaryStratumLabel));
c.Add(new ExportColumn("SecondaryStratum", SecondaryStratumLabel));
c.Add(new ExportColumn("TertiaryStratum", TertiaryStratumLabel));
c.Add(new ExportColumn("StateClass", "State Class"));
c.Add(new ExportColumn("StockGroup", "Stock Group"));
c.Add(new ExportColumn("Amount", TotalValue));
c["Amount"].DecimalPlaces = 2;
c["Amount"].Alignment = Core.ColumnAlignment.Right;
return(c);
}
internal void InternalExport(string location, ExportType exportType, bool showMessage)
{
ExportColumnCollection columns = this.CreateColumnCollection();
if (exportType == ExportType.ExcelFile)
{
this.ExcelExport(location, columns, this.CreateReportQuery(false), "Transition Based Attributes");
}
else
{
columns.Remove("ScenarioName");
this.CSVExport(location, columns, this.CreateReportQuery(true));
if (showMessage)
{
FormsUtilities.InformationMessageBox("Data saved to '{0}'.", location);
}
}
}