MainWindow.xaml.cs 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. using FastReport;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Windows;
  6. namespace DataSources
  7. {
  8. /// <summary>
  9. /// Interaction logic for MainWindow.xaml
  10. /// </summary>
  11. public partial class MainWindow : Window
  12. {
  13. private int[] _array;
  14. private List<Category> businessObject;
  15. private DataSet dataSet;
  16. public MainWindow()
  17. {
  18. InitializeComponent();
  19. CreateArray();
  20. CreateBusinessObject();
  21. CreateDataSet();
  22. }
  23. private void CreateArray()
  24. {
  25. _array = new int[10];
  26. for (int i = 0; i < 10; i++)
  27. {
  28. _array[i] = i + 1;
  29. }
  30. }
  31. private void CreateBusinessObject()
  32. {
  33. businessObject = new List<Category>();
  34. var category = new Category("Beverages", "Soft drinks, coffees, teas, beers");
  35. category.Products.Add(new Product("Chai", 18m));
  36. category.Products.Add(new Product("Chang", 19m));
  37. category.Products.Add(new Product("Ipoh coffee", 46m));
  38. businessObject.Add(category);
  39. category = new Category("Confections", "Desserts, candies, and sweet breads");
  40. category.Products.Add(new Product("Chocolade", 12.75m));
  41. category.Products.Add(new Product("Scottish Longbreads", 12.5m));
  42. category.Products.Add(new Product("Tarte au sucre", 49.3m));
  43. businessObject.Add(category);
  44. category = new Category("Seafood", "Seaweed and fish");
  45. category.Products.Add(new Product("Boston Crab Meat", 18.4m));
  46. category.Products.Add(new Product("Red caviar", 15m));
  47. businessObject.Add(category);
  48. }
  49. private void CreateDataSet()
  50. {
  51. // create simple dataset with one table
  52. dataSet = new DataSet();
  53. var table = new DataTable();
  54. table.TableName = "Employees";
  55. dataSet.Tables.Add(table);
  56. table.Columns.Add("ID", typeof(int));
  57. table.Columns.Add("Name", typeof(string));
  58. table.Rows.Add(1, "Andrew Fuller");
  59. table.Rows.Add(2, "Nancy Davolio");
  60. table.Rows.Add(3, "Margaret Peacock");
  61. }
  62. private void DataFromArray_New_Click(object sender, RoutedEventArgs e)
  63. {
  64. // create report instance
  65. using (var report = new Report())
  66. {
  67. // register the array
  68. report.RegisterData(_array, "Array");
  69. report.GetDataSource("Array").Enabled = true;
  70. // design the report
  71. report.Design();
  72. }
  73. }
  74. private void DataFromArray_Existing_Click(object sender, RoutedEventArgs e)
  75. {
  76. // create report instance
  77. using (var report = new Report())
  78. {
  79. // load the existing report
  80. report.Load("report_from_array.frx");
  81. // register the array
  82. report.RegisterData(_array, "Array");
  83. // run the report
  84. report.Show();
  85. }
  86. }
  87. private void DataFromBO_New_Click(object sender, RoutedEventArgs e)
  88. {
  89. // create report instance
  90. using (var report = new Report())
  91. {
  92. // register the business object (and up to 3 nested data sources)
  93. report.RegisterData(businessObject, "Categories", 3);
  94. report.GetDataSource("Categories").Enabled = true;
  95. // design the report. Enable the data source in the "Report|Choose Report Data..." window
  96. report.Design();
  97. }
  98. }
  99. private void DataFromBO_Existing_Click(object sender, RoutedEventArgs e)
  100. {
  101. // create report instance
  102. using (var report = new Report())
  103. {
  104. // load the existing report
  105. report.Load("report_from_bo.frx");
  106. // register the business object
  107. report.RegisterData(businessObject, "Categories");
  108. // run the report
  109. report.Show();
  110. }
  111. }
  112. private void DataFromDataSet_New_Click(object sender, RoutedEventArgs e)
  113. {
  114. // create report instance
  115. using (var report = new Report())
  116. {
  117. // register the dataset
  118. report.RegisterData(dataSet);
  119. // enable the "Employees" datasource.
  120. // You can also do this in the "Report|Choose Report Data..." menu.
  121. report.GetDataSource("Employees").Enabled = true;
  122. // design the report. Enable the data source in the "Report|Choose Report Data..." window
  123. report.Design();
  124. }
  125. }
  126. private void DataFromDataSet_Existing_Click(object sender, RoutedEventArgs e)
  127. {
  128. // create report instance
  129. using (var report = new Report())
  130. {
  131. // load the existing report
  132. report.Load("report_from_dataset.frx");
  133. // register the dataset
  134. report.RegisterData(dataSet);
  135. // run the report
  136. report.Show();
  137. }
  138. }
  139. }
  140. }