public AdvanceBookingBilling(Entity.Booking booking)
{
InitializeComponent();
getCategoryId();
bookingIdBlock.Text = booking.BookingNo;
bookingDateBlock.Text = Convert.ToString(booking.BookingDate);
tableNoBlock.Text = booking.TableNo;
customerNameBlock.Text = booking.CustomerName;
contactBlock.Text = booking.Phone;
advanceBlock.Text = Convert.ToString(booking.Advance);
if (this.IsLoaded == false)
{
BillingService bs = new BillingService();
bs.TruncateOrder();
}
}
public int AddBooking(Entity.Booking booking)
{
String query = "Insert into Booking (BOOKINGID,BOOKINGDATE,STARTTIME,ENDINGTIME,TABLENO,TOTALTABLE,CUSTOMERNAME,PHONE,ADDRESS,ADVANCE) values('" + booking.BookingNo + "','" + booking.BookingDate + "','" + booking.StartTime + "','" + booking.EndingTime + "','" + booking.TableNo + "','" + booking.TotalTable + "','" + booking.CustomerName + "','" + booking.Phone + "','" + booking.Address + "','" + booking.Advance + "') ";
return(DataAccess.ExecuteQuery(query));
}
protected void Booking_Submit_Click(object sender, EventArgs e)
{
if (!VerifyUtility.IsString_NotNull(Booking_Seq.Text))
ResponseError("请输入订位代号");
if (!VerifyUtility.IsString_NotNull(Booking_Airline.Text))
ResponseError("请输入航空公司");
if (!VerifyUtility.IsString_NotNull(Booking_Airline.Text))
ResponseError("请输入联系人");
if (!VerifyUtility.IsNumber_NotNull(Booking_Num.Text))
ResponseError("请输入人数");
if (!VerifyUtility.IsString_NotNull(Booking_Tel.Text))
ResponseError("请输入电话号码");
if (!VerifyUtility.Check_Date(Booking_LastTime.Text))
ResponseError("结束时间, 请输入正确的日期格式如: " + DateTime.Now.ToString("yyyy-MM-dd"));
Entity.Booking e_Booking = new Entity.Booking();
if (g_Action_ID == 2)
e_Booking.Booking_ID = g_Booking_ID;
e_Booking.Booking_Seq = Booking_Seq.Text;
e_Booking.Booking_Airline = Booking_Airline.Text;
e_Booking.Booking_Contact = Booking_Contact.Text;
e_Booking.Booking_Num = Convert.ToInt32(Booking_Num.Text);
e_Booking.Booking_Tel = Booking_Tel.Text;
e_Booking.Booking_Email = Booking_Email.Text;
if (g_Action_ID == 1)
e_Booking.Booking_AdminUser_ID = g_AdminUser;
if (g_Action_ID == 2)
{
int AdminUser_ID = Convert.ToInt32(Booking_AdminUser_ID.SelectedValue);
e_Booking.Booking_AdminUser_ID = GetAdminUser(AdminUser_ID);
}
if (Booking_Kind1.Checked)
e_Booking.Booking_Kind = true;
else
e_Booking.Booking_Kind = false;
if (g_Action_ID == 1)
e_Booking.Booking_State = 0;
if (g_Action_ID == 2)
e_Booking.Booking_State = Convert.ToInt32(Booking_State.SelectedValue);
if (g_Action_ID == 1)
e_Booking.Booking_AddTime = DateTime.Now;
if (g_Action_ID == 2)
e_Booking.Booking_AddTime = DateTime.Parse(Booking_AddTime.Text);
e_Booking.Booking_LastTime = DateTime.Parse(Booking_LastTime.Text);
if (g_Action_ID == 2 && Booking_State.SelectedValue == "1")
e_Booking.Booking_ComitTime = DateTime.Now.ToString();
if (g_Action_ID == 1)
{
b_Booking.Insert_Booking(e_Booking);
g_TipsTable.Visible = true;
g_MainTable.Visible = false;
TipsMessage.Text = "添加成功";
TipsLink1.NavigateUrl = "?Action_ID=" + g_Action_ID.ToString() + "&Booking_ID=0";
TipsLink1.Text = "继续添加";
}
if (g_Action_ID == 2)
{
b_Booking.Update_Booking(e_Booking);
g_TipsTable.Visible = true;
g_MainTable.Visible = false;
TipsMessage.Text = "修改成功";
TipsLink1.NavigateUrl = "?Action_ID=" + g_Action_ID.ToString() + "&Booking_ID=" + g_Booking_ID.ToString();
TipsLink1.Text = "继续修改";
}
}
