/// <summary>
/// 添加员工订餐信息
/// </summary>
/// <param name="_Dinner">员工订餐信息类</param>
/// <returns>是否添加成功</returns>
public static int AddOrder(Model.Book_Dinner _Dinner)
{
string sql = "insert into Book_Dinner values(@No,@Time,@Name)";
SqlParameter[] parameter =
{
new SqlParameter("@No", _Dinner.work_no),
new SqlParameter("@Time", _Dinner.book_time),
new SqlParameter("@Name", _Dinner.Emp_Name),
};
return(SQLHelper.ExecuteNonQurery(sql, CommandType.Text, parameter));
}
protected void btnOrder_Click(object sender, EventArgs e)
{
DateTime dateTime = DateTime.Now;
if (DateTime.TryParse(txtEndTime.Text, out dateTime) == true)
{
Model.Book_Dinner book_Dinner = new Model.Book_Dinner();
string No = Session["User"].ToString();
Model.Employees employees = BLL.EmployeesBLL.GetEmployeesList().Where(E => E.Emp_No == No).First();
book_Dinner.work_no = No;
book_Dinner.Emp_Name = employees.Emp_Name;
book_Dinner.book_time = dateTime;
if (BLL.Book_DinnerBLL.AddOrder(book_Dinner) > 0)
{
Response.Redirect("BookDinList.aspx");
}
else
{
Response.Write("<script>alert('预定出现错误！，请重试')</script>");
}
}
}
/// <summary>
/// 添加员工订餐信息
/// </summary>
/// <param name="_Dinner">员工订餐信息类</param>
/// <returns>是否添加成功</returns>
public static int AddOrder(Model.Book_Dinner _Dinner)
{
return(DAL.Book_DinnerDAL.AddOrder(_Dinner));
}
