frmborrowinfo.cs

数据库课程设计

                    }
                    else
                    {

                        day = objSelectInfo.SelectMagazineBorrowTime(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Lose);


                        if (day > 60)
                        {
                            double money = Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString()) * 0.2;
                            MessageBox.Show(money.ToString());
                            //删除期刊借阅信息表的信息

                            objSelectInfo.delMagazineLose(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString());
                            objSelectInfo.ReaderBooksMony(money, ReaderDataTable.Rows[0][0].ToString());
                            MessageBox.Show("图书归还严重过期!书将以８折的结个出售给你！");
                        }

                        else
                        {
                            double Money =  Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString())-day * Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString()) * 1.5;
                            //调用归还图书存储过程（4个参数）
                            objSelectInfo.ProcReturnMagazine(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Money, Lose);
                            MessageBox.Show("过期归还，将以1.5的借阅读价格支付！！");
                        }
                    }

                }
                else
                    MessageBox.Show("您没有借过该期刊!");
            }
  
        }

        private void radMagazine_CheckedChanged(object sender, EventArgs e)
        {
            lstBookInfo.Items.Clear();
            txtBookID.Text = "";
            groupBox2.Text = "期刊信息";
        }

        private void radBook_CheckedChanged(object sender, EventArgs e)
        {
            lstBookInfo.Items.Clear();
            txtBookID.Text = "";
            groupBox2.Text = "图书信息";
        }

        private void radBookR_CheckedChanged(object sender, EventArgs e)
        {
            lstBookInfoR.Items.Clear();
            txtBookIDR.Text = "";
            groupBox3.Text = "图书信息";
        }

        private void radMagazineR_CheckedChanged(object sender, EventArgs e)
        {
            lstBookInfoR.Items.Clear();
            txtBookIDR.Text = "";
            groupBox3.Text = "期刊信息";
        }

        private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
        {
            txtBookID.Text = "";
            txtReaderID.Text = "";
            lstBookInfo.Items.Clear();
            lstReaderInfo.Items.Clear();
            txtBookIDR.Text = "";
            txtReaderIDR.Text = "";
            lstBookInfoR.Items.Clear();
            lstReaderInfoR.Items.Clear();
            txtBookIDB.Text = "";
            txtReaderIDB.Text = "";
            lstBookInfoB.Items.Clear();
            lstReaderInfoB.Items.Clear();
        }

        private void btnBookQuery_Click(object sender, EventArgs e)
        {
            if (radBook.Checked)//是否选中图书信息单选按钮
            {
                try
                {
                    frmBookInfoView objBookInfoView = new frmBookInfoView(this);
                    objBookInfoView.MdiParent = fMain;
                    objBookInfoView.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else
            {
                try
                {
                    frmMagazineInfoView objfrmMagazineView = new frmMagazineInfoView(this);
                    objfrmMagazineView.MdiParent = fMain;
                    objfrmMagazineView.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        private void btnReturn_Click(object sender, EventArgs e)
        {
            if (txtReaderIDR.Text == "")
            {
                MessageBox.Show("请选择读者！！");
                return;
            }
            else if (txtBookIDR.Text == "")
            {
                MessageBox.Show("请选择书籍或期刊！！");
            }
            if (lvItemLose.Name == "挂失")
            {
                MessageBox.Show("对不起！您的卡已经挂失，请及时处理。", "卡已挂失");
                return;
            }
            string Lose = "未还";
      
                if (radBookR.Checked)//是否选中图书信息单选按钮
                {
                    try
                    {
                        int day;
                        //检查读者借过当前这本书没有（根据读者编号+图书编号+状态）
                        if (!objSelectInfo.BookBorrowReadLose(ReaderDataTable.Rows[0][0].ToString(), BoosDataTable.Rows[0][0].ToString(), Lose))
                        {
                            //检查该读者的借阅时间是否超过了应还时间，没超过返回true（根据读者编号+图书编号+状态）
                            if (objSelectInfo.SelectOverdoeReaderID(BoosDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Lose))
                            {
                                //查询借越时间计算借越
                                day = objSelectInfo.SelectBookBorrowTime(BoosDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Lose);
                              
                                 //退还押金金额
                                  double Money = Convert.ToDouble(BoosDataTable.Rows[0][3].ToString()) - day * Convert.ToDouble(BoosDataTable.Rows[0][4].ToString());
                               
                                //调用归还图书存储过程（4个参数）
                               objSelectInfo.ProcReturn(ReaderDataTable.Rows[0][0].ToString(), BoosDataTable.Rows[0][0].ToString(), Lose, Money);
                                MessageBox.Show("图书归还成功!", "成功");
                            }
                            else
                            {
                                day = objSelectInfo.SelectBookBorrowTime(BoosDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Lose);


                                if (day > 60)
                                {
                                    //退还押金金额
                                    double money = Convert.ToDouble(BoosDataTable.Rows[0][3].ToString()) * 0.2;
                                    //罚款金额插入书籍丢失表
                                    double BooksMoney = Convert.ToDouble(BoosDataTable.Rows[0][3].ToString()) * 0.8;
                                   
                                    //删除借阅信息表的信息
                                    objSelectInfo.delBorrowBook(BoosDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString());
                                      //退还出售的押金
                                    objSelectInfo.ReaderBooksMony(money, ReaderDataTable.Rows[0][0].ToString());
                                    //把书籍信息插入丢失表
                                    objSelectInfo.InsertBookLose(BoosDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), BooksMoney, "操作员");
                                    MessageBox.Show("图书归还严重过期!书将以８折的结个出售给你！");
                                }

                                else
                                {
                                    //退还押金金额
                                    double Money = Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString())-day * Convert.ToDouble(BoosDataTable.Rows[0][4].ToString()) * 1.5;
                                    //调用归还图书存储过程（4个参数）
                                    objSelectInfo.ProcReturn(ReaderDataTable.Rows[0][0].ToString(), BoosDataTable.Rows[0][0].ToString(), Lose, Money);
                                    MessageBox.Show("过期归还，将以1.5的借阅读价格支付！！");
                                }
                            }
                        }
                        else
                            MessageBox.Show("您没有借过这本书!");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
                else if (radMagazineR.Checked)
                {
                    int day;
                         //检查读者以前借过这本期刊没有?
                    if (!objSelectInfo.MagazineBorrowLose(ReaderDataTable.Rows[0][0].ToString(), MagazineDataTable.Rows[0][0].ToString(), Lose))
                    {
                        //检查读者是否在应该还期刊的时间没有还?
                        if (objSelectInfo.MagazineOverdoeReaderID(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Lose))
                        {
                            //调用归还期刊存储过程
                            day = objSelectInfo.SelectMagazineBorrowTime(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Lose);
                            //退还押金金额
                            double Money = Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString())-day * Convert.ToDouble(MagazineDataTable.Rows[0][3].ToString());
                         　　//调用期刊归还存储过程
                            objSelectInfo.ProcReturnMagazine(MagazineDataTable.Rows[0][0].ToString(),ReaderDataTable.Rows[0][0].ToString(), Money, Lose);
                            MessageBox.Show("期刊归还成功", "成功");
                        }
                        else
                        {

                            day = objSelectInfo.SelectMagazineBorrowTime(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Lose);


                            if (day > 60)
                            {
                                //退还押金金额
                                double money = Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString()) * 0.2;
                                MessageBox.Show(money.ToString());
                                 //书籍0.8折出售的价格
                                double Magazinemoney = Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString()) * 0.8;
                                //删除期刊借阅信息表的信息
                                objSelectInfo.delMagazineLose(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString());
                                objSelectInfo.ReaderBooksMony(money, ReaderDataTable.Rows[0][0].ToString());
                                //插入期刊丢失信息
                                objSelectInfo.InsertMagazineLose(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Magazinemoney, "操作员");
                                MessageBox.Show("图书归还严重过期!书将以８折的结个出售给你！");
                            }

                            else
                            {
                                //删除期刊借阅信息表的信息
                                double Money = Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString())-day * Convert.ToDouble(MagazineDataTable.Rows[0][2].ToString()) * 1.5;
                                //调用归还图书存储过程（4个参数）
                                objSelectInfo.ProcReturnMagazine(MagazineDataTable.Rows[0][0].ToString(), ReaderDataTable.Rows[0][0].ToString(), Money, Lose);
                                MessageBox.Show("过期归还，将以1.5的借阅读价格支付！！");
                            }
                        }
                        
                    }
                     else
                            MessageBox.Show("您没有借过该期刊!");
                }
            
            
        }
    }
}