private void Fetch()
{
recipeSet.Fetch();
RecNo = recipeSet.RecNo;
Code = recipeSet.Name;
Memo = recipeSet.Memo;
ST1_X = recipeSet.ST1_X;
ST1_Y = recipeSet.ST1_Y;
ST1_QR = recipeSet.ST1_QR;
ST2_X = recipeSet.ST2_X;
ST2_Y = recipeSet.ST2_Y;
ST2_QR = recipeSet.ST2_QR;
Work = new WorkObject(RecNo);
Pattern = new PatternList(RecNo);
Rank = new RankList(RecNo);
Bin = new BinList(RecNo);
List <BinObject> bins = Bin.ToList();
foreach (BinObject bin in bins)
{
foreach (BinFormulaObject formula in bin.Formulas)
{
if (string.IsNullOrWhiteSpace(formula.Token.ItemName) == false)
{
if (string.IsNullOrWhiteSpace(Work.Reports[formula.Token.ItemName].ItemRef) == false)
{
int refNo = (int)AppHelper.ExtractRecNo(Work.Reports[formula.Token.ItemName].ItemRef);
formula.Type = Work.Tests[refNo].ItemType;
}
}
}
}
}
private void Initialize()
{
workObject = null;
Dock = DockStyle.Fill;
workBook.Document.LoadDocument(AppRes.Properties.FormWork);
resultBook.Document.LoadDocument(AppRes.Properties.FormResult);
}
public void SetWorkObjects(WorkObject work)
{
workObject = work;
TestWorkList tests = workObject.Tests;
ReportWorkList reports = workObject.Reports;
Worksheet sheet = workBook.Document.Worksheets[0];
workBook.BeginUpdate();
try
{
sheet.ClearContents(sheet["B1:ZZ17"]);
for (int i = 0; i < tests.Count; i++)
{
sheet.Cells[0, i + 1].Value = tests[i + 1].Index;
sheet.Cells[1, i + 1].Value = tests[i + 1].ItemType.ToString();
sheet.Cells[2, i + 1].Value = tests[i + 1].ItemCode.ToString();
sheet.Cells[3, i + 1].Value = tests[i + 1].ItemName;
sheet.Cells[4, i + 1].Value = tests[i + 1].ItemRef;
sheet.Cells[5, i + 1].Value = tests[i + 1].TestPattern;
sheet.Cells[6, i + 1].Value = tests[i + 1].BiasCH;
sheet.Cells[7, i + 1].Value = tests[i + 1].BiasRange;
sheet.Cells[8, i + 1].Value = tests[i + 1].BiasValue;
sheet.Cells[9, i + 1].Value = tests[i + 1].ApplyTime;
}
for (int i = 0; i < reports.Count; i++)
{
sheet.Cells[12, i + 1].Value = reports[i + 1].Index;
sheet.Cells[13, i + 1].Value = reports[i + 1].ItemCode.ToString();
sheet.Cells[14, i + 1].Value = reports[i + 1].ItemName;
sheet.Cells[15, i + 1].Value = reports[i + 1].ItemRef;
sheet.Cells[16, i + 1].Value = reports[i + 1].BiasCH;
}
int maxCount = (tests.Count > reports.Count) ? tests.Count + 1 : reports.Count + 1;
//if (maxCount < 12)
//{
// maxCount = 12;
// workBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Hidden;
//}
//else
//{
// workBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Visible;
//}
workBook.WorksheetDisplayArea.SetSize(0, maxCount, 17);
}
finally
{
workBook.EndUpdate();
}
sheet = resultBook.Document.Worksheets[0];
resultBook.BeginUpdate();
try
{
sheet.ClearContents(sheet["A1:ZZ1000"]);
sheet.Cells["A1"].Value = "DateTime";
sheet.Cells["B1"].Value = "Elapsed Time";
sheet.Cells["C1"].Value = "Bin";
for (int i = 0; i < reports.Count; i++)
{
sheet.Cells[0, i + 3].Value = reports[i + 1].ItemName;
}
int maxCount = reports.Count + 3;
if (maxCount < 12)
{
maxCount = 12;
resultBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Hidden;
}
else
{
resultBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Visible;
}
resultBook.WorksheetDisplayArea.SetSize(0, maxCount, 500);
}
finally
{
resultBook.EndUpdate();
}
}
