frmdatastocktaking.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 frmDataStocktaking : Form
    {
        private static frmDataStocktaking objfrmDataStocktaking;
        SelectInfo objSelectInfo = new SelectInfo();
        RecessionInfo objRecessionInfo = new RecessionInfo();
        public frmDataStocktaking()
        {
            InitializeComponent();
        }
        public static frmDataStocktaking getfrmDataStocktaking() 
        { 
            objfrmDataStocktaking = new  frmDataStocktaking();
            return objfrmDataStocktaking;
        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {

        }

        private void frmDataStocktaking_Load(object sender, EventArgs e)
        {
            this.comSelectItem.Items.Add("书籍资料");
            this.comSelectItem.Items.Add("期刊资料");
            this.comSelectItem.Items.Add("书籍归还");
            this.comSelectItem.Items.Add("期刊归还");
        }

        private void comSelectItem_TextChanged(object sender, EventArgs e)
        {
            if (this.comSelectItem.SelectedItem.ToString() == "书籍资料")
            {
                this.dataGrid1.DataSource = objSelectInfo.GridViewBookInfoTable();
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "期刊资料")
            {
                this.dataGrid1.DataSource = objSelectInfo.SelectMagazineInfo();
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "书籍归还")
            {
                this.dataGrid1.DataSource = objRecessionInfo.GridViewBookRecession();
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "期刊归还")
            {
                this.dataGrid1.DataSource = objRecessionInfo.GridViewMagazineRecessionn();
            }
        }

        private void toolStripButton2_Click(object sender, EventArgs e)
        {

            if (this.comSelectItem.SelectedItem.ToString() == "书籍资料")
            {
                this.dataGrid1.DataSource = objSelectInfo.GridViewBookInfoTable();
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "期刊资料")
            {
                this.dataGrid1.DataSource = objSelectInfo.SelectMagazineInfo();
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "书籍归还")
            {
                this.dataGrid1.DataSource = objRecessionInfo.GridViewBookRecession();
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "期刊归还")
            {
                this.dataGrid1.DataSource = objRecessionInfo.GridViewMagazineRecessionn();
            }
        }

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

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            if (this.comSelectItem.SelectedItem.ToString() == "书籍资料")
            {
                if (txtNum.Text.Trim() == string.Empty)
                {
                    dataGrid1.DataSource = null;
                    dataGrid1.DataSource = objSelectInfo.GridViewBookInfoTable();
                }
                else
                {
                    dataGrid1.DataSource = null;
                    dataGrid1.DataSource = objSelectInfo.SeleLikeBookName(txtNum.Text.Trim());
                 
                
                }

            }
            else if (this.comSelectItem.SelectedItem.ToString() == "期刊资料")
            {
                if (txtNum.Text.Trim() == string.Empty)
                {
                    dataGrid1.DataSource = null;
                    dataGrid1.DataSource = objSelectInfo.SelectMagazineInfo();
                }
                else
                {

                    dataGrid1.DataSource = null;
                    dataGrid1.DataSource = objSelectInfo.SeleLikeMagazineName(txtNum.Text.Trim());
                }
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "书籍归还")
            {
                if (txtNum.Text.Trim() == string.Empty)
                {
                    dataGrid1.DataSource = null;
                    this.dataGrid1.DataSource = objRecessionInfo.GridViewBookRecession();
                }
                else
                {
                    dataGrid1.DataSource = null;
                    dataGrid1.DataSource = objRecessionInfo.SelectLikeBookRecession(txtNum.Text.Trim());
                }
            }
            else if (this.comSelectItem.SelectedItem.ToString() == "期刊归还")
            {
                if (txtNum.Text.Trim() == string.Empty)
                {
                    dataGrid1.DataSource = null;
                    this.dataGrid1.DataSource = objRecessionInfo.GridViewMagazineRecessionn();
                }
                else
                {
                    dataGrid1.DataSource = null;
                    dataGrid1.DataSource = objRecessionInfo.SelectLikeMagazineRecession(txtNum.Text.Trim());
                }
            }
        }
    }
}