gs e)
{= false;=1;=dataGridView1 [0, e.RowIndex]. Value.ToString ();
екземплярToolStripMenuItem.Visible=true; Comand=OC.CreateCommand (); tab=new DataTable ();. CommandText=«SELECT C. " cNumber " AS Номер, C. " cCost " AS Ціна, C. " cDate " AS Дата_поставкі, case when C. " cLost " = 0 then« ні » else «так» end AS Утерян, »+
«case when C. " cLost " = 1 AND C. " repCode " IS NOT NULL then« так » when C. " cLost "=1 AND C. " repCode " IS NULL then «ні» else « » end AS Замінений, » +
«case when C. " woCode " IS NULL then« ні » else «так» end AS Списаний, » +
«P. " plSection " AS Відділ, P. " plRack " AS Стелаж, P. " plShelf " AS Полка, P. " plSector " AS Сектор, »+
«I. " iIssuance " AS Дата_видачі, I. " iExpReturn " AS Ожід_возврат, I. " iFactReturn " AS Факт_возврат» +
«FROM " Book " B INNER JOIN " Copy " C ON B.ISBN=C.ISBN AND B.ISBN=(select to_char (« »+ isbn +« ; ») from dual)» +
«INNER JOIN " Place " P ON C. " plCode " = P. " plCode " » +
«INNER JOIN " Issuance " I ON I. " cNumber " = C. " cNumber " » +
«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 («» + isbn +" ") from dual) »+
«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 ());. DataSource=tab.DefaultView;
} void dataGridView3_RowHeaderMouseClick (object sender, DataGridViewCellMouseEventArgs e)
{= 3;=Convert.ToInt32 (dataGridView3 [0, e.RowIndex]. Value); Comand=OC.CreateCommand (); tab=new DataTable ();. CommandText=«SELECT B.ISBN, B. " bName " AS Назва, C. " cNumber " AS Номер, I. " iExpReturn " AS Ожід_возврат »+
«FROM " Book " B, " Copy " C, " Issuance " I, " Reader " R» +
«WHERE I. " cNumber " = C. " cNumber " AND C.ISBN=B.ISBN AND I. " rNumber " = R. " rNumber " AND R. " rNumber "=(select to_number («» + rNumber +" ") from dual) AND I. " iFactReturn " IS NULL AND I.ICHOICE IS NULL »;. Load (Comand . ExecuteReader ());. DataSource=tab.DefaultView; («так». CompareTo (dataGridView3 [5, e.RowIndex]. Value.ToString ()) == 0)
видатьToolStripMenuItem.Visible=true;
видатьToolStripMenuItem.Visible=false;
} void виходToolStripMenuItem_Click (object sender, EventArgs e)
{Comand=OC.CreateCommand (); tab=new DataTable ();. CommandText=«UPDATE " Copy " SET " cLost " = 1 WHERE " Copy " . " cNumber "=(select to_number («» + cNumber +" ") from dual) »;. Load (Comand.ExecuteReader ()); ();
} void видатьToolStripMenuItem_Click (object sender, EventArgs e)
{I=new Issuance (this);. Enabled=false;. Show ();
} void виходToolStripMenuItem1_Click (object s...
