public void AddBook()
{
Model.Book book = new Model.Book();
book = TestHelper.initBook();
SQLDAL.Book target = new SQLDAL.Book();
bool actual = target.AddBook(book);
bool expected = true;
Assert.AreEqual(expected, actual);
}
public void BorrowMIdErrTest()
{
Model.Book book = new Model.Book();
Model.Viewer viewer = new Model.Viewer();
Model.Manager manager = new Model.Manager();
book.Id = "book";
viewer.Id = "s000001";
manager.Id = "m";//帐号错误
// bool expected = false; //期望值
// bool actual;
int expected = 0; //期望值
Hashtable actual;
SQLDAL.Book target = new SQLDAL.Book();
actual = target.Borrow(book, viewer, manager); //实际值
Assert.AreEqual(expected, actual["result"]);
}
public void BorrowTest()
{
Model.Book book = new Model.Book();
Model.Viewer viewer = new Model.Viewer();
Model.Manager manager = new Model.Manager();
book.Id = "book";
viewer.Id = "st";
manager.Id = "manager";
// bool expected = false; //期望值//因为数据库中已经存在这一项数据 所以为false
//bool actual;
int expected = 0; //期望值//因为数据库中已经存在这一项数据 所以为false
Hashtable actual;
SQLDAL.Book target = new SQLDAL.Book();
actual = target.Borrow(book, viewer, manager); //实际值
Assert.AreEqual(expected, actual["result"]);
}
public void UpdateBook()
{
Model.Book book = new Model.Book();
book = TestHelper.initBook();
book.Id = "DKLFJO2342";
//测试用
SQLDAL.Book target = new SQLDAL.Book();
bool actual = target.UpdateBook(book);
bool expected = true;
Assert.AreEqual(expected, actual);
}
public void ReturnVIdErrTest()
{
Model.Book book = new Model.Book();
Model.Viewer viewer = new Model.Viewer();
Model.Manager manager = new Model.Manager();
book.Id = "book";
viewer.Id = "s00001";//学号错误
manager.Id = "manager";
bool expected = false; //期望值
bool actual;
SQLDAL.Book target = new SQLDAL.Book();
actual = target.ReturnBook(viewer, book, manager); //实际值
Assert.AreEqual(expected, actual);
}
public void ReturnBIdErrTest()
{
string b_id = "9787550264";
string r_id = "s001";
Model.Viewer v = new Model.Viewer();
v.Id = r_id;
Model.Book b = new Model.Book();
b.Id = b_id;
Model.Manager m = new Model.Manager();
//m.Id = m_id;
//Model.Book book = new Model.Book();
//Model.Viewer viewer = new Model.Viewer();
Model.Manager manager = new Model.Manager();
//book.Id = "boo";//书号错误
//viewer.Id = "st";
manager.Id = "manager";
bool expected = false; //期望值
bool actual;
SQLDAL.Book target = new SQLDAL.Book();
actual = target.ReturnBook(v, b, manager); //实际值
Assert.AreEqual(expected, actual);
}
public void ReturnTest()
{
Model.Book book = new Model.Book();
Model.Viewer viewer = new Model.Viewer();
Model.Manager manager = new Model.Manager();
book.Id = "9787569902921";
viewer.Id = "s001";
manager.Id = "manager";
bool expected = false; //期望值//因为数据库中已经存在这一项数据 所以为false
bool actual;
SQLDAL.Book target = new SQLDAL.Book();
actual = target.ReturnBook(viewer, book, manager); //实际值
Assert.AreEqual(expected, actual);
}
public void MulReturnTest()
{
Model.Book book = new Model.Book();
Model.Viewer viewer = new Model.Viewer();
Model.Manager manager = new Model.Manager();
book.Id = "9787513318525";
viewer.Id = "st";
manager.Id = "manager";
bool expected = false; //期望值
bool actual;
SQLDAL.Book target = new SQLDAL.Book();
target.ReturnBook(viewer, book, manager); //第一次还
actual = target.ReturnBook(viewer, book, manager); //实际值//第二次还
Assert.AreEqual(expected, actual);
}
public void MulBorrowTest()
{
Model.Book book = new Model.Book();
Model.Viewer viewer = new Model.Viewer();
Model.Manager manager = new Model.Manager();
book.Id = "9787513318525";
viewer.Id = "st";
manager.Id = "manager";
// bool expected = false; //期望值
//bool actual;
int expected = -1; //期望值 已经借过的返回值为-1
Hashtable actual;
SQLDAL.Book target = new SQLDAL.Book();
target.Borrow(book, viewer, manager);//第一次借
actual = target.Borrow(book, viewer, manager); //实际值//第二次借
Assert.AreEqual(expected, actual["result"]);
//由于系统限制每个人只能借同一本书一次 所以测试时只有第一次是能成功
}
public void GetSingleBookTest()
{
string b_id = "00125415152";
string expected = "计算机组成原理"; //期望值
string actual;
SQLDAL.Book target = new SQLDAL.Book();
actual =target.GetSingleBook(b_id).Name; //实际值
Assert.AreEqual(expected, actual);
}
public void GetListTest()
{
string sql = "b_id ='00125415152'";
int expected = 1; //期望值
int actual;
SQLDAL.Book target = new SQLDAL.Book();
DataTable dt = target.GetList(sql);
actual = dt.Rows.Count; //实际值
Assert.AreEqual(expected, actual);
}
public void DeleteBook()
{
Model.Book book = new Model.Book();
book = TestHelper.initBook();
book.Id = book.Id + "TEST";
//先添加这本书
SQLDAL.Book target = new SQLDAL.Book();
bool actual = target.AddBook(book);
bool expected = true;
Assert.AreEqual(expected, actual);
//删除这本书
bool actual_2 = target.DeleteBook(book);
bool expected_2 = true;
Assert.AreEqual(expected_2, actual_2);
}
