mainform.cs

个人版音像管理系统,可以扩展,内含数据库,支持多数据库使用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DiscSystemBLL;
using DiscSystemModel;

namespace DiscSystemUI
{
    public partial class MainForm : Form
    {
        private string selWhere="";
        public MainForm()
        {
            InitializeComponent();
        }

        //会员查询
        private void btnSelectMem_Click(object sender, EventArgs e)
        {
            btiMember.Checked = true;
            //dgvMemberInfo.DataSource = null;
            
            dgvMemberInfo.DataSource = new DiscSystemBLL.MemberInfoManager().GetMemberInfo(selWhere);
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            selWhere = txtSelWhere.Text;
        }

        private void btnSelectDisc_Click(object sender, EventArgs e)
        {
            btiDisc.Checked = true;
            //dgvDiscInfo.DataSource = null;
            
            dgvDiscInfo.DataSource = new DiscSystemBLL.DiscInfoManager().GetDiscInfo(selWhere);
        }

        private void btnLeaseInfo_Click(object sender, EventArgs e)
        {
            btiLease.Checked = true;
            //MessageBox.Show(cmbLeaseInfo.SelectedItem.ToString());
            dgvLeaseInfo.DataSource = new DiscSystemBLL.LeaseInfoManager().GetLeaseInfo(selWhere,cmbLeaseInfo.SelectedItem.ToString());
        }


        //页面加载
        private void MainForm_Load(object sender, EventArgs e)
        {
            cmbLeaseInfo.SelectedIndex = 0;
            dgvDiscInfo.DataSource = new DiscSystemBLL.DiscInfoManager().GetDiscInfo(selWhere);
            dgvMemberInfo.DataSource = new DiscSystemBLL.MemberInfoManager().GetMemberInfo(selWhere);
        }
        //会员添加
        private void btnInsertMem_Click(object sender, EventArgs e)
        {
            new FrmMem(btnInsertMem.Tag.ToString(),new MemberInfo()).ShowDialog();
            dgvMemberInfo.DataSource = new DiscSystemBLL.MemberInfoManager().GetMemberInfo(selWhere);
        }
        //会员修改
        private void btnUpdateMem_Click(object sender, EventArgs e)
        {
            new FrmMem(btnUpdateMem.Tag.ToString(), dgvMemberInfo.SelectedRows[0].DataBoundItem as MemberInfo).ShowDialog();
            dgvMemberInfo.DataSource = new DiscSystemBLL.MemberInfoManager().GetMemberInfo(selWhere);

        }
        //会员删除
        private void btnDeleteMem_Click(object sender, EventArgs e)
        {
            new FrmMem(btnDeleteMem.Tag.ToString(), dgvMemberInfo.SelectedRows[0].DataBoundItem as MemberInfo).ShowDialog();
            dgvMemberInfo.DataSource = new DiscSystemBLL.MemberInfoManager().GetMemberInfo(selWhere);
        }
        //影碟添加
        private void btnInsertDisc_Click(object sender, EventArgs e)
        {
            new FrmDisc(btnInsertDisc.Tag.ToString(), new DiscInfo()).ShowDialog();
            dgvDiscInfo.DataSource = new DiscSystemBLL.DiscInfoManager().GetDiscInfo(selWhere);
        }
        //影碟修改
        private void btnUpdateDisc_Click(object sender, EventArgs e)
        {
            new FrmDisc(btnUpdateDisc.Tag.ToString(), dgvDiscInfo.SelectedRows[0].DataBoundItem as DiscInfo).ShowDialog();
            dgvDiscInfo.DataSource = new DiscSystemBLL.DiscInfoManager().GetDiscInfo(selWhere);
        }
        //影碟删除
        private void btnDeleteDisc_Click(object sender, EventArgs e)
        {
            new FrmDisc(btnDeleteDisc.Tag.ToString(), dgvDiscInfo.SelectedRows[0].DataBoundItem as DiscInfo).ShowDialog();
            dgvDiscInfo.DataSource = new DiscSystemBLL.DiscInfoManager().GetDiscInfo(selWhere);
        }

        //出租
        private void btnLend_Click(object sender, EventArgs e)
        {
            DiscInfo disc = dgvDiscInfo.SelectedRows[0].DataBoundItem as DiscInfo;
            MemberInfo mem = dgvMemberInfo.SelectedRows[0].DataBoundItem as MemberInfo;
            LeaseInfo lease = new LeaseInfo();
            lease.MemberName = mem.MemberName;
            lease.DiscName = disc.DiscName;
            if (mem.DiscCount >= mem.MaxCount)
            {
                MessageBox.Show("您已经达到出租数量的最大限额\n请办理更高级会员或者重新选择!");
            }
            else
            {
                DialogResult dr = MessageBox.Show(mem.MemberName+"先生,您是否要租"+disc.DiscName,"提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
                if (dr ==DialogResult.Yes)
                {
                    int checkIn = new DiscSystemBLL.LeaseInfoManager().InsertLeaseInfo(lease);
                    btnLeaseInfo.Checked = true;
                }
            }
        }

    }
}