Пример #1
0
        public static void BuildIterationReport(ProjectEntity project, string path)
        {
            ExcelInterop.Application excel = new ExcelInterop.Application();

            excel.DisplayAlerts = false;

            ExcelInterop.Workbook workbook = excel.Workbooks.Add();
            nativeResources.Add(workbook);
            ExcelInterop.Sheets sheets = workbook.Worksheets;
            nativeResources.Add(sheets);

            List <Tuple <string, Type> > allSheets = new List <Tuple <string, Type> >()
            {
                Tuple.Create <string, Type>("首页及说明", typeof(HomeSheet)),
                Tuple.Create <string, Type>("项目整体说明", typeof(OverviewSheet)),
                Tuple.Create <string, Type>("系统需求统计分析", typeof(FeatureSheet)),
                Tuple.Create <string, Type>("Backlog统计", typeof(BacklogSheet)),
                Tuple.Create <string, Type>("提交单分析", typeof(CommitmentSheet)),
                Tuple.Create <string, Type>("Bug统计分析", typeof(BugSheet)),
                Tuple.Create <string, Type>("审查工作分析", typeof(WorkReviewSheet)),
                Tuple.Create <string, Type>("工作量统计", typeof(WorkloadSheet)),
                Tuple.Create <string, Type>("改进建议", typeof(SuggestionSheet)),
                Tuple.Create <string, Type>("人员考评结果", typeof(PerformanceSheet)),
            };

            ExcelInterop.Worksheet lastSheet = null;
            for (int i = 0; i < allSheets.Count; i++)
            {
                ExcelInterop.Worksheet sheet;

                if (lastSheet == null)
                {
                    sheet = (ExcelInterop.Worksheet)sheets.Add();
                }
                else
                {
                    sheet = (ExcelInterop.Worksheet)sheets.Add(After: lastSheet);
                }

                lastSheet = sheet;
                nativeResources.Add(sheet);
                sheet.Name = allSheets[i].Item1;

                Console.WriteLine("\t" + sheet.Name);

                Type   t   = allSheets[i].Item2;
                var    ci  = t.GetConstructor(new Type[] { typeof(ExcelInterop.Worksheet) });
                object obj = ci.Invoke(new object[] { sheet });
                t.InvokeMember("Build", BindingFlags.InvokeMethod, null, obj, new object[] { project });
            }

            Console.WriteLine("保存文件.");
            sheets.Select();//选择所有的sheet

            var window = excel.ActiveWindow;

            nativeResources.Add(window);
            window.DisplayGridlines = false;//都不显示表格线

            var    ite   = TFS.Utility.GetBestIteration(project.Name);
            string fname = String.Format("{0}\\{1}总结({2}_{3}).xlsx",
                                         path,
                                         ite.Path.Replace("\\", " "),
                                         (DateTime.Parse(ite.StartDate)).ToString("yyyyMMdd"),
                                         (DateTime.Parse(ite.EndDate)).ToString("yyyyMMdd")
                                         );

            workbook.SaveAs(fname);
            workbook.Close();

            Console.WriteLine("释放资源.");
            foreach (object com in nativeResources)
            {
                TFS.Utility.ReleaseComObject(com);
            }
            Console.WriteLine("附件已经保存在:" + fname);

            excel.Quit();
        }