frmmagazinepenalty.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 frmMagazinePenalty : Form
    {
      private static frmMagazinePenalty objfrmMagazinePenalty;
        //构造函数里初始化frmBorrowInfo的对象
        SelectInfo objSelectInfo = new SelectInfo();
        public frmMagazinePenalty()
        {
            InitializeComponent();
            
        }
        /// <summary>
        /// frmMagazinePenalty实例化,返回frmMagazinePenalty对象
        ///　　
        /// </summary>
        /// <returns></returns>

        public static frmMagazinePenalty getfrmMagazinePenalty()
        {
            objfrmMagazinePenalty = new frmMagazinePenalty();
            return objfrmMagazinePenalty;
        }
        //加载界面时为指定的文本筐扶植
        private void frmMagazinePenalty_Load(object sender, EventArgs e)
        {
            try
            {
                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 验证字符串是否为空
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public bool IsNull(string input)
        {
            if (input == "")
            {
                return true;
            }
            return false;
        }

        /// <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;
        }
   
        private void yanzheng()
        {
            if (txtID.Text == "")
            {
                MessageBox.Show("编号不能为空！！");
                return;
            }
            else if (txtReaderID.Text == "")
            {
                MessageBox.Show("读者编号不能为空！");
                return;
            }
            else if (IsDigit(txtReaderID.Text.Trim()) || txtReaderID.Text.Trim().IndexOf('R') != 0)
            {
                MessageBox.Show("读者卡号必须以R开头后跟数字");
                txtReaderID.Focus();
                return;
            }
            else if (txtReaderID.Text.Length != 5)
            {
                MessageBox.Show("读者卡号必须为五位");
                txtReaderID.Focus();
                return;
            }

            else if (txtYing.Text == "")
            {
                MessageBox.Show("应付金额不能为空！");
                return;
            }
            else if (txtMoney.Text == "")
            {
                MessageBox.Show("实付金额不能为空！！");
                return;
            }
            else if (txtAdmin.Text == "")
            {
                MessageBox.Show("操作员不能为空！！");
                return;
            }
        }
        //现金交罚款
        private void btuPenalty_Click(object sender, EventArgs e)
        {
            try
            {
                string Lose = "未还";
                //验证方法
                    yanzheng();
                //先给罚款表添加纪录
                if (!this.radLose.Checked)
                {
                    //检查读者借过当前这本书没有
                    if (objSelectInfo.BookBorrowReadLose(txtReaderID.Text.ToString(), txtID.Text.ToString(), Lose))
                    {


                    //计算罚款金额
                    DataTable objBooks = objSelectInfo.SelectBooksBookID(this.txtID.Text.ToString());
                    double Money = Convert.ToDouble(objBooks.Rows[0][0].ToString()) - Convert.ToDouble(this.txtMoney.Text);
                    //插入书籍丢失信息
                    objSelectInfo.InsertBookLose(this.txtID.Text.ToString(),this.txtReaderID.Text.ToString(),Convert.ToDouble(this.txtMoney.Text),this.txtAdmin.Text.ToString());
                    //删除丢失信息
                    objSelectInfo.delBorrowBook(this.txtID.Text.ToString(), this.txtReaderID.Text);
                    //退还押金
                    objSelectInfo.ReaderBooksMony(Money, this.txtReaderID.Text.ToString());
                    MessageBox.Show("支付成功！");

                }
                else
                    MessageBox.Show("您没有借过这本书!");
                }
                else if (this.radMagazineLose.Checked)
                {
                          //检查读者借过当前这本书没有
                    if (!objSelectInfo.BookBorrowReadLose(txtReaderID.Text.ToString(), txtID.Text.ToString(), Lose))
                    {

                     DataTable objBooks = objSelectInfo.SelectMagazineborrowPrice(this.txtID.Text.ToString());
                     double Money = Convert.ToDouble(objBooks.Rows[0][0].ToString()) - Convert.ToDouble(this.txtMoney.Text);

                    //插入期刊丢失信息
                    objSelectInfo.InsertMagazineLose(this.txtID.Text.ToString(), this.txtReaderID.Text.ToString(), Convert.ToDouble(this.txtMoney.Text), this.txtAdmin.Text.ToString());
                    //删除丢失信息
                    objSelectInfo.delMagazineLose(this.txtID.Text.ToString(), this.txtReaderID.Text);
                    //退还押金
                    objSelectInfo.ReaderBooksMony(Money, this.txtReaderID.Text.ToString());
                    MessageBox.Show("支付成功！");
                }
                else
                    MessageBox.Show("您没有借过这本书!");
                }
                else
                {
                    MessageBox.Show("请选择罚款原因");
                }
              
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
       
        }
        //再押金里罚款
        private void btuPrice_Click(object sender, EventArgs e)
        {
            try
            {

                string Lose = "未还";
                //验证方法
                yanzheng();
                //先给罚款表添加纪录
                if (this.radMangle.Checked)
                {
                    
                          //检查读者借过当前这本书没有
                    if (!objSelectInfo.BookBorrowReadLose(txtReaderID.Text.ToString(), txtID.Text.ToString(), Lose))
                    {
                    int day; 
                   
                    //插入书籍丢失信息
                    objSelectInfo.InsertBookAmerce(this.txtID.Text.ToString(), this.txtReaderID.Text.ToString(),Convert.ToDouble(this.txtYing.Text), Convert.ToDouble(this.txtMoney.Text), this.txtAdmin.Text.ToString());
                    //返回借阅天数
                    day = objSelectInfo.SelectBookBorrowTime(this.txtID.Text.ToString(),this.txtReaderID.Text.ToString(), Lose);
                    //计算借阅急呢
                    DataTable objBooks=objSelectInfo.SelectBooksBookID(this.txtID.Text.ToString());
                    double Money = Convert.ToDouble(objBooks.Rows[0][0].ToString()) - day * Convert.ToDouble(objBooks.Rows[0][1].ToString()) + Convert.ToDouble(txtMoney.Text.ToString());
                    if (Convert.ToDouble(objSelectInfo.SelectReaderMoney(this.txtReaderID.Text.ToString()).Rows[0][0].ToString()) > Money)
                    {
                        //退还押金
                        //objSelectInfo.ReaderBooksMony(Money, this.txtReaderID.Text.ToString());
                        objSelectInfo.ProcReturn(txtReaderID.Text,txtID.Text, Lose, Money);
                     
                        MessageBox.Show("罚款成功！！金额从你的押金中扣除！");
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("您的押金不足，请现金支付" + Money + "元！");
                    }
                           }
                else
                               MessageBox.Show("您没有借过这本书!");
                }
                else if (this.radioButton1.Checked)
                {

                    //检查读者借过当前这本书没有
                    if (!objSelectInfo.BookBorrowReadLose(txtReaderID.Text.ToString(), txtID.Text.ToString(), Lose))
                    {
                    int day;

                

                    //插入期刊丢失信息
                    objSelectInfo.InsertMagazineAmerce(this.txtID.Text.ToString(), this.txtReaderID.Text.ToString(), Convert.ToDouble(this.txtYing.Text), Convert.ToDouble(this.txtMoney.Text), this.txtAdmin.Text.ToString());

                    //返回借阅天数
                    day = objSelectInfo.SelectMagazineBorrowTime(this.txtID.Text.ToString(), this.txtReaderID.Text.ToString(), Lose);

               ;
                    //计算借阅金额+罚款几几呢
                    DataTable objBooks = objSelectInfo.SelectMagazineborrowPrice(this.txtID.Text.ToString());
                    double Money = Convert.ToDouble(objBooks.Rows[0][0].ToString()) - day * Convert.ToDouble(objBooks.Rows[0][1].ToString()) + Convert.ToDouble(txtMoney.Text.ToString());
                    if (Convert.ToDouble(objSelectInfo.SelectReaderMoney(this.txtReaderID.Text.ToString()).Rows[0][0].ToString()) > Money)
                    {
                        //退还押金
                       // objSelectInfo.ReaderBooksMony(Money, this.txtReaderID.Text.ToString());
                        objSelectInfo.ProcReturnMagazine(txtID.Text,txtReaderID.Text,  Money, Lose);
                        MessageBox.Show("罚款成功！！金额从你的押金中扣除！");
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("您的押金不足，请现金支付" + Money + "元！");
                    }

                    MessageBox.Show("期刊归还成功");
                           }
                else
                    MessageBox.Show("您没有借过这本书!");
                }
                else
                {
                    MessageBox.Show("请选择罚款原因");
                }
              
            
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
    
        }

        private void radioButton1_Click(object sender, EventArgs e)
        {
      
        }

        private void radioButton2_Click(object sender, EventArgs e)
        {
           
        }

        private void label6_Click(object sender, EventArgs e)
        {

        }

        private void label5_Click(object sender, EventArgs e)
        {

        }
    }
}