columninfo.cs

oracle dal gen,生成.NET ORACLE DAL层代码

using System;
using System.Collections.Generic;
using System.Text;
using Oracle.DataAccess.Client;

using OracleDALGen.Classes.Attributes;
using System.Data;

namespace OracleDALGen.Classes.Generator
{
    [ClassDatabaseType("select * from table_info where table_name = :p_table_name and pk = 1", Method.Select, CommandType.Text)]
    public class ColumnInfo {
        
        private string tableName;        
        private string columnName;        
        private string dataType;        
        private decimal fk;        
        private decimal pk;
        private decimal position;
        private string refColumnName;
        private string refTableName;
        private string refConstraintName;

        private List<ColumnInfo> links = new List<ColumnInfo>();
        
        [OracleDALGen.Classes.IdColumn("TABLE_NAME")]
        public virtual string TableName {
            get {
                return this.tableName;
            }
            set {
                this.tableName = value;
            }
        }

        [OracleDALGen.Classes.DbColumn("COLUMN_NAME")]
        public virtual string ColumnName {
            get {
                return this.columnName;
            }
            set {
                this.columnName = value;
            }
        }
        
        [OracleDALGen.Classes.DbColumn("DATA_TYPE")]
        public virtual string DataType {
            get {
                return this.dataType;
            }
            set {
                this.dataType = value;
            }
        }
        
        [OracleDALGen.Classes.DbColumn("FK")]
        public virtual decimal Fk {
            get {
                return this.fk;
            }
            set {
                this.fk = value;
            }
        }
        
        [OracleDALGen.Classes.DbColumn("PK")]
        public virtual decimal Pk {
            get {
                return this.pk;
            }
            set {
                this.pk = value;
            }
        }

        [OracleDALGen.Classes.DbColumn("POSITION")]
        public virtual decimal Position
        {
            get
            {
                return this.position;
            }
            set
            {
                this.position = value;
            }
        }

        [OracleDALGen.Classes.DbColumn("r_constraint_name")]   
        public virtual string RefConstraintName
        {
            get
            {
                return this.refConstraintName;
            }
            set
            {
                this.refConstraintName = value;
            }
        }

        [OracleDALGen.Classes.DbColumn("r_table_name")]
        public virtual string RefTableName
        {
            get
            {
                return this.refTableName;
            }
            set
            {
                this.refTableName = value;
            }
        }

        [DbColumn("r_column_name")]
        public virtual string RefColumnName
        {
            get
            {
                return this.refColumnName;
            }
            set
            {
                this.refColumnName = value;
            }
        }

        //[ListColumn("TABLE_NAME", "R_TABLE_NAME", "select * from table_info where r_table_name = :p_table_name", Method.Select, CommandType.Text, typeof(ColumnInfo), OracleDbType.Decimal)]
        [ListColumn("TABLE_NAME,COLUMN_NAME", "R_TABLE_NAME,R_CONSTRAINT_NAME", "select * from table_info where r_table_name = :p_table_name and r_column_name = :p_table_name", Method.Select, CommandType.Text, typeof(ColumnInfo), OracleDbType.Decimal)]
        public virtual List<ColumnInfo> Links
        {
            get { return links; }
            set { links = value; }
        }
     }
}