public ReportWorkList(Int64 recipeNo) { reportSet = new ReportWorkDataSet(AppRes.DB.Connect, null, null); indexes = new Dictionary <int, ReportWorkObject>(); names = new Dictionary <string, ReportWorkObject>(); Load(recipeNo); }
public ReportWorkList(Int64 recipeNo, EWorkType type) { reportSet = new ReportWorkDataSet(AppRes.DB.Connect, null, null); indexes = new Dictionary <int, ReportWorkItem>(); names = new Dictionary <string, ReportWorkItem>(); Load(recipeNo, type); }
private void InsertReportWork(FbTransaction trans, ReportWorkDataSet set, Int64 recipeNo) { CtrlReportWorkGrid workGrid; workGrid = reportProcPanel.Controls[0] as CtrlReportWorkGrid; foreach (ReportWorkRow row in workGrid.Rows) { SetReportWorkDataSet(trans, set, row); } }
private void SetReportWorkGridRow(ReportWorkRow row, ReportWorkDataSet set) { row.Index = set.Index; row.ItemCode = set.ItemCode; row.ItemName = set.ItemName; row.ItemRef = set.ItemRef; row.BiasCH = set.BiasCH; row.Rank = set.Rank; row.Lower = set.Lower; row.Upper = set.Upper; }
private void SetReportWorkDataSet(FbTransaction trans, ReportWorkDataSet set, ReportWorkRow row) { set.RecNo = AppRes.DB.GetGenNo("GN_REPORTWORK"); set.RecipeNo = recipeNo; set.Index = row.Index; set.ItemCode = row.ItemCode; set.ItemName = row.ItemName; set.ItemRef = row.ItemRef; set.BiasCH = row.BiasCH; set.Rank = row.Rank; set.Lower = row.Lower; set.Upper = row.Upper; set.Insert(trans); }
private void Initialize() { CtrlTestWorkGrid ctrlTestWork; CtrlReportWorkGrid ctrlReportWork; recipeNo = 0; mode = EDataSetMode.View; bookmark = new GridBookmark(recipeGridView); ctrlTestWork = new CtrlTestWorkGrid(); testProcPanel.Controls.Add(ctrlTestWork); ctrlReportWork = new CtrlReportWorkGrid(); ctrlReportWork.TestRows = ctrlTestWork.Rows; reportProcPanel.Controls.Add(ctrlReportWork); recipeSet = new RecipeDataSet(AppRes.DB.Connect, null, null); slaveSet = new SlavePatternDataSet(AppRes.DB.Connect, null, null); testWorkSet = new TestWorkDataSet(AppRes.DB.Connect, null, null); reportWorkSet = new ReportWorkDataSet(AppRes.DB.Connect, null, null); rankSet = new RankDataSet(AppRes.DB.Connect, null, null); smuSet = new SmuDataSet(AppRes.DB.Connect, null, null); }
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]; } } } }