using?System.Text;
using?FS.Core.Model;

namespace?FS.Core.Bean
{
????///?

????///?????Oracle數據庫Sql生成
????///?

????///?
????internal?class?OracleBuilder?:?DbBuilder?where?TInfo?:?ModelInfo?new（）
????{
????????///?

????????///?????Oracle數據庫Sql生成
????????///?

????????///?表名稱
????????internal?OracleBuilder（string?tableName?=?““）
????????????:?base（tableName）
????????{
????????????TableName?=?dbProvider.CreateTableAegis（TableName）;
????????}

????????public?override?string?ToInfo（）
????????{
????????????if?（WhereString.Length?==?0）?{?WhereString.Append（“WHERE?“）;?}
????????????else?{?WhereString.Append（“?AND?“）;?}

????????????return?string.Format（“select?{0}?from?{1}?{2}?rownum?<=1?{3};“?GetFields（）?TableName?WhereString?SortString）;
????????}

????????public?override?string?GetValue（）
????????{
????????????if?（WhereString.Length?==?0）???{?WhereString.Append（“WHERE?“）;????}
????????????else?{?WhereString.Append（“?AND?“）;????}

????????????return?string.Format（“SELECT?{0}?FROM?{1}?{2}?rownum?<=1?{3};“?GetFields（）?TableName?WhereString
?????????????????????????????????SortString）;
????????}

????????public?override?string?ToTable（int?pageSize?int?pageIndex）
????????{
????????????if?（pageIndex?==?1）????{?return?ToTable（pageSize）;????}

????????????return?string.Format（
????????????????????“SELECT?*?FROM?（?SELECT?A.*?ROWNUM?RN?FROM?（SELECT?{0}?FROM?{3}?{4}?{5}）?A?WHERE?ROWNUM?<=?{2}?）?WHERE?RN?>?{1};“
????????????????????GetFields（）?pageSize?*?（pageIndex?-?1）?pageSize?*?pageIndex?TableName?WhereString?SortString）;
????????}

????????public?override?string?ToTable（int?top?=?0）
????????{
????????????var?strFields?=?SelectString.Length?==?0???“*“?:?SelectString.ToString（）;

????????????var?topString?=?new?StringBuilder（）;
????????????if?（top?>?0）
????????????{
????????????????if?（WhereString.Length?>?0）???{??topString.Append（“?AND?“）;??}
????????????????topString.Append（string.Format（“ROWNUM?<=?{0}“?top））;
????????????}
????????????return?string.Format（“SELECT?{0}?FROM?{1}?{2}?{3}?{4};“?GetFields（）?TableName?WhereString?topString
?????????????????????????????????SortString）;
????????}

????????public?override?string?ToTableByRand（int?top?=?0）
????????{
????????????var?topString?=?top?>?0???string.Format（“WHERE?ROWNUM?<=?{0}“?top）?:?string.Empty;
????????????return?string.Format（“SELECT?*?FROM?（SELECT?{0}?FROM?{1}?{2}?ORDER?BY?dbms_random.value）?{3};“?GetFields（）
?????????????????????????????????TableName?WhereString?topString）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-05-06?15:27??OracleHelper\
?????目錄???????????0??2017-05-06?15:27??OracleHelper\Oracle\
?????文件?????1433600??2015-11-26?17:19??OracleHelper\Oracle.DataAccess.dll
?????文件????????2656??2015-04-09?19:34??OracleHelper\OracleBuilder.cs
?????文件???????31641??2014-05-20?21:39??OracleHelper\OracleHelper.cs
?????文件????????1107??2015-04-09?19:34??OracleHelper\OracleOperate.cs
?????文件?????????619??2015-04-09?19:34??OracleHelper\OracleProvider.cs
?????文件????????4941??2015-04-09?19:34??OracleHelper\OracleVisit.cs
?????文件????????6865??2015-04-09?19:34??OracleHelper\Oracle\expressionBool.cs
?????文件?????????278??2015-04-09?19:34??OracleHelper\Oracle\expressionNew.cs
?????文件?????????619??2015-04-09?19:34??OracleHelper\Oracle\OracleProvider.cs
?????目錄???????????0??2017-05-06?15:27??OracleHelper\Oracle\SqlQuery\
?????文件????????1093??2015-04-09?19:34??OracleHelper\Oracle\SqlQuery\SqlQueryProc.cs
?????文件????????3836??2015-04-09?19:34??OracleHelper\Oracle\SqlQuery\SqlQueryTable.cs
?????文件????????7267??2015-04-09?19:34??OracleHelper\Oracle\SqlQuery\SqlQueryView.cs
?????文件????????8148??2015-02-06?00:57??OracleHelper\PdmReader.Oracle.cs