public async Task <FuncResult> DeleteData(string key)
{
FuncResult fr = new FuncResult()
{
IsSuccess = true, Message = "Ok"
};
try
{
if (string.IsNullOrWhiteSpace(key))
{
fr.IsSuccess = false;
fr.Message = "未接收到参数信息!";
}
var _key = Convert.ToDecimal(key);
ApdFctContaminants entity = context.ApdFctContaminants.FirstOrDefault(f => f.RecordId.Equals(_key));
if (entity == null)
{
fr.IsSuccess = false;
fr.Message = "异常参数，未找到数据!";
}
//删除
context.ApdFctContaminants.Remove(entity);
using (IDbContextTransaction trans = context.Database.BeginTransaction())
{
try
{
await context.SaveChangesAsync();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
fr.IsSuccess = false;
fr.Message = $"{ex.InnerException},{ex.Message}";
throw new Exception("error", ex);
}
}
return(fr);
}
catch (Exception ex)
{
throw new Exception("error", ex);
}
}
public FuncResult Update(string recordid, PostPolluantModel model, string userid)
{
FuncResult fr = new FuncResult()
{
IsSuccess = true, Message = "操作成功"
};
try
{
if (string.IsNullOrWhiteSpace(recordid))
{
fr.IsSuccess = false;
fr.Message = "参数接收异常!";
return(fr);
}
ApdFctContaminants polluant = context.ApdFctContaminants.FirstOrDefault(f => f.RecordId.Equals(recordid));
polluant.IsInSystem = model.IsInSystem;
polluant.Oxygen = model.Oxygen;
polluant.AmmoniaNitrogen = model.AmmoniaNitrogen;
polluant.SulfurDioxide = model.SulfurDioxide;
polluant.NitrogenOxide = model.NitrogenOxide;
polluant.Coal = model.Coal;
polluant.FuelOil = model.FuelOil;
polluant.Hydrogen = model.Hydrogen;
polluant.Firewood = model.Firewood;
polluant.Remark = model.Remark;
polluant.LastUpdateDate = DateTime.Now;
polluant.LastUpdatedBy = Convert.ToDecimal(userid);
context.ApdFctContaminants.Update(polluant);
context.SaveChanges();
return(fr);
}
catch (Exception ex)
{
fr.IsSuccess = false;
fr.Message = $"{ex.InnerException},{ex.Message}";
throw new Exception("error", ex);
}
}
