Пример #1
0
        private void Querybt_Click(object sender, EventArgs e)
        {
            //判空
            if (txtCardNo.Text == "")
            {
                MessageBox.Show("请输入查询的内容!", "提示");
                txtCardNo.Focus();
                return;
            }
            //给card实体带上参数,传给外观
            Entity.Card card = new Entity.Card();
            card.CardNo = Convert.ToInt32(txtCardNo.Text.ToString());
            IList <Entity.Card> Card = new List <Entity.Card>();

            Facade.StudentMoneyFacade StudentMoney = new Facade.StudentMoneyFacade();
            Card = StudentMoney.StudentMoney(card);
            if (Card.Count == 0)
            {
                MessageBox.Show("没有该卡号的相关信息,请重新输入!");
            }
            else
            {
                txtStudentNo.Text = Card[0].StudentNo.ToString();
                txtMoney.Text     = Card[0].Money.ToString();
            }
        }
Пример #2
0
        /// <summary>
        /// 下机
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            //给实体online装参数--正在上机才可以下机
            Entity.online online = new Entity.online();
            online.CardNo = Convert.ToInt16(txtCardno.Text);
            Facade.IsOnlineFacade Isonline = new Facade.IsOnlineFacade();
            IList <Entity.online> lonline  = new List <Entity.online>();

            lonline = Isonline.IsOnline(online);

            if (lonline.Count == 0)
            {
                MessageBox.Show("该卡号下没有学生上机,请选择正在上机的卡号!");
                txtCardno.Text = "";
                txtCardno.Focus();
            }
            else
            {
                //将剩余参数带给line实体
                //补充,这里给line传入金额--2017-02-11
                Entity.Card card = new Entity.Card();
                //卡号
                card.CardNo = Convert.ToInt16(txtCardno.Text.Trim());
                // Facade.QuerIesitCardno queryExitCardno = new Facade.QuerIesitCardno();
                Facade.QueyExitCardno queryExitCardno = new Facade.QueyExitCardno();
                IList <Entity.Card>   lCard           = new List <Entity.Card>();
                lCard = queryExitCardno.queryExitCardno(card);
                Entity.line line = new Entity.line();
                //line.OffDate =Convert .ToDateTime (DateTime.Now.Date.ToShortDateString ());
                //line.OffTime = TimeSpan.Parse(DateTime.Now.ToLongTimeString());
                //line.ConsumeTime =Convert.ToInt16 (lbConsumer.Text);  //不合理,为啥,因为可以让好多人上机,但是呢?只能显示最后一个上机的人的时间

                line.CardNo    = lonline[0].CardNo; //之前line表有的一些参数,根据这些信息找到缺失信息的表
                line.LoginDate = lonline[0].ondate;
                line.LoginTime = lonline[0].ontime;
                line.Money     = lCard[0].Money;
                line.Status    = "正常下机";

                Facade.AddLineFacade addLineOff = new Facade.AddLineFacade();
                addLineOff.addLineOff(line);

                //计算金额,显示消费时间和金额
                Facade.CountMoneyFacade countMoneyfacade = new Facade.CountMoneyFacade();
                IList <Entity.line>     LineAll          = new List <Entity.line>();
                LineAll = countMoneyfacade.CountMoney(line);

                txtConsumeMoney.Text = LineAll[0].ConsumeMoney.ToString();
                txtConsumeTime.Text  = LineAll[0].ConsumeTime.ToString();
                txtName.Text         = LineAll[0].StudentName;
                txtoffDate.Text      = LineAll[0].OffDate.ToString();
                txtoffTime.Text      = LineAll[0].OffTime.ToString();
                txtONdate.Text       = LineAll[0].OffDate.ToString();
                txtOntime.Text       = LineAll[0].LoginTime.ToString();
                txtSex.Text          = LineAll[0].sex;
                txtStudentNo.Text    = LineAll[0].StudentNo.ToString();
                txtType.Text         = LineAll[0].Status;

                //从card实体中获得消费的剩余金额,同时更新card表
                Entity.Card Card = new Entity.Card();
                Card.CardNo = Convert.ToInt16(txtCardno.Text);
                IList <Entity.Card> LCard = new List <Entity.Card>();

                Facade.StudentMoneyFacade CardMoney = new Facade.StudentMoneyFacade();
                LCard = CardMoney.StudentMoney(Card);

                //余额的填充
                txtMoney.Text = (Convert.ToInt16(LCard[0].Money) - Convert.ToInt16(LineAll[0].ConsumeMoney)).ToString(); //////


                //更新表card
                Card.Money = Convert.ToInt16(txtMoney.Text);
                Facade.UpdateMoneyFacade UpdateMoney = new Facade.UpdateMoneyFacade();
                UpdateMoney.UpdateMoney(Card);

                //判断余额,如果余额花完的话需要充点钱
                IList <Entity.Card> IfCardmomey = new List <Entity.Card>();
                IfCardmomey = CardMoney.StudentMoney(Card);
                if (IfCardmomey[0].Money < 0)
                {
                    MessageBox.Show("您需要充值现金" + IfCardmomey[0].Money.ToString() + "元!");
                }
                txtMoney.Text = IfCardmomey[0].Money.ToString();

                //将正在上机表下机
                Facade.deleteFacade deleteOnlineFacade = new Facade.deleteFacade();
                deleteOnlineFacade.DeleteOnline(online);
            }
        }
