/// <summary>
/// 添加书籍信息
/// </summary>
/// <param name="book"></param>
/// <returns></returns>
public bool addBook(tbBook book)
{
if (bookService.addBook(book) > 0)
{
return(true);
}
return(false);
}
public Librery(string UserName)
{
InitializeComponent();
this.DataContext = this;
MyDb = new MyDbContext();
_user = MyDb.Users.Where(x => x.UserName == UserName)
.FirstOrDefault();
SelectedShelve = new Tbshelve();
SelectedBook = new tbBook();
/// Shelves = new ObservableCollection<Tbshelve>(MyDb.Shelves.Where(x => x.UserId == _user.Id).ToList());
///
}
protected void Button3_Click(object sender, EventArgs e)
{
tbBook book = new tbBook()
{
ISBN1 = tb_num.Text.ToString().Trim(),
BookName1 = tb_name.Text.ToString().Trim(),
Price1 = 0,
PublicDate1 = DateTime.Now
};
if (new tbBookManager().addBook(book))
{
MessageBox.Show(this, "添加成功");
}
else
{
MessageBox.Show(this, "添加失败");
}
init();
}
/// <summary>
/// 添加书籍信息
/// </summary>
/// <param name="book"></param>
/// <returns></returns>
public int addBook(tbBook book)
{
String sql = string.Format("insert into tbBook values('{0}','{1}','{2}','{3}')", book.ISBN1, book.BookName1, book.Price1, book.PublicDate1);
return(conn.Excu(sql));
}
