DBTool for Oracle - Part 1

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using Harlinn.Oracle.DBTool.Types.Common;
using Harlinn.Oracle.DBTool.Utils.DB;

namespace Harlinn.Oracle.DBTool.Types.Database
{
    public class DBUserTableIndexColumn : DBElement
    {
        private static readonly log4net.ILog sfLog = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        private static void LogException(Exception exc, System.Reflection.MethodBase method)
        {
            Logger.LogException(sfLog, exc, method);
        }

        private string indexOwner;
        private string indexName;
        private string tableOwner;
        private string tableName;
        private string columnName;
        private decimal columnPosition;
        private decimal columnLength;
        private decimal? charLength;
        private string descend;

        private WeakReference fieldReference;

        public DBUserTableIndexColumn()
        {
            
        }
        public DBUserTableIndexColumn(DBUserTableIndexColumns parent, IndexColumnsReader reader)
            : base(parent, reader.ColumnName)
        {
            this.indexOwner = reader.IndexOwner;
            this.indexName = reader.IndexName;
            this.tableOwner = reader.TableOwner;
            this.tableName = reader.TableName;
            this.columnName = reader.ColumnName;
            this.columnPosition = reader.ColumnPosition;
            this.columnLength = reader.ColumnLength;
            this.charLength = reader.CharLength;
            this.descend = reader.Descend;
        }

        public override DBElementType ElementType
        {
            get 
            {
                return DBElementType.UserTableIndexColumn;
            }
        }

        [Browsable(false)]
        public DBUserTableIndexColumns Columns
        {
            get
            {
                DBUserTableIndexColumns result = (DBUserTableIndexColumns)Parent;
                return result;
            }
        }


        public DBField GetField()
        {
            if (fieldReference == null)
            {
                DBFields fields = Columns.Index.Indexes.Table.GetChildByName<DBFields>("Fields");
                if (fields != null)
                {
                    DBField field = fields[Name];
                    if (field != null)
                    {
                        fieldReference = new WeakReference(field);
                        return field;
                    }
                }
                return null;
            }
            return (DBField)fieldReference.Target;
        }


        public string IndexOwner
        {
            get
            {
                return indexOwner;
            }
            set
            {
                indexOwner = value;
            }
        }


        public string IndexName
        {
            get
            {
                return indexName;
            }
            set
            {
                indexName = value;
            }
        }


        public string TableOwner
        {
            get
            {
                return tableOwner;
            }
            set
            {
                tableOwner = value;
            }
        }


        public string TableName
        {
            get
            {
                return tableName;
            }
            set
            {
                tableName = value;
            }
        }


        public string ColumnName
        {
            get
            {
                return columnName;
            }
            set
            {
                columnName = value;
            }
        }


        public decimal ColumnPosition
        {
            get
            {
                return columnPosition;
            }
            set
            {
                columnPosition = value;
            }
        }


        public decimal ColumnLength
        {
            get
            {
                return columnLength;
            }
            set
            {
                columnLength = value;
            }
        }


        public decimal? CharLength
        {
            get
            {
                return charLength;
            }
            set
            {
                charLength = value;
            }
        }


        public string Descend
        {
            get
            {
                return descend;
            }
            set
            {
                descend = value;
            }
        }

    }
}