using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;
using?LIB.Manage;

public?partial?class?Borrow?:?System.Web.UI.Page
{
????LibraryClass?Libclass?=?new?LibraryClass（）;

????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????Panel1.Visible?=?false;

????????Label2.Text?=?DateTime.Now.ToString（）;

????????if?（Session[“name“]?==?null）
????????{
????????????Response.Redirect（“Default.aspx“）;
????????}
????????else
????????{
????????????Label1.Text?=?Session[“name“].ToString（）;

????????????bookshow（）;

????????????leaveword（）;
????????
????????}
????}
????void?bookshow（）
????{
????????string?strsql?bookid;

????????bookid?=?Request.QueryString[“id“].ToString（）;

????????strsql?=?“select?*?from?圖書信息表?where?流水號=‘“?+?bookid?+?“‘“;

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

????????dt?=?Libclass.ReadTable（strsql）;

????????DataList1.DataSource?=?dt;

????????DataList1.DataBind（）;

????}

????void?leaveword（）
????{
????????string?strsql?bookid;

????????bookid?=?Request.QueryString[“id“].ToString（）;

????????strsql?=?“select?*?from?圖書留言表?where?圖書流水號=‘“?+?bookid?+?“‘“;

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

????????dt?=?Libclass.ReadTable（strsql）;

????????DataList2.DataSource?=?dt;

????????DataList2.DataBind（）;
????????
????}

????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????Panel1.Visible?=?true;

????????TextBox1.Text?=?““;

????????Label6.Text?=?““;
????}
????protected?void?Button3_Click（object?sender?EventArgs?e）
????{
????????if?（TextBox1.Text?!=?““）
????????{
????????????string?strsql?username?bookid;

????????????username?=?Session[“name“].ToString（）;

????????????bookid?=?Request.QueryString[“id“].ToString（）;

????????????strsql?=?“insert?into?圖書留言表（圖書流水號讀者名留言時間留言內容）?values（‘“?+?bookid?+?“‘‘“?+?username?+?“‘‘“?+?Label2.Text?+?“‘‘“?+?TextBox1.Text?+?“‘）“;

????????????Libclass.execsql（strsql）;

????????????Label6.Text?=?“留言成功！“;

????????????Panel1.Visible?=?false;

????????????bookshow（）;

????????????leaveword（）;
????????}
????????else
????????{
????????????Label6.Text?=?“留言不能為空！“;

????????????Panel1.Visible?=?false;
????????}
????????
????}
????protected?void?Button2_Click（object?sender?EventArgs?e）
????{
????????string?strsql?username?bookidstrsql2;

????????username?=?Session[“name“].ToString（）;

????????bookid?=?Request.QueryString[“id“].ToString（）;

????????strsql?=?“select?圖書數量?from?圖書信息表?where?流水號=‘“?+?bookid?+?“‘?and?圖書數量>0“;

????????DataSet?ds=new?DataSet（）;

????????ds=Libclass.GetDataSet（strsql“圖書數量“）;

????????if?（ds.Tables[“圖書數量“].Rows.Count==0）
????????????{
????????????????Label6.Text?=?“該書已全部借完！“;

???????

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

????.......??????1427??2012-01-29?09:25??圖書管理系統\AdminManage\AdminReg.aspx

????.......???????971??2012-01-29?09:25??圖書管理系統\AdminManage\AdminReg.aspx.cs

????.......??????3190??2012-01-29?09:25??圖書管理系統\AdminManage\BookInsert.aspx

????.......??????2016??2012-01-29?09:25??圖書管理系統\AdminManage\BookInsert.aspx.cs

????.......??????3439??2012-01-29?09:25??圖書管理系統\AdminManage\BookManage.aspx

????.......??????4189??2012-01-29?09:25??圖書管理系統\AdminManage\BookManage.aspx.cs

????.......??????3013??2012-01-29?09:25??圖書管理系統\AdminManage\LeaveWordManage.aspx

????.......??????2306??2012-01-29?09:25??圖書管理系統\AdminManage\LeaveWordManage.aspx.cs

????.......??????2140??2012-01-29?09:25??圖書管理系統\AdminManage\ManageDefault.aspx

????.......???????971??2012-01-29?09:25??圖書管理系統\AdminManage\ManageDefault.aspx.cs

????.......??????2670??2012-01-29?09:25??圖書管理系統\AdminManage\SuggestManage.aspx

????.......??????2342??2012-01-29?09:25??圖書管理系統\AdminManage\SuggestManage.aspx.cs

????.......??????3620??2012-01-29?09:25??圖書管理系統\AdminManage\userManage.aspx

????.......??????3475??2012-01-29?09:25??圖書管理系統\AdminManage\userManage.aspx.cs

????.......?????????1??2012-01-29?09:25??圖書管理系統\App_Code\ClassDiagram.cd

?????文件???????3685??2012-04-20?16:28??圖書管理系統\App_Code\LibraryClass.cs

????.......???2293760??2012-01-29?09:25??圖書管理系統\App_Data\LibraryDb.mdf

????.......????573440??2012-01-29?09:26??圖書管理系統\App_Data\LibraryDb_log.LDF

????.......??????6464??2012-01-29?09:25??圖書管理系統\Borrow.aspx

????.......??????3818??2012-01-29?09:25??圖書管理系統\Borrow.aspx.cs

????.......??????2606??2012-01-29?09:25??圖書管理系統\BorrowBook.aspx

????.......??????1686??2012-01-29?09:25??圖書管理系統\BorrowBook.aspx.cs

????.......??????2541??2012-01-29?09:25??圖書管理系統\Default.aspx

????.......??????2162??2012-01-29?09:25??圖書管理系統\Default.aspx.cs

????.......??????4945??2012-01-29?09:25??圖書管理系統\from.gif

????.......?????31753??2012-01-29?09:26??圖書管理系統\images\Librarytopimg.jpg

????..A.SH.??????3584??2012-04-20?16:41??圖書管理系統\images\Thumbs.db

????.......??????1517??2012-01-29?09:25??圖書管理系統\LibraryWeb.sln

????..A..H.?????11776??2012-04-20?16:40??圖書管理系統\LibraryWeb.suo

????.......??????1236??2012-01-29?09:25??圖書管理系統\ManagePlace.aspx

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