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