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);
}
private void button2_Click(object sender, EventArgs e)
{
//对于支付有问题的用户，关闭信息窗后在PAY表增添对应信息，paymoney为"NULL"
YH_JS nm = 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 havewt = new Booking();
havewt = chloe_usebook.See_BOOK_CD(iddc);
String id_pay, name_pay, id_yard, time_begin, time_over, time_book, time_real, money_pay;
DateTime time_pay;
id_pay = havewt.Book_personid.ToString();
name_pay = havewt.Book_person.ToString();
id_yard = havewt.yARDID.ToString();
time_begin = havewt.OpenTime.ToString();
time_over = havewt.CloseTime.ToString();
//预订时间 = Booking表中的BookDate
time_book = havewt.BookDate.ToString();
time_real = havewt.REALDate.ToLongDateString().ToString();
money_pay = PAYMONEY.Trim().ToString();
time_pay = DateTime.Now;
chloe_control_all chloe_obj_haveproblem = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True");
chloe_obj_haveproblem.UserPay(id_pay, name_pay, id_yard, time_begin, time_over, time_book, time_real, money_pay, time_pay);
MessageBox.Show("请联系系统管理员，管理员电话：132XXXXXXXX");
}
private void button1_Click_1(object sender, EventArgs e)
{
//选择好场地id和日期后，点击支付按钮，先判断其有无奖励或者违规标记，有奖励，弹窗提示免单，然后将该条数据保存在PAY表，然后删除该条数据
//将用户的免单标记值修改为NO
//有违规，弹窗显示其为存在违规，需加收违约金，然后弹窗显示支付金额，进入扫码支付界面进行支付，正常付钱，将数据写进PAY表，删除Booking表中该条数据
//支付不正常，将数据写进PAY表，Booking表对应数据不删除
//返回时，还原其标记值
//为普通用户，弹窗显示支付金额，进入扫码支付界面进行支付，后面如上。
//判断用户
Start NE21 = new Start();
String NE22 = Start.CUser;
chloe_control_all chloe_obj1 = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True");
Booking BigBang = new Booking();
BigBang = chloe_obj1.See_BOOK_CD(comboBox1.SelectedValue.ToString());
int BJ_check_result;
BJ_check_result = chloe_obj1.User_checkkkkk(NE22);
if (BJ_check_result == 3) //该值为3时是奖励用户
{
MessageBox.Show("您为奖励用户，已为您本次消费免单！");
String pay_id, pay_name, yard_id, begin_time, over_time, book_time, real_time, pay_money;
DateTime pay_time;
pay_id = BigBang.Book_personid.ToString();
pay_name = BigBang.Book_person.ToString();
yard_id = comboBox1.SelectedValue.ToString();
begin_time = BigBang.OpenTime.ToString();
over_time = BigBang.CloseTime.ToString();
book_time = BigBang.BookDate.ToString();
real_time = BigBang.REALDate.ToLongDateString().ToString();
pay_money = (Paymoney).Trim().ToString();
pay_time = DateTime.Now;
chloe_control_all chloe_obj2 = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True");
chloe_obj2.UserPay(pay_id, pay_name, yard_id, begin_time, over_time, book_time, real_time, pay_money, pay_time);
Booking del = new Booking();
User_BJ bj = new User_BJ();
chloe_control_all chloe_del = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True");
chloe_obj2.QUXIAO_YD(comboBox1.SelectedValue.ToString());
chloe_del.XG_BJ(NE22);
}
else
{
//违规用户
int bj_result;
bj_result = chloe_obj1.USER_CHECK(NE22);
if (bj_result == 0)
{
countmoney();
MessageBox.Show("系统检测到您为违约用户，需在本次消费中收取违约金");
MessageBox.Show("您需要支付：" + MMMM.ToString() + "元");
Count_pay2 br = new Count_pay2();
CHANGDI = comboBox1.SelectedValue.ToString();
this.Hide();
br.Show();
}
//正常用户
countmoney();
MessageBox.Show("您需要支付：" + MMMM.ToString() + "元");
Count_pay2 nor = new Count_pay2();
CHANGDI = comboBox1.SelectedValue.ToString();
this.Hide();
nor.Show();
}
}