Пример #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            //对于正常支付的用户,关闭信息窗后在PAY表增添对应信息
            //调用Booking中的数据
            //删除对应Booking表的数据
            YH_JS  mmp = new YH_JS();
            String iDDc;

            iDDc = YH_JS.CHANGDI;
            chloe_control_all chloe_usebook = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True");
            Booking           usebooking    = new Booking();

            usebooking = chloe_usebook.See_BOOK_CD(iDDc);
            String   pay_id, pay_name, yard_id, begin_time, over_time, book_time, real_time, pay_money;
            DateTime pay_time;

            pay_id     = usebooking.Book_personid;
            pay_name   = usebooking.Book_person;
            yard_id    = usebooking.yARDID;
            begin_time = usebooking.OpenTime;
            over_time  = usebooking.CloseTime;
            book_time  = usebooking.BookDate.ToString();
            real_time  = usebooking.REALDate.ToLongDateString();
            pay_money  = YH_JS.MMMM;
            pay_time   = DateTime.Now;
            chloe_control_all chloe_obj_noproblem = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True");

            chloe_obj_noproblem.UserPay(pay_id, pay_name, yard_id, begin_time, over_time, book_time, real_time, pay_money, pay_time);
            MessageBox.Show("已收到您的支付费用,欢迎再次预约!");
            Booking           del       = new Booking();
            chloe_control_all chloe_del = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True");

            chloe_del.shoudaoqian(iDDc);
        }