private void commentUpload_Click(object sender, EventArgs e)//发布评论 { string time = System.DateTime.Now.ToString(); string nameUpload = username.Text; string bookname = bookName.Text; string comment = commentText.Text; if (comment == null) { return; } LibraryBLL.book bookupdate = new LibraryBLL.book(); try { bookupdate.bookCommentCheckIn(bookname, nameUpload, time, comment); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } if (MessageBox.Show("评论成功") == DialogResult.OK) { bookcommentshow(bookname); } }
private void bookdelet_Click(object sender, EventArgs e)//书本信息删除 { int a = 0; string b = ""; ArrayList bookname = new ArrayList(); for (int i = 0; i < bookinfolist.RowCount; i++) { DataGridViewCell bookselect = (DataGridViewCell)bookinfolist.Rows[i].Cells[0]; if ((string)bookselect.Value == "True") { b = bookinfolist.Rows[i].Cells[8].Value.ToString(); bookname.Add(b); } } if (MessageBox.Show("确定删除" + bookname.Count + "条数据吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK) { LibraryBLL.book book = new LibraryBLL.book(); try { a = book.bookdelete(bookname); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } bookinfoshow("", ""); MessageBox.Show("删除了" + a + "条数据"); } }
private void covershow(string name)//封面显示 { byte[] b; LibraryBLL.book show = new LibraryBLL.book(); try { b = show.covershow(name); } catch { bookPicture.BackgroundImage = null; return; } if (b.Length > 0) { try { byte[] ima = b; bookPicture.BackgroundImage = LibraryBLL.drawimag.headima(ima, bookPicture.Width, bookPicture.Height); } catch { bookPicture.BackgroundImage = null; return; } } }
private void toolStripButton1_Click(object sender, EventArgs e) { int a = 0; ArrayList name = new ArrayList(); ArrayList commentText = new ArrayList(); for (int i = 0; i < commentList.RowCount; i++) { string b, c; DataGridViewCell checkbox = (DataGridViewCell)this.commentList.Rows[i].Cells[0]; if ((string)checkbox.Value == "True") { b = commentList.Rows[i].Cells[1].Value.ToString(); c = commentList.Rows[i].Cells[4].Value.ToString(); name.Add(b); commentText.Add(c); } } if (MessageBox.Show("确定删除" + name.Count + "条数据吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK) { LibraryBLL.book comment = new LibraryBLL.book(); try { a = comment.commentdelete(name, commentText); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } bookcommentshow(); MessageBox.Show("已经删除" + a + "条数据");; } }
private void sure_Click(object sender, EventArgs e) { if (bookname.Text == "" || autor.Text == "" || pubname.Text == "" || type.Text == "" || date.Text == "" || page.Text == "" || textBox1.Text == "" || bookIntro.Text == "") { if (MessageBox.Show("存在字段为空") == DialogResult.OK) { return; } } DateTime tm; if (false == DateTime.TryParse(date.Text, out tm)) { if (MessageBox.Show("时间格式错误") == DialogResult.OK) { return; } } byte[] road = ESBasic.Helpers.ImageHelper.Convert(this.bookimg.BackgroundImage); LibraryBLL.book bookupdate = new LibraryBLL.book(); try { bookupdate.bookinfochange(bookname.Text, autor.Text, type.Text, pubname.Text, date.Text, code, road, bookIntro.Text, Convert.ToInt32(page.Text), Convert.ToInt32(textBox1.Text)); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } this.Hide(); UImain main = new UImain(); main.Focus(); }
private void bookInfoFilled()//书本信息填充 { SqlDataReader bookinfo; try { bookinfo = LibraryBLL.book.bookinfodata(code); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } bookname.Text = bookinfo["name"].ToString(); autor.Text = bookinfo["autor"].ToString(); pubname.Text = bookinfo["pubname"].ToString(); type.Text = bookinfo["type"].ToString(); date.Text = bookinfo["date"].ToString(); page.Text = bookinfo["pagecode"].ToString(); bookIntro.Text = bookinfo["about"].ToString(); textBox1.Text = bookinfo["price"].ToString(); byte[] b; LibraryBLL.book show = new LibraryBLL.book(); try { b = show.covershow(bookname.Text); } catch { bookimg.BackgroundImage = null; return; } if (b.Length > 0) { try { byte[] ima = b; bookimg.BackgroundImage = LibraryBLL.drawimag.headima(ima, bookimg.Width, bookimg.Height); } catch { bookimg.BackgroundImage = null; return; } } }
private void sure_Click(object sender, EventArgs e) { if (bookname.Text == "" || autor.Text == "" || pubname.Text == "" || type.Text == "" || date.Text == "" || bookIds.Text == "" || page.Text == "" || textBox1.Text == "" || bookIntro.Text == "") { if (MessageBox.Show("存在字段为空") == DialogResult.OK) { return; } } DateTime tm; if (false == DateTime.TryParse(date.Text, out tm)) { if (MessageBox.Show("时间格式错误") == DialogResult.OK) { return; } } string[] code = this.bookIds.Text.Trim().Split(';'); for (int i = 0; i < code.Length; i++) { byte[] road = ESBasic.Helpers.ImageHelper.Convert(this.bookimg.BackgroundImage); LibraryBLL.book bookupdate = new LibraryBLL.book(); try { bookupdate.bookCheckIn(bookname.Text, autor.Text, type.Text, pubname.Text, date.Text, code[i], road, bookIntro.Text, Convert.ToInt32(page.Text), Convert.ToInt32(textBox1.Text)); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } if (MessageBox.Show("书本增加成功") == DialogResult.OK) { this.Hide(); UImain main = new UImain(); main.Focus(); } }