frmreaderdeposit.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 frmReaDerdeposit : Form
    {
        private static frmReaDerdeposit objfrmReaDerdeposit;
        ReaderSelect objBusiness = new ReaderSelect();
        public frmReaDerdeposit()
        {
            InitializeComponent();
        }
        public static frmReaDerdeposit getfrmReaDerdeposit() {
            objfrmReaDerdeposit = new frmReaDerdeposit();
            return objfrmReaDerdeposit;
        }

        //冲值前的查询
        private void button1_Click(object sender, EventArgs e)
        {
            //空验证
            if (txtReaderSelect.Text == "")
            {
                MessageBox.Show("读者编号不能为空!");
                txtReaderSelect.Focus();
                return;
                
            }
            try
            {
             //将查询到的结果,关键字段放入listBox
                if (objBusiness.Rcheck(this.txtReaderSelect.Text.Trim()))
                {
                    DataTable temp=new DataTable();
                    temp = objBusiness.SelectReader(this.txtReaderSelect.Text.Trim());
                    lstDisplay.Items.Clear();
                    lstDisplay.Items.Add("读者姓名："+temp.Rows[0][1]);
                    lstDisplay.Items.Add("性    别："+temp.Rows[0][2]);
                    lstDisplay.Items.Add("押金金额：" + temp.Rows[0][11]);
                    lstDisplay.Items.Add("读者等级：" + temp.Rows[0][9]);
                    lstDisplay.Items.Add("办证日期：" + temp.Rows[0][7]);
                    lstDisplay.Items.Add("有效期到：" + temp.Rows[0][8]);
                    lstDisplay.Items.Add("读者状态：" + temp.Rows[0][16]);
                    btnY.Enabled = true;
                }
                else
                {
                    MessageBox.Show("没有此读者,请验证你的输入!", "提示");
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("数据处理时出错了！",ex.Message);
                return;
            }
        }

        //冲值
        private void btnY_Click(object sender, EventArgs e)
        {
            try
            {
                
                objBusiness.updateMoney(this.txtReaderSelect.Text.Trim(),
                    Convert.ToDouble(this.txtDepositMoney.Text.Trim()));
                MessageBox.Show("冲值成功!");
                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

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