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; } }
public async Task <IHttpActionResult> EditOffice(Z_OfficeDto z_OfficeDto) { try { if (ModelState.IsValid) { var type = new Models.Db.Aggregate.FinancialManagement.WarehouseManagements.Z_Office() { Id = z_OfficeDto.Id }; db.Entry(type).State = System.Data.Entity.EntityState.Unchanged; // Z_RawDto z_RawDto1 = new Z_RawDto(); if (!string.IsNullOrWhiteSpace(z_OfficeDto.Name)) { type.Name = z_OfficeDto.Name; } if (z_OfficeDto.Companyid != null) { type.CompanyId = z_OfficeDto.Companyid; } if (z_OfficeDto.Number != null) { type.Number = z_OfficeDto.Number; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.Encoding)) { type.Encoding = z_OfficeDto.Encoding; } if (z_OfficeDto.EntryPersonId != null) { type.EntryPersonId = z_OfficeDto.EntryPersonId; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.Desc)) { type.Desc = z_OfficeDto.Desc; } if (z_OfficeDto.Z_OfficeTypeid != null) { type.Z_OfficeTypeid = z_OfficeDto.Z_OfficeTypeid; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.EnglishName)) { type.EnglishName = z_OfficeDto.EnglishName; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.Abbreviation)) { type.Abbreviation = z_OfficeDto.Abbreviation; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.BeCommonlyCalled1)) { type.BeCommonlyCalled1 = z_OfficeDto.BeCommonlyCalled1; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.BeCommonlyCalled2)) { type.BeCommonlyCalled2 = z_OfficeDto.BeCommonlyCalled2; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.CASNumber)) { type.CASNumber = z_OfficeDto.CASNumber; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.MolecularWeight)) { type.MolecularWeight = z_OfficeDto.MolecularWeight; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.MolecularFormula)) { type.MolecularFormula = z_OfficeDto.MolecularFormula; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.StructuralFormula)) { type.StructuralFormula = z_OfficeDto.StructuralFormula; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.Density)) { type.Density = z_OfficeDto.Density; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.Statement)) { type.Statement = z_OfficeDto.Statement; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.Caution)) { type.Caution = z_OfficeDto.Caution; } if (!string.IsNullOrWhiteSpace(z_OfficeDto.AppearanceState)) { type.AppearanceState = z_OfficeDto.AppearanceState; } if (z_OfficeDto.WarehousingTypeId != null) { type.WarehousingTypeId = z_OfficeDto.WarehousingTypeId; } if (await db.SaveChangesAsync() > 0) { return(Json(new { code = 200, msg = "修改成功" })); } else { return(Json(new { code = 200, msg = "修改失败" })); } } else { return(Json(new { code = 201, msg = "数据格式错误" })); } } catch (Exception) { throw; } }