private void loadPubliser()
{
foreach (Publisher pub in BookManage.getAllPublishers())
{
cobPub.Items.Add(pub);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
Book book = new Book();
book.Isbn = txtISBN.Text;
book.Name = txtName.Text;
book.Author = txtAuthor.Text;
book.Desc = txtDesc.Text;
book.Price = float.Parse(nupPrice.Value.ToString());
Publisher pub = cobPub.SelectedItem as Publisher;
book.PubId = pub.Id;
Genre gen = cobGenres.SelectedItem as Genre;
book.GenId = gen.Id;
book.Statue = cboRebate.Checked ? 1 : 0;
book.Stock = (int)nupStock.Value;
book.PubDate = calPubDate.Value;
int re = BookManage.addBook(book);
if (re == 1)
{
imgAddr = baseAddr + gen.CatId + "/" + book.Isbn + ".jpg";
//FileStream f = File.Create(imgAddr);
Image.FromFile(ofdCover.FileName).Save(imgAddr);
MessageBox.Show(string.Format("图片:{0}保存成功", book.Name));
}
else
{
MessageBox.Show(string.Format("图片:{0}保存失败", book.Name));
}
}
private void frmSeachBook_Load(object sender, EventArgs e)
{
sb = new StringBuilder(BASESQL);
using (MySqlConnection con = DBHelper.getCon())
{
adapter = new MySqlDataAdapter(sb.ToString(), con);
adapter.Fill(ds, "books");
dgvBooks.DataSource = ds.Tables["books"];
lbSearchInfo.Text = string.Format("当前库存的书籍共有 {0} 本", ds.Tables["books"].Rows.Count.ToString());
}
cobCategories.DisplayMember = "Title";
foreach (Categorie cat in BookManage.getAllCategories())
{
cobCategories.Items.Add(cat);
}
cobCategories.Items.Add(new Categorie());
cobGenres.DisplayMember = "Title";
cobGenres.Items.Add(new Genre());
cobPubshers.DisplayMember = "Name";
foreach (Publisher pub in BookManage.getAllPublishers())
{
cobPubshers.Items.Add(pub);
}
cobPubshers.Items.Add(new Publisher());
}
public void loadBook(Book book)
{
lbAuthor.Text = book.Author;
Genre gen = BookManage.getGenreById(book.GenId);
Categorie cat = BookManage.getCategorieById(gen.CatId);
lbCatgroie.Text = cat.Title;
lbGenre.Text = gen.Title;
txtDesc.Text = book.Desc;
lbIsbn.Text = book.Isbn;
lbName.Text = book.Name;
lbPrice.Text = book.Price.ToString();
lbPub.Text = BookManage.getPublisherById(book.PubId).Name;
lbPubDate.Text = book.PubDate.ToString();
lbStatue.Text = book.Statue == 1 ? "否" : "是";
lbStock.Text = book.Stock.ToString();
string imgAddr = string.Format(baseAddr + "{0}/{1}.jpg", cat.Id, book.Isbn);
try
{
FileStream fs = File.Open(imgAddr, FileMode.Open, FileAccess.Read);
pbCover.Image = Image.FromStream(fs);
fs.Close();
}
catch {
FileStream fs = File.Open(baseAddr + "nophoto.jpg", FileMode.Open, FileAccess.Read);
pbCover.Image = Image.FromStream(fs);
fs.Close();
}
// = img;
}
private void frmSaleAccount_Load(object sender, EventArgs e)
{
using (MySqlConnection con = DBHelper.getCon())
{
adapter = new MySqlDataAdapter(sb.ToString(), con);
adapter.Fill(ds, "saleitems");
dgSaleClassify.DataSource = ds.Tables["saleitems"];
float sum = 0;
int count = 0;
for (int i = 0; i < ds.Tables["saleitems"].Rows.Count; i++)
{
sum = sum + float.Parse(ds.Tables["saleitems"].Rows[i]["sumprice"].ToString());
}
lbInfo.Text = string.Format("目前共有{0}条件记录，销售总额为{1}", ds.Tables["saleitems"].Rows.Count.ToString(), sum.ToString());
}
cobCategories.DisplayMember = "Title";
foreach (Categorie cat in BookManage.getAllCategories())
{
cobCategories.Items.Add(cat);
}
cobCategories.Items.Add(new Categorie());
cobGenres.DisplayMember = "Title";
cobGenres.Items.Add(new Genre());
cobPubshers.DisplayMember = "Name";
foreach (Publisher pub in BookManage.getAllPublishers())
{
cobPubshers.Items.Add(pub);
}
cobPubshers.Items.Add(new Publisher());
}
private void btnLoadBook_Click(object sender, EventArgs e)
{
book = BookManage.getBookByISBN(txtISBN.Text);
if (book != null)
{
BookInfo();
}
}
private void loadCategories()
{
foreach (Categorie cat in BookManage.getAllCategories())
{
cobCategories.Items.Add(cat);
}
//cobCategories.SelectedItem = cobCategories.Items[0];
}
private void loadPublisher()
{
foreach (Publisher pub in BookManage.getAllPublishers())
{
cobPub.Items.Add(pub);
}
cobPub.DisplayMember = "Name";
cobPub.SelectedItem = cobPub.Items[0];
}
private void updateSaleItem()
{
foreach (SaleItems item in items)
{
card = cobCardId.SelectedItem as Card;
Book b = BookManage.getBookById(item.BookId);
item.Price = b.Statue == 1 ? b.Price : (b.Price * card.Discount);
}
}
private void loadCategories()
{
foreach (Categorie cat in BookManage.getAllCategories())
{
cobCategories.Items.Add(cat);
}
cobCategories.DisplayMember = "Title";
cobCategories.ValueMember = "Id";
cobCategories.SelectedItem = cobCategories.Items[0];
}
private void tvBooks_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
TreeNode tn = e.Node;
if (tn.Level == 2)
{
this.book = BookManage.getBookById(int.Parse(tn.Tag.ToString()));
loadBook(book);
}
}
private void cobCategories_SelectedIndexChanged(object sender, EventArgs e)
{
Categorie cat = cobCategories.SelectedItem as Categorie;
cobGenres.Items.Clear();
cobGenres.Items.Add(new Genre());
foreach (Genre gen in BookManage.getGenresByCatId(cat.Id))
{
cobGenres.Items.Add(gen);
}
cobGenres.SelectedIndex = 0;
}
private void cobCategories_SelectedIndexChanged(object sender, EventArgs e)
{
Categorie selcat = cobCategories.SelectedItem as Categorie;
cobGenres.Items.Clear();
foreach (Genre gen in BookManage.getGenresByCatId(selcat.Id))
{
cobGenres.Items.Add(gen);
//cobGenres.DisplayMember = "Title";
}
cobGenres.SelectedItem = cobGenres.Items[0];
}
private void tvBooks_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
TreeNode tn = e.Node;
if (tn.Level == 1 && tn.Nodes.Count == 0)
{
foreach (Book book in BookManage.getBooksByGenId(int.Parse(tn.Tag.ToString())))
{
TreeNode btn = new TreeNode(book.Name);
btn.Tag = book.Id;
tn.Nodes.Add(btn);
}
}
}
private void BtnDelet_Click(object sender, EventArgs e)
{
if (BookManage.deleteBook(book.Id) != 0)
{
MessageBox.Show("删除成功！");
File.Delete(string.Format(baseAddr + "{0}/{1}.jpg", BookManage.getGenreById(book.GenId).Id, book.Isbn));
book = BookManage.getFirstBook()[0];
loadBook(book);
}
else
{
MessageBox.Show("删除失败！");
}
}
public void BookInfo()
{
this.lblISBN.Text = book.Isbn;
this.lblName.Text = book.Name;
this.lblAuthor.Text = book.Author;
this.lblPrice.Text = book.Price.ToString();
card = cobCardId.SelectedItem as Card;
this.lblDiscountedPirce.Text = book.Statue == 1 ? book.Price.ToString() : (book.Price * card.Discount).ToString();
this.lblPublisher.Text = BookManage.getPublisherById(book.PubId).Name;
this.lblStock.Text = book.Stock.ToString();
//this.lblPubDate.Text = book.PubDate.ToString().Substring(0,8);
string imgurl = string.Format(baseAddr + "{0}/{1}.jpg", BookManage.getGenreById(book.GenId).CatId, book.Isbn);
this.pbCover.Image = Image.FromFile(imgurl);
}
public void addItemsListView()
{
int salesid = int.Parse(lvSales.SelectedItems[0].Tag.ToString());
items = SaleManage.getSaleItemsBySaleId(salesid);
lvItems.Items.Clear();
foreach (SaleItems saleitem in items)
{
ListViewItem lvi = new ListViewItem(BookManage.getBookById(saleitem.BookId).Name);
lvi.Tag = saleitem.Id;
lvi.SubItems.Add(saleitem.Count.ToString());
lvi.SubItems.Add(saleitem.Price.ToString() + "元");
lvi.SubItems.Add((saleitem.Count * saleitem.Price).ToString() + "元");
lvItems.Items.Add(lvi);
}
}
public void loadBook(Book book)
{
txtName.Text = book.Name;
txtISBN.Text = book.Isbn;
txtAuthor.Text = book.Author;
nupPrice.Value = decimal.Parse(book.Price.ToString());
calPubDate.Value = book.PubDate;
nupStock.Value = decimal.Parse(book.Stock.ToString());
cboRebate.Checked = book.Statue == 1 ? false : true;
txtDesc.Text = book.Desc;
cobPub.Items.Add(BookManage.getPublisherById(book.PubId));
cobPub.SelectedItem = cobPub.Items[0];
loadPubliser();
Genre gen = BookManage.getGenreById(book.GenId);
Categorie cat = BookManage.getCategorieById(gen.CatId);
imgAddr = string.Format(baseAddr + "{0}/{1}.jpg", cat.Id, book.Isbn);
// pbCover.Image = Image.FromFile(imgAddr);
try
{
FileStream fs = File.Open(imgAddr, FileMode.Open, FileAccess.Read);
pbCover.Image = Image.FromStream(fs);
fs.Close();
}
catch
{
FileStream fs = File.Open(baseAddr + "nophoto.jpg", FileMode.Open, FileAccess.Read);
pbCover.Image = Image.FromStream(fs);
fs.Close();
}
ofdChangeCover.FileName = imgAddr;
cobCategories.Items.Add(cat);
cobCategories.SelectedItem = cobCategories.Items[0];
loadCategories();
cobGenres.Items.Add(gen);
cobGenres.SelectedItem = cobGenres.Items[0];
}
private void FrmManageBook_Load(object sender, EventArgs e)
{
List <Categorie> cats = BookManage.getAllCategories();
foreach (Categorie cat in cats)
{
TreeNode ctn = new TreeNode();
ctn.Text = cat.Title;
ctn.Tag = cat.Id;
foreach (Genre gen in BookManage.getGenresByCatId(cat.Id))
{
TreeNode gtn = new TreeNode();
gtn.Text = gen.Title;
gtn.Tag = gen.Id;
ctn.Nodes.Add(gtn);
}
tvBooks.Nodes.Add(ctn);
}
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
if (ofdChangeCover.FileName != imgAddr)
{
this.pbCover.Image = null;
File.Delete(imgAddr);
Image.FromFile(ofdChangeCover.FileName).Save(imgAddr);
//img.Save(imgAddr);
//this.parent.getPbCover().Image = null;
//
// pbCover.Image.Save(imgAddr);
} //这里就已经保存了图片
Book b = new Book();
b.Name = txtName.Text;
b.Isbn = txtISBN.Text;
Publisher pub = cobPub.SelectedItem as Publisher;
b.PubId = pub.Id;
Genre gen = cobGenres.SelectedItem as Genre;
b.GenId = gen.Id;
b.Author = txtAuthor.Text;
b.Price = float.Parse(nupPrice.Value.ToString());
b.PubDate = calPubDate.Value;
b.Stock = (int)nupStock.Value;
;
b.Desc = txtDesc.Text;
b.Statue = cboRebate.Checked ? 0:1;
b.Id = book.Id;
if (BookManage.updateBook(b) != 0)
{
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("修改失败！");
}
BtnReset_Click(sender, e);
this.parent.loadBook(this.book);
}
private void lvSale_Click(object sender, EventArgs e)
{
this.txtISBN.Text = lvSale.SelectedItems[0].Text;
//this.nudCount.Value = int.Parse(lvSale.SelectedItems[0].Tag.ToString());
int id = (int)lvSale.SelectedItems[0].Tag;
foreach (SaleItems item in items)
{
if (id == item.Id)
{
this.nudCount.Value = item.Count;
break;
}
}
book = BookManage.getBookByISBN(txtISBN.Text);
if (book != null)
{
BookInfo();
}
}
private void loadlvSale()
{
float total = 0;
lvSale.Items.Clear();
foreach (SaleItems item in items)
{
Book b = BookManage.getBookById(item.BookId);
ListViewItem lvi = new ListViewItem(b.Isbn);
lvi.Tag = b.Id;
lvi.SubItems.Add(b.Name);
lvi.SubItems.Add(item.Count.ToString());
lvi.SubItems.Add(b.Price.ToString() + "元");
lvi.SubItems.Add(item.Price + "元");
lvi.SubItems.Add((item.Price * item.Count) + "元");
lvSale.Items.Add(lvi);
total = total + (item.Price * item.Count);
totals = total;
}
lblTotal.Text = totals.ToString() + "元";
lblGathering.Text = totals.ToString() + "元";
}
private void btnAdd_Click(object sender, EventArgs e)
{
book = BookManage.getBookByISBN(txtISBN.Text);
if (book != null)
{
if (this.nudCount.Value > book.Stock)
{
MessageBox.Show("库存不足！");
}
else
{
BookInfo();
addSaleItem();
loadlvSale();
this.nudCount.Value = 1;
this.txtISBN.Text = "";
}
}
else
{
MessageBox.Show("ISBN码错误！");
}
}
public frmManageBook()
{
InitializeComponent();
book = BookManage.getFirstBook()[0];
loadBook(book);
}
private void BtnReset_Click(object sender, EventArgs e)
{
book = BookManage.getBookById(book.Id);
loadBook(book);
}
