public async Task <IHttpActionResult> RemoveMaterialCode(Z_MaterialCodeDto z_MaterialCodeDto)
{
try
{
if (z_MaterialCodeDto.del_Id != null)
{
foreach (var item in z_MaterialCodeDto.del_Id)
{
var result = new Z_MaterialCode {
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> AddMaterialCode(Z_MaterialCodeDto z_MaterialCodeDto)
{
try
{
if (ModelState.IsValid)
{
string Moren = " N / A";
Z_MaterialCode z_MaterialCode = new Z_MaterialCode
{
Id = IdentityManager.NewId(),
Name = z_MaterialCodeDto.Name,
Encoding = z_MaterialCodeDto.Encoding != null ? z_MaterialCodeDto.Encoding : Moren,
EntryPersonId = z_MaterialCodeDto.EntryPersonId,
Desc = z_MaterialCodeDto.Desc,
CompanyId = z_MaterialCodeDto.Companyid,
Z_RowTypeid = z_MaterialCodeDto.Z_RowTypeid,
EnglishName = z_MaterialCodeDto.EnglishName != null ? z_MaterialCodeDto.EnglishName : Moren,
Abbreviation = z_MaterialCodeDto.Abbreviation != null ? z_MaterialCodeDto.Abbreviation : Moren,
BeCommonlyCalled1 = z_MaterialCodeDto.BeCommonlyCalled1 != null ? z_MaterialCodeDto.BeCommonlyCalled1 : Moren,
BeCommonlyCalled2 = z_MaterialCodeDto.BeCommonlyCalled2 != null ? z_MaterialCodeDto.BeCommonlyCalled2 : Moren,
CASNumber = z_MaterialCodeDto.CASNumber != null ? z_MaterialCodeDto.CASNumber : Moren,
MolecularWeight = z_MaterialCodeDto.MolecularWeight != null ? z_MaterialCodeDto.MolecularWeight : Moren,
MolecularFormula = z_MaterialCodeDto.MolecularFormula,
StructuralFormula = z_MaterialCodeDto.StructuralFormula,
Density = z_MaterialCodeDto.Density,
Number = z_MaterialCodeDto.Number,
Statement = z_MaterialCodeDto.Statement != null ? z_MaterialCodeDto.Statement : Moren,
Caution = z_MaterialCodeDto.Caution != null ? z_MaterialCodeDto.Caution : Moren,
AppearanceState = z_MaterialCodeDto.AppearanceState != null ? z_MaterialCodeDto.AppearanceState : Moren,
WarehousingTypeId = z_MaterialCodeDto.WarehousingTypeId,
};
db.Z_MaterialCode.Add(z_MaterialCode);
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 ex)
{
throw;
}
}
public async Task <IHttpActionResult> EditMaterialCode(Z_MaterialCodeDto z_MaterialCodeDto)
{
try
{
if (ModelState.IsValid)
{
var type = new Models.Db.Aggregate.FinancialManagement.WarehouseManagements.Z_MaterialCode()
{
Id = z_MaterialCodeDto.Id
};
db.Entry(type).State = System.Data.Entity.EntityState.Unchanged;
// Z_RawDto z_RawDto1 = new Z_RawDto();
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.Name))
{
type.Name = z_MaterialCodeDto.Name;
}
if (z_MaterialCodeDto.Companyid != null)
{
type.CompanyId = z_MaterialCodeDto.Companyid;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.Encoding))
{
type.Encoding = z_MaterialCodeDto.Encoding;
}
if (z_MaterialCodeDto.Number != null)
{
type.Number = z_MaterialCodeDto.Number;
}
if (z_MaterialCodeDto.EntryPersonId != null)
{
type.EntryPersonId = z_MaterialCodeDto.EntryPersonId;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.Desc))
{
type.Desc = z_MaterialCodeDto.Desc;
}
if (z_MaterialCodeDto.Z_RowTypeid != null)
{
type.Z_RowTypeid = z_MaterialCodeDto.Z_RowTypeid;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.EnglishName))
{
type.EnglishName = z_MaterialCodeDto.EnglishName;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.Abbreviation))
{
type.Abbreviation = z_MaterialCodeDto.Abbreviation;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.BeCommonlyCalled1))
{
type.BeCommonlyCalled1 = z_MaterialCodeDto.BeCommonlyCalled1;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.BeCommonlyCalled2))
{
type.BeCommonlyCalled2 = z_MaterialCodeDto.BeCommonlyCalled2;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.CASNumber))
{
type.CASNumber = z_MaterialCodeDto.CASNumber;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.MolecularWeight))
{
type.MolecularWeight = z_MaterialCodeDto.MolecularWeight;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.MolecularFormula))
{
type.MolecularFormula = z_MaterialCodeDto.MolecularFormula;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.StructuralFormula))
{
type.StructuralFormula = z_MaterialCodeDto.StructuralFormula;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.Density))
{
type.Density = z_MaterialCodeDto.Density;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.Statement))
{
type.Statement = z_MaterialCodeDto.Statement;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.Caution))
{
type.Caution = z_MaterialCodeDto.Caution;
}
if (!string.IsNullOrWhiteSpace(z_MaterialCodeDto.AppearanceState))
{
type.AppearanceState = z_MaterialCodeDto.AppearanceState;
}
if (z_MaterialCodeDto.WarehousingTypeId != null)
{
type.WarehousingTypeId = z_MaterialCodeDto.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;
}
}