Пример #3
0
        private void button3_Click(object sender, EventArgs e)
        {
            //判空
            if (txtStudentNo.Text == "")
            {
                txtStudentNo.Focus();
                MessageBox.Show("请输入查询的内容~", "提示");
                return;
            }

            if (txtCardNo.Text == "")
            {
                txtCardNo.Focus();
                MessageBox.Show("请输入查询的内容~", "提示");
                return;
            }

            if (txtMoney.Text == "")
            {
                txtMoney.Focus();
                MessageBox.Show("请输入查询的内容~", "提示");
                return;
            }

            if (comboBox1.Text == "")
            {
                comboBox1.Focus();
                MessageBox.Show("请输入查询的内容~", "提示");
                return;
            }

            //注册金额,不得小于最小的上机金额----------
            //的金额是否满足要求
            Entity.BasicData            basicdate      = new Entity.BasicData();
            Facade.QueryBasicDateFacade queryBasicDate = new Facade.QueryBasicDateFacade();
            IList <Entity.BasicData>    LbasicDate     = queryBasicDate.QueryBasicDate(basicdate);

            if (Convert.ToInt16(txtMoney.Text) < LbasicDate[0].LeastMoney)
            {
                MessageBox.Show("您的注册余额不满足上使用条件,请修改!", "提示");
                txtMoney.Focus();
                return;
            }


            //显示学生的信息,确保有学生
            //txtStudent 给到实体
            Entity.Student student = new Entity.Student();
            student.StudentNo = Convert.ToInt32(txtStudentNo.Text);

            Facade.StudentFacade   studentfacade = new Facade.StudentFacade();
            IList <Entity.Student> Student       = new List <Entity.Student>();

            Student = studentfacade.studentfacade(student);

            if (Student.Count == 0)
            {
                MessageBox.Show("没有该生的信息哦,可以选择添加该生的信息~");
                return;
            }
            else
            {
                txtInfo.Text = "姓名:" + Student[0].Name + "\r\n" + "性别:" + Student[0].Sex + "\r\n" + "年级:" + Student[0].Grade + "\r\n" + "班级:" + Student[0].Class + "\r\n" + "专业:" + Student[0].Department + "\r\n";
            }



            //将卡号的信息传给实体card,然后和数据库绑定
            Entity.Card card = new Entity.Card();

            card.StudentNo = Convert.ToInt32(txtStudentNo.Text);
            card.CardNo    = Convert.ToInt32(txtCardNo.Text);
            card.Money     = Convert.ToInt32(txtMoney.Text);
            //card.Type = listbox.Text .ToString();
            card.Type   = comboBox1.Text.Trim();
            card.Notes  = "使用";
            card.Status = "未结账";
            card.UserID = frmLogin.UserName;
            //card.UserID = "YY";

            //实体带给外观,返回该学号是否注册
            Facade.QuerIesitCardno Queryisexit   = new Facade.QuerIesitCardno();
            IList <Entity.Card>    QueryCardExit = new List <Entity.Card>();

            QueryCardExit = Queryisexit.QuerIsexitcardno(card);
            if (QueryCardExit.Count != 0)
            {
                MessageBox.Show("该学生已注册,无需注册", "提示");
                //获取学生已注册的信息
                card.CardNo = QueryCardExit[0].CardNo;
                Facade.StudentMoneyFacade QueryCardno = new Facade.StudentMoneyFacade();
                IList <Entity.Card>       card_info   = new List <Entity.Card>();
                card_info = QueryCardno.StudentMoney(card);
                txtInfo.Clear();
                // txtInfo.Text = "姓名:" + card_info [0].StudentNo + "\r\n" + "性别:" + Student[0].Sex + "\r\n" + "年级:" + Student[0].Grade + "\r\n" + "班级:" + Student[0].Class + "\r\n" + "专业:" + Student[0].Department + "\r\n";
                txtInfo.Text   = "姓名:" + Student[0].Name + "\r\n" + "性别:" + Student[0].Sex + "\r\n" + "年级:" + Student[0].Grade + "\r\n" + "班级:" + Student[0].Class + "\r\n" + "专业:" + Student[0].Department + "\r\n" + "卡号:" + card_info[0].CardNo.ToString() + "\r\n";
                txtCardNo.Text = "";
                txtMoney.Text  = "";
                comboBox1.Text = "";

                return;
            }

            else
            {
                //实体带给外观,返回是否有学号
                Facade.StudentMoneyFacade QueryCardno = new Facade.StudentMoneyFacade();
                IList <Entity.Card>       card_info   = new List <Entity.Card>();
                card_info = QueryCardno.StudentMoney(card);
                if (card_info.Count != 0)
                {
                    MessageBox.Show("该卡号已被使用,请重新输入!");
                    return;
                }
                else
                {
                    //实体带参给facade,完成添加
                    Facade.addCardFacade addCard = new Facade.addCardFacade();
                    bool falg;
                    falg = addCard.addCard(card);
                    if (falg == true)
                    {
                        MessageBox.Show("注册成功,您可以正常使用", "温馨提示");
                    }

                    //将注册的金额放到充值卡中
                    Entity.Charge charge = new Entity.Charge();
                    charge.CardNo    = txtCardNo.Text;
                    charge.UserID    = frmLogin.UserName;
                    charge.StudentNo = student.StudentNo;
                    charge.AddMoney  = Convert.ToInt16(txtMoney.Text);

                    Facade.AddChargeAndReturn addMoney = new Facade.AddChargeAndReturn();
                    addMoney.addCharge(charge);
                }
            }
        }