public ActionResult Edit(OrderBag bag)
{
OrderItem orderItem = context.OrderItems.Include("Order").Where(o => o.Id.Equals(bag.Id)).FirstOrDefault();
orderItem.IsDispatched = bag.IsDispatched;
orderItem.ProductId = bag.ProductId;
orderItem.NominalWeightPerMeter = bag.NominalWeightPerMeter;
orderItem.TotalWeight = bag.TotalWeight;
orderItem.Amount = bag.Amount;
orderItem.Order.Comments = bag.Comments;
orderItem.HDPEPrice = bag.HDPEPrice;
orderItem.NominalWeightPerMeter = bag.NominalWeightPerMeter;
orderItem.PricePerUnit = bag.PricePerUnit;
orderItem.TotalPrice = bag.Amount * bag.PricePerUnit;
orderItem.WasherPrice = bag.WasherPrice;
orderItem.AmountDispatched = bag.AmountDispatched;
orderItem.DateToRecieve = FormatDate(bag.DateToRecieve);
orderItem.DateOfDispatch = FormatDate(bag.DateOfDispatch);
orderItem.DispatchComments = bag.DispatchComments;
orderItem.Comments = bag.Comments;
orderItem.Order.Date = FormatDate(bag.DateTime);
context.Entry(orderItem).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
ViewBag.ModelOperatedId = orderItem.Id.ToString();
return(RedirectToAction("Index", new { area = "commerce", controller = "Orders" }));
}
public OrderBag FindOrder(DataContext dataContext, string orderId)
{
var orderInDb = Db.order.Find(orderId);
if (orderInDb == null)
{
throw new Exception("订单不存在！orderId=>" + orderId);
}
var order = new OrderBag(dataContext, orderInDb);
return(order);
}
public ActionResult Add(Guid orderId)
{
Order order = context.Orders.Include("Customer").Where(i => i.Id.Equals(orderId)).FirstOrDefault();
OrderBag bag = new OrderBag
{
OrderId = order.Id,
CustomerId = order.CustomerId,
CustomerName = order.Customer.Name,
CustomerTel = order.Customer.TelephoneNumber,
CustomerCity = order.Customer.City
};
return(View("~/Areas/Commerce/Views/OrdersRelated/Orders/Add.cshtml", bag));
}
public ActionResult Edit(Guid id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrderItem orderItem = context.OrderItems.Include("Product").Include("Order.Customer").Where(i => i.Id.Equals(id)).FirstOrDefault();
OrderBag orderBag = null;
if (orderItem != null)
{
orderBag = ConvertIOrderItemToOrderBag(orderItem);
}
return(View("~/Areas/Commerce/Views/OrdersRelated/Orders/Edit.cshtml", orderBag));
}
public static bool SyncOrder(this MyDbContext db, OrderBag orderBag)
{
//同步到数据库
////是否已存在该订单 清空旧数据
//var oldOrder = db.Orders.Find(orderBag.Order.OrderID);
//if (oldOrder != null)
//{
// db.Orders.Remove(oldOrder);
// orderBag.Order.OrderItems.ToList().ForEach(a =>
// {
// db.OrderItems.Remove(db.OrderItems.Find(a.SellOrderItemID));
// });
// //不安全保存
// db.SaveChanges();
//}
//添加新数据
db.order.AddOrUpdate(orderBag.Order);
orderBag.Order.order_item.ToList().ForEach(a => db.order_item.AddOrUpdate(a));
//保存
return(db.SaveChanges() > 0);
}
// [ActivityLogger(ActivityName = "اضافه", ModelNameBeingOperated = "استعلام")]
public ActionResult Add(OrderBag bag)
{
OrderItem item = new OrderItem()
{
Id = Guid.NewGuid(),
Amount = bag.Amount,
Comments = bag.Comments,
HDPEPrice = bag.HDPEPrice,
OrderId = bag.OrderId,
IsDispatched = bag.IsDispatched,
NominalWeightPerMeter = bag.NominalWeightPerMeter,
PricePerUnit = bag.PricePerUnit,
TotalWeight = bag.TotalWeight,
ProductId = bag.ProductId,
WasherPrice = bag.WasherPrice,
TotalPrice = (bag.Amount * bag.PricePerUnit),
DateToRecieve = FormatDate(bag.DateToRecieve),
};
context.OrderItems.Add(item);
context.SaveChanges();
ViewBag.ModelOperatedId = item.Id;
return(RedirectToAction("Index", new { area = "commerce", controller = "Orders" }));
}
public bool SyncOrder(OrderBag orderBag)
{
return(Db.SyncOrder(orderBag));
}
