using?System;
using?System.Text;
using?CodeSmith.Engine;
using?SchemaExplorer;
using?System.ComponentModel;
using?System.Data;
namespace?Common.Data
{
????////?

????///?CodeSmith生成SQL?Server視圖的實體類腳本
????///?

????public?class?ViewUtility
????{
????????//get?Columns?info?by?TableName
????????public?ViewColumnSchemaCollection?GetColumnCollectionByTable（ViewSchema?table）
????????{
????????????ViewColumnSchemaCollection?columns?=?new?ViewColumnSchemaCollection（table.Columns）;
????????????return?columns;
????????}
????????//Get?camelcase?namesuch?as?Customer
????????public?string?GetCamelCaseName（string?str）
????????{
????????????return?str.Substring（0?1）.ToUpper（）?+?str.Substring（1）;
????????}
????????//Get?userprivate?const?String?USER_FIELD?=?“User“
????????public?string?GetMemberConstantDeclarationStatement（ColumnSchema?column）
????????{
????????????return?GetMemberConstantDeclarationStatement（“public?const?String?“?column）;
????????}
????????//such?as?public?const?String?USER_TABLE?=?“User“
????????public?string?GetTableConstantDeclarationStatement（ViewSchema?table）
????????{
????????????return?GetMemberConstantDeclarationStatement（“public?const?String?“?table）;
????????}
????????//suck?as?USER_TABLE
????????public?string?GetUpperStatement（ViewSchema?table）
????????{
????????????return?table.Name.ToUpper（）?+?“_TABLE“;
????????}
????????//suck?as?USER_FIELD
????????public?string?GetUpperStatement（ColumnSchema?column）
????????{
????????????return?column.Name.ToUpper（）?+?“_FIELD“;
????????}
????????//?such?as?USER_TABLE?=?“User“
????????public?string?GetMemberConstantDeclarationStatement（string?protectionLevel?ViewSchema?table）
????????{
????????????return?protectionLevel?+?GetUpperStatement（table）?+?“?=?“?+?GetCamelCaseName（table.Name）?+?““;
????????}
????????//such?as?USERID_FIELD?=?“Userid“
????????public?string?GetMemberConstantDeclarationStatement（string?protectionLevel?ColumnSchema?column）
????????{
????????????return?protectionLevel?+?GetUpperStatement（column）?+?“?=?“?+?GetCamelCaseName（column.Name）?+?““;
????????}
????????public?string?GetCSharpVariableType（ViewColumnSchema?column）
????????{
????????????switch?（column.DataType）
????????????{
????????????????case?DbType.AnsiString:?return?“string“;
????????????????case?DbType.AnsiStringFixedLength:?return?“string“;
????????????????case?DbType.Binary:?return?“byte[]“;
????????????????case?DbType.Boolean:?return?“bool“;
????????????????case?DbType.Byte:?return?“int“;
????????????????case?DbType.Currency:?return?“decimal“;
????????????????case?DbType.Date:?return?“DataTime“;
????????????????case?DbType.DateTime:?return?“DateTime“;
????????????????case?DbType.Decimal:?return?“decimal“;
????????????????case?DbType.Double:?return?“double“;
????????????????case?DbType.Guid:?return?“Guid“;
????????????????case?DbType.Int16:?return?“short“;
????????????????case?DbType.Int32:?return?“int“;
????????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-10-21?23:08??Egert_SanGong\
?????目錄???????????0??2019-08-26?23:31??Egert_SanGong\Egert_SanGong\
?????目錄???????????0??2019-08-26?23:31??Egert_SanGong\Egert_SanGong\.idea\
?????文件?????????469??2019-08-26?23:31??Egert_SanGong\Egert_SanGong\.idea\Egert_SanGong.iml
?????文件?????????179??2019-08-26?23:31??Egert_SanGong\Egert_SanGong\.idea\misc.xml
?????文件?????????285??2019-08-26?23:31??Egert_SanGong\Egert_SanGong\.idea\modules.xml
?????文件????????2204??2019-09-19?23:19??Egert_SanGong\Egert_SanGong\.idea\workspace.xml
?????目錄???????????0??2018-11-22?23:22??Egert_SanGong\Egert_SanGong\.wing\
?????文件?????????169??2018-11-22?16:52??Egert_SanGong\Egert_SanGong\.wing\exml.json
?????文件?????????672??2018-11-22?23:22??Egert_SanGong\Egert_SanGong\.wing\launch.json
?????文件??????????76??2018-11-18?23:06??Egert_SanGong\Egert_SanGong\.wing\settings.json
?????文件?????????637??2018-11-22?23:22??Egert_SanGong\Egert_SanGong\.wing\tasks.json
?????目錄???????????0??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\
?????文件????????2998??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\AssetAdapter.js
?????文件????????1144??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\AssetAdapter.js.map
?????目錄???????????0??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\
?????文件????????1441??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\AlertVerTsFromc.js
?????文件?????????790??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\AlertVerTsFromc.js.map
?????文件?????????545??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\base64.js
?????文件?????????351??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\base64.js.map
?????文件?????????989??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\ByteArrayReader.js
?????文件?????????916??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\ByteArrayReader.js.map
?????文件????????1039??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\CookieOperation.js
?????文件?????????540??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\CookieOperation.js.map
?????文件????????1231??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\Dictionary.js
?????文件????????1084??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\Dictionary.js.map
?????文件????????1015??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\Dl_hallplayerinfo.js
?????文件?????????582??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\Dl_hallplayerinfo.js.map
?????文件?????????514??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\GErrorInfo.js
?????文件?????????324??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\GErrorInfo.js.map
?????文件?????????416??2018-11-23?08:33??Egert_SanGong\Egert_SanGong\bin-debug\comClass\GMessage.js
............此處省略1939個文件信息