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 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 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(); } }
public List <OrderMainEntity> GetOrderMainEntityList(OrderMainEntity condition_entity) { GenericWhereEntity <OrderMainEntity> where_entity = new GenericWhereEntity <OrderMainEntity>(); if (condition_entity.ORDER_ID != null) { where_entity.Where(n => (n.ORDER_ID == condition_entity.ORDER_ID)); } if (condition_entity.RESTAURANT_ID != null) { where_entity.Where(n => (n.RESTAURANT_ID == condition_entity.RESTAURANT_ID)); } if (condition_entity.TABLE_ID != null) { where_entity.Where(n => (n.TABLE_ID == condition_entity.TABLE_ID)); } if (condition_entity.ORDER_FLAG != null) { where_entity.Where(n => (n.ORDER_FLAG == condition_entity.ORDER_FLAG)); } return(EntityExecution.SelectAll(where_entity)); }
public int CreateOrder(int restaurantId, int tableId, decimal price, List <OrderListEntity> listOrderList) { using (TransactionScope ts = new TransactionScope()) { var orderMainEntity = new OrderMainEntity(); orderMainEntity.RESTAURANT_ID = restaurantId; orderMainEntity.TABLE_ID = tableId; orderMainEntity.PRICE = price; orderMainEntity.ORDER_FLAG = "1"; var orderId = InsertOrderMainEntity(orderMainEntity); foreach (var orderList in listOrderList) { orderList.ORDER_ID = orderId; orderList.ORDER_FLAG = "1"; orderList.ORDER_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss"); InsertOrderListEntity(orderList); } ts.Complete(); return(orderId); } }
public void UpdateOrder(int orderId, decimal price, string foodOp, OrderListEntity entity) { using (TransactionScope ts = new TransactionScope()) { //更新主表价格 var orderMainEntity = new OrderMainEntity(); orderMainEntity.ORDER_ID = orderId; orderMainEntity.PRICE = price; UpdateOrderMainEntity(orderMainEntity); //更新子表明细 var dt = GetUnConfirmOrderData(orderId, entity.FOOD_ID); if (foodOp == "add") { if (dt != null && dt.Rows.Count > 0) { var condition = new OrderListEntity(); condition.LIST_ID = int.Parse(dt.Rows[0]["LIST_ID"].ToString()); condition.COUNT = int.Parse(dt.Rows[0]["COUNT"].ToString()) + 1; UpdateOrderListEntity(condition); } else { entity.ORDER_ID = orderId; entity.COUNT = 1; entity.ORDER_FLAG = "1"; entity.ORDER_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss"); InsertOrderListEntity(entity); } } else if (foodOp == "cut") { if (dt != null && dt.Rows.Count > 0) { var count = int.Parse(dt.Rows[0]["COUNT"].ToString()); if (count <= 1) { var condition = new OrderListEntity(); condition.LIST_ID = int.Parse(dt.Rows[0]["LIST_ID"].ToString()); DeleteOrderListEntity(condition); } else { var condition = new OrderListEntity(); condition.LIST_ID = int.Parse(dt.Rows[0]["LIST_ID"].ToString()); condition.COUNT = count - 1; UpdateOrderListEntity(condition); } } } else if (foodOp == "remark") { if (dt != null && dt.Rows.Count > 0) { var condition = new OrderListEntity(); condition.LIST_ID = int.Parse(dt.Rows[0]["LIST_ID"].ToString()); condition.TASTE = entity.TASTE; condition.REMARK = entity.REMARK; UpdateOrderListEntity(condition); } } ts.Complete(); } }
public void DeleteOrderMainEntity(OrderMainEntity condition_entity) { condition_entity.Delete(); }
public void UpdateOrderMainEntity(OrderMainEntity condition_entity) { condition_entity.Update(); }
public int InsertOrderMainEntity(OrderMainEntity condition_entity) { var result = condition_entity.InsertWithIdentity(); return(int.Parse(result.ToString())); }