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();
}
/// <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();
}
private void Client_Load(object sender, EventArgs e)
{
OracleDataBase db = new OracleDataBase();
db.loadQueryToGDV(dgv_client, "select u.UserId, UserPassword, Admin, Email, FirstName, LastName, Adresse, Phone, BrithDay " +
"from Users u,User_Details ud where ud.UserId (+)= u.UserId");
}
public static void TestRO()
{
//OracleDataBase db = new OracleDataBase("User Id=system;Password=spmll1l3x96;Data Source=XE80");
OracleDataBase db = new OracleDataBase("User Id=bpi;Password=yuantacps;Data Source=TS03");
OracleDAOTestOperator opr = new OracleDAOTestOperator(db);
OracleDAOTestRecord record = new OracleDAOTestRecord();
record.ID = 13;
record.Name = "Justin 13";
record.ModifyDate = new DateTime(2011, 1, 1);
int effectedRows = 0;
opr.Insert(record, ref effectedRows);
}
private void btn_ok_Click(object sender, EventArgs e)
{
//test if the fields
OracleDataBase db = new OracleDataBase();
Tables.User_Details user_Details = new Tables.User_Details(txb_user_name.Text, txb_email.Text, txb_first_name.Text,
txb_last_name.Text, txb_adresse.Text, txb_phone_number.Text, DateTime.Parse(dtp_brith_day.Text), false);
Tables.Users user = new Tables.Users(txb_user_name.Text, txb_password.Text, cb_admin.Checked);
db.addClientWithDetails(user, user_Details);
clearTextBoxes();
//test if the fields is not null
//add client if note exist else update with comfirmation msg
//get user detail by id for modify
}
private void btn_ok_Click(object sender, EventArgs e)
{
List <Image> pics = new List <Image>();
foreach (PictureBox pic in panel_car_pics.Controls)
{
pics.Add(pic.Image);
}
//test if the fields is not null
OracleDataBase db = new OracleDataBase();
Tables.Car car = new Tables.Car(txb_matricule.Text, txb_name.Text, txb_color.Text, type_car, Convert.ToDouble(txb_km.Text));
Tables.CarPictures carPictures = new Tables.CarPictures(txb_matricule.Text, pics);
db.addCar(car, carPictures);
//add client if note exist else update with comfirmation msg
//get user detail by id for modify
}
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();
}
private void Contrat_Load(object sender, EventArgs e)
{
OracleDataBase db = new OracleDataBase();
db.loadQueryToGDV(dgv_contrat, "select * from Contrat");
}
private void Car_Load(object sender, EventArgs e)
{
OracleDataBase db = new OracleDataBase();
db.loadQueryToGDV(dgv_car, "select * from Car c, CarPictures cp where c.Matricule = cp.Matricule");
}
public ProjUnitDao(OracleDataBase db)
{
this.odb = db;
}
