public ActionResult InvItemAddDB(WarehouseInvItem model) { WarehouseInvItem newItem = (from i in dbEntity.WarehouseInvItems where i.InvID == model.InvID && i.SkuID == model.SkuID && i.ShelfID == model.ShelfID select i).SingleOrDefault(); if (newItem == null) { newItem = new WarehouseInvItem { InvID = model.InvID, SkuID = model.SkuID, ShelfID = model.ShelfID, TrackLot = model.TrackLot, Quantity = model.Quantity, Remark = model.Remark }; dbEntity.WarehouseInvItems.Add(newItem); } else if (newItem.Deleted) { newItem.Deleted = false; newItem.TrackLot = model.TrackLot; newItem.Quantity = model.Quantity; newItem.Remark = model.Remark; } else { return Error("记录冲突", Url.Action("InventoryEdit", new { invID = model.InvID })); } dbEntity.SaveChanges(); WarehouseInventory inventory = (from s in dbEntity.WarehouseInventories.Include("InvItems") where s.Gid == newItem.InvID && !s.Deleted select s).Single(); inventory.Quantity = inventory.InvItems.Select(item => item.Quantity).Sum(); dbEntity.SaveChanges(); whBll = new WarehouseBLL(dbEntity); whBll.InventoryByWarehouseSku(inventory.WhID, model.SkuID); return RedirectToAction("InventoryEdit", new { invID = model.InvID }); }
public ActionResult InvItemEditDB(WarehouseInvItem model) { WarehouseInvItem item = dbEntity.WarehouseInvItems.Find(model.Gid); if (item == null || item.Deleted) { return Error("记录不存在", Url.Action("InventoryEdit", new { invID = model.InvID })); } else { item.SkuID = model.SkuID; item.ShelfID = model.ShelfID; item.TrackLot = model.TrackLot; item.Quantity = model.Quantity; item.Remark = model.Remark; dbEntity.SaveChanges(); WarehouseInventory inventory = (from s in dbEntity.WarehouseInventories.Include("InvItems") where s.Gid == item.InvID && !s.Deleted select s).Single(); inventory.Quantity = inventory.InvItems.Select(i => i.Quantity).Sum(); dbEntity.SaveChanges(); whBll = new WarehouseBLL(dbEntity); whBll.InventoryByWarehouseSku(inventory.WhID, model.SkuID); return RedirectToAction("InventoryEdit", new { invID = model.InvID }); } }
/// <summary> /// 添加盘点明细 /// </summary> /// <param name="invID">盘点单ID</param> /// <returns></returns> public ViewResult InvItemAdd(Guid invID) { WarehouseInventory inv = dbEntity.WarehouseInventories.Find(invID); if(inv == null || inv.Deleted) { return Error("记录不存在", Url.Action("Inventory")); } else { WarehouseInvItem model = new WarehouseInvItem { InvID = invID, Inventory = inv }; #region 仓库下拉框 IEnumerable<WarehouseShelf> shelves = (from shelf in dbEntity.WarehouseShelves where shelf.WhID == inv.WhID && !shelf.Deleted select shelf).ToList(); IEnumerable<SelectListItem> shelfList = from shelf in shelves select new SelectListItem { Text = shelf.Name, Value = shelf.Gid.ToString() }; ViewBag.ShelfList = shelfList; #endregion 仓库下拉框 return View(model); } }