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; } }
private void SetVariableNotes(RelevantFootNotesRow footNoteRow) { if (mVariables.ContainsKey(footNoteRow.Variable)) { if (mVariables[footNoteRow.Variable].isSelected) { PXSqlNote mNote; mNote = new PXSqlNote(footNoteRow, this.mMeta); mVariableNotes.Add(mNote); // mPXSqlVariables[footNoteRow.Variable].FootNotesVariable.Add(footNoteRow); } } }
private void CheckPxs() { if (this.ConstructedFromPxs) { foreach (PQVariable selVar in mPxsFile.Query.Variables) { if (!mVariables.ContainsKey(selVar.code)) //Should this be considered as an error? YES { throw new PCAxis.Sql.Exceptions.DbPxsMismatchException(7, selVar.code); } } if (mPxsFile.Query.Time.ToString().Length < 1) { throw new PCAxis.Sql.Exceptions.PxsException(8); } if (!mTimeVariable.Name.Equals(mPxsFile.Query.Time.code)) { throw new PCAxis.Sql.Exceptions.PxsException(9); } } }