public void GetTemplateFilePathTest()
        {
            string filePath = RPTPara.GetTemplateFilePath();

            Console.WriteLine(filePath);
            Assert.IsTrue(File.Exists(Path.Combine(filePath, "CxDailyReportAhlq.xls")));
        }
        public void ExcelgfDailyReport()
        {
            string             fileDirPath = RPTPara.GetTemplateFilePath();
            TemplateHandleBase gfms        = new GfmsDailyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 12, 14), Factor = new Factor {
                    Id = 16, NameCN = "锚杆受力监测"
                }, Structure = new Structure {
                    Id = 62
                }, Organization = new Organization {
                    Id = 38, Name = "组织名称", SystemName = "广佛城际轻轨基坑监测"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "GfmsDailyReport.xls")
            });
            TemplateHandleBase gfcj = new GfcjDailyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 12, 15), Factor = new Factor {
                    Id = 42, NameCN = "沉降分组监测"
                }, Structure = new Structure {
                    Id = 62
                }, Organization = new Organization {
                    Id = 38, Name = "组织名称", SystemName = "广佛城际轻轨基坑监测"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "GfcjDailyReport.xls")
            });

            Assert.IsTrue(gfms.WriteFile());
            Assert.IsTrue(gfcj.WriteFile());
            Assert.IsTrue(ExistOrNot(Path.Combine(Path.GetTempPath(), "日报表.xls")));
        }
Example #3
0
        private TemplateHandlerPrams CreateTemplateHandlerPrams()
        {
            TemplateHandlerPrams paPrams = new TemplateHandlerPrams();
            string date     = "2014,11,1";
            var    d        = date.Split(',');
            var    dateTime = new DateTime(int.Parse(d[0]), int.Parse(d[1]), int.Parse(d[2]), 3, 0, 0);

            paPrams.Date = dateTime;
            string fileDirPath = RPTPara.GetTemplateFilePath();

            paPrams.TemplateFileName = Path.Combine(fileDirPath, "StructureMonthlyReport.docx");
            Organization org = DataAccess.GetOrganizationInfo(15);

            paPrams.Organization = org;
            Structure structure = DataAccess.GetStructureInfo(3);

            paPrams.Structure = structure;

            var sb = new StringBuilder(100);

            sb.Append(paPrams.Structure.Name);
            var reportDate = paPrams.Date.AddMonths(-1);

            sb.Append("_月报表").AppendFormat("_{0}年{1}月", reportDate.Year.ToString(), reportDate.Month.ToString());
            sb.Append(".docx");
            var path = Path.Combine(Path.GetTempPath(), sb.ToString());

            paPrams.FileFullName = path;

            return(paPrams);
        }
        public void ExcelWeekReport()
        {
            string             fileDirPath = RPTPara.GetTemplateFilePath();
            TemplateHandleBase cxz         = new CxWeekReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 8, 22), Factor = new Factor {
                    Id = 10, NameCN = "测斜监测周报表"
                }, Structure = new Structure {
                    Id = 4
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "周报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "测斜监测周模板.xls")
            });
            TemplateHandleBase dxsz = new DxsWeekReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 17, NameCN = "地下水位监测周报表"
                }, Structure = new Structure {
                    Id = 16
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "周报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "地下水位监测周模板.xls")
            });
            TemplateHandleBase cjz = new CjWeekReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 11, NameCN = "沉降监测周报表"
                }, Structure = new Structure {
                    Id = 17
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "周报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "沉降监测周模板.xls")
            });
            TemplateHandleBase vsz = new VsWeekReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 9, NameCN = "竖向位移监测周报表"
                }, Structure = new Structure {
                    Id = 2
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "周报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "竖向位移监测周模板.xls")
            });
            TemplateHandleBase hsz = new HsWeekReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 9, NameCN = "水平位移监测周报表"
                }, Structure = new Structure {
                    Id = 2
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "周报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "水平位移监测周模板.xls")
            });

            Assert.IsTrue(cxz.WriteFile());
            Assert.IsTrue(dxsz.WriteFile());
            Assert.IsTrue(cjz.WriteFile());
            Assert.IsTrue(vsz.WriteFile());
            Assert.IsTrue(hsz.WriteFile());
            Assert.IsTrue(ExistOrNot(Path.Combine(Path.GetTempPath(), "周报表.xls")));
        }
