public RedirectToRouteResult MoveItemAddDB(WarehouseMoveItem model) { if (!base.CheckPrivilege("EnablePrepare"))//制表权限验证 return RedirectToAction("ErrorPage", "Home", new { message = "Sorry you have no privilege to visit the Page" }); WarehouseMoveItem item = new WarehouseMoveItem { SkuID = model.SkuID, OldShelf = model.OldShelf, NewShelf = model.NewShelf, Quantity = model.Quantity, TrackLot = model.TrackLot, MoveID = model.MoveID }; ///移货位数量不能大于移库单总数量判断 ////// ///// dbEntity.WarehouseMoveItems.Add(item); dbEntity.SaveChanges(); WarehouseMoving moving = (from s in dbEntity.WarehouseMovings.Include("MoveItems") where s.Gid == item.MoveID && !s.Deleted select s).Single(); moving.Total = moving.MoveItems.Select(i => i.Quantity).Sum(); dbEntity.SaveChanges(); whBll = new WarehouseBLL(dbEntity); whBll.InventoryByWarehouseSku(moving.OldWhID, item.SkuID); whBll.InventoryByWarehouseSku(moving.NewWhID, item.SkuID); return RedirectToAction("MovingEdit", new { moveID = model.MoveID }); }
public ActionResult MoveItemEditDB(WarehouseMoveItem model) { if (!base.CheckPrivilege("EnablePrepare"))//制表权限验证 return RedirectToAction("ErrorPage", "Home", new { message = "Sorry you have no privilege to visit the Page" }); WarehouseMoveItem item = dbEntity.WarehouseMoveItems.Include("Moving").SingleOrDefault(i => i.Gid == model.Gid); if (item == null || item.Deleted) { return Error("记录不存在", Url.Action("MovingEdit", new { moveID = model.MoveID })); } if (item.Moving.Mstatus == (byte)ModelEnum.MovingStatus.CONFIRMED) { return Error("已确认,不能编辑", Url.Action("MovingEdit", new { moveID = item.MoveID })); } item.SkuID = model.SkuID; item.OldShelf = model.OldShelf; item.NewShelf = model.NewShelf; item.Quantity = model.Quantity; item.TrackLot = model.TrackLot; dbEntity.SaveChanges(); WarehouseMoving moving = (from s in dbEntity.WarehouseMovings.Include("MoveItems") where s.Gid == item.MoveID && !s.Deleted select s).Single(); moving.Total = moving.MoveItems.Select(i => i.Quantity).Sum(); dbEntity.SaveChanges(); whBll = new WarehouseBLL(dbEntity); whBll.InventoryByWarehouseSku(moving.OldWhID, item.SkuID); whBll.InventoryByWarehouseSku(moving.NewWhID, item.SkuID); return RedirectToAction("MovingEdit", new { moveID = item.MoveID }); }
/// <summary> /// 添加移库明细 /// </summary> /// <param name="moveID">移库单Id</param> /// <returns></returns> public ActionResult MoveItemAdd(Guid moveID) { if (!base.CheckPrivilege("EnablePrepare"))//制表权限验证 return RedirectToAction("ErrorPage", "Home", new { message = "Sorry you have no privilege to visit the Page" }); WarehouseMoving mov = dbEntity.WarehouseMovings.Find(moveID); if (mov == null || mov.Deleted) { return Error("记录不存在", Url.Action("Moving")); } else { List<WarehouseShelf> oldShelves = mov.OldWarehouse.Shelves.ToList(); List<WarehouseShelf> newShelves = mov.NewWarehouse.Shelves.ToList(); WarehouseMoveItem model = new WarehouseMoveItem { OldShelf = oldShelves.First().Gid, NewShelf = newShelves.First().Gid, MoveID = moveID, Moving = mov, Quantity = 1 }; #region 旧仓库下拉框 List<SelectListItem> ddlOldShelves = (from shelf in oldShelves select new SelectListItem { Text = shelf.Name, Value = shelf.Gid.ToString() }).ToList(); ViewBag.OldShelves = ddlOldShelves; #endregion 旧仓库下拉框 #region 新仓库下拉框 List<SelectListItem> ddlNewShelves = (from shelf in newShelves select new SelectListItem { Text = shelf.Name, Value = shelf.Gid.ToString() }).ToList(); ViewBag.NewShelves = ddlNewShelves; #endregion 新仓库下拉框 return View(model); } }