public static CMetaobjectLanguage sGetLanguage(int LanguageCode, IDatabaseProvider Provider) { CMetaobjectLanguage R = new CMetaobjectLanguage(); Hashtable Params = new Hashtable(); Params.Add(CDBConst.CONST_TABLE_FIELD_LANGUAGES_CODE, LanguageCode); var SQL = "SELECT " + CDBConst.CONST_TABLE_FIELD_LANGUAGES_CODE + ", " + CDBConst.CONST_TABLE_FIELD_LANGUAGES_NAME; SQL += " FROM " + CDBConst.CONST_TABLE_LANGUAGES; SQL += " WHERE " + CDBConst.CONST_TABLE_FIELD_LANGUAGES_CODE + " = @p" + CDBConst.CONST_TABLE_FIELD_LANGUAGES_CODE; var T = Provider.QueryGetData(SQL, false, Params); if (T == null || T.Rows.Count == 0) return null; R.LanguageName = T.Rows[0][1].PostProcessDatabaseValue<string>(""); R.LanguageCode = T.Rows[0][0].PostProcessDatabaseValue<int>(-1); return R; }
public static List<CMetaobjectLanguage> sGetAllLanguages(IDatabaseProvider Provider) { List<CMetaobjectLanguage> R = new List<CMetaobjectLanguage>(); var SQL = "SELECT " + CDBConst.CONST_TABLE_FIELD_LANGUAGES_CODE + ", " + CDBConst.CONST_TABLE_FIELD_LANGUAGES_NAME; SQL += " FROM " + CDBConst.CONST_TABLE_LANGUAGES; var T = Provider.QueryGetData(SQL, false, null); if (T == null || T.Rows.Count == 0) return R; for (int i = 0; i < T.Rows.Count; i++) { var Language = new CMetaobjectLanguage() { LanguageCode = T.Rows[i][0].PostProcessDatabaseValue<int>(), LanguageName = T.Rows[i][1].PostProcessDatabaseValue<string>() }; R.Add(Language); } return R; }