• 大小: 4.26MB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2023-08-14
  • 语言: 数据库
  • 标签: oralce  T4模板  

资源简介

T4模板生成多个文件的model类 适用于oracle数据库

资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Oracle.ManagedDataAccess.Client;
using System.Data;

namespace T4temple
{
    public class Config
    {
        public static readonly string DatabaseType = “Oracle“;

        public static string ConnectionString = “Data Source=(DEscriptION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.236)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));User Id=clcrm;Password=clcrm;“;

        public static readonly string TablePrefix = “OA_“;
    }

    public class Column
    {
        DataColumn columnbase;

        public Column(DataColumn columnbase)
        {
            this.columnbase = columnbase;
        }


        public string ColumnName { get { return this.columnbase.ColumnName; } }

        public string MaxLength { get { return this.columnbase.MaxLength.ToString(); } }


        public string TypeName
        {
            get
            {
                string result = string.Empty;
                result = this.columnbase.DataType.Name;
                return result;
            }
        }


        public string DBType
        {
            get
            {
                DbType dbt;
                try
                {
                    dbt = (DbType)Enum.Parse(typeof(DbType) this.columnbase.DataType.Name);
                }
                catch
                {
                    dbt = DbType.object;
                }
                return dbt.ToString();
            }
        }


        public bool AllowDBNull { get { return this.columnbase.AllowDBNull; } }

        public string UpColumnName
        {
            get
            {
                return string.Format(“{0}{1}“ this.ColumnName[0].ToString().ToUpper() this.ColumnName.Substring(1).ToLower());
            }
        }

        public string LowerColumnName
        {
            get
            {
                return string.Format(“{0}{1}“this.ColumnName[0].ToString().ToLower()this.ColumnName.Substring(1));
            }
        }
    }

    public class Table
    {
        public Table(DataTable t)
        {
            this.PKs = this.GetPKList(t);
            this.Columns = this.GetColumnList(t);
            this.ColumnTypeNames = this.SetColumnNames();
        }

        public List PKs;

        public string TableName { get; set; }

        public List Columns;

        public string ColumnTypeNames;

        public Column FirstPK
        {
            get
            {
                return this.PKs[0];
            }
        }

        public string EntityName
        {
            get
            {
                string result = this.TableName;
                string tablePrefix = Config.TablePrefix;
                if (this.TableName.StartsWith(tablePrefix))
                {
                    result = this.TableName.Substring(tablePref

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件    4055552  2016-12-13 13:15  T4temple\T4temple\bin\Debug\Oracle.ManagedDataAccess.dll

     文件      63488  2016-12-13 14:16  T4temple\T4temple\bin\Debug\T4temple.exe

     文件     108032  2016-12-13 14:16  T4temple\T4temple\bin\Debug\T4temple.pdb

     文件      24216  2016-12-13 14:18  T4temple\T4temple\bin\Debug\T4temple.vshost.exe

     文件       7211  2016-12-13 14:16  T4temple\T4temple\DBSchema.cs

     文件       7401  2016-12-13 14:08  T4temple\T4temple\DBSchema.ttinclude

     文件    4055552  2016-12-13 13:15  T4temple\T4temple\lib\Oracle.ManagedDataAccess.dll

     文件       4638  2016-12-13 11:31  T4temple\T4temple\MultiDocument.ttinclude

     文件         25  2016-12-13 14:08  T4temple\T4temple\MultModelAuto.cs

     文件       2296  2016-12-13 14:08  T4temple\T4temple\MultModelAuto.tt

     文件        963  2016-12-13 14:08  T4temple\T4temple\OA_AGENCY.cs

     文件        802  2016-12-13 14:08  T4temple\T4temple\OA_AGENCYHIS.cs

     文件       2215  2016-12-13 14:08  T4temple\T4temple\OA_BANK.cs

     文件       1586  2016-12-13 14:08  T4temple\T4temple\OA_COMMUNICATE.cs

     文件       1952  2016-12-13 14:08  T4temple\T4temple\OA_COMPANY.cs

     文件       2535  2016-12-13 14:08  T4temple\T4temple\OA_CONTACT.cs

     文件       2183  2016-12-13 14:08  T4temple\T4temple\OA_FINACE.cs

     文件       1615  2016-12-13 14:08  T4temple\T4temple\OA_FOLLOW.cs

     文件       1702  2016-12-13 14:08  T4temple\T4temple\OA_INFO.cs

     文件       2140  2016-12-13 14:08  T4temple\T4temple\OA_INFOSETTING.cs

     文件       1315  2016-12-13 14:08  T4temple\T4temple\OA_MENUS.cs

     文件        447  2016-12-13 14:08  T4temple\T4temple\OA_MENUSPART.cs

     文件       1463  2016-12-13 14:08  T4temple\T4temple\OA_OAFILE.cs

     文件       2101  2016-12-13 14:08  T4temple\T4temple\OA_OALOG.cs

     文件       1060  2016-12-13 14:08  T4temple\T4temple\OA_PART.cs

     文件       1481  2016-12-13 14:08  T4temple\T4temple\OA_PLAN.cs

     文件       1186  2016-12-13 14:08  T4temple\T4temple\OA_SECTORS.cs

     文件       2905  2016-12-13 14:08  T4temple\T4temple\OA_SETTING.cs

     文件       1904  2016-12-13 14:08  T4temple\T4temple\OA_SIGN.cs

     文件       1010  2016-12-13 14:08  T4temple\T4temple\OA_SIGNFOLLOW.cs

............此处省略39个文件信息

评论

共有 条评论