justify">} (Exception ex)
{. Show (ex.Message); final;
}:. Close ();. Dispose ();
}
}
}
Клас SelectModeSystem;System.Collections.Generic;System.ComponentModel;System.Data;System.Drawing;System.Linq;System.Text;System.Threading.Tasks;System.Windows.Forms;DBLibrary
{partial class SelectMode: Form
{SelectMode ()
{();. Checked=false;. Checked=false;. Checked=false;
} void button1_Click (object sender, EventArgs e)
{(radioButton1.Checked == true). DialogResult=System.Windows.Forms.DialogResult.Yes; if (radioButton2.Checked == true). DialogResult=System.Windows.Forms.DialogResult. No; if (radioButton3.Checked == true). DialogResult=System.Windows.Forms.DialogResult.Ignore;. Close ();
} void radioButton1_MouseDown (object sender, MouseEventArgs e)
{. Checked=true;. Checked=false;. Checked=false;
} void radioButton2_MouseDown (object sender, MouseEventArgs e)
{. Checked=false;. Checked=true;. Checked=false;
} void radioButton3_MouseDown (object sender, MouseEventArgs e)
{. Checked=false;. Checked=false;. Checked=true;
}
}
}
Клас ReaderSystem;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 Reader: Form
{AReader AR; int cNumber; string isbn; bool flag; bool clc; Reader (AReader A)
{();=A;. Text=this.Text + « »+ AR.rName;=false;=false;
} void Reader_FormClosed (object sender, FormClosedEventArgs e)
{. Close ();
} void Reader_Load (object sender, EventArgs e)
{tab; Comand=AR.OC.CreateCommand ();. CommandText=«SELECT B. * FROM " Book " B INNER JOIN " Copy " C ON B.ISBN= C.ISBN 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) »;=new DataTable ();. Load (Comand.ExecuteReader ()); (tab.Rows.Count == 5)
{. Show («Ви взяли вже п'ять книг і не можете вибирати нові»);;
}. CommandText=«SELECT " sCode " , " sName " FROM " Section " »;=new DataTable ();. Load (Comand.ExecuteReader ()) ;. DataSource=tab;. ValueMember=«sCode»;. DisplayMember=«sName»;. 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;
} void dataGridView1_RowHeaderMouseClick (object sender, DataGridViewCellMouseEventArgs e)
{Comand=AR.OC.CreateCommand (); tab=new DataTable ();. Co...
