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 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 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 loginBtn_Click(object sender, EventArgs e)
{
UserDAO dao = UserDAO.getInstance();
string inputId = idTxt.Text;
string inputPw = pwTxt.Text;
bool re = dao.userLogin(inputId, inputPw);
if (re)
{
Form frm;
this.Visible = false;
if (inputId == "root")
{
frm = new BookAdmin();
}
else
{
frm = new index(inputId);
}
frm.Owner = this;
frm.Show();
}
else
{
MessageBox.Show("아이디 또는 비밀번호 오류 입니다.");
}
}
public UserRankUpdate(BookAdmin bookAdmin, string rank, int c_idx)
{
InitializeComponent();
this.bookAdmin = bookAdmin;
this.rank = rank;
this.c_idx = c_idx;
ComboAfterRank.SelectedIndex = 0;
}
private void dgvBook_SelectionChanged(object sender, EventArgs e)
{
if (dgvBook.CurrentCell == null)
{
return;
}
book = BookAdmin.GetBook((int)dgvBook["bkID", dgvBook.CurrentCell.RowIndex].Value);
SetBookToText();
}
public UpdateUser(BookAdmin bookAdmin, string id, string name, string phone, string birth, int c_idx)
{
InitializeComponent();
this.bookAdmin = bookAdmin;
txtUserId.Text = id;
txtUserName.Text = name;
txtUserBirth.Text = birth;
string[] _phone = phone.Split('-');
txtUserPhone1.Text = _phone[0];
txtUserPhone2.Text = _phone[1];
txtUserPhone3.Text = _phone[2];
userDTO.C_idx = c_idx;
}
private void loginBtn_Click(object sender, EventArgs e)
{
if (idTxt.Text.Trim() == "" || pwTxt.Text.Trim() == "")
{
MessageBox.Show("아이디 혹은 비밀번호를 입력해주세요.");
return;
}
UserDAO dao = UserDAO.getInstance();
string inputId = idTxt.Text;
string inputPw = pwTxt.Text;
if (id != inputId)
{
id = inputId;
count = 0;
}
bool re = dao.userLogin(inputId, inputPw);
if (re)
{
string userRank = dao.checkUserRank(inputId);
int age = dao.checkAge(inputId);
Form frm;
if (inputId == "root" || userRank == "관리자" || userRank == "사서")
{
frm = new BookAdmin(userRank, userRank);
}
else
{
frm = new index(inputId, userRank, age);
}
frm.Owner = this;
frm.Show();
this.Hide();
}
else
{
if (id == inputId && count < 4)
{
MessageBox.Show("아이디 또는 비밀번호 오류 입니다.");
count++;
}
else
if (MessageBox.Show("로그인 5회 오류 입니다.\r아이디 또는 비밀번호 찾기를 하시겠습니까?", "아이디, 비밀번호 찾기", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
IdPw_SearchForm findForm = new IdPw_SearchForm();
findForm.ShowDialog();
}
}
}
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 = "";
}
// [ValidateAntiForgeryToken]
public async Task <IActionResult> Register([FromBody] AuthModel model)
{
if (ModelState.IsValid)
{
var user = new BookAdmin {
UserName = model.Username
};
var result = await userManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await signInManager.SignInAsync(user, isPersistent : false);
return(Ok(user));
}
return(StatusCode(500));
}
return(BadRequest(model));
}
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);
}
public QA_answer(BookAdmin bookAdmin, int idx)
{
InitializeComponent();
this.bookAdmin = bookAdmin;
this.idx = idx;
}
public AddNotice(BookAdmin bookAdmin)
{
InitializeComponent();
this.bookAdmin = bookAdmin;
}
public UpdatePublisher(BookAdmin bookAdmin, string publisherName)
{
InitializeComponent();
this.bookAdmin = bookAdmin;
txtBefore.Text = publisherName;
}
public updateCategoryForm(BookAdmin form, string updateCategory)
{
InitializeComponent();
txtBefore.Text = updateCategory;
this.form = form;
}
