示例#1
0
        private void Load(Int64 recipeNo)
        {
            reportSet.Select(recipeNo);
            Count = reportSet.RowCount;

            for (int i = 0; i < reportSet.RowCount; i++)
            {
                reportSet.Fetch(i);

                ReportWorkObject item = new ReportWorkObject();
                item.RecNo    = reportSet.RecNo;
                item.RecipeNo = reportSet.RecipeNo;
                item.Index    = reportSet.Index;
                item.ItemCode = reportSet.ItemCode;
                item.ItemName = reportSet.ItemName;
                item.ItemRef  = reportSet.ItemRef;
                item.BiasCH   = reportSet.BiasCH;
                item.Rank     = reportSet.Rank;
                item.Lower    = reportSet.Lower;
                item.Upper    = reportSet.Upper;

                indexes.Add(item.Index, item);
                names.Add(item.ItemName, item);
            }
        }
示例#2
0
        private void SetEditValueFromDataSet()
        {
            string smuString = GetSmuString();

            CtrlTestWorkGrid testGrid = testProcPanel.Controls[0] as CtrlTestWorkGrid;

            testGrid.RecipeNo  = recipeNo;
            testGrid.SmuString = smuString;
            testGrid.Rows.Clear();

            testWorkSet.Select(recipeNo);

            if (testWorkSet.Empty == true)
            {
                testGrid.AddRow();
            }
            else
            {
                for (int i = 0; i < testWorkSet.RowCount; i++)
                {
                    testWorkSet.Fetch(i);
                    testGrid.AddRow();
                    SetTestWorkGridRow(testGrid.Rows[i], testWorkSet);
                }
            }

            testGrid.RefreshGridData();

            CtrlReportWorkGrid reportGrid = reportProcPanel.Controls[0] as CtrlReportWorkGrid;

            reportGrid.RecipeNo  = recipeNo;
            reportGrid.SmuString = smuString;
            reportGrid.Rows.Clear();

            reportWorkSet.Select(recipeNo);

            if (reportWorkSet.Empty == true)
            {
                reportGrid.AddRow();
            }
            else
            {
                for (int i = 0; i < reportWorkSet.RowCount; i++)
                {
                    reportWorkSet.Fetch(i);
                    reportGrid.AddRow();
                    SetReportWorkGridRow(reportGrid.Rows[i], reportWorkSet);
                }
            }

            reportGrid.RefreshGridData();
        }
        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];
                    }
                }
            }
        }