/// <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();
}
static void TestOracleRaw()
{
//byte b = Convert.ToByte("01", 16);
OracleDataBase db = new OracleDataBase("User Id=bpi;Password=yuantacps;Data Source=TS02G");
DataTable dt = db.QueryCommand("SELECT * FROM ptDeptRiskCtrl");
if (dt != null && dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
byte[] rawData = (byte[])(row["PTDeptAuthID"]);
string strRaw = AbstractDataBase.RawToString(rawData);
byte[] raw2 = AbstractDataBase.StringToRaw(strRaw);
System.Diagnostics.Debug.Assert(rawData.Length == raw2.Length);
for (int index = 0; index < raw2.Length; ++index)
{
System.Diagnostics.Debug.Assert(rawData[index] == raw2[index]);
}
string tmps = db.FieldToSQL(new OracleRowID(strRaw));
}
db.Close();
}
public static void TestConcurrentOracle()
{
conDB = new OracleDataBase("User Id=bpi;Password=yuantacps;Data Source=TS03");
List <Thread> listThread = new List <Thread>();
for (int i = 0; i < 3; i++)
{
Thread t = new Thread(OracelAccessThread);
t.IsBackground = true;
t.Start();
listThread.Add(t);
}
foreach (Thread t in listThread)
{
t.Join();
}
conDB.Close();
}
