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); }