frmaddnewmagazine.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 frmAddNewMagazine : Form
    {
        SelectInfo objSelectInfo = new SelectInfo();
        private static frmAddNewMagazine objfrmAddNewMagazine;
        public frmAddNewMagazine()
        {
            InitializeComponent();
        }
        public static frmAddNewMagazine getfrmAddNewMagazine()
        {
            objfrmAddNewMagazine = new frmAddNewMagazine();
            return objfrmAddNewMagazine;
        }
        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;
        }
        private bool yanzheng()
        {
            if (this.txtBarCode.Text == "" || this.txtMagazineName.Text == "" ||
                        this.cboType.Text == "" || this.txtNewsroom.Text == "" ||
          this.txtIssue.Text == "" || this.txtAllIssue.Text == "" || this.txtPrice.Text == "" ||
                      this.txtMBorrowMoney.Text == "" ||
                        this.txtLivingNum.Text == "" || this.txtStorageNum.Text == "" ||
                          this.txtOP.Text == "" ||
                        this.txtSynopsis.Text == "" || this.txtBorrowNum.Text == "")
            {
                MessageBox.Show("信息不能为空！！");
                return false;
            }
            else   if (IsDigit(txtBarCode.Text.Trim()) || txtBarCode.Text.Trim().IndexOf('M') != 0)
            {
                MessageBox.Show("期刊ID必须以M开头后跟数字");
                txtBarCode.Focus();
                return false;
            }
            else if (txtBarCode.Text.Length != 5)
            {
                MessageBox.Show("期刊ID必须为五位");
                txtBarCode.Focus();
                return false;
            }
    
            return true;
        }
        private void btnOk_Click(object sender, EventArgs e)
        {
            try
            {
                if (yanzheng())
                {
                    if (objSelectInfo.MagazineSelect(this.txtMagazineName.Text))
                    {
                        int i;
                        if (rabFou.Checked)
                        {
                            i = 0;
                        }
                        else
                        {
                            i = 1;
                        }
                        Bussiness.MagazineMagane Add = new Bussiness.MagazineMagane();
                        Add.AddNewMagazine(this.txtBarCode.Text, this.txtMagazineName.Text,
                            this.cboType.Text, this.txtNewsroom.Text, Convert.ToString(this.dateTimePicker1.Value),
                           Convert.ToInt32(this.txtIssue.Text), Convert.ToInt32(this.txtAllIssue.Text), Convert.ToDouble(this.txtPrice.Text),
                          Convert.ToDouble(this.txtMBorrowMoney.Text),
                            Convert.ToInt32(this.txtLivingNum.Text), Convert.ToInt32(this.txtStorageNum.Text),
                             Convert.ToString(this.datStorageDate.Value), this.txtOP.Text,
                            this.txtSynopsis.Text, Convert.ToInt32(this.txtBorrowNum.Text),
                              i);
                        MessageBox.Show("添加成功!");
                        this.Close();
                    }
                    else
                    {
                        Bussiness.MagazineMagane update = new Bussiness.MagazineMagane();
                        update.MagazineUpdate(this.txtMagazineName.Text, Convert.ToInt32(this.txtLivingNum.Text), Convert.ToInt32(this.txtStorageNum.Text));
                        MessageBox.Show("更新成功!");
                        this.Close();
                    }
                }
             
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message,"提示");
            }
        }

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


    }
}