frmbookinfoview.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 frmBookInfoView : Form
    {
        //初始化frmBorrowInfo的实例　
     
        frmBorrowInfo objfrmBorrowInfo = null;
        //初始化业务层SelectInfo类的实例
       SelectInfo objSelectInfo = new SelectInfo();
        //构造方法
        public frmBookInfoView(frmBorrowInfo from)
        {
            objfrmBorrowInfo = from;
            InitializeComponent();
        }
        //页面加载时把BookInfo表中的数据返回给GridViewBookInfo里
        private void frmBookInfoView_Load(object sender, EventArgs e)
        {
            GridViewBookInfo.DataSource = objSelectInfo.GridViewBookInfoTable();
        }
        //为lstBookInfo添加图书信息列
        private void AddBookInfo()
        {

            objfrmBorrowInfo.lvItemBookID.SubItems.Add(GridViewBookInfo.CurrentRow.Cells[0].Value.ToString());
            objfrmBorrowInfo.lvItemBookName.SubItems.Add(GridViewBookInfo.CurrentRow.Cells[1].Value.ToString());
            objfrmBorrowInfo.lvItemBookAuthor.SubItems.Add(GridViewBookInfo.CurrentRow.Cells[3].Value.ToString());
            objfrmBorrowInfo.lvItemBookPrice.SubItems.Add(GridViewBookInfo.CurrentRow.Cells[5].Value.ToString());
            objfrmBorrowInfo.lvItemBookshelfName.SubItems.Add(GridViewBookInfo.CurrentRow.Cells[6].Value.ToString());
            objfrmBorrowInfo.lvItemBookStorageData.SubItems.Add(GridViewBookInfo.CurrentRow.Cells[9].Value.ToString());
            objfrmBorrowInfo.lvItemLivingNum.SubItems.Add(GridViewBookInfo.CurrentRow.Cells[7].Value.ToString());

            DataTable objBooks = new DataTable();
            objBooks.Columns.Add("BooksID", typeof(string));
            objBooks.Columns.Add("BooksName", typeof(string));
            objBooks.Columns.Add("BooksAuthor", typeof(string));
            objBooks.Columns.Add("BooksPrice", typeof(string));
            objBooks.Columns.Add("BooksborrowPrice",typeof(string));
            objBooks.Columns.Add("BooksEnterTime",typeof(string));
            objBooks.Columns.Add("BooksExistent",typeof(string));
            DataRow objBooksRows = objBooks.NewRow();
            objBooksRows["BooksID"] = GridViewBookInfo.CurrentRow.Cells[0].Value.ToString();
           objBooksRows["BooksName"] = GridViewBookInfo.CurrentRow.Cells[1].Value.ToString();
            objBooksRows["BooksAuthor"] = GridViewBookInfo.CurrentRow.Cells[3].Value.ToString();
            objBooksRows["BooksPrice"] = GridViewBookInfo.CurrentRow.Cells[5].Value.ToString();
            objBooksRows["BooksborrowPrice"] = GridViewBookInfo.CurrentRow.Cells[6].Value.ToString();
            objBooksRows["BooksEnterTime"] = GridViewBookInfo.CurrentRow.Cells[9].Value.ToString();
            objBooksRows["BooksExistent"] = GridViewBookInfo.CurrentRow.Cells[7].Value.ToString();
         objBooks.Rows.Add(objBooksRows);
         objfrmBorrowInfo.BoosDataTable = objBooks;
            this.Close();
        }
        /// <summary>
        /// 此方法判断当前已经激活哪个选项卡，然后把数据添加到lstBookInfo上
        /// </summary>
        private void SelectdataGridViewToString()
        {
            try
            {
                if (objfrmBorrowInfo.tabControl1.SelectedTab.Text == "出借资料")
                {
                    objfrmBorrowInfo.lstBookInfo.Items.Clear();//清空lstBookInfo的所有内容
                    objfrmBorrowInfo.AddLsitViewBookA();//添加lstBookInfo上的属性列
                    objfrmBorrowInfo.txtBookID.Text = GridViewBookInfo.CurrentRow.Cells[0].Value.ToString();
                    AddBookInfo();//添加lstBookInfo上的信息列
                }
                else if (objfrmBorrowInfo.tabControl1.SelectedTab.Text == "归还资料")
                {
                    objfrmBorrowInfo.lstBookInfoR.Items.Clear();//清空lstBookInfo的所有内容
                    objfrmBorrowInfo.AddLsitViewBookB();//添加lstBookInfo上的属性列
                    objfrmBorrowInfo.txtBookIDR.Text = GridViewBookInfo.CurrentRow.Cells[0].Value.ToString();
                    AddBookInfo();//添加lstBookInfo上的信息列
                }
                else if (objfrmBorrowInfo.tabControl1.SelectedTab.Text == "续借资料")
                {
                    objfrmBorrowInfo.lstBookInfoB.Items.Clear();//清空lstBookInfo的所有内容
                    objfrmBorrowInfo.AddLsitViewBookC();//添加lstBookInfo上的属性列
                    objfrmBorrowInfo.txtBookIDB.Text = GridViewBookInfo.CurrentRow.Cells[0].Value.ToString();
                    AddBookInfo();//添加lstBookInfo上的信息列
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 双机表中的任意一行数据后就把这行数据返回到lstBookInfo中
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GridViewBookInfo_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            SelectdataGridViewToString();
        }
        /// <summary>
        /// 此事件可以根据图书名称进行模糊查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtBookName_TextChanged(object sender, EventArgs e)
        {
            try{
                if (txtBookName.Text.Trim() == string.Empty)
                {
                    GridViewBookInfo.DataSource = null;
                    GridViewBookInfo.DataSource = objSelectInfo.GridViewBookInfoTable();
                }
                else
                {
                    GridViewBookInfo.DataSource = null;
                    GridViewBookInfo.DataSource = objSelectInfo.SeleLikeBookName(txtBookName.Text.Trim());
                }
            }catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 此事件可以根据图书编号进行模糊查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtBookIDorISBN_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (txtBookIDorISBN.Text.Trim() == string.Empty)
                {
                    GridViewBookInfo.DataSource = null;
                    GridViewBookInfo.DataSource = objSelectInfo.GridViewBookInfoTable();
                }
                else
                {
                    GridViewBookInfo.DataSource = null;
                    GridViewBookInfo.DataSource = objSelectInfo.SeleLikeBookID(txtBookIDorISBN.Text.Trim());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        //选择按钮事件
        private void butOK_Click(object sender, EventArgs e)
        {
            SelectdataGridViewToString();
        }
        //关闭当前窗体
        private void butEsc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}