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() + "！\"}");
}
}
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;
}
}
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 void UpdateOrderMainEntity(OrderMainEntity condition_entity)
{
condition_entity.Update();
}
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 int InsertOrderMainEntity(OrderMainEntity condition_entity)
{
var result = condition_entity.InsertWithIdentity();
return int.Parse(result.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 void DeleteOrderMainEntity(OrderMainEntity condition_entity)
{
condition_entity.Delete();
}
