private void SetDataSheet(Int64 dataBookNo, string key, ReportSheet sheet)
{
DataSheetDataSet set = context.DB.DataSheetSet;
sheet.RecNo = context.DB.GetGenNo("GN_DATASHEET");
set.RecNo = sheet.RecNo;
set.DataBookNo = dataBookNo;
set.SheetName = key;
set.Use = sheet.Use;
set.IDTemp = $"{sheet.IndoorDB:f2} / {sheet.IndoorWB:f2} ℃";
if (sheet.IndoorUse == EIndoorUse.NotUsed)
{
set.IDState = $"{sheet.IndoorUse.ToDescription()}";
}
else
{
set.IDState = $"{sheet.IndoorUse.ToDescription()}, {sheet.IndoorMode.ToDescription()}";
}
set.ODTemp = $"{sheet.OutdoorDB:f2} / {sheet.OutdoorWB:f2} ℃";
if (sheet.OutdoorDP == EEtcUse.Use)
{
set.ODState = $"{sheet.OutdoorUse}, DP Used";
}
else
{
set.ODState = $"{sheet.OutdoorUse}";
}
set.NozzleName = sheet.NozzleName;
set.NozzleState = sheet.NozzleState;
}
private void UpdateDataSheet()
{
context.DB.Lock();
try
{
context.Report.Lock();
FbTransaction trans = context.DB.BeginTrans();
try
{
DataSheetDataSet set = context.DB.DataSheetSet;
foreach (KeyValuePair <string, ReportSheet> sheet in context.Report.ValueSheets)
{
try
{
set.RecNo = sheet.Value.RecNo;
set.IDTemp = $"{sheet.Value.IndoorDB:f2} / {sheet.Value.IndoorWB:f2} ℃";
set.ODTemp = $"{sheet.Value.OutdoorDB:f2} / {sheet.Value.OutdoorWB:f2} ℃";
context.DB.DataSheetSet.UpdateTemp(trans);
}
catch (Exception e)
{
Resource.TLog.Log((int)ELogItem.Exception, e.ToString());
throw e;
}
}
context.DB.CommitTrans();
}
catch (Exception e)
{
Resource.TLog.Log((int)ELogItem.Exception, e.ToString());
context.DB.RollbackTrans();
}
finally
{
context.Report.Unlock();
}
}
finally
{
context.DB.Unlock();
}
}
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;
}
}
}
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();
}
}
