private void loadDishesList()
{
StringBuilder sb = new StringBuilder();
string id = Request.Cookies["restaurantId"].Value;
if (id == null)
{
return;
}
DishDAO dishDao = new DishDAO();
List<DishEntity> list = dishDao.getByResaurantId(Convert.ToInt32(id));
if (list.Count > 0) {
for(int i=0;i<list.Count;i++){
sb.Append("<tr>");
sb.Append("<td><input type='checkbox' name='order[]' value='528'/></td>");
sb.Append("<td><a href='edit_dish.aspx?dish_id="+list[i].id+"'>" + list[i].dish_name + "</a></td>");
sb.Append("<td>Product #"+list[i].id+"</td>");
sb.Append("<td><span>"+list[i].price+"</span></td>");
sb.Append("<td>" + list[i].price + "</td>");
sb.Append("<td>"+list[i].dish_name+"</td>");
sb.Append("<td>");
sb.Append("<a href='#' class='button green'>");
sb.Append("<div class='icon'><span id='" + list[i].id + "' class='ico-pencil' OnClick='editDish(this)'></span></div>");
sb.Append("<a href='#' class='button red'>");
sb.Append("<div class='icon'><span id='" + list[i].id + "' class='ico-remove' OnClick='deleteDish(this)'></span></div>");
sb.Append("</a>");
sb.Append("</td>");
sb.Append("</tr>\n");
}
}
dishList = sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
int dish_id = Convert.ToInt32(Request.QueryString["dish_id"]);
DishDAO dishDAO = new DishDAO();
DishEntity dish = new DishEntity();
dish = dishDAO.getDishById(dish_id);
name = dish.dish_name;
price = dish.price;
description = dish.description;
}
public bool deleteDish()
{
string dishId = Request.Form["dishId"];
if (dishId != null)
{
DishDAO dishDAO = new DishDAO();
if (dishDAO.deleteById(Convert.ToInt32(dishId))) { return true; }
else { return false; }
}
return false;
}
protected void Unnamed_Click(object sender, EventArgs e)
{
Response.Write("<Script Language='JavaScript'>alert('"+e.ToString()+"');</Script>");
string dishId = Request.Form["dishId"];
if (dishId != null)
{
DishDAO dishDAO = new DishDAO();
if (dishDAO.deleteById(Convert.ToInt32(dishId))) { Response.Write("<Script Language='JavaScript'>alert('添加成功');</Script>"); }
else { Response.Write("<Script Language='JavaScript'>alert('添加错误,亲!');</Script>"); }
}
}
public void getAllOrders()
{
OrderDAO orderDAO = new OrderDAO();
DishDAO dishDAO = new DishDAO();
List<OrderEntity> list = orderDAO.getAllOrderByRestaurantId(1);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < list.Count;i++ )
{
OrderEntity order = list[i];
String dishString = "";
for (int j = 0; j < order.dishList.Count-1; j++)
{
DishEntity dish = dishDAO.getDishById(order.dishList[j].dish_id);
dishString += dish.dish_name + ",";
}
DishEntity dish2 = dishDAO.getDishById(order.dishList[order.dishList.Count-1].dish_id);
dishString += dish2.dish_name;
DateTime todaydate = Convert.ToDateTime(order.start_time);
String date = todaydate.ToString("MM/dd hh:mm:ss");
switch (order.status)
{
//对订单状态进行分类，应该需要换，优化
case 0:
sb.Append("<tr>");
sb.Append("<td width='55' class='bl_blue'><span class='label label-info'>新订单</span></td>");
sb.Append("<td width='50'>#AA-325 <span class='mark'>"+date+"</span></td>");
//跳转位置
sb.Append("<td><a href='order_list.aspx?orderId="+order.order_id+"' class='cblue'>"+dishString+"</a>");
sb.Append("<span class='mark'>来自"+order.user_id+"号桌</span>");
sb.Append("<input id='" + order.order_id + "' type='button' value='完成' OnClick='finishOrder(this)'></td>");
sb.Append("</tr>");
break;
case 1:
sb.Append("<tr>");
sb.Append("<td class='bl_green'><span class='label label-success'>完成</span></td>");
sb.Append("<td width='50'>#AA-"+order.order_id+" <span class='mark'>" + date + "</span></td>");
sb.Append("<td><a href='order_list.aspx?orderId=" + order.order_id + "' class='cgreen'>" + dishString + "</a>");
sb.Append("<span class='mark'>来自" + order.user_id + "号桌</span></td>");
sb.Append("</tr>");
break;
case 2:
sb.Append("<tr>");
sb.Append("<td class='bl_red'><span class='label label-important'>取消</span></td>");
sb.Append("<td>#VB-57 <span class='mark'>" + date + "</span></td>");
sb.Append("<td><a href='order_list.aspx?orderId=" + order.order_id + "' class='cred'>" + dishString + "</a>");
sb.Append("<span class='mark'>来自" + order.user_id + "号桌</span></td>");
sb.Append("</tr>");
break;
}
}
orderPart = sb.ToString();
}
protected void Unnamed_Click(object sender, EventArgs e)
{
string DishName = Request.Form["name"];
int DishPrice = Convert.ToInt32(Request.Form["price"]);
string DishDescription = Request.Form["description"];
int Spicy = Convert.ToInt32(Request.Form["spicy"]);
DishDAO dishDAO = new DishDAO();
DishEntity dish = new DishEntity();
dish.dish_name = DishName;
dish.price = DishPrice;
dish.description = DishDescription;
if (dishDAO.addOneDish(dish))
{
Response.Write("<Script Language='JavaScript'>alert('添加成功');</Script>");
}
else
{
Response.Write("<Script Language='JavaScript'>alert('添加错误,亲!');</Script>");
}
}
public void addDish()
{
string DishName = Request.Form["name"];
int DishPrice = Convert.ToInt32(Request.Form["price"]);
string DishDescription = Request.Form["description"];
int Spicy = Convert.ToInt32(Request.Form["spicy"]);
string photo;
DishDAO dishDAO = new DishDAO();
DishEntity dish = new DishEntity();
dish.dish_name = DishName;
dish.price = DishPrice;
dish.description = DishDescription;
if (dishDAO.addOneDish(dish))
{
Response.Write("<Script Language='JavaScript'>alert('添加成功');</Script>");
Response.Redirect("menu_list.aspx");
}
else
{
Response.Write("<Script Language='JavaScript'>alert('添加错误,亲!');</Script>");
}
}
public String listDetailOrder(int id)
{
OrderDAO orderDAO = new OrderDAO();
DishDAO dishDAO = new DishDAO();
OrderEntity order = orderDAO.getOneOrderByOrderId(id);
userId = order.user_id;
StringBuilder sb = new StringBuilder();
for (int j = 0; j < order.dishList.Count; j++)
{
DishEntity dish = dishDAO.getDishById(order.dishList[j].dish_id);
total_price += order.dishList[j].count * dish.price;
total_count += order.dishList[j].count;
switch (order.dishList[j].status)
{
//对订单状态进行分类，应该需要换，优化
case 0:
sb.Append("<div class='thumbnail'>");
sb.Append("<a class='fb' rel='group' href='" + dish.photo + "'><img src='" + dish.photo + "' class='img-polaroid'/></a>");
sb.Append("<div class='caption'>");
sb.Append("<h3>菜名:"+dish.dish_name+"</h3>");
sb.Append("<p>数量:" + order.dishList[j].count+ "</p>");
sb.Append("<p class='bl_blue'>状态:" + "未完成" + "</p>");
if (dish.discount != 0)
{
sb.Append("<p>优惠价：" + dish.discount + "</p>");
sb.Append("<p style='text-decoration:line-through;color:#9c9c9c'>单价:" + dish.price + "</p>");
}
else
{
sb.Append("<p>单价:" + dish.price + "</p>");
}
sb.Append("<p>备注:</p>");
sb.Append("<p><a class='btn btn-warning' id='" + order.dishList[j].id + "' OnClick='finishDish(this)' href='###'>完成</a> <a class='btn' href='#'>取消</a></p>");
sb.Append("</div>");
sb.Append("</div>");
break;
case 1:
sb.Append("<div class='thumbnail'>");
sb.Append("<a class='fb' rel='group' href='"+dish.photo+"'><img src='"+dish.photo+"' class='img-polaroid'/></a>");
sb.Append("<div class='caption'>");
sb.Append("<h3>菜名:" + dish.dish_name + "</h3>");
sb.Append("<p>数量:" + order.dishList[j].count + "</p>");
sb.Append("<p class='bl_blue'>状态:" + "完成" + "</p>");
if (dish.discount != 0)
{
sb.Append("<p>优惠价："+ dish.discount+"</p>");
sb.Append("<p style='text-decoration:line-through;color:#9c9c9c'>单价:" + dish.price + "</p>");
}
else {
sb.Append("<p>单价:" + dish.price + "</p>");
}
sb.Append("<p>备注：</p>");
// sb.Append("<p><a class='btn btn-warning' href='#'>完成</a> <a class='btn' href='#'>取消</a></p>");
sb.Append("</div>");
sb.Append("</div>");
break;
case 2:
sb.Append("<div class='thumbnail'>");
sb.Append("<a class='fb' rel='group' href='" + dish.photo + "'><img src='" + dish.photo + "' class='img-polaroid'/></a>");
sb.Append("<div class='caption'>");
sb.Append("<h3>菜名" + dish.dish_name + "</h3>");
sb.Append("<p>数量" + order.dishList[j].count + "</p>");
sb.Append("<p>备注：</p>");
sb.Append("<p><a class='btn btn-warning' href='#'>完成</a> <a class='btn' href='#'>取消</a></p>");
sb.Append("</div>");
sb.Append("</div>");
break;
}
}
sb.Append("<input name='结算订单' type='submit' value='结算订单'");
return sb.ToString();
}
