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);
}
}
