Beispiel #1
0
 public WorkObject(Int64 recipeNo)
 {
     Tests   = new TestWorkList(recipeNo);
     Reports = new ReportWorkList(recipeNo);
 }
        public void SetWorkObjects(WorkObject work)
        {
            workObject = work;
            TestWorkList   tests   = workObject.Tests;
            ReportWorkList reports = workObject.Reports;
            Worksheet      sheet   = workBook.Document.Worksheets[0];

            workBook.BeginUpdate();

            try
            {
                sheet.ClearContents(sheet["B1:ZZ17"]);

                for (int i = 0; i < tests.Count; i++)
                {
                    sheet.Cells[0, i + 1].Value = tests[i + 1].Index;
                    sheet.Cells[1, i + 1].Value = tests[i + 1].ItemType.ToString();
                    sheet.Cells[2, i + 1].Value = tests[i + 1].ItemCode.ToString();
                    sheet.Cells[3, i + 1].Value = tests[i + 1].ItemName;
                    sheet.Cells[4, i + 1].Value = tests[i + 1].ItemRef;
                    sheet.Cells[5, i + 1].Value = tests[i + 1].TestPattern;
                    sheet.Cells[6, i + 1].Value = tests[i + 1].BiasCH;
                    sheet.Cells[7, i + 1].Value = tests[i + 1].BiasRange;
                    sheet.Cells[8, i + 1].Value = tests[i + 1].BiasValue;
                    sheet.Cells[9, i + 1].Value = tests[i + 1].ApplyTime;
                }

                for (int i = 0; i < reports.Count; i++)
                {
                    sheet.Cells[12, i + 1].Value = reports[i + 1].Index;
                    sheet.Cells[13, i + 1].Value = reports[i + 1].ItemCode.ToString();
                    sheet.Cells[14, i + 1].Value = reports[i + 1].ItemName;
                    sheet.Cells[15, i + 1].Value = reports[i + 1].ItemRef;
                    sheet.Cells[16, i + 1].Value = reports[i + 1].BiasCH;
                }

                int maxCount = (tests.Count > reports.Count) ? tests.Count + 1 : reports.Count + 1;

                //if (maxCount < 12)
                //{
                //    maxCount = 12;
                //    workBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Hidden;
                //}
                //else
                //{
                //    workBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Visible;
                //}

                workBook.WorksheetDisplayArea.SetSize(0, maxCount, 17);
            }
            finally
            {
                workBook.EndUpdate();
            }

            sheet = resultBook.Document.Worksheets[0];
            resultBook.BeginUpdate();
            try
            {
                sheet.ClearContents(sheet["A1:ZZ1000"]);
                sheet.Cells["A1"].Value = "DateTime";
                sheet.Cells["B1"].Value = "Elapsed Time";
                sheet.Cells["C1"].Value = "Bin";

                for (int i = 0; i < reports.Count; i++)
                {
                    sheet.Cells[0, i + 3].Value = reports[i + 1].ItemName;
                }

                int maxCount = reports.Count + 3;

                if (maxCount < 12)
                {
                    maxCount = 12;
                    resultBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Hidden;
                }
                else
                {
                    resultBook.Options.HorizontalScrollbar.Visibility = SpreadsheetScrollbarVisibility.Visible;
                }

                resultBook.WorksheetDisplayArea.SetSize(0, maxCount, 500);
            }
            finally
            {
                resultBook.EndUpdate();
            }
        }
 public WorkItem(Int64 recipeNo, EWorkType type)
 {
     Tests   = new TestWorkList(recipeNo, type);
     Reports = new ReportWorkList(recipeNo, type);
 }