private void buttonReservation_Click(object sender, EventArgs e) { oracleConnection1.Open(); oracleCommand1.CommandText = "insert into item values('" + textBoxID.Text + "','" + comboBoxCate.SelectedItem + "','" + textBoxName.Text + "','" + textBoxPrice.Text + "','" + textBoxMileage.Text + "')"; oracleCommand1.ExecuteNonQuery(); oracleCommand2.CommandText = "insert into description values('" + textBoxID.Text + "','" + comboBoxCate.SelectedItem + "','" + textBox1.Text + "')"; oracleCommand2.ExecuteNonQuery(); stockTableAdapter1.Fill(dataSet11.STOCK); StockTable = dataSet11.Tables["STOCK"]; string str = "item_id='" + textBoxID.Text + "'"; DataRow[] foundRows = StockTable.Select(str); string stock = "1"; foreach (DataRow mydataRow in foundRows) { stock = mydataRow["sto_stock"].ToString(); } DateTime day = dateTimePicker1.Value; string date = day.Year + "-" + day.Month + "-" + day.Day; oracleCommand3.CommandText = "insert into stock values ('" + textBoxID.Text + "','" + comboBoxCate.SelectedItem + "','" + stock + "',to_date('" + date + "','YYYY-MM-DD'),'" + textBoxLoc.Text + "','" + textBoxState.Text + "','" + textBoxStock.Text + "')"; oracleCommand3.ExecuteNonQuery(); MessageBox.Show("물건이 추가되었습니다"); this.Visible = false; itemForm.Activate(); oracleConnection1.Close(); itemForm.F5(sender, e); }
private void label3_Click(object sender, EventArgs e) { this.Visible = false; FormAdminItemItem frm = new FormAdminItemItem(mainform); frm.Owner = this; frm.Show(); frm.Activate(); }
private void button1_Click(object sender, EventArgs e) { this.Visible = false; itemForm.Activate(); }