public void InitMenu()
{
#region 分配权限
if (!user.IsAdmin())
{
tabPage3.Parent = null;
tabPage4.Parent = null;
}
else
{
tabPage3.Parent = this.tabControl1;
tabPage4.Parent = this.tabControl1;
}
#endregion
#region 获取读者信息
lab1_1.Text = user.ID.ToString();
lab1_2.Text = user.Name;
lab1_3.Text = user.Sex;
lab1_4.Text = user.CertType;
lab1_5.Text = user.Cert;
lab1_6.Text = user.Phone;
#endregion
#region 初始化界面
tabControl1.SelectedIndex = 0;
dt = BorrowAdmin.GetBorrow(user.ID);
dataGridView1.DataSource = dt;
#endregion
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.tabControl1.SelectedIndex == 0)
{
dt = BorrowAdmin.GetBorrow(user.ID);
dataGridView1.DataSource = dt;
foreach (DataColumn dc in dt.Columns)
{
dataGridView1.Columns[dc.ColumnName].HeaderText = Borrow.ColumnTitle(dc.ColumnName);
}
}
else if (this.tabControl1.SelectedIndex == 1)
{
BookCatalogUpdate(treeView1);
}
else if (this.tabControl1.SelectedIndex == 3)
{
BookTypeUpdate();
BookCatalogUpdate(treeView2);
Clear_4();
Clear_44();
}
else if (this.tabControl1.SelectedIndex == 4)
{
dt = UserAdmin.GetUser();
dataGridView2.DataSource = dt;
foreach (DataColumn dc in dt.Columns)
{
dataGridView2.Columns[dc.ColumnName].HeaderText = User.ColumnTitle(dc.ColumnName);
}
}
}
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 注销_5_Click(object sender, EventArgs e)
{
int ID;
ID = Convert.ToInt32(tb5_6.Text.Trim());
new_user = UserAdmin.GetUser(ID);
if (new_user == null)
{
MessageBox.Show("无此用户！");
return;
}
if (tb5_7.Text != new_user.Pwd)
{
MessageBox.Show("密码不正确！");
return;
}
dt = BorrowAdmin.GetBorrow(ID);
int num = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
//if (Convert.ToInt32(dt.Rows[i][7]) == 0)
if (dt.Rows[i][7].ToString() == "False")
{
num++;
}
}
if (num != 0)
{
MessageBox.Show("该用户有未归还的书！");
return;
}
new_borrow.UID = new_user.ID;
borrowBLL.Delete(new_borrow);
userBLL.Delete(new_user);
MessageBox.Show("状态：注销成功！");
tb5_6.Text = "";
tb5_7.Text = "";
if (ID == user.ID)
{
Login form = new Login();
form.main = this;
form.Show();
this.Hide();
user = null;
}
}
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 tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.tabControl1.SelectedIndex == 0)
{
dt = BorrowAdmin.GetBorrow(user.ID);
dataGridView1.DataSource = dt;
}
else if (this.tabControl1.SelectedIndex == 1)
{
BookCatalogUpdate(treeView1);
}
else if (this.tabControl1.SelectedIndex == 3)
{
BookTypeUpdate();
BookCatalogUpdate(treeView2);
Clear_4();
Clear_44();
}
}
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][7].ToString() == "False")
{
listBox1.Items.Add(dt.Rows[i][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 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 void 除图书_4_Click(object sender, EventArgs e)
{
if (SetTextToBook())
{
dt = BorrowAdmin.GetBorrow();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][7].ToString() == "False" && dt.Rows[i][4].ToString() == new_book.Name)
{
MessageBox.Show("该书未被归还");
return;
}
}
new_borrow.BID = new_book.ID;
new_borrow.BName = "";
new_borrow.UName = "";
borrowBLL.DeleteBook(new_borrow);
bookBLL.Delete(new_book);
MessageBox.Show("状态：删除成功！");
}
BookCatalogUpdate(treeView2);
Clear_4();
}
