Beispiel #1
0
        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];
                    }
                }
            }
        }