public async Task <IHttpActionResult> AddFnishedProductRoom(FnishedProductRoomIntDto fnishedProductRoomInt) { try { FnishedProductRoom fnishedProductRoom = new FnishedProductRoom { Id = IdentityManager.NewId(), FnishedProductId = fnishedProductRoomInt.FnishedProductId, User_id = fnishedProductRoomInt.User_id, EntrepotId = fnishedProductRoomInt.EntrepotId, RawNumber = fnishedProductRoomInt.RawNumber == null?0: fnishedProductRoomInt.RawNumber, RawOutNumber = fnishedProductRoomInt.RawOutNumber == null ? 0 : fnishedProductRoomInt.RawNumber, Warning_RawNumber = fnishedProductRoomInt.Warning_RawNumber == null ? 0 : fnishedProductRoomInt.RawNumber, RoomDes = fnishedProductRoomInt.RoomDes, }; db.FnishedProductRooms.Add(fnishedProductRoom); if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "添加成功" })); } return(Json(new { code = 201, msg = "添加失败" })); } catch (Exception) { throw; } }
public async Task <IHttpActionResult> RemoveFnishedProductRoom(FnishedProductRoomIntDto fnishedProductRoomInt) { try { if (fnishedProductRoomInt.del_Id != null) { foreach (var item in fnishedProductRoomInt.del_Id) { var result = new FnishedProductRoom { Id = item }; // var result = Task.Run(() => (db.Z_Office.AsNoTracking().FirstOrDefault(m => m.Id == item))); db.Entry(result).State = System.Data.Entity.EntityState.Deleted; } if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "删除成功" })); } else { return(Json(new { code = 400, msg = "删除失败" })); } } else { return(Json(new { code = 201, msg = "请勿传递空数据" })); } } catch (Exception) { throw; } }
public async Task <IHttpActionResult> AddFnishedProduct(Z_FnishedProductDto z_FnishedProductDto) { try { var userId = ((UserIdentity)User.Identity).UserId; Z_FnishedProduct z_FnishedProduct = new Z_FnishedProduct { Id = IdentityManager.NewId(), Name = z_FnishedProductDto.Name, Encoding = z_FnishedProductDto.Encoding, EntryPersonId = z_FnishedProductDto.EntryPersonId, CompanyId = z_FnishedProductDto.Companyid, Desc = z_FnishedProductDto.Desc, Z_FinshedProductTypeid = z_FnishedProductDto.Z_FinshedProductTypeid, Finshed_Sign = z_FnishedProductDto.Finshed_Sign, EnglishName = z_FnishedProductDto.EnglishName, Abbreviation = z_FnishedProductDto.Abbreviation, BeCommonlyCalled1 = z_FnishedProductDto.BeCommonlyCalled1, BeCommonlyCalled2 = z_FnishedProductDto.BeCommonlyCalled2, CASNumber = z_FnishedProductDto.CASNumber, MolecularWeight = z_FnishedProductDto.MolecularWeight, MolecularFormula = z_FnishedProductDto.MolecularFormula, StructuralFormula = z_FnishedProductDto.StructuralFormula, Density = z_FnishedProductDto.Density, Statement = z_FnishedProductDto.Statement, Number = z_FnishedProductDto.Number, Caution = z_FnishedProductDto.Caution, AppearanceState = z_FnishedProductDto.AppearanceState, WarehousingTypeId = z_FnishedProductDto.WarehousingTypeId, }; var result = await Task.Run(() => db.Entrepots.AsNoTracking().FirstOrDefaultAsync(p => p.Id > 0)); FnishedProductRoom fnishedProductRoom = new FnishedProductRoom { Id = IdentityManager.NewId(), FnishedProductId = z_FnishedProduct.Id, User_id = userId, RawNumber = 0, EntrepotId = result.Id }; db.FnishedProductRooms.Add(fnishedProductRoom); db.Z_FnishedProduct.Add(z_FnishedProduct); if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "添加成功" })); } else { return(Json(new { code = 400, msg = "添加失败" })); } } catch (Exception ex) { throw; } }
public async Task <IHttpActionResult> EditFnishedProductRoom(FnishedProductRoomIntDto fnishedProductRoomInt) { try { var FnishedProductRoom = new FnishedProductRoom { Id = fnishedProductRoomInt.Id }; db.Entry(FnishedProductRoom).State = System.Data.Entity.EntityState.Unchanged; if (fnishedProductRoomInt.FnishedProductId != null) { FnishedProductRoom.FnishedProductId = fnishedProductRoomInt.FnishedProductId; } if (fnishedProductRoomInt.User_id != null) { FnishedProductRoom.User_id = fnishedProductRoomInt.User_id; } if (fnishedProductRoomInt.EntrepotId != null) { FnishedProductRoom.EntrepotId = fnishedProductRoomInt.EntrepotId; } if (fnishedProductRoomInt.RawNumber != null) { FnishedProductRoom.RawNumber = fnishedProductRoomInt.RawNumber; } if (fnishedProductRoomInt.RawOutNumber != null) { FnishedProductRoom.RawOutNumber = fnishedProductRoomInt.RawOutNumber; } if (fnishedProductRoomInt.Warning_RawNumber != null) { FnishedProductRoom.Warning_RawNumber = fnishedProductRoomInt.Warning_RawNumber; } if (!string.IsNullOrWhiteSpace(fnishedProductRoomInt.RoomDes)) { FnishedProductRoom.RoomDes = fnishedProductRoomInt.RoomDes; } if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "修改成功" })); } return(Json(new { code = 201, msg = "修改失败" })); } catch (Exception) { throw; } }