private void RefreshPattern() { if (recipeCombo.SelectedIndex < 0) { masterNo = 0; return; } DataRow row = ((DataTable)recipeCombo.DataSource).Rows[recipeCombo.SelectedIndex]; recipeSet.Fetch(row); recipeNo = recipeSet.RecNo; RefreshStringToSmus(); masterSet.Select(recipeNo); masterSet.Fetch(); masterNo = masterSet.RecNo; xLengthEdit.EditValue = masterSet.XLength; yHeightEdit.EditValue = masterSet.YHeight; stringCountEdit.EditValue = masterSet.StrCount; ledCountEdit.EditValue = masterSet.LedCount; ctrlPatternGrid.XLength = masterSet.XLength; ctrlPatternGrid.YHeight = masterSet.YHeight; ctrlPatternGrid.StringCount = masterSet.StrCount; ctrlPatternGrid.LedCount = masterSet.LedCount; bookmark.Get(); slaveSet.Select(masterNo); if (slaveSet.Empty == true) { patternGrid.DataSource = null; SetEditValueFromDataSet(); SetEditReadOnly(true); } else { patternGrid.DataSource = slaveSet.DataSet.Tables[0]; } bookmark.Goto(); patternGrid.Focus(); }
private void DeleteRecipe() { FbTransaction trans = AppRes.DB.BeginTrans(); try { Int64 recipeNo = recipeSet.RecNo; masterSet.Select(recipeNo, trans); for (int i = 0; i < masterSet.RowCount; i++) { masterSet.Fetch(i); slaveSet.MasterPatternNo = masterSet.RecNo; slaveSet.Select(masterSet.RecNo, trans); for (int j = 0; j < slaveSet.RowCount; j++) { slaveSet.Fetch(i); slaveLedSet.SlavePatternNo = slaveSet.RecNo; slaveLedSet.Delete(trans); } slaveSet.Delete(masterSet.RecNo, trans); masterLedSet.MasterPatternNo = masterSet.RecNo; masterLedSet.Delete(trans); } masterSet.RecipeNo = recipeNo; masterSet.Delete(trans); smuSet.RecipeNo = recipeNo; smuSet.Delete(trans); recipeSet.Delete(trans); AppRes.DB.CommitTrans(); } catch { AppRes.DB.RollbackTrans(); } }
private void Load(Int64 recipeNo) { masterSet.Select(recipeNo); masterSet.Fetch(0); MasterNo = masterSet.RecipeNo; keys = new Dictionary <Int64, PatternObject>(); names = new Dictionary <string, PatternObject>(); slaveSet.Select(MasterNo); for (int i = 0; i < slaveSet.RowCount; i++) { slaveSet.Fetch(i); PatternObject item = new PatternObject(slaveSet.RecNo); item.RecNo = slaveSet.RecNo; item.Name = slaveSet.Name; item.Memo = slaveSet.Memo; keys.Add(item.RecNo, item); names.Add(item.Name, item); } }