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