private void SetVariables()
{
//mVariables = new Dictionary<string, PXSqlVariable>();
mVariables = new PXSqlVariables(this);
mVariablesClassification = new PXSqlVariablesClassification();
// Get all the variables connected to the selected maintable
foreach (MainTableVariableRow aTVRow in mMetaQuery.GetMainTableVariableRows(mMainTableId))
{
if (aTVRow.VariableType == mConfig.Codes.VariableTypeT)
{
mTimeVariable = new PXSqlVariableTime(aTVRow, this);
mSqlVariable = mTimeVariable;
mVariables.Add(mSqlVariable.Name, mSqlVariable);
}
else
{ // Should be changed so that variabletype is set separate.
if (!mVariables.ContainsKey(aTVRow.Variable))
{
mSqlVariable = new PXSqlVariableClassification(aTVRow, this);
mVariablesClassification.Add(mSqlVariable.Name, (PXSqlVariableClassification)mSqlVariable);
mVariables.Add(mSqlVariable.Name, mSqlVariable);
}
}
mSqlVariable.VariableType = aTVRow.VariableType;
}
}
internal PXSqlNotes(PXSqlMeta_22 mMeta, string mMainTableId, bool inPresentationModus)
{
this.mMeta = mMeta;
this.mVariables = mMeta.Variables;
this.mSubTables = mMeta.SubTables;
this.mContents = mMeta.Contents;
this.mTimeVariable = mMeta.TimeVariable;
this.mMainTableId = mMainTableId;
this.showFootnotesCodes = new StringCollection();
if (inPresentationModus)
{
showFootnotesCodes.Add(mMeta.Config.Codes.FootnoteShowP);
}
else
{
showFootnotesCodes.Add(mMeta.Config.Codes.FootnoteShowS);
}
showFootnotesCodes.Add(mMeta.Config.Codes.FootnoteShowB);
allRelevantFoonotes = mMeta.MetaQuery.GetRelevantFoonotes(this.mMainTableId);
//Adding footnotes for grouping
allRelevantFoonotes.AddRange(this.getRelevantGroupingNotes(inPresentationModus));
this.SetFootNotes();
}