示例#1
0
 public PdfProvider(SqlConnection dbCon, MarginProvider marginProvider, Font font)
 {
     this.Document = new PdfDocument();
     this.BrushColor = PdfBrushes.Black;
     this.Margin = marginProvider.Margins;
     this.Font = font;
     this.TrueTypeFont = new PdfTrueTypeFont(this.Font);
     this.Alignment = new PdfStringFormat(PdfTextAlignment.Center);
     this.DbCon = dbCon;
     this.Page = this.Document.Pages.Add(PdfPageSize.A4, this.Margin);
 }
示例#2
0
        static void Main(string[] args)
        {
            using (var db = new RheniumSportsEntities())
            {
                Console.WriteLine(db.Matches.FirstOrDefault());
            }

            var dbCon = new SqlConnection("Server=.\\SQLEXPRESS; Database=TelerikAcademy; Integrated Security=true");
            var margin = new MarginProvider(2.54f, 3.17f);
            var font = new Font("Arial", 16f, FontStyle.Bold);
            var pdfProvider = new PdfProvider(dbCon, margin, font);
            pdfProvider.SetHeader("Rhenium League", 50);
            pdfProvider.CreatePdf("../../Reports/PdfReport.pdf", "SELECT TOP 100 FirstName, LastName, Salary FROM Employees");
        }