public async Task <IHttpActionResult> AddChemistry(Z_ChemistryDto z_ChemistryDto)
{
try
{
var userId = ((UserIdentity)User.Identity).UserId;
Z_Chemistry z_Chemistry = new Z_Chemistry
{
Id = IdentityManager.NewId(),
Name = z_ChemistryDto.Name,
Encoding = z_ChemistryDto.Encoding,
EntryPersonId = z_ChemistryDto.EntryPersonId,
Desc = z_ChemistryDto.Desc,
Z_ChemistryTypeid = z_ChemistryDto.Z_ChemistryTypeid,
EnglishName = z_ChemistryDto.EnglishName,
Abbreviation = z_ChemistryDto.Abbreviation,
BeCommonlyCalled1 = z_ChemistryDto.BeCommonlyCalled1,
BeCommonlyCalled2 = z_ChemistryDto.BeCommonlyCalled2,
CASNumber = z_ChemistryDto.CASNumber,
MolecularWeight = z_ChemistryDto.MolecularWeight,
MolecularFormula = z_ChemistryDto.MolecularFormula,
StructuralFormula = z_ChemistryDto.StructuralFormula,
Density = z_ChemistryDto.Density,
CompanyId = z_ChemistryDto.Companyid,
Statement = z_ChemistryDto.Statement,
Caution = z_ChemistryDto.Caution,
Number = z_ChemistryDto.Number,
AppearanceState = z_ChemistryDto.AppearanceState,
WarehousingTypeId = z_ChemistryDto.WarehousingTypeId,
};
db.Z_Chemistry.Add(z_Chemistry);
var result = await Task.Run(() => db.Entrepots.AsNoTracking().FirstOrDefaultAsync(p => p.Id > 0));
ChemistryRoom chemistryRoom = new ChemistryRoom
{
Id = IdentityManager.NewId(),
ChemistryId = z_Chemistry.Id,
RawNumber = 0,
User_id = userId,
EntrepotId = result.Id
};
db.ChemistryRooms.Add(chemistryRoom);
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> RemoveChemistry(Z_ChemistryDto z_ChemistryDto)
{
try
{
if (z_ChemistryDto.del_Id != null)
{
foreach (var item in z_ChemistryDto.del_Id)
{
var result = new Z_Chemistry {
Id = item
};
// var result = Task.Run(() => (db.Z_Office.AsNoTracking().FirstOrDefault(m => m.Id == item)));
db.Entry(result).State = System.Data.Entity.EntityState.Unchanged;
result.del_or = 1;
var resul = new ChemistryRoom {
ChemistryId = item
};
var res = await db.ChemistryRooms.SingleOrDefaultAsync(s => s.ChemistryId == 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> EditChemistrye(Z_ChemistryDto z_ChemistryDto)
{
try
{
if (ModelState.IsValid)
{
var type = new Models.Db.Aggregate.FinancialManagement.WarehouseManagements.Z_Chemistry()
{
Id = z_ChemistryDto.Id
};
db.Entry(type).State = System.Data.Entity.EntityState.Unchanged;
// Z_RawDto z_RawDto1 = new Z_RawDto();
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.Name))
{
type.Name = z_ChemistryDto.Name;
}
if (z_ChemistryDto.Companyid != null)
{
type.CompanyId = z_ChemistryDto.Companyid;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.Encoding))
{
type.Encoding = z_ChemistryDto.Encoding;
}
if (z_ChemistryDto.Number != null)
{
type.Number = z_ChemistryDto.Number;
}
if (z_ChemistryDto.EntryPersonId != null)
{
type.EntryPersonId = z_ChemistryDto.EntryPersonId;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.Desc))
{
type.Desc = z_ChemistryDto.Desc;
}
if (z_ChemistryDto.Z_ChemistryTypeid != null)
{
type.Z_ChemistryTypeid = z_ChemistryDto.Z_ChemistryTypeid;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.EnglishName))
{
type.EnglishName = z_ChemistryDto.EnglishName;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.Abbreviation))
{
type.Abbreviation = z_ChemistryDto.Abbreviation;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.BeCommonlyCalled1))
{
type.BeCommonlyCalled1 = z_ChemistryDto.BeCommonlyCalled1;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.BeCommonlyCalled2))
{
type.BeCommonlyCalled2 = z_ChemistryDto.BeCommonlyCalled2;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.CASNumber))
{
type.CASNumber = z_ChemistryDto.CASNumber;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.MolecularWeight))
{
type.MolecularWeight = z_ChemistryDto.MolecularWeight;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.MolecularFormula))
{
type.MolecularFormula = z_ChemistryDto.MolecularFormula;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.StructuralFormula))
{
type.StructuralFormula = z_ChemistryDto.StructuralFormula;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.Density))
{
type.Density = z_ChemistryDto.Density;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.Statement))
{
type.Statement = z_ChemistryDto.Statement;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.Caution))
{
type.Caution = z_ChemistryDto.Caution;
}
if (!string.IsNullOrWhiteSpace(z_ChemistryDto.AppearanceState))
{
type.AppearanceState = z_ChemistryDto.AppearanceState;
}
if (z_ChemistryDto.WarehousingTypeId != null)
{
type.WarehousingTypeId = z_ChemistryDto.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;
}
}
