using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Timers;
using?System.Data.OleDb;

namespace?librarySystem
{
????public?partial?class?borrow?:?Form
????{
????????public?borrow（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?borrowBt1_Click（object?sender?EventArgs?e）
????????{
????????????readers?readers=new?readers（）;
????????????DateTime?td=new?DateTime（）;
????????????td=System.DateTime.Now;
????????????if?（txtBookid.Text?==?““?||?txtBookname.Text?==?““?||?txtReaderid.Text?==?““?||?txtReadername.Text?==?““）
????????????{
????????????????MessageBox.Show（“信息不完整！請完善信息......“）;
????????????}
????????????else
????????????{
???
????????????readers.setbookid（Convert.ToInt32（this.txtBookid.Text））;
????????????readers.setbookname（this.txtBookname.Text）;
????????????readers.setreaderid（Convert.ToInt32（?this.txtReaderid.Text））;
????????????readers.setreadername（this.txtReadername.Text）;
????????????readers.setborrowdata（td）;
????????????readers.setreturndata（td.AddDays（30））;

????????????string?strConnection?=?“Provider=Microsoft.Jet.OleDb.4.0;Data?Source=library.mdb“;
????????????OleDbConnection?mycon?=?new?OleDbConnection（strConnection）;?????
????????????????try
????????????????{
????????????????????mycon.Open（）;
????????????????}
????????????????catch?（OleDbException?oledbe）
????????????????{
????????????????????MessageBox.Show（oledbe.Message?“連接失敗對話框“）;
????????????????????return;
????????????????}
????????????????string?sqlstr1?=“select?*?from?reader?where?readerid=“?+?readers.getreaderid（）?+?“?and?readername=‘“+readers.getreadername（）+“‘“;
????????????????string?sqlstr2?=?“select?*?from?book?where?bookid=“?+?readers.getbookid（）?+?“?and?bookname=‘“+readers.getbookname（）+“‘“;
????????????????string?sqlstr3?=?“select?*?from?records?where?bookid=“?+?readers.getbookid（）?+?“?and?readerid=“+readers.getreaderid（）+““;
????????????????OleDbCommand?cmd1?=?new?OleDbCommand（sqlstr1?mycon）;
????????????????OleDbCommand?cmd2?=?new?OleDbCommand（sqlstr2?mycon）;
????????????????OleDbCommand?cmd3?=?new?OleDbCommand（sqlstr3?mycon）;
????????????????int?count1?=?Convert.ToInt32（cmd1.ExecuteScalar（））;
????????????????int?count2?=?Convert.ToInt32（cmd2.ExecuteScalar（））;
????????????????int?count3?=?Convert.ToInt32（cmd3.ExecuteScalar（））;
????????????????if?（count1?<=?0）
????????????????{
????????????????????MessageBox.Show（“讀者信息庫沒有該學生信息，或者你輸入的學好與用戶名不一致，您無法借閱“）;
????????????????}
????????????????if?（count2?<=?0）
????????????????{
????????????????????MessageBox.Show（“書庫沒有您要借閱的書目ID，或者你輸入的數目編號與書名不一致，請查證后再借閱“）;
????????????????}
????????????????else
????????????????{
????????????????????if?（count3?>?0）
????????????????????{
????????????????????????MessageBox.Show（“您已經借閱了本書，不能再借“）;
????????????????????}
????????????????????else
????????????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????403??2009-06-08?10:50??librarySystem\librarySystem\app.config

?????文件?????495616??2009-06-23?08:47??librarySystem\librarySystem\bin\Debug\library.mdb

?????文件?????294912??2009-06-23?11:31??librarySystem\librarySystem\bin\Debug\librarySystem.exe

?????文件????????403??2009-06-08?10:50??librarySystem\librarySystem\bin\Debug\librarySystem.exe.config

?????文件?????114176??2009-06-23?11:31??librarySystem\librarySystem\bin\Debug\librarySystem.pdb

?????文件???????5632??2005-12-08?14:51??librarySystem\librarySystem\bin\Debug\librarySystem.vshost.exe

?????文件????????403??2009-06-08?10:50??librarySystem\librarySystem\bin\Debug\librarySystem.vshost.exe.config

?????文件???????4362??2009-06-23?11:29??librarySystem\librarySystem\borrow.cs

?????文件??????11416??2009-06-23?11:29??librarySystem\librarySystem\borrow.Designer.cs

?????文件??????42295??2009-06-23?11:29??librarySystem\librarySystem\borrow.resx

?????文件???????4034??2009-06-22?18:06??librarySystem\librarySystem\contr.cs

?????文件??????15735??2009-06-22?18:06??librarySystem\librarySystem\contr.Designer.cs

?????文件??????10574??2009-06-22?18:06??librarySystem\librarySystem\contr.resx

?????文件????????441??2009-06-22?17:34??librarySystem\librarySystem\dools.cs

?????文件??????61441??2009-06-08?10:50??librarySystem\librarySystem\libraryDataSet.Designer.cs

?????文件??????????3??2009-06-08?10:50??librarySystem\librarySystem\libraryDataSet.xsc

?????文件??????19942??2009-06-08?10:50??librarySystem\librarySystem\libraryDataSet.xsd

?????文件??????????3??2009-06-08?10:50??librarySystem\librarySystem\libraryDataSet.xss

?????文件???????5388??2009-06-23?11:29??librarySystem\librarySystem\librarySystem.csproj

?????文件???????2343??2009-06-22?18:06??librarySystem\librarySystem\login.cs

?????文件???????8090??2009-06-23?10:36??librarySystem\librarySystem\login.Designer.cs

?????文件?????133749??2009-06-23?10:36??librarySystem\librarySystem\login.resx

?????文件????????791??2009-06-23?11:29??librarySystem\librarySystem\login2.cs

?????文件???????4419??2009-06-23?11:29??librarySystem\librarySystem\login2.Designer.cs

?????文件?????134099??2009-06-23?11:29??librarySystem\librarySystem\login2.resx

?????文件??????24616??2009-06-23?11:29??librarySystem\librarySystem\obj\Debug\librarySystem.borrow.resources

?????文件???????3058??2009-06-23?10:07??librarySystem\librarySystem\obj\Debug\librarySystem.contr.resources

?????文件???????1140??2009-06-23?11:31??librarySystem\librarySystem\obj\Debug\librarySystem.csproj.GenerateResource.Cache

?????文件?????294912??2009-06-23?11:31??librarySystem\librarySystem\obj\Debug\librarySystem.exe

?????文件??????85772??2009-06-23?10:36??librarySystem\librarySystem\obj\Debug\librarySystem.login.resources

............此處省略31個文件信息