frmreaderinfo.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 frmReaderInfo : Form
    {
        //实例化business 类
        ReaderSelect obj = new ReaderSelect();
        //实例化一个数据集中的表
        DataTable objTable = new DataTable();
        public frmReaderInfo()
        {
            InitializeComponent();
        }

        //添加读者信息
        private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                frmAddNewReader f = new frmAddNewReader();
                f.Show();
                objTable = obj.RetureTable();
                whereSelect(objTable);
            }catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            
        }

        /// <summary>
        /// 通过选定行，修改读者信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnAmend_Click(object sender, EventArgs e)
        {
            try
            {
                if (!dgMagazine.IsSelected(dgMagazine.CurrentRowIndex))
                {
                    MessageBox.Show("没有选定行，无法修改~~","错误");
                    return;
                }
                DataRow objDataRow = objTable.Rows[dgMagazine.CurrentRowIndex];
                frmReaderManage f = new frmReaderManage(objDataRow);
                f.Show();
                whereSelect(obj.RetureTable());
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //精确查询读者
        private void btnAllShow_Click(object sender, EventArgs e)
        {
           frmPartShow f = new frmPartShow(this);
            f.ShowDialog();
        }

        //退出此子窗体
        private void btnExcel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        //Load事件中为DataGrid中载入数据
        private void frmReaderInfo_Load(object sender, EventArgs e)
        {
            try
            {
                objTable = obj.RetureTable();
                dgMagazine.DataSource = objTable;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //全部显示记录
        private void btnAllShow_Click_1(object sender, EventArgs e)
        {
            try
            {
                objTable = obj.RetureTable();
                whereSelect(objTable);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //删除选定行的读者信息
        private void btnDelete_Click(object sender, EventArgs e)
        {

            try
            {
                if (!dgMagazine.IsSelected(dgMagazine.CurrentRowIndex))
                {
                    MessageBox.Show("无法删除~请选定要删除的行~", "错误");
                    return;
                }
                DialogResult objDialogResult = MessageBox.Show("确认删除,数据删除将无法恢复!", "确认",
                    MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (objDialogResult == DialogResult.No)
                {
                    return;
                }
                else
                {
                    DataRow objDataRow = objTable.Rows[dgMagazine.CurrentRowIndex];
                    obj.procDeleteReaderID((string)objDataRow[0]);
                    whereSelect(obj.RetureTable());
                    MessageBox.Show("删除记录成功!");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message); 
                return;
            }

        }

        //一个全部显示的方法——为实现即时更新
        public void whereSelect(DataTable objdattab)
        {

            dgMagazine.DataSource = null;
            dgMagazine.DataSource = objdattab;
        }
    }
}