using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?Library
{
????public?partial?class?BookBorrow?:?Form
????{
????????private?int?totalCount?thisCount;//儲存已借書和本次借書數據
????????private?DataTable?tblBooks;
????????private?string?readerID;//保存查詢到的讀者編號
????????public?BookBorrow（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?BookBorrow_Load（object?sender?EventArgs?e）
????????{
????????????this.DataGridStateControl（）;
????????????totalCount?=?0;
????????????thisCount?=?0;
????????}
????????//----------設置明細表格各列的屬性----------
????????private?void?DataGridStateControl（）
????????{
????????????tblBooks?=?new?DataTable（）;
????????????tblBooks.Columns.Add（“狀態“?typeof（string））;
????????????tblBooks.Columns.Add（“圖書編號“?typeof（string））;
????????????tblBooks.Columns.Add（“書名“?typeof（string））;
????????????tblBooks.Columns.Add（“借閱時間“?typeof（string））;
????????????tblBooks.Columns.Add（“應還時間“?typeof（string））;
????????????tblBooks.Columns.Add（“出版社“?typeof（string））;
????????????tblBooks.Columns.Add（“價格“?typeof（decimal））;


????????????this.dataGrid1.DataSource?=?tblBooks;
????????????tblBooks.Rows.Add（tblBooks.NewRow（））;?//向表中添加一行

????????????DataGridTablestyle?ts?=?new?DataGridTablestyle（）;
????????????DataGridTextBoxColumn?aColumnTextColumn;
????????????ts.AllowSorting?=?false;
????????????ts.AlternatingBackColor?=?Color.LightGray;
????????????ts.MappingName?=?tblBooks.TableName;
????????????int?numCols?=?tblBooks.Columns.Count;
????????????for?（int?i?=?0;?i?????????????{
????????????????aColumnTextColumn?=?new?DataGridTextBoxColumn（）;

????????????????if?（i?==?2）
????????????????{
????????????????????aColumnTextColumn.Width?=?140;//設置圖書名稱寬度
????????????????}

????????????????if?（i?==?5）
????????????????{
????????????????????aColumnTextColumn.Width?=?100;//設置出版社名稱列寬度
????????????????}

????????????????aColumnTextColumn.MappingName?=?tblBooks.Columns[i].ColumnName;
????????????????aColumnTextColumn.HeaderText?=?tblBooks.Columns[i].ColumnName;
????????????????aColumnTextColumn.NullText?=?““;
????????????????aColumnTextColumn.Format?=?“N“;?//設置為數字格式顯示
????????????????ts.GridColumnstyles.Add（aColumnTextColumn）;
????????????}
????????????
????????????//dataGrid1.Tablestyles.Add（ts）;
????????}


		//------------顯示讀者信息和所借圖書信息----------------
		private?void?showInfo（）
		{
????????????string?strConn?=?Properties.Settings.Default.libbookConnectionString;
			SqlConnection?cn=new?SqlConnection（strConn）;
			cn.Open（）;
			SqlCommand?cmd=cn.CreateCommand（）;
			
			if（radioButton1.Checked）//判斷根據編號查詢讀者信息還是根據條形碼
			{
				cmd.CommandText=“select?a.姓名a.類型b.圖書冊書a.編號?from?讀者信息?a讀者類型?b“
					+“?where?（a.類型=b.類型）and（a.編號=‘“+text1.Text.Trim（）+“‘）“;
			}
			else
			{
				cmd.Comm

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

?????文件????????911??2010-12-25?10:20??Library\Library.sln

????..A..H.?????25600??2010-12-29?23:19??Library\Library.suo

?????文件??????30126??2010-12-28?22:05??Library\Library\ReaderClassify.Designer.cs

?????文件??????50310??2010-12-28?22:02??Library\Library\ReaderInfo.Designer.cs

?????文件???????9503??2010-12-28?23:06??Library\Library\Library.csproj

?????文件??????13529??2010-12-28?22:05??Library\Library\ReaderClassify.resx

?????文件????????492??2010-12-29?11:17??Library\Library\Program.cs

?????文件??????16193??2010-12-28?22:02??Library\Library\ReaderInfo.resx

?????文件???????1553??2010-12-28?22:10??Library\Library\BookClassify.cs

?????文件???????2397??2010-12-28?22:22??Library\Library\libbookDataSet.xsc

?????文件???????3452??2010-12-29?11:17??Library\Library\BookReturn.cs

?????文件??????13008??2010-12-29?11:16??Library\Library\FormMain.Designer.cs

?????文件???????2012??2010-12-28?22:04??Library\Library\ReaderInfo.cs

?????文件??????25625??2010-12-28?22:09??Library\Library\BookClassify.Designer.cs

?????文件??????13695??2010-12-28?22:09??Library\Library\BookClassify.resx

?????文件???????2654??2010-12-29?11:16??Library\Library\FormMain.cs

?????文件???????1614??2010-12-28?22:05??Library\Library\ReaderClassify.cs

?????文件??????52876??2010-12-28?22:28??Library\Library\BookInfo.Designer.cs

?????文件??????16537??2010-12-28?22:28??Library\Library\BookInfo.resx

?????文件???????1535??2010-12-28?22:29??Library\Library\BookInfo.cs

?????文件???????9708??2010-12-29?23:11??Library\Library\BookBorrow.cs

?????文件??????14772??2010-12-29?23:04??Library\Library\BookBorrow.Designer.cs

?????文件???????5814??2010-12-29?23:01??Library\Library\BookBorrow.resx

?????文件???????5550??2010-12-29?11:17??Library\Library\BookReturn.Designer.cs

?????文件???????5814??2010-12-29?11:17??Library\Library\BookReturn.resx

?????文件???????6213??2010-12-29?11:16??Library\Library\FormMain.resx

?????文件??????20425??2010-12-29?22:23??Library\Library\FormAbout.resx

?????文件???????5366??2010-12-29?22:23??Library\Library\FormAbout.Designer.cs

?????文件????????824??2010-12-29?22:23??Library\Library\FormAbout.cs

?????文件????2621440??2010-12-29?00:39??Library\Library\libbook.mdf

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