//根据Id查询图书信息
public static Books GetBooksById(int id)
{
int PublisherId;
int CategoryId;
string sql = "select * from Books where Id=" + id;
try
{
SqlDataReader row = DBHelper.GetReader(sql);
if (row.Read())
{
Books book = new Books();
book.Id = (int)row["Id"];
book.Title = (string)row["Title"];
book.Author = (string)row["Author"];
book.AurhorDescription = (string)row["AurhorDescription"];
book.ISBN = (string)row["ISBN"];
book.TOC = (string)row["TOC"];
book.ContentDescription = (string)row["ContentDescription"];
book.EditorComment = (string)row["EditorComment"];
book.WordsCount = (int)row["WordsCount"];
book.UnitPrice = (decimal)row["UnitPrice"];
book.PublishDate = (DateTime)row["PublishDate"];
book.Clicks = (int)row["Clicks"];
PublisherId = (int)row["PublisherId"];
CategoryId = (int)row["CategoryId"];
row.Close();
book.Publisher = PublisherService.GetPublishersById(PublisherId);
book.Catagorys = CatagoryService.GetCatagoryById(CategoryId);
return(book);
}
else
{
row.Close();
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
//查询所有图书信息
public static IList <Books> GetBooksAll()
{
IList <Books> list = new List <Books>();
string sql = "select * from Books";
try
{
DataTable table = DBHelper.GetDataSet(sql);
foreach (DataRow row in table.Rows)
{
Books book = new Books();
book.Id = (int)row["Id"];
book.Title = (string)row["Title"];
book.Author = (string)row["Author"];
book.AurhorDescription = (string)row["AurhorDescription"];
book.ISBN = (string)row["ISBN"];
book.TOC = (string)row["TOC"];
book.ContentDescription = (string)row["ContentDescription"];
book.EditorComment = (string)row["EditorComment"];
book.WordsCount = (int)row["WordsCount"];
book.UnitPrice = (decimal)row["UnitPrice"];
book.PublishDate = (DateTime)row["PublishDate"];
book.Clicks = (int)row["Clicks"];
book.Publisher = PublisherService.GetPublishersById((int)row["PublisherId"]);
book.Catagorys = CatagoryService.GetCatagoryById((int)row["CategoryId"]);
list.Add(book);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
