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