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