private void SubmitDeskOrder()
{
if (this.txtConsumeTime.Text.Trim().Length == 0)
{
ShowMessageAlert("请输入消费时间!");
return;
}
if (this.txtPersons.Text.Trim().Length == 0)
{
ShowMessageAlert("请输入消费人数!");
return;
}
if (this.ddlDeskType.SelectedIndex == -1)
{
ShowMessageAlert("请选择包间类型!");
return;
}
if (this.txtCustomerName.Text.Trim().Length == 0)
{
ShowMessageAlert("请输入预订人姓名!");
return;
}
if (this.txtPersons.Text.Trim().Length == 0)
{
ShowMessageAlert("请输入联系电话!");
return;
}
if (this.txtValidateCode.Text.Trim().Length == 0)
{
ShowMessageAlert("请输入验证码!");
return;
}
if (this.txtValidateCode.Text.Trim() != Session["CheckCode"].ToString())
{
ShowMessageAlert("验证码不正确!");
return;
}
DeskOrder objDishBook = new DeskOrder()
{
CustomerName = this.txtCustomerName.Text.Trim(),
ConsumeTime = Convert.ToDateTime(this.txtConsumeTime.Text),
CustomerPhone = this.txtPhoneNumber.Text.Trim(),
ConsumePersons = Convert.ToInt32(this.txtPersons.Text),
DeskType = this.ddlDeskType.Text,
Comments = this.txtComment.Text.Trim() == "" ? "无" : this.txtComment.Text.Trim()
};
try
{
new DAL.DeskService().OrderBook(objDishBook);
this.ltaMsg.Text = "<script>alert('预定成功');location.href='/Pages/Default.aspx'</script>";
}
catch (Exception ex)
{
ShowMessageAlert("提交失败" + ex.Message);
}
}
public int OrderBook(DeskOrder deskBook)
{
string sql = "INSERT INTO DeskOrder(ConsumeTime,ConsumePersons,DeskType,CustomerName,CustomerPhone,Comments) VALUES(@ConsumeTime,@ConsumePersons,@DeskType,@CustomerName,@CustomerPhone,@Comments);";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ConsumeTime", deskBook.ConsumeTime),
new SqlParameter("@ConsumePersons", deskBook.ConsumePersons),
new SqlParameter("@DeskType", deskBook.DeskType),
new SqlParameter("@CustomerName", deskBook.CustomerName),
new SqlParameter("@CustomerPhone", deskBook.CustomerPhone),
new SqlParameter("@Comments", deskBook.Comments),
};
return(SQLHelper.Update(sql, param));
}
