三层架构图书管理系统源码下载(access数据库)

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Test1.View
{
    public partial class BorrowBook_Mgr : Form
    {
        public BorrowBook_Mgr()
        {
            InitializeComponent();
        }

        private BLL.BookQuery_BLL bookQueryMethod = new BLL.BookQuery_BLL();
        private BLL.ReaderQuery_BLL readerQueryMethod = new BLL.ReaderQuery_BLL();
        private BLL.BorrowBook_BLL borrowBookMethod = new BLL.BorrowBook_BLL();

        /// <summary>
        /// 显示全部读者
        /// </summary>
        private void displayAllReaderInView()
        {
            readerListView.DataSource = readerQueryMethod.GetAllReaderlist();
        }

        /// <summary>
        /// 根据读者姓名查询按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void readerNameQuery_Btn_Click(object sender, EventArgs e)
        {
            readerListView.DataSource = readerQueryMethod.QueryReaderByName(readerName_Query_Txt.Text);
            readerListView.Refresh();
        }


        /// <summary>
        /// 根据读者ID查询按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void readerIDQuery_Btn_Click(object sender, EventArgs e)
        {
            readerListView.DataSource = readerQueryMethod.QueryReaderByID(readerIDQuery_txt.Text);
            readerListView.Refresh();
        }

        /// <summary>
        /// 界面加载时执行
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void BorrowBook_Mgr_Load(object sender, EventArgs e)
        {
            displayAllReaderInView();
        }

        /// <summary>
        /// 对读者信息选择变化事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void readerListView_SelectionChanged(object sender, EventArgs e)
        {
            if (readerListView.SelectedRows.Count > 0)
            {
                personBorrowedBookDisplay();
                readerBorrowedBook_label.Text = readerListView.SelectedRows[0].Cells["ReaderName"].Value.ToString().Trim()   "借阅的书籍列表：";
            }
        }

        /// <summary>
        /// 选择读者信息，读者借阅的书籍显示功能
        /// </summary>
        private void personBorrowedBookDisplay()
        {
            
            string selectionedReaderID = readerListView.SelectedRows[0].Cells["ReaderID"].Value.ToString().Trim();
            borrowedBookListView.DataSource = borrowBookMethod.PersonBorrowedBooksList(selectionedReaderID);
            borrowedBookListView.Refresh();
        }

        private void borrowBook_Btn_Click(object sender, EventArgs e)
        {
            if (readerListView.SelectedRows.Count > 0)
            {

                string selectionedReaderID = readerListView.SelectedRows[0].Cells["ReaderID"].Value.ToString().Trim();
                string selectionedReaderName = readerListView.SelectedRows[0].Cells["ReaderName"].Value.ToString().Trim();

                View.PersonBorrowBookAdd personBorrowBookAdd = new PersonBorrowBookAdd();
                personBorrowBookAdd.Text =selectionedReaderName   "读者书籍借阅";
                personBorrowBookAdd.ReaderID = selectionedReaderID;
                personBorrowBookAdd.ReaderName = selectionedReaderName;
                personBorrowBookAdd.personalBorrowedBookListRefresh  = new PersonBorrowBookAdd.personalBorrowedBookEventHandler(personBorrowBookAdd_personalBorrowedBookListRefresh);
                personBorrowBookAdd.ShowDialog();
            }
            else
            {
                MessageBox.Show("请选择需要借阅的读者！","提示");
            }
        }

        /// <summary>
        /// 读者借阅界面委托执行的读者借阅书籍更新
        /// </summary>
        private void personBorrowBookAdd_personalBorrowedBookListRefresh()
        {
            personBorrowedBookDisplay();
        }

        /// <summary>
        /// 还书功能
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void returnBook_Btn_Click(object sender, EventArgs e)
        {
            if (borrowedBookListView.SelectedRows.Count > 0)
            {
                int borrowID = int.Parse(borrowedBookListView.SelectedRows[0].Cells["BorrowID"].Value.ToString());
                bool iResult = borrowBookMethod.ReturnBook(borrowID);
                if (iResult)
                {
                    MessageBox.Show(borrowedBookListView.SelectedRows[0].Cells["ReaderName"].Value.ToString()   "还书《"   borrowedBookListView.SelectedRows[0].Cells["BorrowedBookName"].Value.ToString()   "》成功！", "提示");
                }
                else
                {
                    MessageBox.Show(borrowedBookListView.SelectedRows[0].Cells["ReaderName"].Value.ToString()   "还书《"   borrowedBookListView.SelectedRows[0].Cells["BorrowedBookName"].Value.ToString()   "》失败！", "提示");
                }
                personBorrowedBookDisplay();
            }
            else
            {
                MessageBox.Show("请选择需要还的书！","提示");
            }
            
        }

        
    }
}