frmmagazineinfo.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;
using System.IO;

namespace UI
{
    public partial class frmMagazineInfo : Form
    {        //初始化SelectInfo类的实例
        SelectInfo objSelectInfo = new SelectInfo();
        DataTable objDataTable;
        //初始化MagazineMagane类的实例
        MagazineMagane objMagazineMagane = new MagazineMagane();
        public frmMagazineInfo()
        {
            InitializeComponent();
        }

        public DataTable xian()
        { 
            objDataTable =objSelectInfo.SelectMagazineInfo();
            return objDataTable;
        }
        private void btnAllShow_Click(object sender, EventArgs e)
        {
            this.dgMagazine.DataSource = xian();     
        }

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

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

        private void txtMagazineID_TextChanged(object sender, EventArgs e)
        {
           try {
               if (txtMagazineID.Text.Trim() == string.Empty)
                {
                    dgMagazine.DataSource = null;
         objDataTable=objSelectInfo.SelectMagazineInfo();

         dgMagazine.DataSource = objDataTable;
                }
                else
                {
                    dgMagazine.DataSource = null;
                     objDataTable=objSelectInfo.SeleLikeMagazineID(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.SelectMagazineInfo();
                   dgMagazine.DataSource = objDataTable;
                }
                else
                {
                    dgMagazine.DataSource = null;
                    objDataTable=objSelectInfo.SeleLikeMagazineName(txtMagazineName.Text.Trim());
                    dgMagazine.DataSource = objDataTable;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnExcel_Click(object sender, EventArgs e)
        {
           
            try
            {

                this.Close();
                   
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            frmAddNewMagazine objfrmAddNewMagazine = new frmAddNewMagazine();
            objfrmAddNewMagazine.Show();
        }

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

        private void btnDelete_Click(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();
              
                    objMagazineMagane.procDelMagazine(a);

                    MessageBox.Show("数据删除" + a + "数据成功！！！");
               
               
            }  }catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
        }

    }
}