public async Task <IHttpActionResult> SetSaleMonad(LeaderShip_InputDto leaderShip_Input) { var userId = ((UserIdentity)User.Identity).UserId; var result = await Task.Run(() => db.Product_Sales.SingleOrDefaultAsync(p => p.Id == leaderShip_Input.Sale_Id)); result.Is_Or = 3; db.Entry(result).State = System.Data.Entity.EntityState.Modified; db.Entry(result).Property("Is_Or").IsModified = true; //添加领料 long Enportid;//仓库id if (leaderShip_Input.enportid == null || leaderShip_Input.enportid == 0) { var res = await Task.Run(() => db.FnishedProductRooms .FirstOrDefaultAsync(p => p.FnishedProductId == result.FishProductId && p.RawNumber >= result.QuasiPurchaseNumber)); if (res == null) { return(Json(new { code = 200, msg = "仓库数量不足,请安排产成品入库" })); } Enportid = (long)res.EntrepotId; res.RawNumber = res.RawNumber - (double)result.QuasiPurchaseNumber; db.Entry(result).State = System.Data.Entity.EntityState.Modified; db.Entry(result).Property("RawNumber").IsModified = true; } else { Enportid = leaderShip_Input.enportid; var fnishedProductRoom = await db.FnishedProductRooms .FirstOrDefaultAsync(p => p.FnishedProductId == result.FishProductId && p.EntrepotId == Enportid); // OfficeRoom officeRoom = new OfficeRoom { OfficeId = (long)resuls.OfficeId, EntrepotId = Enportid }; db.Entry(fnishedProductRoom).State = System.Data.Entity.EntityState.Unchanged; fnishedProductRoom.RawNumber = fnishedProductRoom.RawNumber - (double)result.QuasiPurchaseNumber; } //签核表 LeaderShip leaderShip = new LeaderShip { Id = IdentityManager.NewId(), Sale_Id = leaderShip_Input.Sale_Id, User_DId = userId, Des = leaderShip_Input.Des }; db.LeaderShips.Add(leaderShip); //领取详情记录表 FnishedProduct_UserDetils fnishedProduct_UserDetils = new FnishedProduct_UserDetils { Id = IdentityManager.NewId(), FnishedProductId = result.z_FnishedProduct.Id, User_id = userId, is_or = 1,//出库状态 entrepotid = Enportid, FnishedProductNumber = result.QuasiPurchaseNumber, GetTime = DateTime.Now, }; db.FnishedProduct_UserDetils.Add(fnishedProduct_UserDetils); if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "出库成功" })); } else { return(Json(new { code = 400, msg = "出库失败" })); } }
public async Task <IHttpActionResult> AddFinshedProductMonad(FinshProduct_UserIn finshProduct_User) { try { // FinishProductId if (finshProduct_User.FinishProductId != null) { var result = await db.FnishedProductMonad.SingleOrDefaultAsync(p => p.Id == finshProduct_User.FinishProductId && p.IsDelete == false); //修改采购单 result.is_or = 2;//添加入库 db.Entry(result).State = System.Data.Entity.EntityState.Modified; db.Entry(result).Property("is_or").IsModified = true; var results = await Task.Run(() => db.FnishedProductRooms .FirstOrDefaultAsync(p => p.FnishedProductId == result.FnishedProductId && p.del_or == false) ); if (finshProduct_User.enportid != 0) { results = await Task.Run(() => db.FnishedProductRooms.FirstOrDefaultAsync(p => p.EntrepotId == finshProduct_User.enportid)); } if ((double)result.ApplyNumber != null) { results.RawNumber = results.RawNumber + (double)result.ApplyNumber; db.Entry(results).State = System.Data.Entity.EntityState.Modified; db.Entry(results).Property("RawNumber").IsModified = true; } //if (results == null) //{ FnishedProduct_UserDetils fnishedProduct_User = new FnishedProduct_UserDetils { Id = IdentityManager.NewId(), FnishedProductId = (long)result.Z_FnishedProduct.Id, FnishedProductNumbers = (double)result.ApplyNumber, User_id = (long)result.Applicant.Id, entrepotid = results.EntrepotId }; db.FnishedProduct_UserDetils.Add(fnishedProduct_User); //} //if (results != null) //{ // } if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "入库成功" })); } return(Json(new { code = 201, msg = "入库失败" })); } return(Json(new { code = 200, msg = "入库失败" })); } catch (Exception) { throw; } }