基本信息
源码名称:三层架构图书管理系统源码下载(access数据库)
源码大小:10.29M
文件格式:.zip
开发语言:C#
更新时间:2017-11-29
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559

本次赞助数额为: 2 元 
   源码介绍




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("请选择需要还的书!","提示");
            }
            
        }

        
    }
}