// POST: StockInDtls/Create
// 若要免於過量張貼攻擊，請啟用想要繫結的特定屬性，如需
// 詳細資訊，請參閱 https://go.microsoft.com/fwlink/?LinkId=317598。
public void Create(string stockInid)
{
StockInDtl stockInDtl = new StockInDtl();
stockInDtl.StockInID = stockInid;
var porid = db.StockIn.Where(w1 => w1.StockInID == stockInid).Select(s => s.PurchaseOrderReceiveID).ToList();
//庫存編號
string si = porid[0];
var code = db.PurchaseOrderReceiveDtl.Where(w => w.PurchaseOrderReceiveID == si).Select(s => s.PurchaseOrderDtlCode);
var sz = code.ToList();
foreach (var item in sz)
{
//1.倉庫必須先有資料才能有入庫明細，不然抓不到庫存編號
//2.必須選擇所要進入的倉庫是哪個，因為一個料件可能存放不同倉庫
//3.等於不能自動產生
var sourcelist = db.PurchaseOrderDtl.Where(w => w.PurchaseOrderDtlCode == item).Select(s => s.SourceListID).ToList();
string list = sourcelist[0];
var codee = db.InventoryDtl.Where(w => w.SourceListID == list).Select(s => s.InventoryCode).ToList();
stockInDtl.InventoryCode = codee[0];
var num = db.PurchaseOrderDtl.Where(w => w.PurchaseOrderDtlCode == item).Select(s => s.PartNumber).ToList();
stockInDtl.PartNumber = num[0];
stockInDtl.StockInQty = 0;
if (ModelState.IsValid)
{
db.StockInDtl.Add(stockInDtl);
db.SaveChanges();
}
}
}
public ActionResult Edit(StockInDtl stockInDtl)
{
string message = "修改成功!!";
bool status = true;
var data = db.Part.Where(w => w.PartName == stockInDtl.PartNumber).Select(s => s.PartNumber).ToList();
stockInDtl.PartNumber = data[0];
if (ModelState.IsValid)
{
db.Entry(stockInDtl).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { status = status, message = message, id = db.StockInDtl.Max(x => x.StockInDtlOID) }, JsonRequestBehavior.AllowGet));
}
else
{
message = "修改失敗!!";
status = false;
return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult StockInEdit(StockInDtl stockInDtl)
{
string message = "入庫成功!!";
bool status = true;
var data = db.Part.Where(w => w.PartName == stockInDtl.PartNumber).Select(s => s.PartNumber).ToList();
stockInDtl.PartNumber = data[0];
string oid = stockInDtl.InventoryCode;
//StockInDtlOID: oidd, Y
// StockInID:$("#StockInID").val(),Y
// InventoryCode: $("#InventoryCode").val(),Y
// PartNumber: $("#PartName").val(),Y
// StockInQty: $("#StockInQty").val(),Y
// Remark: $("#Remark").val(),
// EXP: $("#EXP").val()Y
int senstockin = Convert.ToInt32(stockInDtl.Remark); //本次入庫數量
stockInDtl.StockInQty = stockInDtl.StockInQty + senstockin; //原本入庫數量+本次入庫數量
stockInDtl.Remark = "";
if (ModelState.IsValid)
{
db.Entry(stockInDtl).State = EntityState.Modified;
db.SaveChanges();
InventoryDtlEdit(oid, senstockin);
return(Json(new { status = status, message = message, id = db.StockInDtl.Max(x => x.StockInDtlOID) }, JsonRequestBehavior.AllowGet));
}
else
{
message = "入庫失敗!!";
status = false;
return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet));
}
}
