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(); }