frmmembermanage.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 frmMemberManage : Form
    {
        private static frmMemberManage objfrmMemberManage;
        public frmMemberManage()
        {
            InitializeComponent();
        }

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

        private void frmMemberManage_Load(object sender, EventArgs e)
        {
            cboOPType.Text = "正常";
            this.button1.Enabled = false;
        }
        public static frmMemberManage getfrmMemberManage()
        {
           objfrmMemberManage = new frmMemberManage();
            return objfrmMemberManage;
        }

        //查询是否有此会员
        private void button3_Click(object sender, EventArgs e)
        {
            //空验证
            if (txtReaderID.Text.Trim() == "")
            {
                MessageBox.Show("会员卡号不能为空!");
                return;
            }
            try
            {
                //查询是否有此会员
                ReaderSelect objBusiness = new ReaderSelect();
                DataTable objDataTable = new DataTable();
                if (objBusiness.Rcheck(this.txtReaderID.Text.Trim()))
                {
                    objDataTable = objBusiness.SelectReader(this.txtReaderID.Text.Trim());
                    txtReaderName.Text = (string)objDataTable.Rows[0][1];
                    txtBuff.Text = (string)objDataTable.Rows[0][16];
                    txtReaderType.Text = (string)objDataTable.Rows[0][9];
                    txtReaderID.Enabled = false;
                    button1.Enabled = true;
                }
                else
                {
                    MessageBox.Show("会员卡号输入不正确或没有此会员!");
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("与数据库连接时出错!错误信息" + ex.Message);
                return;
            }
            
        }

        //如果有此会员的话，修改
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                ReaderSelect objBusiness = new ReaderSelect();
                objBusiness.updateState(txtReaderID.Text.Trim(), cboOPType.Text.Trim());
                MessageBox.Show("修改成功!");
                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show("与数据库连接时出错!"+ex.Message+"");
                return;
            }
        }
    }
}