mmandText=«SELECT B. * FROM " Book " B INNER JOIN " Copy " C ON B.ISBN=C.ISBN AND B.ISBN=(select to_char («» + dataGridView1 [0, e.RowIndex]. Value +" ") from dual) AND C. " cLost "= 0 AND C. " woCode " IS NULL » +
«INNER JOIN " Issuance " I ON I. " cNumber " = C. " cNumber " AND I. " iFactReturn " IS NULL» +
«INNER JOIN " Reader " R ON R. " rNumber " = I. " rNumber " AND R. " rNumber " = (select to_number (« » ; + AR.rNumber +" ") from dual) »;. Load (Comand.ExecuteReader ()); (tab.Rows.Count!=0)
{. Show («Ви вже вибрали цю книгу»);
}=new DataTable ();. CommandText=«SELECT C. " cNumber " AS Номер, P. " plSection " AS Відділ, P. " plRack " AS Стелаж , P. " plShelf " AS Полка, P. " plSector " AS Сектор » +
«FROM " Book " B INNER JOIN " Copy " C ON B.ISBN=C.ISBN AND B.ISBN=(select to_char (« »+ dataGridView1 [0 , e.RowIndex]. Value +" ") from dual) AND C. " cLost "=0 AND C. " woCode " IS NULL » +
«INNER JOIN " Place " P ON C. " plCode " = P. " plCode " » +
«where (select count (I. " iNumber " ) from " Issuance " I where I. " cNumber " = C. " cNumber " GROUP by C. " cNumber ") IS NULL »;. Load (Comand.ExecuteReader ()); (tab.Rows.Count == 0)
{= new DataTable ();. CommandText=«SELECT C. " cNumber " AS Номер, P. " plSection " AS Відділ, P. " plRack " AS Стелаж , P. " plShelf " AS Полка, P. " plSector " AS Сектор » +
«FROM " Book " B INNER JOIN " Copy " C ON B.ISBN=C.ISBN AND B.ISBN=(select to_char (« »+ dataGridView1 [0 , e.RowIndex]. Value +" ") from dual) AND C. " cLost "=0 AND C. " woCode " IS NULL » +
«INNER JOIN " Place " P ON C. " plCode " = P. " plCode " » +
«INNER JOIN " Issuance " I ON I. " cNumber " = C. " cNumber " AND I. " iFactReturn " IS NOT NULL» +
«AND I. " iIssuance " = (select max (I2. " iIssuance " ) from " Book " B2 INNER JOIN " Copy " C2 ON B2.ISBN =C2.ISBN AND B2.ISBN=(select to_char («» + dataGridView1 [0, e.RowIndex]. Value +" ") from dual) AND C2. " cLost "=0 AND C2. " woCode " IS NULL »+
«INNER JOIN " Place " P2 ON C2. " plCode " = P2. " plCode " » +
«INNER JOIN " Issuance " I2 ON I2. " cNumber " = C2. " cNumber " » +
«WHERE C2. " cNumber " = C. " cNumber " » +
«GROUP BY C2. " cNumber " )»;. Load (Comand.ExecuteReader ()); (tab.Rows.Count == 0)
{. CommandText=«SELECT C. " cNumber " AS Номер, I. " iExpReturn " AS Дата_возврата» +
«FROM " Book " B INNER JOIN " Copy " C ON B.ISBN=C.ISBN AND B.ISBN=(select to_char (« »+ dataGridView1 [0 , e.RowIndex]. Value.ToString () +" ") from dual) AND C. " cLost "=0 AND C. " woCode " IS NULL » +
«INNER JOIN " Place " P ON C. " plCode " = P. " plCode " » +
«INNER JOIN " Issuance " I ON I. " cNumber " = C. " cNumber " AND I. " iFactReturn " IS NULL»;=new DataTable ( );. Load (Comand.ExecuteReader ()); f=false; (int i=0; i
{(DateTime.Compare (Convert.ToDateTi...
