«ORDER BY видача DESC»;. Load (Comand.ExecuteReader ());. DataSource=table.DefaultView;
} if (lbl == 3)
{. CommandText=«SELECT B. " bName " AS Книга, C. " cNumber " AS Номер, C. " cCost " AS " Ціна " , R . " rFullName " AS ФІО_чітателя »+
«FROM " Book " B, " Issuance " I, " Copy " C, " Reader " R» +
«WHERE B. " ISBN " = C. " ISBN " AND C. " cNumber " = I. " cNumber " AND I. " rNumber " =R. " rNumber " AND C. " cLost "=1 AND C. " repCode " IS NULL »;. Load (Comand.ExecuteReader ());. DataSource=table.DefaultView;
}. Enabled=false;. Enabled=false;. Enabled=false;
}
}
}
Клас LibrarianSystem;System.Collections.Generic;System.ComponentModel;System.Data;System.Drawing;System.Linq;System.Text;System.Threading.Tasks;System.Windows.Forms;System.Data.OracleClient;DBLibrary
{partial class Librarian: Form
{OracleConnection OC; bool flag; bool D; string isbn; int rNumber; int mode; int cNumber; Librarian (OracleConnection oc)
{();=oc;=false;
} void Librarian_Load (object sender, EventArgs e)
{
екземплярToolStripMenuItem.Visible=false;. Enabled=true;
видатьToolStripMenuItem.Visible=false;
спісатьToolStripMenuItem.Visible=false;
заменToolStripMenuItem.Visible=false; tab; Comand=OC.CreateCommand ();. CommandText=«SELECT " sCode " , " sName " FROM " Section " »; =new DataTable ();. Load (Comand.ExecuteReader ());. DataSource=tab;. ValueMember=«sCode»;. DisplayMember=«sName»; ();
} void FLoad ()
{tab; Comand=OC.CreateCommand ();. CommandText=«SELECT B. * FROM " Book " B, " saved " s WHERE B.ISBN=s.ISBN AND s. " sCode "=» +. SelectedValue.ToString ();=new DataTable ();. Load (Comand.ExecuteReader ());. DataSource=tab.DefaultView;. CommandText=«SELECT R. " rNumber " AS Номер_білета, R. " rFullName " AS ПІБ, R. " rAddress " AS Адреса, R. " rPhone " AS Телефон, R. " rData " AS Дата_рожденія, » +
«case when (select count (I. " iIssuance " ) from " Issuance " I, " Reader " R2 where I. " rNumber " = R2. " rNumber " AND R2. " rNumber "=R. " rNumber " AND I.ICHOICE IS NOT NULL group by R2. " rNumber ") IS NULL then «ні» else «так» end AS Вибрал_кнігу » +
«FROM " Reader " R»;=new DataTable ();. Load (Comand.ExecuteReader ());. DataSource=tab.DefaultView;
} void comboBox1_SelectedIndexChanged (object sender, EventArgs e)
{(flag)
{tab; Comand=OC.CreateCommand ();. CommandText=«SELECT B. * FROM " Book " B, " saved " s WHERE B.ISBN=s.ISBN AND s. " sCode "=» +. SelectedValue.ToString ();=new DataTable ();. Load (Comand.ExecuteReader ());. DataSource=tab.DefaultView;
}=false;
} void comboBox1_MouseClick (object sender, MouseEventArgs e)
{= true;
} void dataGridView1_RowHeaderMouseClick (object sender, DataGridViewCellMouseEventAr...
