private void labelRentalClick(object sender, EventArgs e)
{
this.Visible = false;
FormEmployRental frm = new FormEmployRental(mainform, id);
frm.Owner = this;
frm.Show();
frm.Activate();
}
private void buttonPreClick(object sender, EventArgs e)
{
oracleConnection1.Open();
string st = "item_id='" + itemID + "'";
DataRow[] foundRows = RentalTable.Select(st);
int count = 0;
foreach (DataRow mydataRow in foundRows)
{
count = int.Parse(mydataRow["ren_count"].ToString());
}
count++;
for (int i = 0; i < itemName.Count; i++)
{
string str = "item_id='" + itemID[i] + "'";
DataRow[] foundRows2 = StockTable.Select(str);
int num = 0;
List <string> loc = new List <string>();
foreach (DataRow mydataRow2 in foundRows2)
{
num = int.Parse(mydataRow2["sto_NUM"].ToString());
loc.Add(mydataRow2["sto_loc"].ToString());
}
string str2 = "sto_num='" + num + "' AND sto_loc='" + loc[loc.Count - 1] + "' AND item_id='" + itemID[i] + "'";
oracleCommand1.CommandText = "update stock set sto_NUM='" + (num - 1) + "' where " + str2;
oracleCommand1.ExecuteNonQuery();
DateTime now = DateTime.Now;
string date = now.Year + "-" + now.Month + "-" + now.Day;
oracleCommand2.CommandText = "insert into rental values('" + consuID + "','" + itemID[i] + "','" + cateID[i] + "','" + id + "','" + TotalMoney[i] + "',TO_DATE('" + date + "', 'YYYY-MM-DD'),'F','" + count + "','" + num + "')";
oracleCommand2.ExecuteNonQuery();
}
MessageBox.Show("대출이 완료 되었습니다");
oracleConnection1.Close();
this.Visible = false;
rentalForm.F5(sender, e);
rentalForm.Activate();
Reservation(itemID, consuID, cateID);
}