frmborrowinfo.cs

数据库课程设计

            lstBookInfoR.Items.Add(lvItemMagazineStorageData);
            lvItemMagazineLivingNum = new ListViewItem();
            lvItemMagazineLivingNum.SubItems[0].Text = "馆内余数:";
            lstBookInfoR.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 AddLsitViewReaderC()
        {
            lvItemID = new ListViewItem();
            lvItemID.SubItems[0].Text = "读者编号:";
            lstReaderInfoB.Items.Add(lvItemID);
            lvItemName = new ListViewItem();
            lvItemName.SubItems[0].Text = "读者姓名:";
            lstReaderInfoB.Items.Add(lvItemName);
            lvItemSex = new ListViewItem();
            lvItemSex.SubItems[0].Text = "读者性别:";
            lstReaderInfoB.Items.Add(lvItemSex);
            lvItemProfession = new ListViewItem();
            lvItemProfession.SubItems[0].Text = "读者类型:";
            lstReaderInfoB.Items.Add(lvItemProfession);
            lvItemPrice = new ListViewItem();
            lvItemPrice.SubItems[0].Text = "当前押金:";
            lstReaderInfoB.Items.Add(lvItemPrice);
            lvItemLose = new ListViewItem();
            lvItemLose.SubItems[0].Text = "当前状态:";
            lstReaderInfoB.Items.Add(lvItemLose);
            lvItemTel = new ListViewItem();
            lvItemTel.SubItems[0].Text = "联系方式:";
            lstReaderInfoB.Items.Add(lvItemTel);
            lvItemBorrowBookNum = new ListViewItem();
            lvItemBorrowBookNum.SubItems[0].Text = "已借图书:";
            lstReaderInfoB.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 AddLsitViewBookC()
        {
            lvItemBookID = new ListViewItem();
            lvItemBookID.SubItems[0].Text = "图书编号:";
            lstBookInfoB.Items.Add(lvItemBookID);
            lvItemBookName = new ListViewItem();
            lvItemBookName.SubItems[0].Text = "图书名称:";
            lstBookInfoB.Items.Add(lvItemBookName);
            lvItemBookAuthor = new ListViewItem();
            lvItemBookAuthor.SubItems[0].Text = "作者:";
            lstBookInfoB.Items.Add(lvItemBookAuthor);
            lvItemBookPrice = new ListViewItem();
            lvItemBookPrice.SubItems[0].Text = "价钱:";
            lstBookInfoB.Items.Add(lvItemBookPrice);
            lvItemBookshelfName = new ListViewItem();
            lvItemBookshelfName.SubItems[0].Text = "借阅价格:";
            lstBookInfoB.Items.Add(lvItemBookshelfName);
            lvItemBookStorageData = new ListViewItem();
            lvItemBookStorageData.SubItems[0].Text = "入库时间:";
            lstBookInfoB.Items.Add(lvItemBookStorageData);
            lvItemLivingNum = new ListViewItem();
            lvItemLivingNum.SubItems[0].Text = "馆内余数:";
            lstBookInfoB.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;
        }
        private void frmBorrowInfo_Load(object sender, EventArgs e)
        {
            //界面加载时为lstReaderInfo添加列
            lstReaderInfo.View = View.Details;
            lstReaderInfo.Columns.Add("属性", 100, HorizontalAlignment.Center);
            lstReaderInfo.Columns.Add("信息", 122, HorizontalAlignment.Center);
            //界面加载时为lstReaderInfoR添加列
            lstReaderInfoR.View = View.Details;
            lstReaderInfoR.Columns.Add("属性", 100, HorizontalAlignment.Center);
            lstReaderInfoR.Columns.Add("信息", 122, HorizontalAlignment.Center);
            //界面加载时为lstReaderInfoB添加列
            lstReaderInfoB.View = View.Details;
            lstReaderInfoB.Columns.Add("属性", 100, HorizontalAlignment.Center);
            lstReaderInfoB.Columns.Add("信息", 122, HorizontalAlignment.Center);
            //界面加载时为lstBookInfo添加列
            lstBookInfo.View = View.Details;
            lstBookInfo.Columns.Add("属性", 100, HorizontalAlignment.Center);
            lstBookInfo.Columns.Add("信息", 122, HorizontalAlignment.Center);
            //界面加载时为lstBookInfoR添加列
            lstBookInfoR.View = View.Details;
            lstBookInfoR.Columns.Add("属性", 100, HorizontalAlignment.Center);
            lstBookInfoR.Columns.Add("信息", 122, HorizontalAlignment.Center);
            //界面加载时为lstBookInfoB添加列
            lstBookInfoB.View = View.Details;
            lstBookInfoB.Columns.Add("属性", 100, HorizontalAlignment.Center);
            lstBookInfoB.Columns.Add("信息", 122, HorizontalAlignment.Center);
        }
        /// <summary>
        /// 读者部分
        /// 此事件弹出一个可以按读者姓名或编号模糊查询的界面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnReaderQuery_Click(object sender, EventArgs e)
        {

            try
            {
                frmReaderInfoView objfrmReader = new frmReaderInfoView(this);
                objfrmReader.MdiParent = fMain;
                objfrmReader.Show();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 归还部分
        /// 此事件弹出一个可以按读者姓名或编号模糊查询的界面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnReaderQueryR_Click_1(object sender, EventArgs e)
        {
            btnReaderQuery_Click(sender, e);
        }
        /// <summary>
        /// 归还部分
        /// 如果选中图书信息就打开图书模糊查询界面，否则打开期刊模糊查询界面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnBookQueryR_Click_1(object sender, EventArgs e)
        {
            if (radBookR.Checked)//是否选中图书信息单选按钮
            {
                try
                {
                    frmBookInfoView objBookInfoView = new frmBookInfoView(this);
                    objBookInfoView.MdiParent = fMain;
                    objBookInfoView.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else
            {
                try
                {
                    frmMagazineInfoView objfrmMagazineView = new frmMagazineInfoView(this);
                   objfrmMagazineView.MdiParent = fMain;
                    objfrmMagazineView.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
        /// <summary>
        /// 续借部分
        /// 此事件弹出一个可以按读者姓名或编号模糊查询的界面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnReaderQueryB_Click(object sender, EventArgs e)
        {
            btnReaderQuery_Click(sender, e);
        }
        /// <summary>
        /// 续借部分
        /// 期刊不能续借
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnBookQueryB_Click(object sender, EventArgs e)
        {
            if (radBookX.Checked)//是否选中图书信息单选按钮
            {
                try
                {
                    frmBookInfoView objBookInfoView = new frmBookInfoView(this);
                    objBookInfoView.MdiParent = fMain;
                    objBookInfoView.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else
            {
                try
                {
                    frmMagazineInfoView objfrmMagazineView = new frmMagazineInfoView(this);
                    objfrmMagazineView.MdiParent = fMain;
                    objfrmMagazineView.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        
        /// <summary>
        /// 此方法是对借阅图书时的验证
        /// </summary>
        private void CheckBorrowBook()
        {
            double ReaderMoney;
            double BookMoney;

            try
            {
                //验证当前图书的库存量是否大于要借出的数量
                if (Convert.ToInt32(BoosDataTable.Rows[0][6].ToString()) >= 1)
                {
                    ReaderMoney = Convert.ToDouble(ReaderDataTable.Rows[0][4].ToString());//当前读者的押金
                    BookMoney = Convert.ToDouble(BoosDataTable.Rows[0][3].ToString());//图书的价钱
                    if (ReaderMoney > BookMoney)//如果读者的押金大于图书的价钱
                    {
                        //调用图书借阅存储过程（4个参数）
                        objSelectInfo.ProcBorrow(ReaderDataTable.Rows[0][0].ToString(), BoosDataTable.Rows[0][0].ToString(), BookMoney);
                        MessageBox.Show("图书借阅成功!", "成功");
                    }
                    else
                    {