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;

namespace?BookManage
{
????public?partial?class?AllBooks?:?Form
????{
????????public?AllBooks（）
????????{
????????????InitializeComponent（）;
????????}
????????private?string?_Admin;
????????private?bool?_f;//判斷控件隱藏
????????public?string?name;
????????public?double?price;
????????public?int?_Id;
?????
????????public?string?BookId;
????????public?AllBooks（string?admin）
????????{
????????????InitializeComponent（）;
????????????this._Admin?=?admin;
???????????
????????}
????????public?AllBooks（bool?f）
????????{
????????????InitializeComponent（）;
????????????_f?=?f;
????????}

????????List?lstBook?=?new?List（）;
????????List?lstPress?=?new?List（）;
????????List?lstBookType?=?new?List（）;
????????List?lstBount?=?new?List（）;
????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;
????????}
????????public?void?show（）
????????{
????????????lstBook?=?Datebase.getListBooks（）;
????????????lstPress?=?Datebase.getListPress（）;
????????????lstBookType?=?Datebase.getListBookType（）;

????????????DataTable?dt?=?new?DataTable（）;

????????????dt.Columns.Add（“圖書ID“?typeof（int））;
????????????dt.Columns.Add（“書名“?typeof（string））;
????????????dt.Columns.Add（“單價“?typeof（double））;
????????????dt.Columns.Add（“庫存“?typeof（int））;
????????????dt.Columns.Add（“銷售量“?typeof（int））;
????????????dt.Columns.Add（“出版社“?typeof（string））;
????????????dt.Columns.Add（“圖書類別“?typeof（string））;

????????????cboNumber.Items.Clear（）;

????????????foreach?（Books?b?in?lstBook）
????????????{
????????????????DataRow?dr?=?dt.NewRow（）;
????????????????dr[“圖書ID“]?=?b.BookId;
????????????????dr[“書名“]?=?b.BookName;
????????????????dr[“單價“]?=?b.BookPrice;
????????????????dr[“庫存“]?=?b.Stock;
????????????????dr[“銷售量“]?=?b.Sell;
????????????????foreach?（Press?p?in?lstPress）//根據出版社id顯示出版社名稱
????????????????{
????????????????????if?（p.PressId?==?b.PressId）
????????????????????{?
????????????????????????dr[“出版社“]?=?p.PressName;
????????????????????????break;
????????????????????}
????????????????}
????????????????foreach?（BookType?bt?in?lstBookType）//根據圖書類別id顯示圖書類別
????????????????{
????????????????????if?（bt.BookTypeId?==?b.BookTypeId）
????????????????????{?
????????????????????????dr[“圖書類別“]?=?bt.BookTypeName;
????????????????????????break;
????????????????????}
????????????????}?
????????????????dt.Rows.Add（dr）;
????????????????cboNumber.Items.Add（b.BookId）;
????????????}
????????????dvBooks.DataSource?=?dt;
????????}
????????private?void?AllBooks_Load（object?sender?EventArgs?e）
????????{
????????????cboBookType.SelectedIndex?=?0;
????????????cboNumber.SelectedIndex?=?0;
????????????cboPublish.SelectedIndex?=?0;
????????????panel

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

?????文件???????9500??2010-12-27?19:42??圖書管理系統\BookManage\AllBooks.cs

?????文件??????16167??2010-12-24?21:25??圖書管理系統\BookManage\AllBooks.Designer.cs

?????文件???????5814??2010-12-24?21:23??圖書管理系統\BookManage\AllBooks.resx

?????文件?????519168??2010-12-28?09:56??圖書管理系統\BookManage\bin\Debug\BookManage.exe

?????文件?????230912??2010-12-28?09:56??圖書管理系統\BookManage\bin\Debug\BookManage.pdb

?????文件??????14328??2010-12-28?09:50??圖書管理系統\BookManage\bin\Debug\BookManage.vshost.exe

?????文件????????490??2007-07-21?01:33??圖書管理系統\BookManage\bin\Debug\BookManage.vshost.exe.manifest

?????文件???????2289??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\1.jpg

?????文件???????2103??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\111.jpg

?????文件???????2303??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\2.jpg

?????文件???????2503??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\23.jpg

?????文件??????13069??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\C++程序設計.jpg

?????文件???????8585??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\C語言程序設計.jpg

?????文件???????2479??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\fak.jpg

?????文件???????2123??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\hei.jpg

?????文件??????11779??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\JAVA編程思想.jpg

?????文件?????189117??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\kobe.jpg

?????文件??????12219??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\NET編程思想.jpg

????..A.SH.????100352??2010-12-25?16:21??圖書管理系統\BookManage\bin\Debug\img\Thumbs.db

?????文件?????215056??2000-09-22?17:25??圖書管理系統\BookManage\bin\Debug\img\Transball.bmp

?????文件??????12741??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\UNIX.jpg

?????文件???????2033??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\書架信息.jpg

?????文件???????2217??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\出版社.jpg

?????文件??????10697??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\單片機開發.jpg

?????文件???????2307??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\圖書信息.jpg

?????文件???????2347??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\圖書分類.jpg

?????文件???????2334??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\圖書狀態.jpg

?????文件?????257037??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\圖書管理系統.jpg

?????文件???????2097??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\圖書館信息.jpg

?????文件??????10797??2010-12-20?21:28??圖書管理系統\BookManage\bin\Debug\img\家用電器技術.jpg

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