frmborrowinfo.cs

数据库课程设计

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

namespace UI
{
    public partial class frmBorrowInfo : Form
    {
        //读者信息项
        public ListViewItem lvItemID;//读者编号
        public ListViewItem lvItemName;//读者姓名
        public ListViewItem lvItemSex;//读者性别
        public ListViewItem lvItemProfession;//类型
        public ListViewItem lvItemPrice;//押金
        public ListViewItem lvItemLose;//状态
        public ListViewItem lvItemTel;//联系方式
        public ListViewItem lvItemBorrowBookNum;//已借图书数量
        public DataTable ReaderDataTable;
        //图书信息项
        public ListViewItem lvItemBookID;//图书ID
        public ListViewItem lvItemBookName;//书名
        public ListViewItem lvItemBookAuthor;//作者
        public ListViewItem lvItemBookPrice;//价钱
        public ListViewItem lvItemBookshelfName;//借阅价格
        public ListViewItem lvItemBookStorageData;//入库时间
        public ListViewItem lvItemLivingNum;//库存量
        public DataTable BoosDataTable;
        //期刊信息项
        public ListViewItem lvItemMagazineID;//期刊编号
        public ListViewItem lvItemMagazineName;//期刊名称
        public ListViewItem lvItemMagazinePrice;//期刊价钱
        public ListViewItem lvItemMagazineshelfName;//期刊借阅价格
        public ListViewItem lvItemMagazineStorageData;//入库时间
        public ListViewItem lvItemMagazineLivingNum;//库存量
        public DataTable MagazineDataTable;
        //初始化业务层的SelectInfo类
        SelectInfo objSelectInfo = new SelectInfo();
        ReaderSelect objReaderSelect = new ReaderSelect();
        public string str1 = null;
        public double money1 = 0.5;
        public double money2 = 1;
        private frmMain fMain = null;

        public frmBorrowInfo()
        {
            InitializeComponent();
        }

