void GetFromDBDatas()
{
string sql = string.Format("select {0} from {1}", string.Join(",", Task.From.Columns), Task.From.Table);
if (!string.IsNullOrEmpty(Task.From.Sequence))
{
fixSeqValue = FixSeqValue(Task.From.SeqValue);
if (fixSeqValue.Trim('\'') != "")
{
sql = string.Format("{0} where {1} > {2}", sql, Task.From.Sequence, fixSeqValue);
}
sql = string.Format("{0} order by {1}", sql, Task.From.Sequence);
}
//限制每次最多复制500条数据
// sql = sql + " fetch first 500 rows only";
OracleConPara para = new OracleConPara()
{
HostName = Task.From.HostName,
Password = Task.From.Password,
Port = Task.From.Port,
ServiceName = Task.From.ServiceName,
UserID = Task.From.UserID
};
if (DbType == "db2")
{
DB2DynamicDataCatcher db2 = new DB2DynamicDataCatcher(Task.From.Table, para, sql);
entities = db2.GetEntities();
}
else if (DbType == "oracle")
{
OracleDynamicDataCatcher oracle = new OracleDynamicDataCatcher(Task.From.Table, para, sql);
entities = oracle.GetEntities();
}
else if (DbType == "sqlserver")
{
MsDynamicDataCatcher ms = new MsDynamicDataCatcher(Task.From.Table, para, sql);
entities = ms.GetEntities();
}
}
public OracleDynamicDataCatcher(string tableName, OracleConPara para, string sql)
{
entities = new DBDynamicEntities(tableName, new List <string>());
Para = para;
_sql = sql;
}
public OracleDynamicDataCatcher(string tableName, List <string> columns, OracleConPara para)
{
entities = new DBDynamicEntities(tableName, columns);
Para = para;
}
