private void UpdateRankRow(FbTransaction trans, RankRowDataSet set, Int64 rankNo)
{
set.RankNo = rankNo;
set.Delete(trans);
InsertRankRow(trans, set, rankNo);
}
private void Initialize()
{
rankSet = new RankDataSet(AppRes.DB.Connect, null, null);
rankRowSet = new RankRowDataSet(AppRes.DB.Connect, null, null);
Text = code.ToDescription() + " Rank";
}
public RankRowList(Int64 rankNo)
{
indexes = new Dictionary <int, RankRowObject>();
names = new Dictionary <string, RankRowObject>();
rankRowSet = new RankRowDataSet(AppRes.DB.Connect, null, null);
Load(rankNo);
}
private void InsertRankRow(FbTransaction trans, RankRowDataSet set, Int64 rankNo)
{
foreach (TestRankRow row in rankRows)
{
set.RecNo = AppRes.DB.GetGenNo("GN_RANKROW");
set.RankNo = rankNo;
set.Index = row.Index;
set.Name = row.Name.Trim();
set.Lower1 = row.Lower1;
set.Upper1 = row.Upper1;
set.Lower2 = row.Lower2;
set.Upper2 = row.Upper2;
set.Insert(trans);
}
}
private void Initialize()
{
recipeSet = new RecipeDataSet(AppRes.DB.Connect, null, null);
rankSet = new RankDataSet(AppRes.DB.Connect, null, null);
rankRowSet = new RankRowDataSet(AppRes.DB.Connect, null, null);
rankRows = new List <TestRankRow>();
mode = EDataSetMode.View;
bookmark = new GridBookmark(rankGridView);
NameValue <EReportItemCode>[] itemCodes = EnumHelper.GetNameValues <EReportItemCode>();
itemCodeCombo.DataSource = itemCodes;
itemCodeCombo.DisplayMember = "Name";
itemCodeCombo.ValueMember = "Value";
LoadRecipeComboItems();
}
private void Initialize(string formula)
{
string[] items;
Result = "";
conditionCombo.DataSource = EnumHelper.GetNameValues <EBinCondition>();
conditionCombo.DisplayMember = "Name";
conditionCombo.ValueMember = "Value";
workSet = new ReportWorkDataSet(AppRes.DB.Connect, null, null);
rankRowSet = new RankRowDataSet(AppRes.DB.Connect, null, null);
condition = EBinCondition.Equal;
if (string.IsNullOrWhiteSpace(formula) == false)
{
if (formula.Contains(" = ") == true)
{
condition = EBinCondition.Equal;
items = formula.Split(new string[] { " = " }, StringSplitOptions.RemoveEmptyEntries);
}
else
{
condition = EBinCondition.NotEqual;
items = formula.Split(new string[] { " <> " }, StringSplitOptions.RemoveEmptyEntries);
}
if (items.Length == 2)
{
work = items[0];
rank = items[1];
}
}
conditionCombo.SelectedValue = condition;
workSet.Select(recipeNo);
workGrid.DataSource = workSet.DataSet.Tables[0];
workGridView.Appearance.EvenRow.BackColor = Color.FromArgb(244, 244, 236);
workGridView.OptionsView.EnableAppearanceEvenRow = true;
workItemCodeColumn.DisplayFormat.FormatType = FormatType.Custom;
workItemCodeColumn.DisplayFormat.Format = new ReportItemCodeFormat();
rankGridView.Appearance.EvenRow.BackColor = Color.FromArgb(244, 244, 236);
rankGridView.OptionsView.EnableAppearanceEvenRow = true;
if (string.IsNullOrWhiteSpace(work) == false)
{
for (int i = 0; i < workGridView.RowCount; i++)
{
string name = (string)workGridView.GetRowCellValue(i, "ITEMNAME");
if (work == name)
{
workGridView.FocusedRowHandle = i;
break;
}
}
}
if (string.IsNullOrWhiteSpace(rank) == false)
{
string[] ranks = rank.Split(',');
if (ranks.Length > 0)
{
for (int i = 0; i < rankGridView.RowCount; i++)
{
string name = (string)rankGridView.GetRowCellValue(i, "ROWNAME");
for (int j = 0; j < ranks.Length; j++)
{
if (ranks[j] == name)
{
rankGridView.SelectRow(i);
break;
}
}
}
if (rankGridView.SelectedRowsCount > 0)
{
rankGridView.FocusedRowHandle = rankGridView.GetSelectedRows()[0];
}
}
}
}
