private void BindControlData() { IOrder orderBiz = new OrderBiz(); var entity = orderBiz.GetOrderMainEntity(OrderId); this.hOrderStatus.Value = entity.ORDER_FLAG; this.lTableId.InnerText = "桌号为:" + entity.TABLE_ID; }
public void ProcessRequest(HttpContext context) { try { var tableId = Helper.ParseInt(context.Request.QueryString["tid"]); var restaurantId = Helper.ParseInt(context.Request.QueryString["rid"]); var orderData = context.Request.Form["orderData"]; var price = Helper.ParseDecimal(context.Request.Form["price"]); IOrder orderBiz = new OrderBiz(); var condition = new OrderMainEntity(); condition.RESTAURANT_ID = restaurantId; condition.TABLE_ID = tableId; condition.ORDER_FLAG = "1"; var list = orderBiz.GetOrderMainEntityList(condition); if (list != null && list.Count > 0) { context.Response.Write("{\"success\":0,\"msg\":\"上个订单还未结束,不能创建新的订单,请重新重新刷新页面!\"}"); return; } var list2 = JsonToObjects(orderData); if (list2 != null && list2.Count > 0) { var orderId = orderBiz.CreateOrder(restaurantId, tableId, price, list2); context.Response.Write("{\"success\":1,\"id\":" + orderId.ToString() + "}"); } } catch (Exception ex) { context.Response.Write("{\"success\":0,\"msg\":\"订单数据有误,原因是" + ex.ToString() + "!\"}"); } }
private void BindTableData() { IOrder orderBiz = new OrderBiz(); var dt = orderBiz.GetOrderData(OrderId); if (dt != null && dt.Rows.Count > 0) { var data1 = dt.Clone(); var drs = dt.Select(" ( FINISH_TIME = '' or FINISH_TIME is null ) and ( CONFIRM_TIME = '' or CONFIRM_TIME is null ) "); foreach (DataRow row in drs) { data1.Rows.Add(row.ItemArray); } this.rUnconfirm.DataSource = data1; this.rUnconfirm.DataBind(); var data2 = dt.Clone(); drs = dt.Select("( FINISH_TIME = '' or FINISH_TIME is null ) and ( CONFIRM_TIME <> '' and CONFIRM_TIME is not null ) "); foreach (DataRow row in drs) { data2.Rows.Add(row.ItemArray); } this.rConfirm.DataSource = data2; this.rConfirm.DataBind(); var data3 = dt.Clone(); drs = dt.Select(" FINISH_TIME <> '' and FINISH_TIME is not null "); foreach (DataRow row in drs) { data3.Rows.Add(row.ItemArray); } this.rFinish.DataSource = data3; this.rFinish.DataBind(); decimal totalPrice = 0; foreach (DataRow row in dt.Rows) { totalPrice += base.ParseDecimal(row["PRICE"].ToString()) * base.ParseInt(row["COUNT"].ToString()); } this.sTotalPrice.InnerText = totalPrice.ToString(); } else { this.rUnconfirm.DataSource = null; this.rUnconfirm.DataBind(); this.rConfirm.DataSource = null; this.rConfirm.DataBind(); this.rFinish.DataSource = null; this.rFinish.DataBind(); } }
public void ProcessRequest(HttpContext context) { try { var orderId = Helper.ParseInt(context.Request.Form["oid"]); IOrder orderBiz = new OrderBiz(); orderBiz.ClearCart(orderId); context.Response.Write("{\"success\":1}"); } catch (Exception ex) { context.Response.Write("{\"success\":0,\"msg\":\" " + ex.ToString() + " \"}"); } }
public void ProcessRequest(HttpContext context) { var orderId = Helper.ParseInt(context.Request.Form["oid"]); IOrder orderBiz = new OrderBiz(); var dt = orderBiz.GetOrderData(orderId); if (dt != null && dt.Rows.Count > 0) { var result = JsonHelper.DataTableToJson(dt); context.Response.Write(result); } else { context.Response.Write("{}"); } }
private void OperateOrder() { try { if (!string.IsNullOrEmpty(this.hOperationId.Value)) { var op = this.hOperationId.Value.Split('|')[0]; var id = base.ParseInt(this.hOperationId.Value.Split('|')[1]); IOrder biz = new OrderBiz(); var condition = new OrderMainEntity(); condition.ORDER_ID = id; if (op == "finish") { condition.ORDER_FLAG = "2"; biz.UpdateOrderMainEntity(condition); this.lMsg.InnerText = "完成订单成功!"; } else if (op == "cancel") { condition.ORDER_FLAG = "3"; biz.UpdateOrderMainEntity(condition); this.lMsg.InnerText = "取消订单成功!"; } } } catch (Exception ex) { this.lMsg.InnerText = "操作失败,原因:" + ex.ToString(); } }
private void BindTableData() { var type = this.hOrderStatus.Value; if (string.IsNullOrEmpty(type)) type = "1"; this.lType.InnerText = GetTypeName(type); if (type == "0") type = null; int? restaurantId = base.ParseInt(this.ddlRestaurant.SelectedValue); if (restaurantId == 0) restaurantId = null; IOrder biz = new OrderBiz(); DataTable dt = (bool)base.CurEmployeeEntity.IS_ADMIN ? biz.GetOrderMainDataTable(restaurantId, type) : biz.GetOrderMainDataTable(base.CurEmployeeEntity.RESTAURANT_ID, type); repeater1.DataSource = GetPagedDataSource(dt.DefaultView); repeater1.DataBind(); }
private void BindData() { //绑定菜单列表 IFood foodBiz = new FoodBiz(); var dt = foodBiz.GetFoodDataTable(RestaurantId); repeater2.DataSource = dt; repeater2.DataBind(); //绑定菜单类型列表 var strFoodId = string.Empty; var listFoodType = new List<FoodTypeEntity>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (!strFoodId.Contains(dr["FOOD_TYPE_ID"].ToString() + "|")) { strFoodId += dr["FOOD_TYPE_ID"].ToString() + "|"; listFoodType.Add(new FoodTypeEntity() { FOOD_TYPE_ID = base.ParseInt(dr["FOOD_TYPE_ID"].ToString()), FOOD_TYPE_NAME = dr["FOOD_TYPE_NAME"].ToString() }); } } } repeater1.DataSource = listFoodType; repeater1.DataBind(); //获取是否已经点过菜 IOrder orderBiz = new OrderBiz(); var condition = new OrderMainEntity(); condition.RESTAURANT_ID = RestaurantId; condition.TABLE_ID = TableId; condition.ORDER_FLAG = "1"; var list = orderBiz.GetOrderMainEntityList(condition); if (list != null && list.Count > 0) this.hOrderId.Value = list[0].ORDER_ID.ToString(); }
private void OperateOrder() { try { if (!string.IsNullOrEmpty(this.hOperation.Value)) { IOrder orderBiz = new OrderBiz(); if (this.hOperation.Value.IndexOf('|') > -1) { var op = this.hOperation.Value.Split('|')[0]; var listId = base.ParseInt(this.hOperation.Value.Split('|')[1]); if (listId == 0) { this.lMsg.InnerText = "处理失败,参数 LIST_ID 不正确!"; return; } if (op == "cancel") { var condition = new OrderListEntity(); condition.LIST_ID = listId; condition.CANCEL_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss"); orderBiz.UpdateOrderListEntity(condition); } if (op == "confirm") { var condition = new OrderListEntity(); condition.LIST_ID = listId; condition.CONFIRM_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss"); orderBiz.UpdateOrderListEntity(condition); } else if (op == "finish") { //假如存在已完成同样的菜单,更新原有的数量 var curOrderListEntity = orderBiz.GetOrderListEntity(listId); var condition = new OrderListEntity(); condition.FOOD_ID = curOrderListEntity.FOOD_ID; condition.ORDER_ID = OrderId; var list = orderBiz.GetOrderListEntityList(condition); condition = null; if (list != null && list.Count > 0) { foreach (OrderListEntity e in list) { if (!string.IsNullOrEmpty(e.FINISH_TIME) && string.IsNullOrEmpty(e.CANCEL_TIME)) { condition = new OrderListEntity(); condition.LIST_ID = e.LIST_ID; condition.COUNT = e.COUNT; } } } if (condition != null) { condition.COUNT += curOrderListEntity.COUNT; orderBiz.UpdateOrderListEntity(condition); orderBiz.DeleteOrderListEntity(new OrderListEntity() { LIST_ID = curOrderListEntity.LIST_ID }); } else { condition = new OrderListEntity(); condition.LIST_ID = listId; condition.FINISH_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss"); orderBiz.UpdateOrderListEntity(condition); } } else if (op == "cancelfinish") { //假如存在已完成同样的菜单,更新原有的数量 var curOrderListEntity = orderBiz.GetOrderListEntity(listId); var condition = new OrderListEntity(); condition.FOOD_ID = curOrderListEntity.FOOD_ID; condition.ORDER_ID = OrderId; var list = orderBiz.GetOrderListEntityList(condition); condition = null; if (list != null && list.Count > 0) { foreach (OrderListEntity e in list) { if (!string.IsNullOrEmpty(e.CONFIRM_TIME) && string.IsNullOrEmpty(e.FINISH_TIME) && string.IsNullOrEmpty(e.CANCEL_TIME)) { condition = new OrderListEntity(); condition.LIST_ID = e.LIST_ID; condition.COUNT = e.COUNT; } } } if (condition != null) { condition.COUNT += curOrderListEntity.COUNT; orderBiz.UpdateOrderListEntity(condition); orderBiz.DeleteOrderListEntity(new OrderListEntity() { LIST_ID = curOrderListEntity.LIST_ID }); } else { condition = new OrderListEntity(); condition.LIST_ID = listId; condition.FINISH_TIME = string.Empty; orderBiz.UpdateOrderListEntity(condition); } } } else { if (this.hOperation.Value == "confirmall" || this.hOperation.Value == "finishall") { orderBiz.BatchProcessOrder(OrderId, this.hOperation.Value); } } } } catch (Exception ex) { this.lMsg.InnerText = "处理失败,原因:" + ex.ToString(); } }