?? book.cs
字號:
?using System;
using System.Data;
using System.Collections;
using System.Data.SqlClient;
using MyLibrary.DataAccessLayer;
using MyLibrary.DataAccessHelper;
namespace MyLibrary.BusinessLogicLayer
{
//用戶類
public class Book
{
#region 私有成員
private int _bookID; //書號
private string _bookName; //書名
private string _bookISBN; //ISBN
private string _bookAuthor; //作者
private string _bookPublish; //出版社
private DateTime _bookPublishDate; //出版時間
private string _bookClassify; //分類
private string _bookSubject; //主題
private string _bookIndex; //索書號
private double _bookPrice; //價格
private int _bookPageNum; //頁數
private string _bookSeries; //系列
private string _bookDescription; //描述
#endregion 私有成員
#region 屬性
public int BookID
{
set
{
this._bookID = value;
}
get
{
return this._bookID;
}
}
public string BookName
{
set
{
this._bookName = value;
}
get
{
return this._bookName;
}
}
public string BookISBN
{
set
{
this._bookISBN = value;
}
get
{
return this._bookISBN;
}
}
public string BookAuthor
{
set
{
this._bookAuthor = value;
}
get
{
return this._bookAuthor;
}
}
public string BookPublish
{
set
{
this._bookPublish = value;
}
get
{
return this._bookPublish;
}
}
public DateTime BookPublishDate
{
set
{
this._bookPublishDate = value;
}
get
{
return this._bookPublishDate;
}
}
public string BookClassify
{
set
{
this._bookClassify = value;
}
get
{
return this._bookClassify;
}
}
public string BookSubject
{
set
{
this._bookSubject = value;
}
get
{
return this._bookSubject;
}
}
public string BookIndex
{
set
{
this._bookIndex = value;
}
get
{
return this._bookIndex;
}
}
public double BookPrice
{
set
{
this._bookPrice = value;
}
get
{
return this._bookPrice;
}
}
public int BookPageNum
{
set
{
this._bookPageNum = value;
}
get
{
return this._bookPageNum;
}
}
public string BookSeries
{
set
{
this._bookSeries = value;
}
get
{
return this._bookSeries;
}
}
public string BookDescription
{
set
{
this._bookDescription = value;
}
get
{
return this._bookDescription;
}
}
#endregion 屬性
#region 方法
//根據書號 BookID 初始化
//輸入：
// XBookID - 書號；
//輸出：
// 書存在：返回True；
// 書不在：返回False；
public bool LoadData(int XBookID)
{
SqlParameter[] Params = new SqlParameter[1];
DataBase DB = new DataBase();
Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID); //書號
DataSet ds = DB.GetDataSet("Proc_BookDetail", Params);
ds.CaseSensitive = false;
DataRow DR;
if (ds.Tables[0].Rows.Count > 0)
{
DR = ds.Tables[0].Rows[0];
this._bookID = GetSafeData.ValidateDataRow_N(DR, "BookID"); //書號
this._bookName = GetSafeData.ValidateDataRow_S(DR, "BookName"); //書名
this._bookISBN = GetSafeData.ValidateDataRow_S(DR, "BookISBN"); //書ISBN號
this._bookAuthor = GetSafeData.ValidateDataRow_S(DR, "BookAuthor"); //作者
this._bookPublish = GetSafeData.ValidateDataRow_S(DR, "BookPublish"); //出版社
this._bookPublishDate = GetSafeData.ValidateDataRow_T(DR, "BookPublishDate"); //出版時間
this._bookClassify = GetSafeData.ValidateDataRow_S(DR, "BookClassify"); //分類
this._bookSubject = GetSafeData.ValidateDataRow_S(DR, "BookSubject"); //主題
this._bookIndex = GetSafeData.ValidateDataRow_S(DR, "BookIndex"); //索引號
this._bookPrice = GetSafeData.ValidateDataRow_F(DR, "BookPrice"); //價格
this._bookPageNum = GetSafeData.ValidateDataRow_N(DR, "BookPageNum"); //頁數
this._bookSeries = GetSafeData.ValidateDataRow_S(DR, "BookSeries"); //系列
this._bookDescription = GetSafeData.ValidateDataRow_S(DR, "BookDescription"); //介紹
return true;
}
else
{
return false;
}
}
//根據BookID判斷該圖書是否存在
//輸入：
// XBookID - 用戶編號；
//輸出：
// 用戶存在：返回True；
// 用戶不在：返回False；
public bool CheckBook(string XBookID)
{
SqlParameter[] Params = new SqlParameter[1];
DataBase DB = new DataBase();
Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID); //書號
SqlDataReader DR = DB.RunProcGetReader("Proc_BookDetail", Params);
if (!DR.Read())
{
return false;
}
else
{
return true;
}
}
//向Books表中添加書籍信息(采用存儲過程)
//輸出：
// 插入成功：返回True；
// 插入失敗：返回False；
public bool InsertByProc()
{
SqlParameter[] Params = new SqlParameter[12];
DataBase DB = new DataBase();
//Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, BookID); //書號
Params[0] = DB.MakeInParam("@BookName", SqlDbType.VarChar, 50, BookName); //書名
Params[1] = DB.MakeInParam("@BookISBN", SqlDbType.VarChar, 50, BookISBN); //ISBN
Params[2] = DB.MakeInParam("@BookAuthor", SqlDbType.VarChar, 50, BookAuthor); //作者
Params[3] = DB.MakeInParam("@BookPublish", SqlDbType.VarChar, 50, BookPublish); //出版社
Params[4] = DB.MakeInParam("@BookPublishDate", SqlDbType.DateTime, 8, BookPublishDate); //出版時間
Params[5] = DB.MakeInParam("@BookClassify", SqlDbType.VarChar, 50, BookClassify); //分類
Params[6] = DB.MakeInParam("@BookSubject", SqlDbType.VarChar, 50, BookSubject); //主題
Params[7] = DB.MakeInParam("@BookIndex", SqlDbType.VarChar, 50, BookIndex); //索引號
Params[8] = DB.MakeInParam("@BookPrice", SqlDbType.Float, 8, BookPrice); //價格
Params[9] = DB.MakeInParam("@BookPageNum", SqlDbType.Int, 4, BookPageNum); //頁數
Params[10] = DB.MakeInParam("@BookSeries", SqlDbType.VarChar, 50, BookSeries); //系列
Params[11] = DB.MakeInParam("@BookDescription", SqlDbType.VarChar, 50, BookDescription);//描述
int Count = -1;
Count = DB.RunProc("Proc_BookAdd", Params);
if (Count > 0)
return true;
else return false;
}
//更新書籍的信息
public bool UpdateByProc(int XBookID)
{
SqlParameter[] Params = new SqlParameter[13];
DataBase DB = new DataBase();
Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID); //書號
Params[1] = DB.MakeInParam("@BookName", SqlDbType.VarChar, 50, BookName); //書名
Params[2] = DB.MakeInParam("@BookISBN", SqlDbType.VarChar, 50, BookISBN); //ISBN
Params[3] = DB.MakeInParam("@BookAuthor", SqlDbType.VarChar, 50, BookAuthor); //作者
Params[4] = DB.MakeInParam("@BookPublish", SqlDbType.VarChar, 50, BookPublish); //出版社
Params[5] = DB.MakeInParam("@BookPublishDate", SqlDbType.DateTime, 8, BookPublishDate); //出版時間
Params[6] = DB.MakeInParam("@BookClassify", SqlDbType.VarChar, 50, BookClassify); //分類
Params[7] = DB.MakeInParam("@BookSubject", SqlDbType.VarChar, 50, BookSubject); //主題
Params[8] = DB.MakeInParam("@BookIndex", SqlDbType.VarChar, 50, BookIndex); //索引號
Params[9] = DB.MakeInParam("@BookPrice", SqlDbType.Float, 8, BookPrice); //價格
Params[10] = DB.MakeInParam("@BookPageNum", SqlDbType.Int, 4, BookPageNum); //頁數
Params[11] = DB.MakeInParam("@BookSeries", SqlDbType.VarChar, 50, BookSeries); //系列
Params[12] = DB.MakeInParam("@BookDescription", SqlDbType.VarChar, 50, BookDescription);//描述
int Count = -1;
Count = DB.RunProc("Proc_BookModify", Params);
if (Count > 0)
return true;
else return false;
}
//刪除書籍
//輸入：
// XBookID - 書號；
//輸出：
// 刪除成功：返回True；
// 刪除失敗：返回False；
public bool DeleteByProc(int XBookID)
{
SqlParameter[] Params = new SqlParameter[1];
DataBase DB = new DataBase();
Params[0] = DB.MakeInParam("@BookID", SqlDbType.Int, 4, XBookID); //書號
int Count = -1;
Count = DB.RunProc("Proc_BookDelete", Params);
if (Count > 0)
return true;
else return false;
}
//查詢所有書籍
//不需要參數
public DataSet QueryBooks()
{
DataBase DB = new DataBase();
return DB.GetDataSet("Proc_BookList");
}
////查詢最大書號
//public int QueryMaxID()
//{
// DataBase DB = new DataBase();
// SqlDataReader sdr = DB.RunProcGetReader("Proc_MaxBookID");
// return int.Parse(sdr["maxbookid"].ToString());
//}
#endregion 方法
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -