using?System;
using?System.Data;
using?System.Configuration;
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;


public?class?BookManage
{
????private?string?CallNo;
????private?string?title;
????private?string?Author;
????private?string?Publisher;
????private?decimal?Price?=?0;
????private?int?Pages?=?0;
????private?int?Number?=?0;
????private?int?AvailableNumber?=?0;
????private?string?st1;
????private?string?st2;

????Database?data?=?new?Database（）;


????public?BookManage（）
????{
????????//
????????//?TODO:?在此處添加構(gòu)造函數(shù)邏輯
????????//
????}

???

????public?string?索書號
????{
????????get?{?return?CallNo;?}
????????set?{?CallNo?=?value;?}
????}
???
????public?string?書名
????{
????????get?{?return?title;?}
????????set?{?title?=?value;?}
????}
????
????public?string?作者
????{
????????get?{?return?Author;?}
????????set?{?Author?=?value;?}
????}
????
????public?string?查詢條件1
????{
????????get?{?return?st1;?}
????????set?{?st1?=?value;?}
????}
????public?string?查詢條件2
????{
????????get?{?return?st2;?}
????????set?{?st2?=?value;?}
????}

????public?string?出版社
????{
????????get?{?return?Publisher;?}
????????set?{?Publisher?=?value;?}
????}
???
????public?decimal?價格
????{
????????get?{?return?Price;?}
????????set?{?Price?=?value;?}
????}
???
????public?int?頁數(shù)?
????{
????????get?{?return?Pages;?}
????????set?{?Pages?=?value;?}
????}
????
????public?int?總數(shù)
????{
????????get?{?return?Number;?}
????????set?{?Number?=?value;?}
????}
????
????public?int?可借數(shù)量
????{
????????get?{?return?AvailableNumber;?}
????????set?{?AvailableNumber?=?value;?}
????}

??
????public?DataSet?queryad01and（BookManage?bookmanage）
????{
????????SqlParameter[]?prams?=
????????{
????????????data.MakeInParam（“@CallNo“SqlDbType.VarChar20bookmanage.索書號+“%“）
????????????data.MakeInParam（“@title“SqlDbType.VarChar20bookmanage.書名+“%“）
????????};
????????return?（data.RunProcReturn（“select?*?from?Book?where?CallNo?like?@CallNo?and?title?like?@title“prams?“Book“））;
????}
????public?DataSet?queryad01or（BookManage?bookmanage）
????{
????????SqlParameter[]?prams?=
????????{
????????????data.MakeInParam（“@CallNo“SqlDbType.VarChar20bookmanage.索書號+“%“）
????????????data.MakeInParam（“@title“SqlDbType.VarChar20bookmanage.書名+“%“）
????????};
????????return?（data.RunProcReturn（“select?*?from?Book?where?CallNo?like?@CallNo?or?title?like?@title“prams?“Book“））;
????}
????public?DataSet?queryad02and（BookManage?bookmanage）
????{
????????SqlParameter[]?prams?=
????????{
????????????data.MakeInParam（“@CallNo“SqlDbType.VarChar20bookmanage.索書號+“%“）
????????????data.MakeInParam（“@Author“SqlDbType.VarChar20bookmanage.作者+“%“）
????????};
????????return?（data.RunProcReturn（“select?*?from?Book?where?CallNo?like?@CallNo?and?Author?li

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????2359296??2016-06-18?01:39??TSG.mdf
?????文件??????589824??2016-06-18?01:39??TSG_log.LDF
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\.vs\
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\.vs\config\
?????文件???????85932??2016-06-13?21:32??圖書管理系統(tǒng)\.vs\config\applicationhost.config
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\.vs\圖書管理系統(tǒng)\
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\.vs\圖書管理系統(tǒng)\v14\
?????文件???????69632??2016-06-19?10:26??圖書管理系統(tǒng)\.vs\圖書管理系統(tǒng)\v14\.suo
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\
?????文件??????313735??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\Microsoft.ApplicationInsights.1.2.3.nupkg
?????文件?????????507??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\[Content_Types].xml
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\net40\
?????文件??????134987??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\net40\Microsoft.ApplicationInsights.xml
?????文件??????151288??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\net40\Microsoft.ApplicationInsights.dll
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\net45\
?????文件??????135417??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\net45\Microsoft.ApplicationInsights.xml
?????文件??????149752??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\net45\Microsoft.ApplicationInsights.dll
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\portable-win81+wpa81\
?????文件??????132678??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\portable-win81+wpa81\Microsoft.ApplicationInsights.xml
?????文件??????145656??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\portable-win81+wpa81\Microsoft.ApplicationInsights.dll
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\wp8\
?????文件??????135798??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\wp8\Microsoft.ApplicationInsights.xml
?????文件??????144624??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.1.2.3\lib\wp8\Microsoft.ApplicationInsights.dll
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.Agent.Intercept.1.2.0\
?????文件?????1458435??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.Agent.Intercept.1.2.0\Microsoft.ApplicationInsights.Agent.Intercept.1.2.0.nupkg
?????文件?????????448??2016-06-13?21:33??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.Agent.Intercept.1.2.0\[Content_Types].xml
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.Agent.Intercept.1.2.0\lib\
?????目錄???????????0??2016-06-19?10:32??圖書管理系統(tǒng)\packages\Microsoft.ApplicationInsights.Agent.Intercept.1.2.0\lib\net40\
............此處省略422個文件信息