public async Task <IHttpActionResult> AddOffice(Z_OfficeDto z_OfficeDto) { try { var userId = ((UserIdentity)User.Identity).UserId; Z_Office z_Office = new Z_Office { Id = IdentityManager.NewId(), Name = z_OfficeDto.Name, Encoding = z_OfficeDto.Encoding, EntryPersonId = z_OfficeDto.EntryPersonId, Desc = z_OfficeDto.Desc, CompanyId = z_OfficeDto.Companyid, Z_OfficeTypeid = z_OfficeDto.Z_OfficeTypeid, EnglishName = z_OfficeDto.EnglishName, Abbreviation = z_OfficeDto.Abbreviation, BeCommonlyCalled1 = z_OfficeDto.BeCommonlyCalled1, BeCommonlyCalled2 = z_OfficeDto.BeCommonlyCalled2, CASNumber = z_OfficeDto.CASNumber, MolecularWeight = z_OfficeDto.MolecularWeight, MolecularFormula = z_OfficeDto.MolecularFormula, StructuralFormula = z_OfficeDto.StructuralFormula, Density = z_OfficeDto.Density, Statement = z_OfficeDto.Statement, Number = z_OfficeDto.Number, Caution = z_OfficeDto.Caution, AppearanceState = z_OfficeDto.AppearanceState, WarehousingTypeId = z_OfficeDto.WarehousingTypeId, }; var result = await Task.Run(() => db.Entrepots.AsNoTracking().FirstOrDefaultAsync(p => p.Id > 0)); OfficeRoom officeRoom = new OfficeRoom { Id = IdentityManager.NewId(), OfficeId = z_Office.Id, EntrepotId = result.Id, User_id = userId, RawNumber = 0, }; db.Offices.Add(officeRoom); db.Z_Office.Add(z_Office); 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> RemoveOffice(Z_OfficeDto z_OfficeDto) { try { if (z_OfficeDto.del_Id != null) { foreach (var item in z_OfficeDto.del_Id) { var result = new Z_Office { Id = item }; db.Entry(result).State = System.Data.Entity.EntityState.Unchanged; result.del_or = 1; // var resul = new OfficeRoom { OfficeId = item }; var res = await db.Offices.SingleOrDefaultAsync(s => s.OfficeId == item); if (res != null) { res.RawNumber = 10; res.RawOutNumber = 0; res.Warning_RawNumber = 0; } } 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; } }