frmbookconcerninfo.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 frmBookConcernInfo : Form
    {
        DataTable objDataTable;
        SelectInfo objSelectInfo = new SelectInfo();
        BookConcern objBookConcern = new BookConcern();
        Books objBooks = new Books();
        public frmBookConcernInfo()
        {
            InitializeComponent();
        }
        //自己做的方法Xian()用于把查询出来的
        //表的全部信息显示在DataGrid中
        public void xian()
        {
           
            objDataTable = objSelectInfo.GridViewBookConcernnfoTable();

            this.dgMagazine.DataSource = objDataTable;

        }
        //点击事件全部显示调用Xian()的方法!
        private void button5_Click(object sender, EventArgs e)
        {
            xian();
        }
        //得到用户要查询输入的出版社编号的信息,
        //判断输入的数据表里有没有!如果有则显示这条记录!
        private void txtMagazineID_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (txtMagazineID.Text.Trim() == string.Empty)
                {
                    dgMagazine.DataSource = null;
                     objDataTable = objSelectInfo.GridViewBookConcernnfoTable();
                     dgMagazine.DataSource = objDataTable;
                }
                else
                {
                    dgMagazine.DataSource = null;
                   objDataTable = objSelectInfo.selectLikeBookConcernID(txtMagazineID.Text.Trim());
                   dgMagazine.DataSource = objDataTable;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //得到用户要查询输入的出版社名称的信息,
        //判断输入的数据表里有没有!如果有则显示这条记录!
        private void txtMagazineName_TextChanged(object sender, EventArgs e)
        {
            try{
             if (txtMagazineName.Text.Trim() == string.Empty)
                {
                    dgMagazine.DataSource = null;
                  objDataTable = objSelectInfo.GridViewBookConcernnfoTable();
                  dgMagazine.DataSource = objDataTable;
                }
                else
                {
                    dgMagazine.DataSource = null;
                    objDataTable = objSelectInfo.selectLikeBookConcernName(txtMagazineName.Text.Trim());
                    dgMagazine.DataSource = objDataTable;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //点击事件(添加用户要新建的出版社信息)
        private void button3_Click(object sender, EventArgs e)
        {
            frmAddBookConcern objfrmAddBookConcern = new frmAddBookConcern();
            objfrmAddBookConcern.Show();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //点击事件(由用户选中表中行来进行修改选中的记录)
        private void button2_Click(object sender, EventArgs e)
        {
            DataRow objUpdateRows = objDataTable.Rows[this.dgMagazine.CurrentRowIndex];

            frmUpdateBookConcern objfrmUpdateBookConcern = new frmUpdateBookConcern(objUpdateRows);
            objfrmUpdateBookConcern.Show();
        }
        //点击事件(由用户选中表中的行来对记录进行删除操作)
        private void button1_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("确认删除数据码？", "数据删除",
                MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                //首先删除数据集当中的数据.
                string a = objDataTable.Rows[this.dgMagazine.CurrentRowIndex][0].ToString();
                try
                {
                    //带参数传递调删除的方法!
                    objBookConcern.DELETEBookConcern(a);//删除出版社表中的数据
                    objBooks.BookConcernIDDelete(a);//删除图书表中的数据
                    xian();
                    MessageBox.Show("数据删除" + a + "数据成功！！！");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }
        }
    }
}