public FuncResult Update(string recordid, PostWorkerModel model, string userid)
{
FuncResult fr = new FuncResult()
{
IsSuccess = true, Message = "操作成功"
};
try
{
if (string.IsNullOrWhiteSpace(recordid))
{
fr.IsSuccess = false;
fr.Message = "参数接收异常!";
return(fr);
}
ApdFctWorker worker = context.ApdFctWorker.FirstOrDefault(f => f.RecordId.Equals(recordid));
worker.WorkerMonth = model.WorkerMonth;
worker.Remark = model.Remark;
worker.LastUpdateDate = DateTime.Now;
worker.LastUpdatedBy = Convert.ToDecimal(userid);
context.ApdFctWorker.Update(worker);
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);
ApdFctWorker entity = context.ApdFctWorker.FirstOrDefault(f => f.RecordId.Equals(_key));
if (entity == null)
{
fr.IsSuccess = false;
fr.Message = "异常参数，未找到数据!";
}
//删除
context.ApdFctWorker.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;
}
}
