资源简介
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个文件信息
评论
共有 条评论