private void tabControl2_SelectedIndexChanged(object sender, EventArgs e) { if (this.tabControl2.SelectedIndex == 0) { dt = UserAdmin.GetUser(); dataGridView2.DataSource = dt; foreach (DataColumn dc in dt.Columns) { dataGridView2.Columns[dc.ColumnName].HeaderText = User.ColumnTitle(dc.ColumnName); } } else if (this.tabControl2.SelectedIndex == 1) { dt = BookAdmin.GetBook(); dataGridView3.DataSource = dt; foreach (DataColumn dc in dt.Columns) { dataGridView3.Columns[dc.ColumnName].HeaderText = Book.ColumnTitle(dc.ColumnName); } } else if (this.tabControl2.SelectedIndex == 2) { dt = BorrowAdmin.GetBorrow(); dataGridView4.DataSource = dt; foreach (DataColumn dc in dt.Columns) { dataGridView4.Columns[dc.ColumnName].HeaderText = Borrow.ColumnTitle(dc.ColumnName); } } }
private void treeView2_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { if (e.Node.Parent == null) { return; } string name = e.Node.Text.Trim(); string ID = null; dt = BookAdmin.GetBook(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][1].ToString() == name) { tb4_3.Text = dt.Rows[i][1].ToString(); tb4_4.Text = dt.Rows[i][3].ToString(); tb4_5.Text = dt.Rows[i][4].ToString(); tb4_6.Text = dt.Rows[i][5].ToString(); cb4_2.Text = dt.Rows[i][7].ToString(); ID = dt.Rows[i][2].ToString(); } } dt = BookTypeAdmin.GetBookType(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][0].ToString() == ID) { cb4_1.Text = dt.Rows[i][1].ToString(); } } }
private void BookCatalogUpdate(TreeView treeView) { treeView.Nodes.Clear(); dt = BookTypeAdmin.GetBookType(); TreeNode[] tn = new TreeNode[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { tn[i] = new TreeNode(); tn[i].Text = dt.Rows[i][1].ToString(); treeView.Nodes.Add(tn[i]); } DataTable dt2 = BookAdmin.GetBook(); TreeNode[] tn_book = new TreeNode[dt2.Rows.Count]; for (int i = 0; i < dt2.Rows.Count; i++) { for (int j = 0; j < dt.Rows.Count; j++) { if (Convert.ToInt32(dt.Rows[j][0]) == Convert.ToInt32(dt2.Rows[i][2])) { tn_book[i] = new TreeNode(); tn_book[i].Text = dt2.Rows[i][1].ToString(); tn[j].Nodes.Add(tn_book[i]); break; } } } }
private void dgvBook_SelectionChanged(object sender, EventArgs e) { if (dgvBook.CurrentCell == null) { return; } book = BookAdmin.GetBook((int)dgvBook["bkID", dgvBook.CurrentCell.RowIndex].Value); SetBookToText(); }
private void 注销_3_Click(object sender, EventArgs e) { if (listBox1.SelectedItems.Count == 0) { MessageBox.Show("请选择注销项"); return; } if (SetTextToBorrow()) { borrowBLL.Updata(new_borrow); new_book = BookAdmin.GetBook(new_borrow.BID); new_book.Condition = "在馆"; bookBLL.Updata(new_book); MessageBox.Show("状态:注销成功!"); } listBox1.Items.Clear(); }
private void 登记_3_Click(object sender, EventArgs e) { if (tb3_3.Text == "") { MessageBox.Show("请输入完整信息"); return; } new_user = UserAdmin.GetUser(Convert.ToInt32(tb3_2.Text)); if (new_user == null) { MessageBox.Show("该用户不存在"); return; } new_book = BookAdmin.GetBook(Convert.ToInt32(tb3_3.Text)); if (new_book.Name == null) { MessageBox.Show("该图书不存在"); return; } dt = BorrowAdmin.GetBorrow(Convert.ToInt32(tb3_2.Text)); for (int i = 0; i < dt.Rows.Count; i++) { //if (dt.Rows[i][4].ToString() == listBox1.SelectedItems[0].ToString() && Convert.ToInt32(dt.Rows[i][7]) == 0) if (dt.Rows[i][3].ToString() == tb3_3.Text && dt.Rows[i][7].ToString() == "False") { MessageBox.Show("该图书已借出"); return; } } if (SetTextToBorrow()) { borrowBLL.Insert(new_borrow); new_book = BookAdmin.GetBook(new_book.ID); new_book.Condition = "借出"; bookBLL.Updata(new_book); MessageBox.Show("状态:登记成功!"); } tb3_3.Text = ""; }
private void 除图书_4_Click(object sender, EventArgs e) { if (SetTextToBook()) { dt = BookAdmin.GetBook(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][7].ToString() == "借出" && dt.Rows[i][1].ToString() == tb4_3.Text) { MessageBox.Show("该书未被归还"); return; } } bookBLL.Delete(new_book); MessageBox.Show("状态:删除成功!"); } BookCatalogUpdate(treeView2); Clear_4(); }
private bool SetTextToBorrow() { if (tb3_2.Text == "") { MessageBox.Show("请输入完整信息"); return(false); } new_borrow.UID = Convert.ToInt32(tb3_2.Text); new_user = UserAdmin.GetUser(new_borrow.UID); new_borrow.UName = new_user.Name; if (tb3_3.Text != "") { new_borrow.BID = Convert.ToInt32(tb3_3.Text); new_book = BookAdmin.GetBook(new_borrow.BID); new_borrow.BName = new_book.Name; } new_borrow.Borrow_time = DateTime.Now; new_borrow.Return_time = DateTime.Now; if (listBox1.SelectedItems.Count != 0) { dt = BorrowAdmin.GetBorrow(new_borrow.UID); for (int i = 0; i < dt.Rows.Count; i++) { //if (dt.Rows[i][4].ToString() == listBox1.SelectedItems[0].ToString() && Convert.ToInt32(dt.Rows[i][7]) == 0) if (dt.Rows[i][4].ToString() == listBox1.SelectedItems[0].ToString() && dt.Rows[i][7].ToString() == "False") { if (tb3_3.Text == "") { new_borrow.BID = Convert.ToInt32(dt.Rows[i][3].ToString()); new_borrow.BName = listBox1.SelectedItems[0].ToString(); } new_borrow.ID = Convert.ToInt32(dt.Rows[i][0].ToString()); new_borrow.Is_return = 1; break; } } } return(true); }
private void 借阅情况_3_Click(object sender, EventArgs e) { listBox1.Items.Clear(); new_user = UserAdmin.GetUser(Convert.ToInt32(tb3_2.Text)); if (new_user == null) { MessageBox.Show("该用户不存在"); return; } dt = BorrowAdmin.GetBorrow(Convert.ToInt32(tb3_2.Text)); for (int i = 0; i < dt.Rows.Count; i++) { //if (Convert.ToInt32(dt.Rows[i][7]) == 0) if (dt.Rows[i][5].ToString() == "NO") { int x = int.Parse(dt.Rows[i][2].ToString()); new_book = BookAdmin.GetBook(x); listBox1.Items.Add(new_book.Name); } } }
private bool SetTextToBorrow() { if (tb3_2.Text == "") { MessageBox.Show("请输入完整信息"); return(false); } new_borrow.UID = Convert.ToInt32(tb3_2.Text); new_user = UserAdmin.GetUser(new_borrow.UID); if (tb3_3.Text != "") { new_borrow.BID = Convert.ToInt32(tb3_3.Text); new_book = BookAdmin.GetBook(new_borrow.BID); new_borrow.Is_return = "NO"; } new_borrow.Borrow_time = DateTime.Now; new_borrow.Return_time = DateTime.Now; if (listBox1.SelectedItems.Count != 0) { dt = BorrowAdmin.GetBorrow(new_borrow.UID); for (int i = 0; i < dt.Rows.Count; i++) { string bname = BookAdmin.GetBook(int.Parse(dt.Rows[i][2].ToString())).Name; if (bname == listBox1.SelectedItems[0].ToString() && dt.Rows[i][5].ToString() == "NO") { if (tb3_3.Text == "") { new_borrow.BID = Convert.ToInt32(dt.Rows[i][2].ToString()); } new_borrow.ID = Convert.ToInt32(dt.Rows[i][0].ToString()); new_borrow.Is_return = "YES"; break; } } } return(true); }
private bool SetTextToBook() { if (tb4_3.Text == "" || tb4_4.Text == "" || tb4_5.Text == "" || tb4_6.Text == "" || cb4_1.Text == "" || cb4_2.Text == "") { MessageBox.Show("请输入完整信息"); return(false); } new_book.Name = tb4_3.Text; new_book.Concern = tb4_4.Text; new_book.Author = tb4_5.Text; new_book.Price = float.Parse(tb4_6.Text); new_book.Condition = cb4_2.Text; dt = BookTypeAdmin.GetBookType(); for (int i = 0; i < dt.Rows.Count; i++) { if (cb4_1.Text == dt.Rows[i][1].ToString()) { new_book.Type = Convert.ToInt32(dt.Rows[i][0]); } } if (treeView2.SelectedNode != null) { string name = treeView2.SelectedNode.Text.Trim(); dt = BookAdmin.GetBook(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][1].ToString() == name) { new_book.ID = Convert.ToInt32(dt.Rows[i][0].ToString()); } } } return(true); }
private void btnBookScan_Click(object sender, EventArgs e) { dt = bookBLL.GetBook(); ShowData(); }