基本信息
源码名称:三层架构图书管理系统源码下载(access数据库)
源码大小:10.29M
文件格式:.zip
开发语言:C#
更新时间:2017-11-29
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559
本次赞助数额为: 2 元×
微信扫码支付:2 元
×
请留下您的邮箱,我们将在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("请选择需要还的书!","提示");
}
}
}
}