internal ValueText2HM(DataRow mRow, SqlDbConfig_23 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 ContentsRow(DataRow myRow, SqlDbConfig_23 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_23 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_23 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); }
public PXSqlContent(ContentsRow row, PXSqlMeta_23 pxsqlMeta, SqlDbConfig_23 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 ValueRow2HM(DataRow mRow, SqlDbConfig_23 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 FootnoteContTimeRow(DataRow myRow, SqlDbConfig_23 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 MainTableVariableHierarchyRow(DataRow myRow, SqlDbConfig_23 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 SecondaryLanguageRow(DataRow myRow, SqlDbConfig_23 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 SubTableVariableRow(DataRow myRow, SqlDbConfig_23 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(); }
public TextCatalogRow(DataRow myRow, SqlDbConfig_23 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 ValueRowHM(DataRow mRow, SqlDbConfig_23 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_23 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_23(string mainTableId, string preferredLang, bool getAllLangs, SqlDbConfig config, InfoForDbConnection selectedDbInfo, PCAxis.Sql.Parser.Instancemodus aModus) : 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_23)config; mMetaQuery = new MetaQuery(this.mConfig, this.SelectedDbInfo); SetLanguageCodesNoPxs(preferredLang, getAllLangs); BuildMeta(); }
public FootnoteContValueRow(DataRow myRow, SqlDbConfig_23 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 VSValueRow(DataRow myRow, SqlDbConfig_23 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)); } }
public PersonRow(DataRow myRow, SqlDbConfig_23 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 SubTableRow(DataRow myRow, SqlDbConfig_23 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 GroupingLevelRow(DataRow myRow, SqlDbConfig_23 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)); } }
internal FootnoteTexts(DataRow myRow, SqlDbConfig_23 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(); } }
internal GroupingLevelTexts(DataRow myRow, SqlDbConfig_23 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(); } }
internal ValueGroupTexts(DataRow myRow, SqlDbConfig_23 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(); } }
internal VariableTexts(DataRow myRow, SqlDbConfig_23 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(); } }
public MenuSelectionRow(DataRow myRow, SqlDbConfig_23 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_23 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_23 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)); } }
internal ValueSetTexts(DataRow myRow, SqlDbConfig_23 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(); } }
internal SpecialCharacterTexts(DataRow myRow, SqlDbConfig_23 dbconf, String languageCode) { if (dbconf.isSecondaryLanguage(languageCode)) { this.mPresCharacter = myRow[dbconf.SpecialCharacterLang2.PresCharacterCol.Label(languageCode)].ToString(); this.mPresText = myRow[dbconf.SpecialCharacterLang2.PresTextCol.Label(languageCode)].ToString(); } else { this.mPresCharacter = myRow[dbconf.SpecialCharacter.PresCharacterCol.Label()].ToString(); this.mPresText = myRow[dbconf.SpecialCharacter.PresTextCol.Label()].ToString(); } }
public ValuePoolRow(DataRow myRow, SqlDbConfig_23 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_23 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)); } }