public JsonResult WareOutInventory(int WarehouseIdOut, int ProductId) { MotaiDataEntities dbContext = new MotaiDataEntities(); tWarehouse warehouse = dbContext.tWarehouses.Where(w => w.wProductId.Equals(ProductId) && w.WarehouseNameId.Equals(WarehouseIdOut)).FirstOrDefault(); int MaxQty = warehouse.wPQty; return(Json(MaxQty)); }
public JsonResult 進貨單建立(StockCreateViewModel stockList) { if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; if (Session[CSession關鍵字.SK_STOCKDETAIL] == null) { return(Json(new { result = false, msg = "進貨單尚未完成!", url = "" })); } else { List <StockDetailViewModel> stocks = Session[CSession關鍵字.SK_STOCKDETAIL] as List <StockDetailViewModel>; MotaiDataEntities dbContext = new MotaiDataEntities(); tStockList list = new tStockList(); list.sEmployeeId = emp.EmployeeId; list.sStockSerialValue = stockList.sStockSerialValue; list.sVendor = stockList.sVendor; list.sVendorTel = stockList.sVendorTel; list.sStockDate = stockList.sStockDate; list.sStockNote = stockList.sStockNote; dbContext.tStockLists.Add(list); dbContext.SaveChanges(); foreach (var items in stocks) { tStockDetail detail = new tStockDetail(); detail.sStockId = dbContext.tStockLists.OrderByDescending(i => i.StockId).First().StockId; detail.sProductId = items.sProductId; detail.sCost = items.sCost; detail.sQuantity = items.sQuantity; detail.sWarehouseNameId = items.sWarehouseNameId; detail.sNote = items.sNote; dbContext.tStockDetails.Add(detail); //倉儲變動 tWarehouse Warehouse = dbContext.tWarehouses.Where(w => w.WarehouseNameId.Equals(items.sWarehouseNameId) && w.wProductId.Equals(items.sProductId)).FirstOrDefault(); if (Warehouse != null) { Warehouse.wPQty += items.sQuantity; } else { tWarehouse warehouse = new tWarehouse(); warehouse.WarehouseNameId = items.sWarehouseNameId; warehouse.wProductId = items.sProductId; warehouse.wPQty = items.sQuantity; dbContext.tWarehouses.Add(warehouse); } } dbContext.SaveChanges(); Session[CSession關鍵字.SK_STOCKDETAIL] = null; return(Json(new { result = true, msg = "新增成功", url = Url.Action("進貨單建立", "Commodity") })); } } else { return(Json(new { result = false, msg = "尚未登入!", url = Url.Action("員工登入", "Employee") })); } }
public ActionResult 出貨單建立(ShipCreateModel ShipList) { MotaiDataEntities dbContext = new MotaiDataEntities(); if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { tEmployee employee = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; tShipList Shiplist = new tShipList(); Shiplist.sEmployeeId = employee.EmployeeId; Shiplist.sShipSerialValue = ShipList.sShipSerialValue; Shiplist.sOrderId = ShipList.SelectOrder; Shiplist.sShipDate = ShipList.sShipDate; Shiplist.sShipNote = ShipList.sShipNote; dbContext.tShipLists.Add(Shiplist); dbContext.SaveChanges(); for (int i = 0; i < ShipList.WareHouseId.Count; i++) { if (ShipList.ShipProductQty[i] != 0) { tShipDetail tShipdetail = new tShipDetail(); tShipdetail.ShipId = dbContext.tShipLists.OrderByDescending(s => s.ShipId).First().ShipId; tShipdetail.sOrderDetailId = ShipList.OrderDetailId[i]; tShipdetail.sProductId = ShipList.ProductId[i]; tShipdetail.sQuantity = ShipList.ShipProductQty[i]; tShipdetail.sWarehouseNameId = ShipList.WareHouseId[i]; dbContext.tShipDetails.Add(tShipdetail); //倉儲變動 tWarehouse Warehouse = dbContext.tWarehouses.Where(w => w.WarehouseNameId == tShipdetail.sWarehouseNameId && w.wProductId == tShipdetail.sProductId).FirstOrDefault(); if (Warehouse != null) { Warehouse.wPQty -= ShipList.ShipProductQty[i]; } } } tOrder order = dbContext.tOrders.Where(o => o.OrderId == Shiplist.sOrderId).FirstOrDefault(); order.oDeliverDate = ShipList.sShipDate; dbContext.SaveChanges(); } return(RedirectToAction("出貨單查詢")); }
public ActionResult 調貨單建立(TransferSaveModel save) { MotaiDataEntities dbContext = new MotaiDataEntities(); if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { tEmployee employee = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; tTransfer transfer = new tTransfer(); transfer.tProductId = save.ProductId; transfer.tProductQty = save.ProductQty; transfer.tEmployeeId = employee.EmployeeId; transfer.tWNIdOut = save.WarehouseIdOut; transfer.tWNIdIn = save.WarehouseIdIn; transfer.tDate = save.Date; transfer.tNote = save.Note; tWarehouse warehouseOut = dbContext.tWarehouses.Where(wo => wo.WarehouseNameId.Equals(save.WarehouseIdOut) && wo.wProductId.Equals(save.ProductId)).FirstOrDefault(); warehouseOut.wPQty = warehouseOut.wPQty - save.ProductQty; tWarehouse warehouseIn = dbContext.tWarehouses.Where(wo => wo.WarehouseNameId.Equals(save.WarehouseIdIn) && wo.wProductId.Equals(save.ProductId)).FirstOrDefault(); if (warehouseIn == null) { tWarehouse newwarehouseIn = new tWarehouse(); newwarehouseIn.WarehouseNameId = save.WarehouseIdIn; newwarehouseIn.wProductId = save.ProductId; newwarehouseIn.wPQty = save.ProductQty; dbContext.tWarehouses.Add(newwarehouseIn); } else { warehouseIn.wPQty = warehouseIn.wPQty + save.ProductQty; } dbContext.tTransfers.Add(transfer); dbContext.SaveChanges(); return(RedirectToAction("調貨單查詢", "Commodity")); } return(RedirectToAction("員工登入", "Employee")); }