using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?Modle;
using?DAL;

namespace?BLL
{
????public?class?BookInfo
????{
???????
????????public?BookInfo（）
????????{?}
????????#region??實現分頁中的————獲取數據

????????public?static?DataTable?GetInfo（string?Condition?int?PageNumber?int?PageSize?int?IsCount）
????????{
????????????SqlParameter[]?sqlpar?=?
????????????{
????????????????new?SqlParameter（“@Table““booksInfo“）?//
????????????????new?SqlParameter（“@Primarykey““BookID“）//--主鍵?
????????????????new?SqlParameter（“@Condition“Condition）//-查詢條件?
????????????????new?SqlParameter（“@PageNumber“PageNumber）//開始頁數
????????????????new?SqlParameter（“@PageSize“PageSize）//每頁大小?
????????????????new?SqlParameter（“@IsCount“IsCount）//是否獲得記錄數，0為否
????????????};
????????????DAL.Database?database?=?new?DAL.Database（）;
????????????return?database.ExecuteDataSet（“proc_Page“?sqlpar?CommandType.StoredProcedure）.Tables[“s“];
????????????
????????}
????????#endregion

????????#region?BooksInfo插入數據
????????///?

????????///?BooksInfo插入數據------強正斌
????????///?

????????///?
????????///?
????????public?static?int?Insert（booksInfo?bookinfo）
????????{
????????????//string?strsql?=?“procInsertBooksInfo“;
????????????string?strsql?=?“INSERT?INTO?booksInfo?VALUES（@BookID@BookName@WritterName@PublisherID@PublishDate@TypeID@LentCount@Status@InDate@BookView@BookImage）“;
????????????SqlParameter[]?sqlparameter?=?
????????????{
????????????????new?SqlParameter（“@BookID“bookinfo.BookID）
????????????????new?SqlParameter（“@BookName“bookinfo.BookName）
????????????????new?SqlParameter（“@WritterName“bookinfo.WritterName）
????????????????new?SqlParameter（“@PublisherID“bookinfo.PublisherID）
????????????????new?SqlParameter（“@PublishDate“Convert.ToDateTime（bookinfo.PublishDate））
????????????????new?SqlParameter（“@TypeID“bookinfo.TypeID）
????????????????new?SqlParameter（“@LentCount“bookinfo.LentCount）
????????????????new?SqlParameter（“@Status“bookinfo.Status）
????????????????new?SqlParameter（“@InDate“Convert.ToDateTime（bookinfo.InDate））
????????????????new?SqlParameter（“@BookView“bookinfo.BookView）
????????????????new?SqlParameter（“@BookImage“bookinfo.BookImage）
????????????};
????????????Database?data?=?new?Database（）;
????????????return?data.ExecuteNonQuery（strsql?sqlparameter?CommandType.Text）;
????????}
????????//查詢publisherInfo的數據
????????public?static?DataSet?SelecPublisherInfo（）
????????{
????????????string?strsql?=?“select?*?from?publisherInfo“;
????????????Database?data?=?new?Database（）;
????????????return?data.ExecuteDataSet（strsql?null?CommandType.Text）;
????????}
????????//查詢bookstyle的數據
????????public?static?DataSet?SelectBookstyle（）
????????{
????????????string?strsql?=?“select?*?from?bookstyle“;
????????????Database?data?=?new?DataBa

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

?????文件???????2317??2008-06-28?15:05??tushuguanlixito\librarian\Librarian\Librarian.sln

????..A..H.????117248??2008-08-09?11:56??tushuguanlixito\librarian\Librarian\Librarian.suo

?????文件???????2044??2008-07-05?11:06??tushuguanlixito\librarian\Librarian\Modle\booksInfo.cs

?????文件????????495??2008-06-20?15:33??tushuguanlixito\librarian\Librarian\Modle\bookstyle.cs

?????文件???????1128??2008-06-20?15:33??tushuguanlixito\librarian\Librarian\Modle\borrowNote.cs

?????文件???????1739??2008-07-05?10:51??tushuguanlixito\librarian\Librarian\Modle\cardsInfo.cs

?????文件????????687??2008-06-20?15:33??tushuguanlixito\librarian\Librarian\Modle\cardstyle.cs

?????文件????????137??2008-06-20?13:38??tushuguanlixito\librarian\Librarian\Modle\Class1.cs

?????文件???????2357??2008-07-01?14:45??tushuguanlixito\librarian\Librarian\Modle\Modle.csproj

?????文件????????271??2008-06-20?14:58??tushuguanlixito\librarian\Librarian\Modle\Modle.csproj.vspscc

?????文件????????188??2008-06-20?15:33??tushuguanlixito\librarian\Librarian\Modle\mssccprj.scc

?????文件????????515??2008-06-20?15:33??tushuguanlixito\librarian\Librarian\Modle\publisherInfo.cs

?????文件????????804??2008-06-23?15:33??tushuguanlixito\librarian\Librarian\Modle\UsersInfo.cs

?????文件????????192??2008-06-20?15:33??tushuguanlixito\librarian\Librarian\Modle\vssver.scc

?????文件???????1313??2008-06-20?13:38??tushuguanlixito\librarian\Librarian\Modle\Properties\AssemblyInfo.cs

?????文件?????????48??2008-06-20?14:58??tushuguanlixito\librarian\Librarian\Modle\Properties\vssver.scc

?????文件????????126??2008-08-09?11:55??tushuguanlixito\librarian\Librarian\Modle\obj\Modle.csproj.FileList.txt

?????文件??????20480??2008-07-08?03:25??tushuguanlixito\librarian\Librarian\Modle\obj\Debug\Modle.dll

?????文件??????40448??2008-07-08?03:25??tushuguanlixito\librarian\Librarian\Modle\obj\Debug\Modle.pdb

?????文件??????20480??2008-07-05?14:15??tushuguanlixito\librarian\Librarian\Modle\obj\Debug\Refactor\Modle.dll

?????文件??????20480??2008-07-08?03:25??tushuguanlixito\librarian\Librarian\Modle\bin\Debug\Modle.dll

?????文件??????40448??2008-07-08?03:25??tushuguanlixito\librarian\Librarian\Modle\bin\Debug\Modle.pdb

?????文件????????784??2008-07-05?16:05??tushuguanlixito\librarian\Librarian\LibrarianUI\AboutUs.cs

?????文件???????1720??2008-07-05?16:03??tushuguanlixito\librarian\Librarian\LibrarianUI\AboutUs.Designer.cs

?????文件???????5814??2008-07-05?16:03??tushuguanlixito\librarian\Librarian\LibrarianUI\AboutUs.resx

?????文件????????335??2008-06-25?16:10??tushuguanlixito\librarian\Librarian\LibrarianUI\app.config

?????文件???????2179??2008-07-10?17:16??tushuguanlixito\librarian\Librarian\LibrarianUI\Backup?.cs

?????文件???????5822??2008-07-10?17:06??tushuguanlixito\librarian\Librarian\LibrarianUI\Backup?.Designer.cs

?????文件??????21871??2008-07-10?17:06??tushuguanlixito\librarian\Librarian\LibrarianUI\Backup?.resx

?????文件???????3111??2008-07-11?09:48??tushuguanlixito\librarian\Librarian\LibrarianUI\ChangePwd.cs

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