frmaddnewreader.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 frmAddNewReader : Form
    {

        private static frmAddNewReader objfrmAddNewReader;
        public frmAddNewReader()
        {
            InitializeComponent();
        }
        public static frmAddNewReader getfrmAddNewReader()
        {
            objfrmAddNewReader = new frmAddNewReader();
            return objfrmAddNewReader;
        }
        /// <summary>
        /// 此方法用于检测输入的字符串是否全为数字
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public bool IsDigit(string input)
        {
            int count = 0;
            foreach(char ch in input)
            {
               if(char.IsDigit(ch))
               {
                   count++;               
               }
            }
            if (input.Length == count)
            
                return true;
            return false;
        }
        /// <summary>
        /// 验证字符串是否为空
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public bool IsNull(string input)
        { 
           if(input=="")
           {
               return true;
           }
           return false;
        }
        /// <summary>
        /// 初始化时间
        /// </summary>
        private void getTime()
        {
            int year = DateTime.Today.Year + 1;
            object objYear = year;
            string strMonth = (DateTime.Today.Month.ToString().Length > 1) ?
                DateTime.Today.Month.ToString() : "0" + DateTime.Today.Month.ToString();
            string strDay = (DateTime.Today.Day.ToString().Length > 1) ?
                DateTime.Today.Day.ToString() : "0" + DateTime.Today.Day.ToString();
         //   this.txtPeriodOfValidity.Text = objYear+strMonth+strDay;
            
        }
        
        private void btnOK_Click(object sender, EventArgs e)
        {
            if (IsNull(txtReaderCardID.Text.Trim()))
            {
                MessageBox.Show("读者卡号不能为空");
                txtReaderCardID.Focus();
                return;
            }
            else if (IsDigit(txtReaderCardID.Text.Trim()) || txtReaderCardID.Text.Trim().IndexOf('R')!=0)
            {
                MessageBox.Show("读者卡号必须以R开头后跟数字");
                txtReaderCardID.Focus();
                return;
            }
            else if (txtReaderCardID.Text.Length != 5)
            {
                MessageBox.Show("读者卡号必须为五位");
                txtReaderCardID.Focus();
                return;
            }
           
            else if (IsNull(txtReaderName.Text.Trim()))
            {
                MessageBox.Show("读者姓名不能为空");
                txtReaderName.Focus();
                return;
            }
            else if (IsNull(txtBalance.Text.Trim()))
            {
                MessageBox.Show("押金金额必须输入");
                txtBalance.Focus();
                return;
            }
            else if ((!IsDigit(txtBalance.Text.Trim())) || Convert.ToInt32(txtBalance.Text.Trim()) < 0)
            {
                MessageBox.Show("押金金额必须大于零且必须为数字类型");
                txtReaderCardID.Focus();
                return;
            }
            else if (Convert.ToInt32(txtBalance.Text.Trim()) < 100)
            {
                MessageBox.Show("押金金额最少为100元");
                txtReaderCardID.Focus();
                return;
            }           
            else
            {
               
            //验证读者是否存在
                try
                {

                    ReaderSelect objBusiness = new ReaderSelect();
                    if (objBusiness.Rcheck(this.txtReaderCardID.Text.Trim()))
                    {
                        MessageBox.Show("此读者已存在!!", "提示");
                        return;
                    }
                    else
                    {
                        //如果不存在添加
                        objBusiness.AddReader(this.txtReaderCardID.Text.Trim(),
                            this.txtReaderName.Text.Trim(),
                            this.cboSex.Text.Trim(),
                            Convert.ToInt32(this.txtBalance.Text.Trim()),
                            this.cboReaderType.Text.Trim(),
                            Convert.ToDateTime(this.dtpBirthday.Text.Trim()),
                            Convert.ToDateTime(this.dtpAccession.Text.Trim()),
                            Convert.ToDateTime(this.dtpRegisterData.Text.Trim()),
                            this.cboStatus.Text.Trim(),
                            Convert.ToInt32(this.txtReaderDay.Text.Trim()),
                            this.txtPaper.Text.Trim(),
                            this.txtPaperNum.Text.Trim(),
                            this.txtContactMode.Text.Trim(),
                            this.txtOperator.Text.Trim(),
                            Convert.ToInt32(this.nudBookBorrowNum.Value),
                            Convert.ToInt32(this.nudMagazBorrowNum.Value),
                            this.txtRemark.Text.Trim());
                        MessageBox.Show("添加读者信息成功", "提示");

                    }
                    this.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

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

        //载入时默认读者卡号第一个获得焦点
        private void frmAddNewReader_Activated(object sender, EventArgs e)
        {
            this.txtReaderCardID.Focus();
            
        }

        //Load事件
        private void frmAddNewReader_Load(object sender, EventArgs e)
        {
            this.getTime();
            this.cboSex.Text = "男";
            this.cboReaderType.Text = "普通读者";
            this.cboStatus.Text = "正常";
        }

    }
}