private void UpdateDataBook(ETestState state) { if (context.Report.RecNo < 0) { return; } context.DB.Lock(); try { FbTransaction trans = context.DB.BeginTrans(); try { DataBookDataSet set = context.DB.DataBookSet; set.RecNo = context.Report.RecNo; set.Update(state, trans); context.DB.CommitTrans(); } catch (Exception e) { Resource.TLog.Log((int)ELogItem.Exception, e.ToString()); context.DB.RollbackTrans(); } } finally { context.DB.Unlock(); } }
private void SetDataBook() { ValueRow row; ConditionNote note = context.Report.Note; ConditionRated rated = context.Report.Rated; ConditionMethod method = context.Report.Method; DataBookDataSet set = context.DB.DataBookSet; context.Report.RecNo = context.DB.GetGenNo("GN_DATABOOK"); context.Report.RegTime = DateTime.Now; set.RecNo = context.Report.RecNo; set.UserNo = Resource.UserNo; set.BeginTime = context.Report.RegTime.ToString(Resource.csDateTimeFormat); set.EndTime = set.BeginTime; set.ElapsedTime = "00 00:00:00"; set.TestLine = context.Handle; set.IntegCount = method.IntegralCount; set.IntegTime = method.IntegralTime; set.ScanTime = method.ScanTime; set.Company = note.Company; set.TestName = note.Name; set.TestNo = note.No; set.Observer = note.Observer; set.Maker = note.Maker; set.Model1 = note.Model1; set.Serial1 = note.Serial1; set.Model2 = note.Model2; set.Serial2 = note.Serial2; set.Model3 = note.Model3; set.Serial3 = note.Serial3; set.ExpDevice = note.ExpDevice; set.Refrige = note.Refrigerant; set.RefCharge = note.RefCharge; row = context.Value.Calcurated["Total.Capacity"]; set.Capacity = $"{rated.Capacity.ToString(row.Format)} {row.Unit.ToDescription}"; row = context.Value.Calcurated["Total.Power"]; set.PowerInput = $"{rated.PowerInput.ToString(row.Format)} {row.Unit.ToDescription}"; row = context.Value.Calcurated["Total.EER_COP"]; set.EER_COP = $"{rated.EER_COP.ToString(row.Format)} {row.Unit.ToDescription}"; set.PowerSource = $"{rated.Voltage}V / {rated.Current}A / {rated.Frequency}Hz / {EnumHelper.GetNames<EWT330Wiring>()[(int)rated.Wiring]}"; set.TotalCapacity = "0.0 kcal/h"; set.TotalPower = "0.0 W"; set.TotalEER_COP = "0.0 kcal/hW"; set.Memo = note.Memo; set.State = ETestState.Testing; }
private void SetSheetTitle(Dictionary <string, Cell> sheet, DataBookDataSet bookSet, DataSheetDataSet sheetSet) { sheetTags.SetWorkSheetVisible(sheetSet.SheetName, sheetSet.Use); if (sheetSet.Use == true) { sheet["{300}"].Value = bookSet.Company; sheet["{302}"].Value = bookSet.TestName; sheet["{304}"].Value = bookSet.TestNo; sheet["{306}"].Value = bookSet.Observer; sheet["{308}"].Value = bookSet.Maker; sheet["{310}"].Value = bookSet.Model1; sheet["{312}"].Value = bookSet.Serial1; sheet["{314}"].Value = bookSet.Model2; sheet["{316}"].Value = bookSet.Serial2; string str = bookSet.Model3 + " / " + bookSet.Serial3; if (str.Trim() == "/") { sheet["{318}"].Value = ""; } else { sheet["{318}"].Value = str; } sheet["{320}"].Value = sheetSet.IDTemp; sheet["{322}"].Value = sheetSet.IDState; sheet["{301}"].Value = bookSet.Capacity; sheet["{303}"].Value = bookSet.PowerInput; sheet["{305}"].Value = bookSet.EER_COP; sheet["{307}"].Value = bookSet.PowerSource; sheet["{309}"].Value = bookSet.ExpDevice; sheet["{311}"].Value = bookSet.Refrige; sheet["{313}"].Value = bookSet.RefCharge; sheet["{315}"].Value = bookSet.BeginTime; sheet["{321}"].Value = sheetSet.ODTemp; sheet["{323}"].Value = sheetSet.ODState; sheet["{299}"].Value = ""; if (sheetSet.SheetName.EndsWith("TC") == false) { sheet["{365}"].Value = sheetSet.NozzleName; } } }
private void UpdateDataBook(DateTime time, TimeSpan elpased, string capacity, string power, string eer_cop, ETestState state) { if (context.Report.RecNo < 0) { return; } context.DB.Lock(); try { FbTransaction trans = context.DB.BeginTrans(); try { DataBookDataSet set = context.DB.DataBookSet; set.RecNo = context.Report.RecNo; set.EndTime = time.ToString(Resource.csDateTimeFormat); set.ElapsedTime = elpased.ToString(@"ddd\.hh\:mm\:ss"); set.TotalCapacity = capacity; set.TotalPower = power; set.TotalEER_COP = eer_cop; set.State = state; set.Update(trans); context.DB.CommitTrans(); } catch (Exception e) { Resource.TLog.Log((int)ELogItem.Exception, e.ToString()); context.DB.RollbackTrans(); } } finally { context.DB.Unlock(); } }
public void Open(Int64 recNo) { db.Lock(); try { this.recNo = recNo; bufferedSeries.ClearPoints(); double totalTime = 0; DataBookDataSet bookSet = db.DataBookSet; DataRawUnitDataSet rawUnitSet = db.DataRawUnitSet; DataRawDataSet rawSet = db.DataRawSet; UnitConvert unit = new UnitConvert(EUnitType.None, 0, 0); bookSet.Select(recNo); if (bookSet.IsEmpty() == false) { bookSet.Fetch(); scanTime = bookSet.ScanTime; bufferedSeries.BaseTime = scanTime * 1000; if (string.IsNullOrWhiteSpace(bookSet.TestName) == true) { fName = $"None_Line{bookSet.TestLine + 1}"; } else { fName = $"{bookSet.TestName}_Line{bookSet.TestLine + 1}"; } rawUnitSet.Select(bookSet.RecNo); try { for (int i = 0; i < rawUnitSet.GetRowCount(); i++) { rawUnitSet.Fetch(i); unit.Type = (EUnitType)rawUnitSet.UnitType; unit.From = rawUnitSet.UnitFrom; unit.To = rawUnitSet.UnitTo; SetMethodUnit((EUnitType)rawUnitSet.UnitType, rawUnitSet.UnitTo); SetPlotSeriesUnit(i, (EUnitType)rawUnitSet.UnitType, rawUnitSet.UnitTo); rawSet.Select(rawUnitSet.RecNo); for (int j = 0; j < rawSet.GetRowCount(); j++) { rawSet.Fetch(j); if (rawSet.DataRaw == null) { break; } if (i == 0) { totalTime += (rawSet.DataRaw.Length - 1) * bufferedSeries.BaseTime; } ConvertUnit(unit, rawSet.DataRaw); bufferedSeries[i].Points.AddRange(rawSet.DataRaw); } Win32.SwitchToThread(); } } finally { foreach (TabPage page in graphTab.TabPages) { CtrlViewGraphPanel ctrl = page.Controls[0] as CtrlViewGraphPanel; ctrl.Method = method; ctrl.RefreshYAxesUnit(); ctrl.SetMaxRangeAxisX(totalTime); } InvalidateGraphSeries(graphTab.SelectedTab); } } } finally { db.Unlock(); } }
private void Initialize() { RecNo = -1; dataSet = Resource.ViewDB.DataBookSet; }
public void Open(Int64 recNo) { sheetTags.Clear(); db.Lock(); try { Dictionary <string, Cell> sheet; DataBookDataSet bookSet = db.DataBookSet; DataSheetDataSet sheetSet = db.DataSheetSet; DataValueUnitDataSet valueUnitSet = db.DataValueUnitSet; DataValueDataSet valueSet = db.DataValueSet; bookSet.Select(recNo); if (bookSet.IsEmpty() == false) { bookSet.Fetch(); if (string.IsNullOrWhiteSpace(bookSet.TestName) == true) { fName = $"None_Line{bookSet.TestLine + 1}"; } else { fName = $"{bookSet.TestName}_Line{bookSet.TestLine + 1}"; } sheetSet.Select(bookSet.RecNo); for (int i = 0; i < sheetSet.GetRowCount(); i++) { sheetSet.Fetch(i); bool isNozzle = false; if ((sheetSet.IDState.EndsWith("Cooling") == true) || (sheetSet.IDState.EndsWith("Heating") == true)) { isNozzle = true; } sheet = sheetTags.Sheets[sheetSet.SheetName]; reportSheet.BeginUpdate(); try { SetSheetTitle(sheet, bookSet, sheetSet); if (sheetSet.Use == true) { valueUnitSet.Select(sheetSet.RecNo); if (i < 4) { SetSheetValues(sheet, calorieTags, bookSet.IntegCount, bookSet.IntegTime, valueUnitSet, valueSet, false, isNozzle); } else { SetSheetValues(sheet, thermoTags, bookSet.IntegCount, bookSet.IntegTime, valueUnitSet, valueSet, true, false); } } } finally { reportSheet.EndUpdate(); } Thread.Sleep(1); } } } finally { db.Unlock(); } }