public ActionResult OutItemEditDB(WarehouseOutItem model)
{
if (!base.CheckPrivilege("EnablePrepare"))//制表权限验证
return RedirectToAction("ErrorPage", "Home", new { message = "Sorry you have no privilege to visit the Page" });
if (model.Quantity == 0m)
{
return Error("数量必须大于0", Url.Action("StockOutEdit", new { outID = model.OutID }));
}
WarehouseOutItem temp;
temp = (from o in dbEntity.WarehouseOutItems
where o.Gid == model.Gid
&& !o.Deleted
select o).SingleOrDefault();
if (temp == null)
{
return Error("记录不存在", Url.Action("StockOutEdit", new { outID = model.OutID }));
}
temp.TrackLot = model.TrackLot;
temp.Quantity = model.Quantity;
temp.ShelfID = model.ShelfID;
dbEntity.SaveChanges();
WarehouseStockOut stockOut = (from s in dbEntity.WarehouseStockOuts.Include("StockOutItems")
where s.Gid == temp.OutID
&& !s.Deleted
select s).Single();
stockOut.Total = stockOut.StockOutItems.Select(item => item.Quantity).Sum();
dbEntity.SaveChanges();
whBll = new WarehouseBLL(dbEntity);
whBll.InventoryByWarehouseSku(stockOut.WhID, model.SkuID);
return RedirectToAction("StockOutEdit", new { temp.OutID });
}
public StockOutSku(WarehouseOutItem oOutItem, OrderItem oOderItem)
{
this.oOutItem = oOutItem;
this.oOderItem = oOderItem;
}
/// <summary>
/// 出库记录明细添加
/// </summary>
/// <param name="outID">要添加书库记录明细的出库单GUID</param>
/// <returns>出库记录明细添加页面</returns>
public ActionResult OutItemAdd(Guid outID)
{
if (!base.CheckPrivilege("EnablePrepare"))//制表权限验证
return RedirectToAction("ErrorPage", "Home", new { message = "Sorry you have no privilege to visit the Page" });
WarehouseStockOut stockOut = dbEntity.WarehouseStockOuts.Find(outID);
if (stockOut == null || stockOut.Deleted)
{
return Error("记录不存在", Url.Action("StockOut"));
}
WarehouseOutItem model = new WarehouseOutItem
{
OutID = outID,
StockOut = stockOut
};
#region 货架下拉框数据
var shelves = (from shelf in dbEntity.WarehouseShelves
where shelf.WhID == stockOut.WhID
&& shelf.Deleted == false
select new { Code = shelf.Code, Gid = shelf.Gid }).ToList();
List<SelectListItem> list = (from shelf in shelves
select new SelectListItem
{
Text = shelf.Code,
Value = shelf.Gid.ToString()
}).ToList();
ViewBag.Shelf = list;
#endregion 货架下拉框数据
return View(model);
}