frmbookinfo.cs

数据库课程设计

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.SqlClient;
using Bussiness;

namespace UI
{
    public partial class frmBookInfo : Form
    {
       SelectInfo objSelectInfo=new SelectInfo();
        DataTable objDataTable;
        Books objBooks = new Books();
        public frmBookInfo()
        {
            InitializeComponent();
        }
        private void Win()
        {
            btnAllShow.Left = this.Left + 18;
        }

        //显示全部的图书信息

        public void xian()
        {
            dgMagazine.DataSource = null;
            objDataTable=objSelectInfo.GridViewBookInfoTable();
            dgMagazine.DataSource = objDataTable;
        }
        private void btnQuery_Click(object sender, EventArgs e)
        {
        }

        private void txtBookName_TextChanged(object sender, EventArgs e)
        {
            if (cboAuto.Checked)
            { 
                btnQuery_Click(null, null);
            }
            
        }

        private void btnIDQuery_Click(object sender, EventArgs e)
        {
           
        }

        private void txtBookID_TextChanged(object sender, EventArgs e)
        {
            if (cboAuto.Checked)
            {
                btnIDQuery_Click(null, null);
            }
            
        }

        private void btnTianJia_Click(object sender, EventArgs e)
        {
            frmAddNewBook objfrmAddNewBook = new frmAddNewBook();
            objfrmAddNewBook.Show();
        }

        private void btnXiuGai_Click(object sender, EventArgs e)
        {

        }

        private void btnShanChu_Click(object sender, EventArgs e)
        {
            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            
            try
            {
             
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void frmBookInfo_Load(object sender, EventArgs e)
        {

        }

        private void button3_Click(object sender, EventArgs e)
        {//添加书管理
      
            frmAddNewBook objfrmAddNewBook = frmAddNewBook.getfrmAddNewBook();
            objfrmAddNewBook.Show();
        }

        private void button1_Click_1(object sender, EventArgs e)
        { try
                {
                   
            if (!dgMagazine.IsSelected(dgMagazine.CurrentRowIndex))
            {
                MessageBox.Show("请选中要删除的行！");
                return;
            }
            if (MessageBox.Show("确认删除数据码,删除将把所有有关信息删除？", "数据删除",
                    MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                //首先删除数据集当中的数据.
                string a = objDataTable.Rows[this.dgMagazine.CurrentRowIndex][0].ToString();
                
                objBooks.procDelBooks(a);
                    xian();
                    MessageBox.Show("数据删除" + a + "数据成功！！！");
             
            }   }
                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.GridViewBookInfoTable();
             dgMagazine.DataSource = objDataTable;
                }
                else
                {
                    dgMagazine.DataSource = null;
                   objDataTable=objSelectInfo.SeleLikeBookName(txtMagazineName.Text.Trim());
                   dgMagazine.DataSource = objDataTable;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void txtMagazineID_TextChanged(object sender, EventArgs e)
        {
            //按照图书ＩＤ对书籍表进行模糊查询
            if (txtMagazineID.Text.Trim() == string.Empty)
            {
                dgMagazine.DataSource = null;
               objDataTable= objSelectInfo.GridViewBookInfoTable();
               dgMagazine.DataSource = objDataTable;
            }
            else
            {
                dgMagazine.DataSource = null;
              objDataTable=objSelectInfo.SeleLikeBookID(txtMagazineID.Text.Trim());
              dgMagazine.DataSource = objDataTable;
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
        
            try
            {
                if (!dgMagazine.IsSelected(dgMagazine.CurrentRowIndex))
                {
                    MessageBox.Show("请选中要修改的行！");
                    return;
                }
                DataRow objUpdateRows = objDataTable.Rows[this.dgMagazine.CurrentRowIndex];
                frmBooksUpdate objfrmBooksUpdate = new frmBooksUpdate(objUpdateRows);
                objfrmBooksUpdate.Show();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void button5_Click(object sender, EventArgs e)
        {
            xian();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void groupBox3_Enter(object sender, EventArgs e)
        {

        }
    }
}