public async Task <int> InsertAsync(LTopEngineResultModel model)
{
try
{
if (FreeHanlder.SqliteHandler == null)
{
throw new NullReferenceException("未初始化SqliteHandler数据库访问程序;");
}
model.Id = (int)(await FreeHanlder.SqliteHandler.Insert <LTopEngineResultModel>()
.AppendData(model)
.ExecuteIdentityAsync());
return(model.Id);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 新增结果记录
/// </summary>
/// <param name="code"></param>
private async Task CreateResult(string code)
{
topEngineResultModel = new LTopEngineResultModel
{
EngineCode = code,
StationId = Station?.StationID,
Result = 0,
CreateTime = DateTime.Now,
};
await RFIDDBHelper.LocalSQLHandler.LTopEngineResult.InsertAsync(topEngineResultModel);
if (_screenConfig.Part.Available)
{
metasModel = new MaterialMetasModel
{
EngineCode = code,
StationCode = Station?.StationID
//ResultId = result.Id
};
}
}
public async Task <int> UpdateAsync(LTopEngineResultModel model)
{
if (model == null)
{
throw new ArgumentNullException(nameof(model));
}
try
{
if (FreeHanlder.SqliteHandler == null)
{
throw new NullReferenceException("未初始化SqliteHandler数据库访问程序;");
}
return(await FreeHanlder.SqliteHandler.Update <LTopEngineResultModel>()
.SetSource(model)
.ExecuteAffrowsAsync());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新结果数据
/// </summary>
/// <param name="code">发动机条码</param>
/// <param name="tdResult">拧紧结果</param>
private async void UpdateEngineResultToDB(string code, int tdResult)
{
try
{
if (topEngineResultModel != null && topEngineResultModel.Id > 0 && topEngineResultModel.EngineCode == code)
{
topEngineResultModel.Result = tdResult;
topEngineResultModel.UpdateTime = DateTime.Now;
await RFIDDBHelper.LocalSQLHandler.LTopEngineResult.UpdateAsync(topEngineResultModel);
}
else
{
topEngineResultModel = new LTopEngineResultModel
{
EngineCode = code,
StationId = Station?.StationID,
CreateTime = DateTime.Now,
Result = tdResult,
UpdateTime = DateTime.Now
};
await RFIDDBHelper.LocalSQLHandler.LTopEngineResult.InsertAsync(topEngineResultModel);
if (metasModel != null)
{
if (metasModel.Id > 0)
{
RFIDDBHelper.MSSQLHandler.MaterialMetas.Update(metasModel);
}
}
}
}
catch (Exception ex)
{
Log.Error("保存结果数据时异常", ex);
}
}
