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;
}
}
}
}
}
public bool Load(string code)
{
if ((RecNo > 0) && (code == Code))
{
return(false);
}
recipeSet.SelectName(code);
if (recipeSet.Empty == true)
{
RecNo = 0;
Code = "None";
Memo = "";
ST1_X = 0;
ST1_Y = 0;
ST1_QR = "";
ST2_X = 0;
ST2_Y = 0;
ST2_QR = "";
Work = null;
Pattern = null;
Rank = null;
Bin = null;
return(false);
}
Fetch();
return(true);
}
public RecipeObject()
{
RecNo = 0;
Code = "";
Memo = "";
Pattern = null;
Rank = null;
Work = null;
Bin = null;
recipeSet = new RecipeDataSet(AppRes.DB.Connect, null, null);
}
public void Load(string code)
{
if ((RecNo > 0) && (code == Code))
{
return;
}
recipeSet.SelectName(code);
if (recipeSet.Empty == true)
{
RecNo = 0;
Code = "None";
Memo = "";
ST1_X = 0;
ST1_Y = 0;
ST1_QR = "";
ST2_X = 0;
ST2_Y = 0;
ST2_QR = "";
Work = null;
Pattern = null;
Rank = null;
Bin = null;
}
else
{
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 Dictionary <EWorkType, WorkItem>();
Pattern = new PatternList(RecNo);
Rank = new RankList(RecNo);
Bin = new BinList(RecNo);
Work.Add(EWorkType.Full, new WorkItem(RecNo, EWorkType.Full));
Work.Add(EWorkType.Sampling, new WorkItem(RecNo, EWorkType.Sampling));
}
}
public void SetBinItems()
{
BinList bins = context.Recipe.Bin;
Worksheet sheet = binBook.Document.Worksheets[0];
binBook.BeginUpdate();
try
{
sheet.ClearContents(sheet["A1:J20"]);
for (int i = 0; i < 10; i++)
{
for (int j = 0; j < 10; j++)
{
if (i * 10 + j < bins.Count)
{
sheet.Cells[i * 2 + 0, j].FillColor = bins[i * 10 + j + 1].Mark;
int index = bins[i * 10 + j + 1].Index;
string name = bins[i * 10 + j + 1].Name;
if (string.IsNullOrWhiteSpace(name) == true)
{
sheet.Cells[i * 2 + 0, j].Value = $"{index}";
}
else
{
sheet.Cells[i * 2 + 0, j].Value = $"{name}({index})";
}
}
else
{
sheet.Cells[i * 2 + 0, j].FillColor = Color.FromKnownColor(KnownColor.Transparent);
sheet.Cells[i * 2 + 0, j].Value = "";
}
}
}
}
finally
{
binBook.EndUpdate();
}
}