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