/// <summary> /// 点击借阅历史 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_lendRecord_Click(object sender, EventArgs e) { DataTable dt = lendService.getLendByKeyWord(Common.user.user_name); if (dt.Rows.Count > 0) { dataGridView.Visible = true; dataGridView.DataSource = dt; dataGridView.Columns["lend_id"].HeaderText = "编号"; dataGridView.Columns["lend_user_id"].HeaderText = "用户编号"; dataGridView.Columns["lend_user_name"].HeaderText = "用户姓名"; dataGridView.Columns["lend_book_id"].HeaderText = "图书编号"; dataGridView.Columns["lend_book_name"].HeaderText = "书名"; dataGridView.Columns["lend_create_date"].HeaderText = "借出日期"; dataGridView.Columns["lend_update_date"].HeaderText = "更新日期"; dataGridView.Columns["lend_status"].HeaderText = "借阅状态"; } else { dataGridView.Visible = false; } }
/// <summary> /// 点击查找按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_search_Click(object sender, EventArgs e) { string btnType = btnSearch.Text; string keyWord = textBox_search.Text.Trim(); DataTable dt = null; switch (btnType) { case "查询用户": dt = userService.getUserByKeyWord(keyWord); break; case "查询图书": dt = bookService.getBookByKeyWord(keyWord); break; case "查询借阅": dt = lendService.getLendByKeyWord(keyWord); break; case "查询申请": dt = applyService.getApplyByKeyWord(keyWord); break; default: break; } if (dt.Rows.Count > 0) { dataGridView.DataSource = dt; dataGridView.Visible = true; } else { dataGridView.Visible = false; } }