/// <summary>
/// 測試連接Oracle資料庫
/// </summary>
public static void TestYuantaOracle()
{
OracleDataBase db = new OracleDataBase("User Id=bpi;Password=yuantacps;Data Source=TS03");
PTTradingUnitOperator opr = new PTTradingUnitOperator(db);
//int totalRecords = opr.Select(null);
//foreach (PTTradingUnitRecord record in opr.RecordList)
//{
// Console.WriteLine( record.PTCorpID + "," + record.PTCostCenter + "," + record.PTCustID + "," + record.PTDeptID +
// "," + record.PTTradeGoal + "," + record.PTUserID );
//}
foreach (PTTradingUnitRecord record in opr.SelectIterator(null))
{
Console.WriteLine(record.PTCorpID + "," + record.PTCostCenter + "," + record.PTCustID + "," + record.PTDeptID +
"," + record.PTTradeGoal + "," + record.PTUserID);
}
string[] corpID = opr.SelectFields <string>("ptCorpID", false, 10, null, AbstractOperator <PTTradingUnitRecord> .ConvertFirstColumn <string>);
foreach (string cid in corpID)
{
Console.WriteLine(cid);
}
int totalCount = opr.SelectCount(null);
Console.WriteLine("TotalCount " + totalCount);
db.Close();
}
protected static void OracelAccessThread()
{
PTTradingUnitOperator opr = new PTTradingUnitOperator(conDB);
int counter = 100;
while (counter-- > 0)
{
int totalRecords = opr.Select(null);
Console.WriteLine(Thread.CurrentThread.ManagedThreadId.ToString() + "," + opr.RecordList.Count);
}
}