public async Task <IHttpActionResult> AddRow(Z_RawDto z_RawDto)
{
try
{
string Moren = " N / A";
Z_Raw z_Raw = new Z_Raw
{
Id = IdentityManager.NewId(),
Name = z_RawDto.Name,
Encoding = z_RawDto.Encoding != null? z_RawDto.Encoding: Moren,
EntryPersonId = z_RawDto.EntryPersonId,
Desc = z_RawDto.Desc,
CompanyId = z_RawDto.Companyid,
Z_RowTypeid = z_RawDto.Z_RowTypeid,
EnglishName = z_RawDto.EnglishName != null? z_RawDto.EnglishName: Moren,
Abbreviation = z_RawDto.Abbreviation != null ? z_RawDto.Abbreviation : Moren,
BeCommonlyCalled1 = z_RawDto.BeCommonlyCalled1 != null ? z_RawDto.BeCommonlyCalled1 : Moren,
BeCommonlyCalled2 = z_RawDto.BeCommonlyCalled2 != null ? z_RawDto.BeCommonlyCalled2 : Moren,
CASNumber = z_RawDto.CASNumber != null ? z_RawDto.CASNumber : Moren,
MolecularWeight = z_RawDto.MolecularWeight != null ? z_RawDto.MolecularWeight : Moren,
MolecularFormula = z_RawDto.MolecularFormula,
StructuralFormula = z_RawDto.StructuralFormula,
Density = z_RawDto.Density,
Number = z_RawDto.Number,
Statement = z_RawDto.Statement != null ? z_RawDto.Statement : Moren,
Caution = z_RawDto.Caution != null ? z_RawDto.Caution : Moren,
AppearanceState = z_RawDto.AppearanceState != null ? z_RawDto.AppearanceState : Moren,
WarehousingTypeId = z_RawDto.WarehousingTypeId,
};
var result = await Task.Run(() => db.Entrepots.AsNoTracking().FirstOrDefaultAsync(p => p.Id > 0));
// var results = await Task.Run(() => db.RawRooms.AsNoTracking().Where(p => p.RawId == z_Raw.Id).ToListAsync());
//foreach (var item in result)
//{
// if (results==null)
// {
// this.EntrepotId = item.Id;
// break;
// }
//}
var userId = ((UserIdentity)User.Identity).UserId;
RawRoom rawRoom = new RawRoom
{
Id = IdentityManager.NewId(),
RawId = z_Raw.Id,
RawNumber = 0,
User_id = userId,
EntrepotId = result.Id
};
db.RawRooms.Add(rawRoom);
db.Z_Raw.Add(z_Raw);
if (await db.SaveChangesAsync() > 0)
{
return(Json(new { code = 200, msg = "添加成功" }));
}
else
{
return(Json(new { code = 400, msg = "添加失败" }));
}
}
catch (Exception)
{
throw;
}
}
public async Task <IHttpActionResult> RemoveRow(Z_RawDto z_RawDto)
{
try
{
if (z_RawDto.del_Id != null)
{
foreach (var item in z_RawDto.del_Id)
{
var result = new Z_Raw {
Id = item
};
db.Entry(result).State = System.Data.Entity.EntityState.Unchanged;
result.del_or = 1;
//var resul = new RawRoom { RawId = item };
//db.Entry(resul).State = System.Data.Entity.EntityState.Unchanged;
var res = await db.RawRooms.SingleOrDefaultAsync(s => s.RawId == 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 = "删除成功" }));
}
return(Json(new
{
code = 201,
msg = "删除失败;"
}));
////[Pursh_User]
////var Presud = new Purchase { RawId = item };
////db.Entry(Presud).State = System.Data.Entity.EntityState.Deleted;
////var PresudU = new Pursh_User { Purchase_Id = Presud.Id };
////db.Entry(PresudU).State = System.Data.Entity.EntityState.Deleted;
////优化的地方
//using (XiAnOuDeContext db = new XiAnOuDeContext()) {
// var reltp = await Task.Run(() => db.RawRooms.SingleOrDefaultAsync(p => p.RawId == item));
// db.RawRooms.Remove(reltp);
// await db.SaveChangesAsync();
// // var resud = new RawRoom { RawId = item };
// // db.Entry(resud).State = System.Data.Entity.EntityState.Deleted;
//}
//using (XiAnOuDeContext db = new XiAnOuDeContext())
//{
// var relt = await Task.Run(() => db.Z_Raw.SingleOrDefaultAsync(p => p.Id == item));
// db.Z_Raw.Remove(relt);
// db.Entry(result).State = System.Data.Entity.EntityState.Deleted;
}
else
{
return(Json(new { code = 201, msg = "请勿传递空数据" }));
}
}
catch (Exception)
{
throw;
}
}
