public async Task <IHttpActionResult> RemoveRawRoom(RawInDto rawInDto)
{
try
{
if (rawInDto.del_Id != null)
{
foreach (var item in rawInDto.del_Id)
{
var result = new RawRoom {
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> AddRawRoom(RawInDto rawInDto)
{
try
{
RawRoom rawRoom = new RawRoom
{
Id = IdentityManager.NewId(),
RawId = rawInDto.RawId,
User_id = rawInDto.User_id,
EntrepotId = rawInDto.EntrepotId,
RawNumber = rawInDto.RawNumber,
RawOutNumber = rawInDto.RawOutNumber,
Warning_RawNumber = rawInDto.Warning_RawNumber,
RoomDes = rawInDto.RoomDes,
};
db.RawRooms.Add(rawRoom);
if (await db.SaveChangesAsync() > 0)
{
return(Json(new { code = 200, msg = "添加成功" }));
}
return(Json(new { code = 201, msg = "添加失败" }));
}
catch (Exception)
{
throw;
}
}
public async Task <IHttpActionResult> EditRawRoom(RawInDto rawInDto)
{
try
{
var RawRoom = new RawRoom {
Id = rawInDto.Id
};
db.Entry(RawRoom).State = System.Data.Entity.EntityState.Unchanged;
if (rawInDto.RawId != null)
{
RawRoom.RawId = rawInDto.RawId;
}
if (rawInDto.User_id != null)
{
RawRoom.User_id = rawInDto.User_id;
}
if (rawInDto.EntrepotId != null)
{
RawRoom.EntrepotId = rawInDto.EntrepotId;
}
if (rawInDto.RawNumber != null)
{
RawRoom.RawNumber = rawInDto.RawNumber;
}
if (rawInDto.RawOutNumber != null)
{
RawRoom.RawOutNumber = rawInDto.RawOutNumber;
}
if (rawInDto.Warning_RawNumber != null)
{
RawRoom.Warning_RawNumber = rawInDto.Warning_RawNumber;
}
if (!string.IsNullOrWhiteSpace(rawInDto.RoomDes))
{
RawRoom.RoomDes = rawInDto.RoomDes;
}
if (await db.SaveChangesAsync() > 0)
{
return(Json(new { code = 200, msg = "修改成功" }));
}
return(Json(new { code = 201, msg = "修改失败" }));
}
catch (Exception)
{
throw;
}
}
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;
}
}
