fy"> {= Convert.ToInt32 (tab.Rows [0] [0]. ToString ());
} (code> 0)
{. CommandText=«begin PROCEDURE_INS_COPY (« »+ isbn +« »,« »+ numericUpDown1.Value +« »,« »+ dateTimePicker1. Value.ToShortDateString () + «», «» + code +" "); end; »;. ExecuteNonQuery ();
}
{= new DataTable ();. CommandText=«begin PROCEDURE_INS_PLACE (« »+ comboBox1.Items [comboBox1.SelectedIndex]. ToString () +« »,« » +. Items [comboBox2.SelectedIndex]. ToString () + «», «» +. Items [comboBox3.SelectedIndex]. ToString () + «», «» + textBox2.Text + « ; »); end; »;. ExecuteNonQuery ();. CommandText =« select max (" plCode ") from " Place " »;. Load (Comand.ExecuteReader ());=Convert.ToInt32 (tab. Rows [0] [0]);. CommandText=«begin PROCEDURE_INS_COPY (« »+ isbn +« »,« »+ numericUpDown1.Value +« »,« »+ dateTimePicker1. Value.ToShortDateString () + «», «» + code +" "); end; »;. ExecuteNonQuery ();
}. Show («Примірник книги зареєстрований»);
}
{Comand=OC.CreateCommand (); tab=new DataTable (); (comboBox1.SelectedIndex == - 1 | | comboBox2.SelectedIndex == - 1 | |. SelectedIndex == - 1 | | textBox2.Text == null | | textBox2.Text =="")
{. Show («Заповніть всі поля!");;
} (DateTime.Compare (dateTimePicker1.Value, DateTime.Now)> 0)
{. Show («Дата поставки не може перевищувати поточну дату»);;
}. CommandText=«begin PROCEDURE_EDIT_COPY (« »+ cNumber +« »,« »+ numericUpDown1.Value +« », '» + dateTimePicker1.Value . ToShortDateString () +
««, »» + ComboBox1.Items [comboBox1.SelectedIndex]. ToString () + ««, »» + ComboBox2.Items [comboBox2.SelectedIndex]. ToString () + ««, »» + ComboBox3.Items [comboBox3.SelectedIndex]. ToString () +
««, »» + textBox2.Text + «'); end; »;. ExecuteNonQuery ();. Show (« Зміни збережені »);. Close ();
}
} void AddCopy_Load (object sender, EventArgs e)
{. Text=isbn; Comand=OC.CreateCommand (); tab=new DataTable ();. CommandText=«select " bName " from " Book " where ISBN=( select to_char («» + isbn +" ") from dual) »;. Load (Comand.ExecuteReader ());. Text=tab.Rows [0] [0]. ToString (); (bflag )
{= new DataTable ();. CommandText=«select C. " cCost " , C. " cDate " , P. " plSection " , P. " plRack " , P. " plShelf " , P. " plSector " » +
«from " Copy " C inner join " Place " P on C. " plCode " = P. " plCode " where C. " cNumber " = (select to_number («» + cNumber +" ") from dual) »;. Load (Comand.ExecuteReader ());. Value=Convert.ToDecimal (tab.Rows [0] [0]); . Value=Convert.ToDateTime (tab.Rows [0] [1]); (int i=0; i
{(comboBox1.Items [i]. ToString () == tab.Rows [0] [2]. ToString ())
{. SelectedIndex=i;;
}
} (int i=0; i
{(comboBox2.Items [i]. ToString () == tab.Rows [0] [3]. ToString ())
{. SelectedIndex=i;;
}
} (int i=0; i
{(comboBox3.It...
