public ContentsRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mMainTable = myRow[dbconf.Contents.MainTableCol.Label()].ToString();
this.mContents = myRow[dbconf.Contents.ContentsCol.Label()].ToString();
this.mPresCode = myRow[dbconf.Contents.PresCodeCol.Label()].ToString();
this.mCopyright = myRow[dbconf.Contents.CopyrightCol.Label()].ToString();
this.mStatAuthority = myRow[dbconf.Contents.StatAuthorityCol.Label()].ToString();
this.mProducer = myRow[dbconf.Contents.ProducerCol.Label()].ToString();
this.mLastUpdated = myRow[dbconf.Contents.LastUpdatedCol.Label()] == DBNull.Value ? "" : Convert.ToDateTime(myRow[dbconf.Contents.LastUpdatedCol.Label()]).ToString("yyyyMMdd HH:mm");
this.mPublished = myRow[dbconf.Contents.PublishedCol.Label()].ToString();
this.mPresDecimals = myRow[dbconf.Contents.PresDecimalsCol.Label()].ToString();
this.mPresCellsZero = myRow[dbconf.Contents.PresCellsZeroCol.Label()].ToString();
this.mPresMissingLine = myRow[dbconf.Contents.PresMissingLineCol.Label()].ToString();
this.mAggregPossible = myRow[dbconf.Contents.AggregPossibleCol.Label()].ToString();
this.mStockFA = myRow[dbconf.Contents.StockFACol.Label()].ToString();
this.mCFPrices = myRow[dbconf.Contents.CFPricesCol.Label()].ToString();
this.mDayAdj = myRow[dbconf.Contents.DayAdjCol.Label()].ToString();
this.mSeasAdj = myRow[dbconf.Contents.SeasAdjCol.Label()].ToString();
this.mStoreColumnNo = myRow[dbconf.Contents.StoreColumnNoCol.Label()].ToString();
this.mStoreFormat = myRow[dbconf.Contents.StoreFormatCol.Label()].ToString();
this.mStoreNoChar = myRow[dbconf.Contents.StoreNoCharCol.Label()].ToString();
this.mStoreDecimals = myRow[dbconf.Contents.StoreDecimalsCol.Label()].ToString();
this.mMetaId = myRow[dbconf.Contents.MetaIdCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new ContentsTexts(myRow, dbconf, languageCode));
}
}
public FootnoteValueSetValueRow(DataRow myRow, SqlDbConfig_24 dbconf)
{
this.mValuePool = myRow[dbconf.FootnoteValueSetValue.ValuePoolCol.Label()].ToString();
this.mValueSet = myRow[dbconf.FootnoteValueSetValue.ValueSetCol.Label()].ToString();
this.mValueCode = myRow[dbconf.FootnoteValueSetValue.ValueCodeCol.Label()].ToString();
this.mFootnoteNo = myRow[dbconf.FootnoteValueSetValue.FootnoteNoCol.Label()].ToString();
}
/**
* Translates database code to Paxiom code for StockFA.
*/
private string PaxiomifyStockFA(string StockFA, SqlDbConfig_24 config)
{
string myOut = "";
if (!String.IsNullOrEmpty(StockFA))
{
if (StockFA.Equals(config.Codes.StockFAS))
{
myOut = PXConstant.STOCKFA_STOCK;
}
else if (StockFA.Equals(config.Codes.StockFAA))
{
myOut = PXConstant.STOCKFA_AVERAGE;
}
else if (StockFA.Equals(config.Codes.StockFAF))
{
myOut = PXConstant.STOCKFA_FLOW;
}
else
{
myOut = PXConstant.STOCKFA_OTHER;
//throw new ApplicationException("Unknown StockFA code:\"" + StockFA + "\"");
}
}
return(myOut);
}
internal ValueText2HM(DataRow mRow, SqlDbConfig_24 dbconf)
{
this.mSortCodeValue = mRow["SortCodeValue"].ToString();
this.mSortCodeVsValue = mRow["SortCodeVsValue"].ToString();
this.mValueTextS = mRow[dbconf.Value.ValueTextSCol.PureColumnName()].ToString();
this.mValueTextL = mRow[dbconf.Value.ValueTextLCol.PureColumnName()].ToString();
}
public PXSqlContent(ContentsRow row, PXSqlMeta_24 pxsqlMeta, SqlDbConfig_24 config, PXSqlContact contact)
{
mRow = row;
mContact = contact;
//pxsqlMeta.MetaQuery.DB.Codes.Copyright1;
mContents = row.Contents;
//mFootnoteContents = row.FootnoteContents;
//mFootnoteTime = row.FootnoteTime;
//mFootnoteValue = row.FootnoteValue;
//mFootnoteVariable = row.FootnoteVariable;
mPresText = new Dictionary <string, string>();
mPresTextS = new Dictionary <string, string>();
mPresCode = row.PresCode;
mBasePeriod = new Dictionary <string, string>();
mRefPeriod = new Dictionary <string, string>();
mUnit = new Dictionary <string, string>();
foreach (string langCode in pxsqlMeta.LanguageCodes)
{
mPresText[langCode] = row.texts[langCode].PresText;
mPresTextS[langCode] = row.texts[langCode].PresTextS;
mBasePeriod[langCode] = row.texts[langCode].BasePeriod;
mRefPeriod[langCode] = row.texts[langCode].RefPeriod;
mUnit[langCode] = row.texts[langCode].Unit;
}
mPresDecimals = mRow.PresDecimals;
pxsqlMeta.DecimalHandler.ShowDecimals = mPresDecimals;
pxsqlMeta.DecimalHandler.StoreDecimals = mRow.StoreDecimals;
mSeasAdj = mRow.SeasAdj.Equals(config.Codes.Yes);
mDayAdj = mRow.DayAdj.Equals(config.Codes.Yes);
mLastUpdatet = mRow.LastUpdated;
mStockFA = PaxiomifyStockFA(mRow.StockFA, config);
mCFPrices = PaxiomifyCFPrices(mRow.CFPrices, config);
mAggregPossible = !mRow.AggregPossible.Equals(config.Codes.No); //not notPossible since yes is default
#region mCategoryOfCellsInMissingRows and mValueOfCellsInMissingRows
if (pxsqlMeta.inPresentationModus && mRow.PresCellsZero.Equals(config.Codes.No))
{
// both 2.1 and 2.2 uses a mRow.PresMissingLine from the SpecialCharacter.CharacterType( which is the primary key)
// or if mRow.PresMissingLine is missing: the default
mValueOfCellsInMissingRows = pxsqlMeta.mPxsqlNpm.DefaultCodeMissingLineMagic;
mNPMcharacterinMissingRows = pxsqlMeta.mPxsqlNpm.DefaultCodeMissingLineNPMCharacter;
if (!(String.IsNullOrEmpty(mRow.PresMissingLine)))
{
mValueOfCellsInMissingRows = pxsqlMeta.mPxsqlNpm.DataSymbolNMagic(mRow.PresMissingLine);
mNPMcharacterinMissingRows = pxsqlMeta.mPxsqlNpm.DataSymbolNNPMCharacter(mRow.PresMissingLine);
}
mCategoryOfCellsInMissingRows = pxsqlMeta.mPxsqlNpm.GetCategory(mValueOfCellsInMissingRows).ToString();
}
#endregion mCategoryOfCellsInMissingRows and mValueOfCellsInMissingRows
}
public MainTableVariableHierarchyRow(DataRow myRow, SqlDbConfig_24 dbconf)
{
this.mMainTable = myRow[dbconf.MainTableVariableHierarchy.MainTableCol.Label()].ToString();
this.mVariable = myRow[dbconf.MainTableVariableHierarchy.VariableCol.Label()].ToString();
this.mGrouping = myRow[dbconf.MainTableVariableHierarchy.GroupingCol.Label()].ToString();
this.mShowLevels = myRow[dbconf.MainTableVariableHierarchy.ShowLevelsCol.Label()].ToString();
this.mAllLevelsStored = myRow[dbconf.MainTableVariableHierarchy.AllLevelsStoredCol.Label()].ToString();
}
public FootnoteContTimeRow(DataRow myRow, SqlDbConfig_24 dbconf)
{
this.mMainTable = myRow[dbconf.FootnoteContTime.MainTableCol.Label()].ToString();
this.mContents = myRow[dbconf.FootnoteContTime.ContentsCol.Label()].ToString();
this.mTimePeriod = myRow[dbconf.FootnoteContTime.TimePeriodCol.Label()].ToString();
this.mFootnoteNo = myRow[dbconf.FootnoteContTime.FootnoteNoCol.Label()].ToString();
this.mCellnote = myRow[dbconf.FootnoteContTime.CellnoteCol.Label()].ToString();
}
public ValueRow2HM(DataRow mRow, SqlDbConfig_24 dbconf, int sortOrder)
{
this.mValuePool = mRow[dbconf.VSValue.ValuePoolCol.PureColumnName()].ToString(); // VAL_Vardeforrad
this.mValueSet = mRow[dbconf.VSValue.ValueSetCol.PureColumnName()].ToString(); // VAL_Vardemangd
this.mValueCode = mRow[dbconf.VSValue.ValueCodeCol.PureColumnName()].ToString();
this.mSortOrder = sortOrder.ToString();
this.mFootnote = null;
}
public SecondaryLanguageRow(DataRow myRow, SqlDbConfig_24 dbconf)
{
this.mMainTable = myRow[dbconf.SecondaryLanguage.MainTableCol.Label()].ToString();
this.mLanguage = myRow[dbconf.SecondaryLanguage.LanguageCol.Label()].ToString();
this.mCompletelyTranslated = myRow[dbconf.SecondaryLanguage.CompletelyTranslatedCol.Label()].ToString();
this.mPublished = myRow[dbconf.SecondaryLanguage.PublishedCol.Label()].ToString();
this.mUserId = myRow[dbconf.SecondaryLanguage.UserIdCol.Label()].ToString();
this.mLogDate = myRow[dbconf.SecondaryLanguage.LogDateCol.Label()].ToString();
}
public TextCatalogRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mTextCatalogNo = myRow[dbconf.TextCatalog.TextCatalogNoCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new TextCatalogTexts(myRow, dbconf, languageCode));
}
}
public FootnoteContValueRow(DataRow myRow, SqlDbConfig_24 dbconf)
{
this.mMainTable = myRow[dbconf.FootnoteContValue.MainTableCol.Label()].ToString();
this.mContents = myRow[dbconf.FootnoteContValue.ContentsCol.Label()].ToString();
this.mVariable = myRow[dbconf.FootnoteContValue.VariableCol.Label()].ToString();
this.mValuePool = myRow[dbconf.FootnoteContValue.ValuePoolCol.Label()].ToString();
this.mValueCode = myRow[dbconf.FootnoteContValue.ValueCodeCol.Label()].ToString();
this.mFootnoteNo = myRow[dbconf.FootnoteContValue.FootnoteNoCol.Label()].ToString();
this.mCellnote = myRow[dbconf.FootnoteContValue.CellnoteCol.Label()].ToString();
}
public ValueRowHM(DataRow mRow, SqlDbConfig_24 dbconf, StringCollection languageCodes, int sortOrder)
{
this.mValuePool = mRow[dbconf.Value.ValuePoolCol.Label()].ToString();
this.mValueCode = mRow[dbconf.Value.ValueCodeCol.Label()].ToString();
this.mMetaId = mRow[dbconf.Value.MetaIdCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new ValueTextHM(mRow, dbconf, languageCode));
}
}
public OrganizationRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mOrganizationCode = myRow[dbconf.Organization.OrganizationCodeCol.Label()].ToString();
this.mMetaId = myRow[dbconf.Organization.MetaIdCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new OrganizationTexts(myRow, dbconf, languageCode));
}
}
/// <summary>
///
/// </summary>
/// <param name="mainTableId"></param>
/// <param name="preferredLang">The code ("no","en",...) of the language the client wants as main language in paxiom. May be null or empty, indicating the client dont care, in which case a "random" language is choosen.</param>
/// <param name="getAllLangs"></param>
/// <param name="config"></param>
/// <param name="selectedDbInfo"></param>
/// <param name="aModus"></param>
public PXSqlMeta_24(string mainTableId, string preferredLang, bool getAllLangs, SqlDbConfig config, InfoForDbConnection selectedDbInfo, PCAxis.Sql.Parser.Instancemodus aModus, bool useTempTables)
: base(config, selectedDbInfo, aModus, false)
{
log.Info("PXSqlMeta(string mainTableId(=" + mainTableId + "), StringCollection desiredLanguages, SqlDbConfig config, Instancemodus aModus(=" + aModus.ToString() + "))");
this.mMainTableId = mainTableId;
this.mConfig = (SqlDbConfig_24)config;
mMetaQuery = new MetaQuery(this.mConfig, this.SelectedDbInfo, useTempTables);
SetLanguageCodesNoPxs(preferredLang, getAllLangs);
BuildMeta();
}
public SubTableRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mMainTable = myRow[dbconf.SubTable.MainTableCol.Label()].ToString();
this.mSubTable = myRow[dbconf.SubTable.SubTableCol.Label()].ToString();
this.mCleanTable = myRow[dbconf.SubTable.CleanTableCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new SubTableTexts(myRow, dbconf, languageCode));
}
}
public RelevantFoonotesTexts(DataRow myRow, SqlDbConfig_24 dbconf, String languageCode)
{
if (dbconf.isSecondaryLanguage(languageCode))
{
this.mFootNotetext = myRow[dbconf.FootnoteLang2.FootnoteTextCol.Label(languageCode)].ToString();
}
else
{
this.mFootNotetext = myRow[dbconf.Footnote.FootnoteTextCol.Label()].ToString();
}
}
public VSValueRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mValueSet = myRow[dbconf.VSValue.ValueSetCol.Label()].ToString();
this.mValuePool = myRow[dbconf.VSValue.ValuePoolCol.Label()].ToString();
this.mValueCode = myRow[dbconf.VSValue.ValueCodeCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new VSValueTexts(myRow, dbconf, languageCode));
}
}
internal VariableTexts(DataRow myRow, SqlDbConfig_24 dbconf, String languageCode)
{
if (dbconf.isSecondaryLanguage(languageCode))
{
this.mPresText = myRow[dbconf.VariableLang2.PresTextCol.Label(languageCode)].ToString();
}
else
{
this.mPresText = myRow[dbconf.Variable.PresTextCol.Label()].ToString();
}
}
internal GroupingLevelTexts(DataRow myRow, SqlDbConfig_24 dbconf, String languageCode)
{
if (dbconf.isSecondaryLanguage(languageCode))
{
this.mLevelText = myRow[dbconf.GroupingLevelLang2.LevelTextCol.Label(languageCode)].ToString();
}
else
{
this.mLevelText = myRow[dbconf.GroupingLevel.LevelTextCol.Label()].ToString();
}
}
public GroupingLevelRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mGrouping = myRow[dbconf.GroupingLevel.GroupingCol.Label()].ToString();
this.mLevelNo = myRow[dbconf.GroupingLevel.LevelNoCol.Label()].ToString();
this.mGeoAreaNo = myRow[dbconf.GroupingLevel.GeoAreaNoCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new GroupingLevelTexts(myRow, dbconf, languageCode));
}
}
public SubTableVariableRow(DataRow myRow, SqlDbConfig_24 dbconf)
{
this.mMainTable = myRow[dbconf.SubTableVariable.MainTableCol.Label()].ToString();
this.mSubTable = myRow[dbconf.SubTableVariable.SubTableCol.Label()].ToString();
this.mVariable = myRow[dbconf.SubTableVariable.VariableCol.Label()].ToString();
this.mValueSet = myRow[dbconf.SubTableVariable.ValueSetCol.Label()].ToString();
this.mVariableType = myRow[dbconf.SubTableVariable.VariableTypeCol.Label()].ToString();
this.mStoreColumnNo = myRow[dbconf.SubTableVariable.StoreColumnNoCol.Label()].ToString();
this.mSortCode = myRow[dbconf.SubTableVariable.SortCodeCol.Label()].ToString();
this.mDefaultInGui = myRow[dbconf.SubTableVariable.DefaultInGuiCol.Label()].ToString();
}
internal ValueGroupTexts(DataRow myRow, SqlDbConfig_24 dbconf, String languageCode)
{
if (dbconf.isSecondaryLanguage(languageCode))
{
this.mSortCode = myRow[dbconf.ValueGroupLang2.SortCodeCol.Label(languageCode)].ToString();
}
else
{
this.mSortCode = myRow[dbconf.ValueGroup.SortCodeCol.Label()].ToString();
}
}
public PersonRow(DataRow myRow, SqlDbConfig_24 dbconf)
{
this.mPersonCode = myRow[dbconf.Person.PersonCodeCol.Label()].ToString();
this.mOrganizationCode = myRow[dbconf.Person.OrganizationCodeCol.Label()].ToString();
this.mForename = myRow[dbconf.Person.ForenameCol.Label()].ToString();
this.mSurname = myRow[dbconf.Person.SurnameCol.Label()].ToString();
this.mPhonePrefix = myRow[dbconf.Person.PhonePrefixCol.Label()].ToString();
this.mPhoneNo = myRow[dbconf.Person.PhoneNoCol.Label()].ToString();
this.mFaxNo = myRow[dbconf.Person.FaxNoCol.Label()].ToString();
this.mEmail = myRow[dbconf.Person.EmailCol.Label()].ToString();
}
public MenuSelectionRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mMenu = myRow[dbconf.MenuSelection.MenuCol.Label()].ToString();
this.mSelection = myRow[dbconf.MenuSelection.SelectionCol.Label()].ToString();
this.mLevelNo = myRow[dbconf.MenuSelection.LevelNoCol.Label()].ToString();
this.mMetaId = myRow[dbconf.MenuSelection.MetaIdCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new MenuSelectionTexts(myRow, dbconf, languageCode));
}
}
public VariableRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mVariable = myRow[dbconf.Variable.VariableCol.Label()].ToString();
this.mVariableInfo = myRow[dbconf.Variable.VariableInfoCol.Label()].ToString();
this.mMetaId = myRow[dbconf.Variable.MetaIdCol.Label()].ToString();
this.mFootnote = myRow[dbconf.Variable.FootnoteCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new VariableTexts(myRow, dbconf, languageCode));
}
}
public SpecialCharacterRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mCharacterType = myRow[dbconf.SpecialCharacter.CharacterTypeCol.Label()].ToString();
this.mAggregPossible = myRow[dbconf.SpecialCharacter.AggregPossibleCol.Label()].ToString();
this.mDataCellPres = myRow[dbconf.SpecialCharacter.DataCellPresCol.Label()].ToString();
this.mDataCellFilled = myRow[dbconf.SpecialCharacter.DataCellFilledCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new SpecialCharacterTexts(myRow, dbconf, languageCode));
}
}
public ValuePoolRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mValuePool = myRow[dbconf.ValuePool.ValuePoolCol.Label()].ToString();
this.mDescription = myRow[dbconf.ValuePool.DescriptionCol.Label()].ToString();
this.mValueTextExists = myRow[dbconf.ValuePool.ValueTextExistsCol.Label()].ToString();
this.mValuePres = myRow[dbconf.ValuePool.ValuePresCol.Label()].ToString();
this.mMetaId = myRow[dbconf.ValuePool.MetaIdCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new ValuePoolTexts(myRow, dbconf, languageCode));
}
}
public FootnoteRow(DataRow myRow, SqlDbConfig_24 dbconf, StringCollection languageCodes)
{
this.mFootnoteNo = myRow[dbconf.Footnote.FootnoteNoCol.Label()].ToString();
this.mFootnoteType = myRow[dbconf.Footnote.FootnoteTypeCol.Label()].ToString();
this.mShowFootnote = myRow[dbconf.Footnote.ShowFootnoteCol.Label()].ToString();
this.mMandOpt = myRow[dbconf.Footnote.MandOptCol.Label()].ToString();
this.mPresCharacter = myRow[dbconf.Footnote.PresCharacterCol.Label()].ToString();
foreach (string languageCode in languageCodes)
{
texts.Add(languageCode, new FootnoteTexts(myRow, dbconf, languageCode));
}
}
internal ValuePoolTexts(DataRow myRow, SqlDbConfig_24 dbconf, String languageCode)
{
if (dbconf.isSecondaryLanguage(languageCode))
{
this.mValuePoolAlias = myRow[dbconf.ValuePoolLang2.ValuePoolAliasCol.Label(languageCode)].ToString();
this.mPresText = myRow[dbconf.ValuePoolLang2.PresTextCol.Label(languageCode)].ToString();
}
else
{
this.mValuePoolAlias = myRow[dbconf.ValuePool.ValuePoolAliasCol.Label()].ToString();
this.mPresText = myRow[dbconf.ValuePool.PresTextCol.Label()].ToString();
}
}
internal ValueSetTexts(DataRow myRow, SqlDbConfig_24 dbconf, String languageCode)
{
if (dbconf.isSecondaryLanguage(languageCode))
{
this.mPresText = myRow[dbconf.ValueSetLang2.PresTextCol.Label(languageCode)].ToString();
this.mDescription = myRow[dbconf.ValueSetLang2.DescriptionCol.Label(languageCode)].ToString();
}
else
{
this.mPresText = myRow[dbconf.ValueSet.PresTextCol.Label()].ToString();
this.mDescription = myRow[dbconf.ValueSet.DescriptionCol.Label()].ToString();
}
}
