private static Guid WarehouseGuidSelected; //选中的仓库 #endregion Fields #region Constructors // // GET: /Order/ public OrderController() { warehouseBll = new WarehouseBLL(dbEntity); orderBll = new OrderBLL(dbEntity); }
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 }); } }
public JsonResult InvItemDeleteDB(Guid itemID) { WarehouseInvItem item = dbEntity.WarehouseInvItems.Find(itemID); if (item == null || item.Deleted) { // // To do // } else { item.Deleted = true; dbEntity.SaveChanges(); whBll = new WarehouseBLL(dbEntity); WarehouseInventory inventory = (from s in dbEntity.WarehouseInventories.Include("InvItems") where s.Gid == item.InvID && !s.Deleted select s).Single(); whBll.InventoryByWarehouseSku(inventory.WhID, item.SkuID); } return Json(true, JsonRequestBehavior.AllowGet); }
public JsonResult MoveItemDeleteDB(Guid itemID) { if (!base.CheckPrivilege("EnablePrepare"))//制表权限验证 return Json("NoPrivilege", JsonRequestBehavior.AllowGet); WarehouseMoveItem item = dbEntity.WarehouseMoveItems.Find(itemID); if (item == null || item.Deleted) { //已删除 } else { item.Deleted = true; dbEntity.SaveChanges(); WarehouseMoving moving = (from s in dbEntity.WarehouseMovings.Include("MoveItems") where s.Gid == item.MoveID && !s.Deleted select s).Single(); whBll = new WarehouseBLL(dbEntity); whBll.InventoryByWarehouseSku(moving.OldWhID, item.SkuID); whBll.InventoryByWarehouseSku(moving.NewWhID, item.SkuID); } return Json(true, JsonRequestBehavior.AllowGet); }
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 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 }); }
public JsonResult MovingDeleteDB(Guid moveID) { if (!base.CheckPrivilege("EnableDelete"))//制表权限验证 return Json("NoPrivilege", JsonRequestBehavior.AllowGet); whBll = new WarehouseBLL(dbEntity); int state = whBll.MovingDiscard(moveID, CurrentSession.UserID); bool result = (state == 0); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult MovingConfirmDB(Guid moveID) { if (!base.CheckPrivilege("EnableApprove"))//权限验证 return Json("NoPrivilege", JsonRequestBehavior.AllowGet); whBll = new WarehouseBLL(dbEntity); int result = whBll.MoveingConfirm(moveID, CurrentSession.UserID); return Json(result, JsonRequestBehavior.AllowGet); }
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 }); }
/// <summary> /// 确认出库单到数据库 /// </summary> /// <param name="outID">出库单ID</param> /// <returns></returns>0 1 2 3 4 5 11:确认成功,订单用户无订阅消息12:邮件提醒消息队列添加失败13:短信提醒消息队列添加失败 public JsonResult StockOutConfirmDB(Guid outID) { if (!base.CheckPrivilege("EnableApprove"))//确认出库单权限验证 return Json("NoPrivilege", JsonRequestBehavior.AllowGet); whBll = new WarehouseBLL(dbEntity); int result = whBll.StockOutConfirm(outID, CurrentSession.UserID); //add by tianyou 2011/10/25 设置消息队列 int _SetMessagePending ;//判断消息队列设置返回值 if (result == 0) { //验证单据类型是否为订单 RefType==0? WarehouseStockOut oStockOut = dbEntity.WarehouseStockOuts.Where(o => o.Gid == outID && o.RefType == (byte)ModelEnum.NoteType.ORDER && o.Deleted == false).FirstOrDefault(); if (oStockOut != null) {//如果是订单 则判断用户是否订阅发货消息 OrderInformation oOrder = dbEntity.OrderInformations.Where(o => o.Deleted == false && o.Gid == oStockOut.RefID).FirstOrDefault(); if (oOrder != null) { //设置消息队列 _SetMessagePending = whBll.DeliveryMessageSet(oOrder.UserID, 1, oOrder.Gid,CurrentSession.Culture); result = _SetMessagePending; } } } return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult InItemDeleteDB(Guid itemID) { if (!base.CheckPrivilege("EnablePrepare"))//制表权限验证,有制表权限就能删除明细条目,而不是根据入库单的删除权限 return Json("NoPrivilege", JsonRequestBehavior.AllowGet); WarehouseInItem inItem = dbEntity.WarehouseInItems.Find(itemID); if (inItem == null || inItem.Deleted) { //不存在记录 } else { inItem.Deleted = true; dbEntity.SaveChanges(); WarehouseStockIn stockIn = (from s in dbEntity.WarehouseStockIns.Include("StockInItems") where s.Gid == inItem.InID && !s.Deleted select s).Single(); whBll = new WarehouseBLL(dbEntity); whBll.InventoryByWarehouseSku(stockIn.WhID, inItem.SkuID); } return Json(true, JsonRequestBehavior.AllowGet); }
public ActionResult InItemEditDB(WarehouseInItem 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("数量必须大于零", Url.Action("InItemEdit", new { itemID = model.Gid })); } WarehouseInItem inItem = dbEntity.WarehouseInItems.Find(model.Gid); if (inItem == null || inItem.Deleted) { return Error("记录不存在", Url.Action("StockIn")); } else { inItem.SkuID = model.SkuID; inItem.ShelfID = model.ShelfID; inItem.TrackLot = model.TrackLot; inItem.Quantity = model.Quantity; inItem.Guarantee = model.Guarantee; inItem.GenBarcode = model.GenBarcode; dbEntity.SaveChanges(); WarehouseStockIn stockIn = (from s in dbEntity.WarehouseStockIns.Include("StockInItems") where s.Gid == inItem.InID && !s.Deleted select s).Single(); stockIn.Total = stockIn.StockInItems.Select(item => item.Quantity).Sum(); dbEntity.SaveChanges(); whBll = new WarehouseBLL(dbEntity); whBll.InventoryByWarehouseSku(stockIn.WhID, model.SkuID); return RedirectToAction("StockInEdit", new { inID = inItem.InID }); } }
public string outWare() { Guid? userid = CurrentSession.UserID; Guid gInWareId; WarehouseBLL oWarehouseBLL = new WarehouseBLL(dbEntity); int nResult = oWarehouseBLL.GenerateStockInFromPurchase(gPurId, userid, out gInWareId); if (nResult == 0) { string sInCode = (from s in dbEntity.WarehouseStockIns where s.Gid == gInWareId select s.Code).FirstOrDefault(); } else { } return "success"; }