frmreaderinfoview.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 frmReaderInfoView : Form
    {
        //初始化Bussiness层的SelectInfo对象
        SelectInfo objSelectInfo = new SelectInfo();
        //声明借阅管理面板　
        frmBorrowInfo objfrmBorrowInfo = null;
        public frmReaderInfoView(frmBorrowInfo from)
        {
            objfrmBorrowInfo = from;
            InitializeComponent();
        }

        //页面加载时将GridViewReaderInfo填充数据
        private void frmReaderInfo_Load(object sender, EventArgs e)
        {
            GridViewReaderInfo.DataSource = objSelectInfo.GridViewReaderTable();
        }
        //此方法为lstReaderInfo添加读者信息列
        private void AddReaderInfo()
        {
            DataTable objReader = new DataTable();
            objReader.Columns.Add("ReaderID", typeof(string));
            objReader.Columns.Add("ReaderName", typeof(string));
            objReader.Columns.Add("ReaderSex", typeof(string));
            objReader.Columns.Add("ReaderDistinction", typeof(string));
            objReader.Columns.Add("ReaderMoney", typeof(string));
            objReader.Columns.Add("ReaderState",typeof(string));
            objReader.Columns.Add("ReaderPhone",typeof(string));
            objReader.Columns.Add("ReaderBookBorrowNum",typeof(string));
            objfrmBorrowInfo.lvItemID.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[0].Value.ToString());
            objfrmBorrowInfo.lvItemName.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[1].Value.ToString());
            objfrmBorrowInfo.lvItemSex.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[2].Value.ToString());
            objfrmBorrowInfo.lvItemProfession.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[9].Value.ToString());
            objfrmBorrowInfo.lvItemPrice.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[11].Value.ToString());
            objfrmBorrowInfo.lvItemLose.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[16].Value.ToString());
            objfrmBorrowInfo.lvItemTel.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[6].Value.ToString());
            objfrmBorrowInfo.lvItemBorrowBookNum.SubItems.Add(GridViewReaderInfo.CurrentRow.Cells[14].Value.ToString());
            DataRow objReaderRows = objReader.NewRow();

            objReaderRows["ReaderID"] = GridViewReaderInfo.CurrentRow.Cells[0].Value.ToString();
            objReaderRows["ReaderName"] = GridViewReaderInfo.CurrentRow.Cells[1].Value.ToString();
            objReaderRows["ReaderSex"] = GridViewReaderInfo.CurrentRow.Cells[2].Value.ToString();
            objReaderRows["ReaderDistinction"] = GridViewReaderInfo.CurrentRow.Cells[9].Value.ToString();
            objReaderRows["ReaderMoney"] = GridViewReaderInfo.CurrentRow.Cells[11].Value.ToString();
            objReaderRows["ReaderState"] = GridViewReaderInfo.CurrentRow.Cells[16].Value.ToString();
            objReaderRows["ReaderPhone"] = GridViewReaderInfo.CurrentRow.Cells[6].Value.ToString();
            objReaderRows["ReaderBookBorrowNum"] = GridViewReaderInfo.CurrentRow.Cells[14].Value.ToString();
            objReader.Rows.Add(objReaderRows);
            objfrmBorrowInfo.ReaderDataTable = objReader;
            this.Close();
        }
        /// <summary>
        /// 此方法判断当前已经激活哪个选项卡，然后为lstReaderInfo上添加数据
        /// </summary>
        private void SelectdataGridViewToString()
        {
            try
            {
                if (objfrmBorrowInfo.tabControl1.SelectedTab.Text == "出借资料")
                {
                    objfrmBorrowInfo.lstReaderInfo.Items.Clear();//清空lstReaderInfo全部内容
                    objfrmBorrowInfo.AddLsitViewReaderA();//添加lstReaderInfo上的属性列
                    objfrmBorrowInfo.txtReaderID.Text = GridViewReaderInfo.CurrentRow.Cells[0].Value.ToString();
                    AddReaderInfo();//添加lstReaderInfo上的信息列
                }
                else if (objfrmBorrowInfo.tabControl1.SelectedTab.Text == "归还资料")
                {
                    objfrmBorrowInfo.lstReaderInfoR.Items.Clear();//清空lstReaderInfo全部内容
                    objfrmBorrowInfo.AddLsitViewReaderB();//添加lstReaderInfo上的属性列
                    objfrmBorrowInfo.txtReaderIDR.Text = GridViewReaderInfo.CurrentRow.Cells[0].Value.ToString();
                    AddReaderInfo();//添加lstReaderInfo上的信息列
                }
                else if (objfrmBorrowInfo.tabControl1.SelectedTab.Text == "续借资料")
                {
                    objfrmBorrowInfo.lstReaderInfoB.Items.Clear();//清空lstReaderInfo全部内容
                    objfrmBorrowInfo.AddLsitViewReaderC();//添加lstReaderInfo上的属性列
                    objfrmBorrowInfo.txtReaderIDB.Text = GridViewReaderInfo.CurrentRow.Cells[0].Value.ToString();
                    AddReaderInfo();//添加lstReaderInfo上的信息列
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 双机GridViewReaderInfo上的某行数据后把这行数据返回给lstBookInfo中
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GridViewReaderInfo_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            SelectdataGridViewToString();
        }
        /// <summary>
        /// 此方法按读者姓名模糊查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtReaderName_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (txtReaderName.Text.Trim() == string.Empty)
                {
                    GridViewReaderInfo.DataSource = null;
                    GridViewReaderInfo.DataSource = objSelectInfo.GridViewReaderTable();
                }
                else
                {
                    GridViewReaderInfo.DataSource = null;
                    GridViewReaderInfo.DataSource = objSelectInfo.SeleLikeName(txtReaderName.Text.Trim());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 此方法按读者编号模糊查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtReaderID_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (txtReaderID.Text.Trim() == string.Empty)
                {
                    GridViewReaderInfo.DataSource = null;
                    GridViewReaderInfo.DataSource = objSelectInfo.GridViewReaderTable();
                }
                else
                {
                    GridViewReaderInfo.DataSource = null;
                    GridViewReaderInfo.DataSource = objSelectInfo.SeleLikeID(txtReaderID.Text.Trim());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        //选择按钮事件
        private void btuOK_Click(object sender, EventArgs e)
        {
            SelectdataGridViewToString();
        }
        //关闭当前的窗体
        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void GridViewReaderInfo_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }
    }
}