frmpenaltyinfo.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 frmPenaltyInfo : Form
    {
      private static  frmPenaltyInfo objfrmPenaltyInfo;
        SelectInfo objSelectInfo = new SelectInfo();
        public frmPenaltyInfo()
        {
            InitializeComponent();
        }
        public static frmPenaltyInfo getfrmPenaltyInfo()
        {
            objfrmPenaltyInfo = new frmPenaltyInfo();
            return objfrmPenaltyInfo;
        }
        private void frmPenaltyInfo_Load_1(object sender, EventArgs e)
        {
            
        }
      
        //关闭当前窗体
        private void btuEsc_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }

        private void topbtnBooksPenalty_Click(object sender, EventArgs e)
        {
            frmMagazinePenalty objfrmMagazinePenalty = frmMagazinePenalty.getfrmMagazinePenalty();
            objfrmMagazinePenalty.Show();
        }

        private void topbtnMagazinePenalty_Click(object sender, EventArgs e)
        {

        }

        private void topdel_Click(object sender, EventArgs e)
        {
          
            frmAmercedel objfrmAmercedel = new frmAmercedel();
            objfrmAmercedel.Show();
        }

        private void frmPenaltyInfo_Load(object sender, EventArgs e)
        {
            this.comCondition.Items.Add("书籍丢失");
            this.comCondition.Items.Add("期刊丢失");
            this.comCondition.Items.Add("书籍罚款");
            this.comCondition.Items.Add("期刊罚款");
        }

        private void comCondition_ContextMenuStripChanged(object sender, EventArgs e)
        {

        }

        private void comCondition_TextChanged(object sender, EventArgs e)
        {
            if (this.comCondition.SelectedItem.ToString() == "书籍丢失")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewBookLoseTable();
            }
            else if (this.comCondition.SelectedItem.ToString() == "期刊丢失")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewMagazineLoseTable();
            }
            else if (this.comCondition.SelectedItem.ToString() == "书籍罚款")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewBookAmerceTable();
            }
            else if (this.comCondition.SelectedItem.ToString() == "期刊罚款")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewMagazineAmerceTable();
            }
        }

        private void topF5_Click(object sender, EventArgs e)
        {
            if (this.comCondition.SelectedItem.ToString() == "书籍丢失")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewBookLoseTable();
            }
            else if (this.comCondition.SelectedItem.ToString() == "期刊丢失")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewMagazineLoseTable();
            }
            else if (this.comCondition.SelectedItem.ToString() == "书籍罚款")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewBookAmerceTable();
            }
            else if (this.comCondition.SelectedItem.ToString() == "期刊罚款")
            {
                this.datGrview.DataSource = objSelectInfo.GridViewMagazineAmerceTable();
            }
        }

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

        private void txtReaderID_TextChanged(object sender, EventArgs e)
        {
            if (this.comCondition.SelectedItem.ToString() == "书籍丢失")
            {
                if (txtReaderID.Text.Trim() == string.Empty)
                {
                    this.datGrview.DataSource = null;
                this.datGrview.DataSource = objSelectInfo.GridViewBookLoseTable();
                }
                else
                {
                    this.datGrview.DataSource = null;
                    this.datGrview.DataSource = objSelectInfo.SelectLikeBookLose(txtReaderID.Text);
                }
            }
            else if (this.comCondition.SelectedItem.ToString() == "期刊丢失")
            {
                if (txtReaderID.Text.Trim() == string.Empty)
                {
                    this.datGrview.DataSource = null;
                    this.datGrview.DataSource = objSelectInfo.GridViewMagazineLoseTable();
                }
                else
                {
                    this.datGrview.DataSource = null;
                    this.datGrview.DataSource = objSelectInfo.SelectLikeMagazineLose(txtReaderID.Text);
                }
            }
            else if (this.comCondition.SelectedItem.ToString() == "书籍罚款")
            {
                  if (txtReaderID.Text.Trim() == string.Empty)
                {
                    this.datGrview.DataSource = null;
                this.datGrview.DataSource = objSelectInfo.GridViewBookAmerceTable();
                }
            else
            {
                this.datGrview.DataSource = null;
                this.datGrview.DataSource = objSelectInfo.SelectLikeBookAmerce(txtReaderID.Text);
            }
            }
            else if (this.comCondition.SelectedItem.ToString() == "期刊罚款")
            {
                     if (txtReaderID.Text.Trim() == string.Empty)
                {
                    this.datGrview.DataSource = null;
                this.datGrview.DataSource = objSelectInfo.GridViewMagazineAmerceTable();
            }
            else
            {
                this.datGrview.DataSource = null;
                this.datGrview.DataSource = objSelectInfo.SelectMagazineAmerce(txtReaderID.Text);
            }
            }
        }
    }
}