/// <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); }