Example #5
0
        private TemplateHandlerPrams CreateCrackTemplateHandlerPrams(string template, string fullName)
        {
            string fileDirPath = RPTPara.GetTemplateFilePath();

            TemplateHandlerPrams paPrams = new TemplateHandlerPrams()
            {
                Date             = new DateTime(2015, 1, 19, 0, 0, 0, DateTimeKind.Local),
                Factor           = DataAccess.GetFactorInfoById(41),
                Structure        = DataAccess.GetStructureInfo(82),
                Organization     = DataAccess.GetOrganizationInfo(48),
                FileFullName     = Path.Combine(Path.GetTempPath(), fullName),
                TemplateFileName = Path.Combine(fileDirPath, template)
            };

            return(paPrams);
        }
        public void TestXwzxWeekReport()
        {
            string               fileDirPath = RPTPara.GetTemplateFilePath();
            string               template    = "GfMonthlyReport.docx";
            string               reportName  = "广佛新闻中心周报.docx";
            string               handleName  = "StructureWeekReportTemplateHandler";
            DateTime             date        = new DateTime(2015, 2, 9, 0, 0, 0, DateTimeKind.Local);
            int                  factorId    = -1;
            int                  structId    = 62;
            int                  orgId       = 38;
            TemplateHandlerPrams para        = TestPinghanReport.CreateTemplateHandlerPrams(date, factorId, structId, orgId,
                                                                                            template, reportName);
            string reportFullName = TestPinghanReport.CallTemplateHandle(para, handleName);

            Assert.IsTrue(File.Exists(reportFullName));
        }
