Как сделать авто создание алиасов для полей баз данных

1
2
3
4
5
6

using FastReport;
using FastReport.Utils;
using FastReport.Data;
using FastReport.Design;
using FastReport.Wizards;
using System.IO;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

 private void RegisterData(Report report)
 {
 // cteate any DataSet
 DataSet dataSet = new DataSet();
 dataSet.ReadXml(Path.Combine(appPath, "nwind.xml"));
 
 // register data source in the report
 report.RegisterData(dataSet, "NorthWind");
 
 // Loop through the tables. Override aliases have necessary tables. Activate visibility of the tables
 foreach (DataSourceBase dsItem in report.Dictionary.DataSources)
 {
 if (dsItem.Name == "Employees")
 {
 dsItem.Enabled = true;
 dsItem.Alias = "Mitarbeiter";
 dsItem.Columns.FindByName("EmployeeID").Alias = "Identifier";
 dsItem.Columns.FindByName("LastName").Alias = "Nachname";
 dsItem.Columns.FindByName("FirstName").Alias = "Vorname";
 dsItem.Columns.FindByName("Title").Alias = "City";
 dsItem.Columns.FindByName("TitleOfCourtesy").Alias = "Titel";
 dsItem.Columns.FindByName("BirthDate").Alias = "Geburtsdatum";
 dsItem.Columns.FindByName("HireDate").Alias = "Datum der Beschäftigung";
 dsItem.Columns.FindByName("Address").Alias = "Anschrift";
 dsItem.Columns.FindByName("City").Alias = "Stadt";
 dsItem.Columns.FindByName("Region").Alias = "Bereich";
 dsItem.Columns.FindByName("PostalCode").Alias = "Index";
 dsItem.Columns.FindByName("Country").Alias = "Land";
 dsItem.Columns.FindByName("HomePhone").Alias = "Haustelefon";
 dsItem.Columns.FindByName("Extension").Alias = "Area Code";
 dsItem.Columns.FindByName("Photo").Alias = "Photographie";
 dsItem.Columns.FindByName("Notes").Alias = "Hinweise";
 dsItem.Columns.FindByName("ReportsTo").Alias = "Vorlage";
 }
 }
 
 // set report parameters
 report.SetParameterValue("Die Testparameter 1", "Der Parameter 1 vor dem Aufruf des Berichts");
 report.SetParameterValue("Parameter 2", "\"Der Parameter 2 Standard\"");
 }

1
2
3
4
5
6
7
8
9
10

private string appPath;
 
private void Designer_Load(object sender, EventArgs e)
 { 
 appPath = Path.GetDirectoryName(Application.ExecutablePath);
 // load the German local for designer
 Res.LoadLocale(Path.Combine(appPath, "German.frl"));
 // intercept the load event of designer for further overriding the event handlers
 Config.DesignerSettings.DesignerLoaded += DesignerSettings_DesignerLoaded;
 }

1
2
3
4
5
6
7
8
9

 // load event of designer
 private void DesignerSettings_DesignerLoaded(object sender, EventArgs e)
 {
 // intercept action of creating a new report for the registration of our sources and parameters
 (sender as Designer).cmdNew.CustomAction += new EventHandler(cmdNew_CustomAction);
 
 // except cmdNew. Similarly, you can intercept other Designer.cmd * and do anything inside,
 // for example, load report from database field and save it back
 }

1
2
3
4
5
6
7
8
9
10
11
12
13

 void cmdNew_CustomAction(object sender, EventArgs e)
 {
 Designer designer = sender as Designer;
 // Use blank wizard to create blank report
 BlankReportWizard wizard = new BlankReportWizard();
 //StandardReportWizard wizard = new StandardReportWizard(); // you can use other wizards
 // run wizard
 wizard.Run(designer);
 // register our data and parameters
 RegisterData(designer.Report);
 // update data tree
 designer.SetModified(this, "EditData");
 }

1
2
3
4
5
6
7
8
9

 // create new report
 private void btnNewReport_Click(object sender, EventArgs e)
 {
 using (Report report = new Report())
 {
 RegisterData(report); 
 report.Design();
 }
 }

1
2
3
4
5
6
7
8
9
10

 // edit report
 private void btnLoadReport_Click(object sender, EventArgs e)
 {
 using (Report report = new Report())
 {
 report.Load(Path.Combine(appPath, "report.frx"));
 RegisterData(report);
 report.Design();
 }
 }