//更新一本书
//0：更新失败
//1：更新成功
//2：连接出错，更新失败
//3：图片为空，更新失败
//4：ID为空，更新失败
//
public int update(Model.Book book)
{
string id = book.Id;
string name = book.Name;
string author = book.Author;
string publisher = book.Publisher;
string pubtime = book.Pubtime;
string pritime = book.Pritime;
string edition = book.Edition;
string impression = book.Impression;
string pages = book.Pages;
string words = book.Words;
string format = book.Format;
string paper = book.Paper;
string packaging = book.Packaging;
string isbn = book.Isbn;
byte[] picture = book.Picture;
string price = book.Price;
string sort = book.Sort;
string inventory = book.Inventory;
//判断连接
if (DbHelper.checkConnection() == false)
{
return(2);
}
if (picture == null)
{
return(3);
}
if (id == null || id == "")
{
return(4);
}
string cmdText = "update book set b_name='" + name + "',b_author='" + author + "',b_publisher='" + publisher + "',b_pubtime='" + pubtime + "',b_pritime='" + pritime + "',b_edition='" + edition + "',b_impression='" + impression + "',b_pages='" + pages + "',b_words='" + words + "',b_format='" + format + "',b_paper='" + paper + "',b_packaging='" + packaging + "',b_isbn='" + isbn + "',b_picture=@picture,b_price='" + price + "',b_sort='" + sort + "',b_inventory='" + inventory + "' where b_id='" + id + "'";
SqlParameter[] parameters = { new SqlParameter("@picture", SqlDbType.Binary) };
parameters[0].Value = picture;
int i = DbHelper.ExecuteNonQuery(cmdText, parameters);
if (i == 1)
{
return(1);
}
else
{
Console.WriteLine("更新失败");
return(0);
}
}