public FuncResult Update(string recordid, PostElectricModel model, string userid)
{
FuncResult fr = new FuncResult()
{
IsSuccess = true, Message = "操作成功"
};
try
{
if (string.IsNullOrWhiteSpace(recordid))
{
fr.IsSuccess = false;
fr.Message = "参数接收异常!";
return(fr);
}
ApdFctElectric electric = context.ApdFctElectric.FirstOrDefault(f => f.RecordId.Equals(recordid));
electric.NetSupply = model.NetSupply;
electric.Spontaneous = model.Spontaneous;
electric.Remark = model.Remark;
electric.LastUpdateDate = DateTime.Now;
electric.LastUpdatedBy = Convert.ToDecimal(userid);
context.ApdFctElectric.Update(electric);
context.SaveChanges();
return(fr);
}
catch (Exception ex)
{
fr.IsSuccess = false;
fr.Message = $"{ex.InnerException},{ex.Message}";
throw new Exception("error", ex);
}
}
public async Task <FuncResult> Delete(string key)
{
try
{
FuncResult fr = new FuncResult()
{
IsSuccess = true, Message = "Ok"
};
try
{
if (string.IsNullOrWhiteSpace(key))
{
fr.IsSuccess = false;
fr.Message = "未接收到参数信息!";
}
var _key = Convert.ToDecimal(key);
ApdFctElectric entity = context.ApdFctElectric.FirstOrDefault(f => f.RecordId.Equals(_key));
if (entity == null)
{
fr.IsSuccess = false;
fr.Message = "异常参数，未找到数据!";
}
//删除
context.ApdFctElectric.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);
}
}
catch (Exception)
{
throw;
}
}
