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); }