public RelevantFootNotesRow(string variable, FootnoteRow fr, SqlDbConfig_22 dbconf, StringCollection languageCodes) { this.mFootNoteNo = fr.FootnoteNo; this.mFootNoteType = PXSqlNoteType.Variable; // well, not really but sort of, I hope this.mContents = "*"; this.mVariable = variable; this.mValuePool = "*"; this.mValueCode = "*"; this.mTimePeriod = "*"; this.mSubTable = "*"; this.mMandOpt = fr.MandOpt; this.mShowFootNote = fr.ShowFootnote; foreach (string languageCode in languageCodes) { texts.Add(languageCode, new RelevantFoonotesTexts(fr.texts[languageCode].FootnoteText)); } }
//returns the single "row" found when all PKs are spesified public FootnoteRow GetFootnoteRow(string aFootnoteNo) { //SqlDbConfig dbconf = DB; string sqlString = GetFootnote_SQLString_NoWhere(); sqlString += " WHERE " + DB.Footnote.FootnoteNoCol.Is(aFootnoteNo); DataSet ds = mSqlCommand.ExecuteSelect(sqlString); DataRowCollection myRows = ds.Tables[0].Rows; if (myRows.Count != 1) { throw new PCAxis.Sql.Exceptions.DbException(36, " FootnoteNo = " + aFootnoteNo); } FootnoteRow myOut = new FootnoteRow(myRows[0], DB, mLanguageCodes); return(myOut); }