        public frmBorrowInfo(frmMain fMain)
        {
            this.fMain = fMain;
            InitializeComponent();
        }
        //页面加载时给lstReaderInfo添加读者属性信息项
        public void AddLsitViewReaderA()
        {
            lvItemID = new ListViewItem();
            lvItemID.SubItems[0].Text = "读者编号:";
            lstReaderInfo.Items.Add(lvItemID);
            lvItemName = new ListViewItem();
            lvItemName.SubItems[0].Text = "读者姓名:";
            lstReaderInfo.Items.Add(lvItemName);
            lvItemSex = new ListViewItem();
            lvItemSex.SubItems[0].Text = "读者性别:";
            lstReaderInfo.Items.Add(lvItemSex);
            lvItemProfession = new ListViewItem();
            lvItemProfession.SubItems[0].Text = "读者类型:";
            lstReaderInfo.Items.Add(lvItemProfession);
            lvItemPrice = new ListViewItem();
            lvItemPrice.SubItems[0].Text = "当前押金:";
            lstReaderInfo.Items.Add(lvItemPrice);
            lvItemLose = new ListViewItem();
            lvItemLose.SubItems[0].Text = "当前状态:";
            lstReaderInfo.Items.Add(lvItemLose);
            lvItemTel = new ListViewItem();
            lvItemTel.SubItems[0].Text = "联系方式:";
            lstReaderInfo.Items.Add(lvItemTel);
            lvItemBorrowBookNum = new ListViewItem();
            lvItemBorrowBookNum.SubItems[0].Text = "已借图书:";
            lstReaderInfo.Items.Add(lvItemBorrowBookNum);
            //蓝色
            lvItemID.SubItems[0].ForeColor = Color.Blue;
            lvItemName.SubItems[0].ForeColor = Color.Blue;
            lvItemSex.SubItems[0].ForeColor = Color.Blue;
            lvItemProfession.SubItems[0].ForeColor = Color.Blue;
            lvItemPrice.SubItems[0].ForeColor = Color.Blue;
            lvItemLose.SubItems[0].ForeColor = Color.Blue;
            lvItemTel.SubItems[0].ForeColor = Color.Blue;
            lvItemBorrowBookNum.SubItems[0].ForeColor = Color.Blue;
        }
        //页面加载时给lstBookInfo添加图书属性信息项
        public void AddLsitViewBookA()
        {
            lvItemBookID = new ListViewItem();
            lvItemBookID.SubItems[0].Text = "图书编号:";
            lstBookInfo.Items.Add(lvItemBookID);
            lvItemBookName = new ListViewItem();
            lvItemBookName.SubItems[0].Text = "图书名称:";
            lstBookInfo.Items.Add(lvItemBookName);
            lvItemBookAuthor = new ListViewItem();
            lvItemBookAuthor.SubItems[0].Text = "作者:";
            lstBookInfo.Items.Add(lvItemBookAuthor);
            lvItemBookPrice = new ListViewItem();
            lvItemBookPrice.SubItems[0].Text = "价钱:";
            lstBookInfo.Items.Add(lvItemBookPrice);
            lvItemBookshelfName = new ListViewItem();
            lvItemBookshelfName.SubItems[0].Text = "借阅价格:";
            lstBookInfo.Items.Add(lvItemBookshelfName);
            lvItemBookStorageData = new ListViewItem();
            lvItemBookStorageData.SubItems[0].Text = "入库时间:";
            lstBookInfo.Items.Add(lvItemBookStorageData);
            lvItemLivingNum = new ListViewItem();
            lvItemLivingNum.SubItems[0].Text = "馆内余数:";
            lstBookInfo.Items.Add(lvItemLivingNum);
            //蓝色
            lvItemBookID.SubItems[0].ForeColor = Color.Blue;
            lvItemBookName.SubItems[0].ForeColor = Color.Blue;
            lvItemBookAuthor.SubItems[0].ForeColor = Color.Blue;
            lvItemBookPrice.SubItems[0].ForeColor = Color.Blue;
            lvItemBookshelfName.SubItems[0].ForeColor = Color.Blue;
            lvItemBookStorageData.SubItems[0].ForeColor = Color.Blue;
            lvItemLivingNum.SubItems[0].ForeColor = Color.Blue;
        }
        //页面加载时给lstBookInfo添加期刊属性信息项
        public void AddLsitViewMagazineA()
        {
            lvItemMagazineID = new ListViewItem();
            lvItemMagazineID.SubItems[0].Text = "期刊编号:";
            lstBookInfo.Items.Add(lvItemMagazineID);
            lvItemMagazineName = new ListViewItem();
            lvItemMagazineName.SubItems[0].Text = "期刊名称:";
            lstBookInfo.Items.Add(lvItemMagazineName);
            lvItemMagazinePrice = new ListViewItem();
            lvItemMagazinePrice.SubItems[0].Text = "期刊价钱:";
            lstBookInfo.Items.Add(lvItemMagazinePrice);
            lvItemMagazineshelfName = new ListViewItem();
            lvItemMagazineshelfName.SubItems[0].Text = "期刊借阅价格:";
            lstBookInfo.Items.Add(lvItemMagazineshelfName);
            lvItemMagazineStorageData = new ListViewItem();
            lvItemMagazineStorageData.SubItems[0].Text = "入库时间:";
            lstBookInfo.Items.Add(lvItemMagazineStorageData);
            lvItemMagazineLivingNum = new ListViewItem();
            lvItemMagazineLivingNum.SubItems[0].Text = "馆内余数:";
            lstBookInfo.Items.Add(lvItemMagazineLivingNum);
            //蓝色
            lvItemMagazineID.SubItems[0].ForeColor = Color.Blue;
            lvItemMagazineName.SubItems[0].ForeColor = Color.Blue;
            lvItemMagazinePrice.SubItems[0].ForeColor = Color.Blue;
            lvItemMagazineshelfName.SubItems[0].ForeColor = Color.Blue;
            lvItemMagazineStorageData.SubItems[0].ForeColor = Color.Blue;
            lvItemMagazineLivingNum.SubItems[0].ForeColor = Color.Blue;
        }
        //页面加载时给lstReaderInfo添加读者属性信息项
        public void AddLsitViewReaderB()
        {
            lvItemID = new ListViewItem();
            lvItemID.SubItems[0].Text = "读者编号:";
            lstReaderInfoR.Items.Add(lvItemID);
            lvItemName = new ListViewItem();
            lvItemName.SubItems[0].Text = "读者姓名:";
            lstReaderInfoR.Items.Add(lvItemName);
            lvItemSex = new ListViewItem();
            lvItemSex.SubItems[0].Text = "读者性别:";
            lstReaderInfoR.Items.Add(lvItemSex);
            lvItemProfession = new ListViewItem();
            lvItemProfession.SubItems[0].Text = "读者类型:";
            lstReaderInfoR.Items.Add(lvItemProfession);
            lvItemPrice = new ListViewItem();
            lvItemPrice.SubItems[0].Text = "当前押金:";
            lstReaderInfoR.Items.Add(lvItemPrice);
            lvItemLose = new ListViewItem();
            lvItemLose.SubItems[0].Text = "当前状态:";
            lstReaderInfoR.Items.Add(lvItemLose);
            lvItemTel = new ListViewItem();
            lvItemTel.SubItems[0].Text = "联系方式:";
            lstReaderInfoR.Items.Add(lvItemTel);
            lvItemBorrowBookNum = new ListViewItem();
            lvItemBorrowBookNum.SubItems[0].Text = "已借图书:";
            lstReaderInfoR.Items.Add(lvItemBorrowBookNum);
            //蓝色
            lvItemID.SubItems[0].ForeColor = Color.Blue;
            lvItemName.SubItems[0].ForeColor = Color.Blue;
            lvItemSex.SubItems[0].ForeColor = Color.Blue;
            lvItemProfession.SubItems[0].ForeColor = Color.Blue;
            lvItemPrice.SubItems[0].ForeColor = Color.Blue;
            lvItemLose.SubItems[0].ForeColor = Color.Blue;
            lvItemTel.SubItems[0].ForeColor = Color.Blue;
            lvItemBorrowBookNum.SubItems[0].ForeColor = Color.Blue;
        }
        //页面加载时给lstBookInfo添加图书属性信息项
        public void AddLsitViewBookB()
        {
            lvItemBookID = new ListViewItem();
            lvItemBookID.SubItems[0].Text = "图书编号:";
            lstBookInfoR.Items.Add(lvItemBookID);
            lvItemBookName = new ListViewItem();
            lvItemBookName.SubItems[0].Text = "图书名称:";
            lstBookInfoR.Items.Add(lvItemBookName);
            lvItemBookAuthor = new ListViewItem();
            lvItemBookAuthor.SubItems[0].Text = "借阅价钱:";
            lstBookInfoR.Items.Add(lvItemBookAuthor);
            lvItemBookPrice = new ListViewItem();
            lvItemBookPrice.SubItems[0].Text = "价钱:";
            lstBookInfoR.Items.Add(lvItemBookPrice);
            lvItemBookshelfName = new ListViewItem();
            lvItemBookshelfName.SubItems[0].Text = "书籍类型:";
            lstBookInfoR.Items.Add(lvItemBookshelfName);
            lvItemBookStorageData = new ListViewItem();
            lvItemBookStorageData.SubItems[0].Text = "入库时间:";
            lstBookInfoR.Items.Add(lvItemBookStorageData);
            lvItemLivingNum = new ListViewItem();
            lvItemLivingNum.SubItems[0].Text = "馆内余数:";
            lstBookInfoR.Items.Add(lvItemLivingNum);
            //蓝色
            lvItemBookID.SubItems[0].ForeColor = Color.Blue;
            lvItemBookName.SubItems[0].ForeColor = Color.Blue;
            lvItemBookAuthor.SubItems[0].ForeColor = Color.Blue;
            lvItemBookPrice.SubItems[0].ForeColor = Color.Blue;
            lvItemBookshelfName.SubItems[0].ForeColor = Color.Blue;
            lvItemBookStorageData.SubItems[0].ForeColor = Color.Blue;
            lvItemLivingNum.SubItems[0].ForeColor = Color.Blue;
        }
        //页面加载时给lstBookInfo添加期刊属性信息项
        public void AddLsitViewMagazineB()
        {
            lvItemMagazineID = new ListViewItem();
            lvItemMagazineID.SubItems[0].Text = "期刊编号:";
            lstBookInfoR.Items.Add(lvItemMagazineID);
            lvItemMagazineName = new ListViewItem();
            lvItemMagazineName.SubItems[0].Text = "期刊名称:";
            lstBookInfoR.Items.Add(lvItemMagazineName);
            lvItemMagazinePrice = new ListViewItem();
            lvItemMagazinePrice.SubItems[0].Text = "期刊价钱:";
            lstBookInfoR.Items.Add(lvItemMagazinePrice);
            lvItemMagazineshelfName = new ListViewItem();
            lvItemMagazineshelfName.SubItems[0].Text = "期刊借阅价格:";
            lstBookInfoR.Items.Add(lvItemMagazineshelfName);
            lvItemMagazineStorageData = new ListViewItem();
            lvItemMagazineStorageData.SubItems[0].Text = "入库时间:";