-
大小: 4.26MB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-08-14
- 語言: 數(shù)據(jù)庫
- 標(biāo)簽: oralce??T4模板??
資源簡(jiǎn)介
T4模板生成多個(gè)文件的model類
適用于oracle數(shù)據(jù)庫

代碼片段和文件信息
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
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????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個(gè)文件信息
評(píng)論
共有 條評(píng)論