/// <summary>
/// 拧紧数据上传
/// </summary>
private async void UpLoadTightenData()
{
while (true)
{
try
{
List <TightenModel> lstData = await RFIDDBHelper.LocalSQLHandler.TighteningService.GetNoUploadDataAsync(10);
if (lstData.Count > 0)
{
foreach (var data in lstData)
{
TighteningResultModel model = TightenMapper.MapTightenData(data);
if (RFIDDBHelper.MSSQLHandler.TightenService.Insert(model))
{
data.IsUpload = 1;
await RFIDDBHelper.LocalSQLHandler.TighteningService.UpdateAsync(data);
}
}
}
List <LTopEngineResultModel> lstStationData = await RFIDDBHelper.LocalSQLHandler.LTopEngineResult.GetNoUploadDataAsync(10);
if (lstStationData.Count > 0)
{
foreach (var item in lstStationData)
{
if (currentEngine != null && item.EngineCode == currentEngine.EngineCode)
{
continue;
}
TopEngineResultModel model = new TopEngineResultModel()
{
EngineCode = item.EngineCode,
Result = item.Result,
StationId = item.StationId,
CreateTime = item.CreateTime,
UpdateTime = item.UpdateTime
};
if (RFIDDBHelper.MSSQLHandler.TopEngineResult.Insert(model) > 0)
{
item.IsUpload = 1;
await RFIDDBHelper.LocalSQLHandler.LTopEngineResult.UpdateAsync(item);
}
}
}
}
catch (Exception exx)
{
Log.Error("上传拧紧数据时出现异常", exx);
}
finally
{
await Task.Delay(1000 * 30);
}
}
}
/// <summary>
/// 保存拧紧数据到本地
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
private void SaveTightenToLocal(TightenData data)
{
if (data == null)
{
return;
}
try
{
var model = TightenMapper.LocalMap(data);
model.StationName = _screenConfig.Station.StationID;
model.IsUpload = 0;
RFIDDBHelper.LocalSQLHandler.TighteningService.Insert(model);
}
catch (Exception ex)
{
Log.Error("拧紧数据存储到本地数据库异常", ex);
}
}
public void TestTighteningInsert()
{
LocalSQLService LocalSQLHandler = new LocalSQLService();
string code = "L15B84104476";
var data = new TightenData();
data.EngineCode = code;
data.Torque = 195.5;
data.Angle = 360;
data.BoltNo = 1;
data.Result = 1;
//data.TightenTime = DateTime.Now;
var model = TightenMapper.LocalMap(data);
model.StationName = "td";
int result = LocalSQLHandler.TighteningService.Insert(model);
Assert.IsTrue(result > 0);
}
