コード例 #1
0
        // Token: 0x060006E4 RID: 1764 RVA: 0x0002BC68 File Offset: 0x00029E68
        public OidEnums GetEnums(string enumName)
        {
            OidEnums oidEnums = new OidEnums();

            if (string.IsNullOrEmpty(enumName))
            {
                return(oidEnums);
            }
            using (OleDbConnection dbconnection = MibHelper.GetDBConnection())
            {
                dbconnection.Open();
                using (OleDbCommand oleDbCommand = new OleDbCommand())
                {
                    oleDbCommand.CommandText = string.Format("Select {0} from Enums WHERE Name=@name order by Value;", "Name, Value, Enum");
                    oleDbCommand.Parameters.AddWithValue("name", enumName);
                    using (IDataReader dataReader = OleDbHelper.ExecuteReader(oleDbCommand, dbconnection))
                    {
                        while (dataReader.Read())
                        {
                            oidEnums.Add(new OidEnum
                            {
                                Id   = DatabaseFunctions.GetDouble(dataReader, 1).ToString(),
                                Name = DatabaseFunctions.GetString(dataReader, 2)
                            });
                        }
                    }
                }
            }
            return(oidEnums);
        }
コード例 #2
0
ファイル: MibDAL.cs プロジェクト: SkyBulk/Threat-Intelligence
        public OidEnums GetEnums(string enumName)
        {
            OidEnums oidEnums = new OidEnums();

            if (string.IsNullOrEmpty(enumName))
            {
                return(oidEnums);
            }
            using (OleDbConnection dbConnection = MibHelper.GetDBConnection())
            {
                dbConnection.Open();
                using (OleDbCommand oleDbCommand = new OleDbCommand())
                {
                    oleDbCommand.CommandText = string.Format("Select {0} from Enums WHERE Name=@name order by Value;", (object)"Name, Value, Enum");
                    oleDbCommand.Parameters.AddWithValue("name", (object)enumName);
                    using (IDataReader dataReader = OleDbHelper.ExecuteReader(oleDbCommand, dbConnection))
                    {
                        while (dataReader.Read())
                        {
                            OidEnum oidEnum = new OidEnum();
                            oidEnum.set_Id(DatabaseFunctions.GetDouble(dataReader, 1).ToString());
                            oidEnum.set_Name(DatabaseFunctions.GetString(dataReader, 2));
                            ((Collection <string, OidEnum>)oidEnums).Add((object)oidEnum);
                        }
                    }
                }
            }
            return(oidEnums);
        }