Comand.ExecuteReader ());. Visible=false;. Visible=false;. Enabled=false;
}
}
}
Клас AdministrationSystem;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 Administration: Form
{OracleConnection OC; int lbl; Administration (OracleConnection oc)
{();=oc;=0;
} void Administration_Load (object sender, EventArgs e)
{. Enabled=false;. Enabled=false;. Enabled=false;
} void недобросовестныеЧитателиToolStripMenuItem_Click (object sender, EventArgs e)
{. Enabled=true;. Enabled=true;. Enabled=true;=1;
} void label1_Click (object sender, EventArgs e)
{} void популярныеКнигиToolStripMenuItem_Click (object sender, EventArgs e)
{. Enabled=true;. Enabled=true;. Enabled=true;=2;
} void стоимостьУтерянныхКнигToolStripMenuItem_Click (object sender, EventArgs e)
{= 3; _Click (sender, e);
} void button1_Click (object sender, EventArgs e)
{Comand=OC.CreateCommand (); table=new DataTable (); (lbl == 1)
{dateBegin=dateTimePicker1.Value.ToShortDateString (); dateEnd=dateTimePicker2.Value.ToShortDateString ();. CommandText=«SELECT R. " rFullName " AS ПІБ, R. " rAddress " AS Адреса, R. " rPhone " AS Телефон,» +
«R. " rData " AS Дата_рожденія, COUNT (I. " iNumber " ) AS Опозданія_Долгі» +
«FROM " Reader " R, " Issuance " I» +
«WHERE R. " rNumber " = I. " rNumber " AND» +
«(I. " iExpReturn "
«(I. " iFactReturn " BETWEEN (select to_date (« »+ dateBegin +« »,« dd-mm-rr ») from dual) AND» +
«(select to_date (« »+ dateEnd +« »,« dd-mm-rr ») from dual) OR I. " iFactReturn " IS NULL)» ; +
«GROUP BY R. " rFullName " , R. " rAddress " , R. " rPhone " , R. " rData " » +
«ORDER BY Опозданія_Долгі DESC»;. Load (Comand.ExecuteReader ());. DataSource=table.DefaultView;
} if (lbl == 2)
{dateBegin=dateTimePicker1.Value.ToShortDateString (); dateEnd=dateTimePicker2.Value.ToShortDateString ();. CommandText=«SELECT B. " bName " AS Книга, B. " bAuthor " AS Автор, B. " bPublish " AS Видавництво,» +
«B. " bYear " AS Год_ізданія, COUNT (I. " iNumber " ) AS видачу» +
«FROM " Book " B, " Issuance " I, " Copy " C» +
«WHERE B. " ISBN " = C. " ISBN " AND C. " cNumber " = I. " cNumber " AND» +
«I. " iIssuance " BETWEEN (select to_date (« »+ dateBegin +« »,« dd-mm-rr ») from dual) AND» +
«(select to_date (« »+ dateEnd +« »,« dd-mm-rr ») from dual)» +
«GROUP BY B. " bName " , B. " bAuthor " , B. " bPublish " , B. " bYear " » +
...