Example #7
0
        public static TemplateHandlerPrams CreateTemplateHandlerPrams(DateTime date, int factorId, int structId, int orgId, string template, string reportName)
        {
            string fileDirPath           = RPTPara.GetTemplateFilePath();
            TemplateHandlerPrams paPrams = new TemplateHandlerPrams()
            {
                Date      = date,
                Factor    = DataAccess.GetFactorInfoById(factorId),
                Structure = DataAccess.GetStructureInfo(structId),
                // Organization = DataAccess.GetOrganizationInfo(orgId),
                Organization = new Organization {
                    Id = orgId, Name = "组织名称", SystemName = "系统名称"
                },
                FileFullName     = Path.Combine(Path.GetTempPath(), reportName),
                TemplateFileName = Path.Combine(fileDirPath, template)
            };

            return(paPrams);
        }
        public void ExcelDailyReport()
        {
            string             fileDirPath = RPTPara.GetTemplateFilePath();
            TemplateHandleBase cjr         = new CjDailyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 11, NameCN = "沉降监测日报表"
                }, Structure = new Structure {
                    Id = 17
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "沉降监测日模板.xls")
            });
            TemplateHandleBase dxsr = new DxsDailyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 17, NameCN = "地下水位监测日报表"
                }, Structure = new Structure {
                    Id = 16
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "地下水位监测日模板.xls")
            });
            TemplateHandleBase cxr = new CxDailyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 8, 22), Factor = new Factor {
                    Id = 10, NameCN = "测斜监测日报表"
                }, Structure = new Structure {
                    Id = 4
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "测斜监测日模板.xls")
            });
            TemplateHandleBase vsr = new VsDailyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 9, NameCN = "竖向位移监测日报表"
                }, Structure = new Structure {
                    Id = 2
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "竖向位移监测日模板.xls")
            });
            TemplateHandleBase hsr = new HsDailyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams {
                Date = new DateTime(2014, 5, 22), Factor = new Factor {
                    Id = 9, NameCN = "水平位移监测日报表"
                }, Structure = new Structure {
                    Id = 2
                }, Organization = new Organization {
                    Id = 12, Name = "组织名称", SystemName = "系统名称"
                }, FileFullName = Path.Combine(Path.GetTempPath(), "日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "水平位移监测日模板.xls")
            });

            //以下模板涉及到xml计数,在当前测试确保结构物名称不为null
            //TemplateHandleBase cxahlqr = new CxDailyUnifyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams { Date = new DateTime(2014, 7, 19), Factor = new Factor { Id = 10, NameCN = "测斜监测日报表" }, Structure = new Structure { Id = 2,Name = "安徽六潜测斜"}, Organization = new Organization { Id = 12, Name = "组织名称", SystemName = "安徽六潜" }, FileFullName = Path.Combine(Path.GetTempPath(), "安徽六潜测斜日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "CxDailyReportAhlq.xls") });
            // TemplateHandleBase cxncdwyr = new CxDailyUnifyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams { Date = new DateTime(2014, 7, 19), Factor = new Factor { Id = 10, NameCN = "测斜监测日报表" }, Structure = new Structure { Id = 26,Name = "动物园测斜"}, Organization = new Organization { Id = 12, Name = "组织名称", SystemName = "动物园" }, FileFullName = Path.Combine(Path.GetTempPath(), "围护结构测斜日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "CxDailyReportNcdwy.xls") });
            // TemplateHandleBase cxthyr = new CxDailyUnifyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams { Date = new DateTime(2014, 7, 19), Factor = new Factor { Id = 10, NameCN = "测斜监测日报表" }, Structure = new Structure { Id = 26 ,Name = "桃花源测斜"}, Organization = new Organization { Id = 12, Name = "组织名称", SystemName = "桃花源" }, FileFullName = Path.Combine(Path.GetTempPath(), "桃花源测斜日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "CxDailyReportThy.xls") });
            // TemplateHandleBase dxsylr = new SwDailyUnifyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams { Date = new DateTime(2014, 5, 22), Factor = new Factor { Id = 17, NameCN = "地下水位监测日报表" }, Structure = new Structure { Id = 26,Name = "桃花源地下水"}, Organization = new Organization { Id = 12, Name = "组织名称", SystemName = "桃花源" }, FileFullName = Path.Combine(Path.GetTempPath(), "桃花源地下水日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "SwDailyReportThy.xls") });
            //TemplateHandleBase dxncvylr = new SwDailyUnifyReport(new ReportGeneratorService.ReportModule.TemplateHandlerPrams { Date = new DateTime(2014, 5, 22), Factor = new Factor { Id = 17, NameCN = "地下水位监测日报表" }, Structure = new Structure { Id = 72,Name = "动物园地下水"}, Organization = new Organization { Id = 12, Name = "组织名称", SystemName = "动物园" }, FileFullName = Path.Combine(Path.GetTempPath(), "围护结构地下水日报表.xls"), TemplateFileName = Path.Combine(fileDirPath, "SwDailyReportNcdwy.xls") });
            //  Assert.IsTrue(cxahlqr.WriteFile());
            // Assert.IsTrue(cxncdwyr.WriteFile());
            // Assert.IsTrue(cxthyr.WriteFile());
            // Assert.IsTrue(dxsylr.WriteFile());
            //Assert.IsTrue(dxncvylr.WriteFile());
            Assert.IsTrue(cjr.WriteFile());
            Assert.IsTrue(dxsr.WriteFile());
            Assert.IsTrue(cxr.WriteFile());
            Assert.IsTrue(vsr.WriteFile());
            Assert.IsTrue(hsr.WriteFile());
            Assert.IsTrue(ExistOrNot(Path.Combine(Path.GetTempPath(), "日报表.xls")));
        }