//根据图书条码获取图书信息
public Book GetBookByBarCode(string barCode)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@BarCode", barCode)
};
Book objBook = null;
try
{
SqlDataReader objReader = SQLHelper.GetReaderByProcedure("usp_GetBookByBarCode", param);
if (objReader.Read())
{
objBook = new Book()
{
Author = objReader["Author"].ToString(),
BarCode = objReader["BarCode"].ToString(),
BookCategory = Convert.ToInt32(objReader["BookCategory"]),
BookCount = Convert.ToInt32(objReader["BookCount"]),
BookId = Convert.ToInt32(objReader["BookId"]),
BookImage = objReader["BookImage"].ToString(),
BookName = objReader["BookName"].ToString(),
BookPosition = objReader["BookPosition"].ToString(),
PublishDate = Convert.ToDateTime(objReader["PublishDate"]),
PublisherId = Convert.ToInt32(objReader["PublisherId"]),
PublisherName = objReader["PublisherName"].ToString(),
RegTime = Convert.ToDateTime(objReader["RegTime"]),
Remainder = Convert.ToInt32(objReader["Remainder"]),
UnitPrice = Convert.ToDouble(objReader["UnitPrice"]),
CategoryName = objReader["CategoryName"].ToString()
};
}
objReader.Close();
return(objBook);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
