public App()
{
RegisteredObjects.AddConnection(typeof(SqlCeDataConnection));
AppDomain.CurrentDomain.AssemblyLoad += CurrentDomain_AssemblyLoad;
EventManager.RegisterClassHandler(typeof(TextBox), UIElement.KeyDownEvent, new KeyEventHandler(KeyDown));
EventManager.RegisterClassHandler(typeof(ComboBox), UIElement.KeyDownEvent, new KeyEventHandler(KeyDown));
}
public static void Main()
{
// AppDomain.CurrentDomain.AssemblyResolve +=OnResolveAssembly;
RegisteredObjects.AddConnection(typeof(SQLiteDataConnection));
// Debug.WriteLine("dbthread init now....");
App.Main();
}
public IActionResult ParameterBasedReport([FromForm] ParameterBasedReport parameterBasedReport)
{
string reportTitle = parameterBasedReport.ReportTitle;
var report = _businessLayer.GetAllReportInfos().Where(x => x.ReportName == reportTitle).FirstOrDefault();
string filepath = parameterBasedReport.ReportPath;
string finId = parameterBasedReport.ParameterValue;
//string fromDate = parameterBasedReport.FromDate;
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
WebReport webReport = new WebReport();
webReport.Report.Load(filepath);
/*TableDataSource ds = webReport.Report.GetDataSource("Settlement") as TableDataSource;
* string command = ds.SelectCommand;*/
ViewBag.WebReport = webReport;
ViewBag.banklist = GetBankList();
ViewBag.ReportName = filepath;
ViewBag.ReportTitle = reportTitle;
if (finId != null)
{
var bank = _businessLayer.GetFinInstitutionInfoById(finId);
webReport.Report.SetParameterValue("BankName", bank.InstitutionName);
webReport.Report.SetParameterValue("FinancialInstitutionId", finId);
ViewBag.FinancialId = finId;
}
TempData["ReportLoaded"] = "true";
return(View(report));
}
public WebReport GetReport(string OPID, string DDL_License_Name, string DDL_PlanID)
{
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
var webReport = new WebReport();
var sqlConnection = new MsSqlDataConnection
{
ConnectionString = "Data Source=10.29.1.116;Initial Catalog=sptosystem;Persist Security Info=True;User ID=sa;Password=pwpolicy;Application Name=SPTO_SYSTEM"
};
//sqlConnection.ConnectionString = sqlConnection;
sqlConnection.CreateAllTables();
webReport.Report.Dictionary.Connections.Add(sqlConnection);
webReport.Report.Load($@"Reports/Untitled.frx");
//var string staffop = OPID ;
//const string planid = "T2220-0001";
//const string license = "CO1001";
webReport.Report.SetParameterValue("PAM_OP", OPID);
webReport.Report.SetParameterValue("PAM_PLANID", DDL_PlanID);
webReport.Report.SetParameterValue("PAM_License", DDL_License_Name);
ViewBag.WebReport = webReport;
ViewBag.OPID = OPID;
return(webReport);
}
//public static string EncryptedVeritabanıadresi;
/// <summary>
/// Initializes a new instance of the <see cref="App"/> class.
/// </summary>
public App()
{
//string Encrypted = System.Configuration.ConfigurationManager.ConnectionStrings["SqlceConnection"].ConnectionString;
//byte[] data = Convert.FromBase64String(Encrypted);
//EncryptedVeritabanıadresi = Encoding.UTF8.GetString(data);
RegisteredObjects.AddConnection(typeof(SqlCeDataConnection));
AppDomain.CurrentDomain.AssemblyLoad += CurrentDomain_AssemblyLoad;
EventManager.RegisterClassHandler(typeof(TextBox), UIElement.KeyDownEvent, new KeyEventHandler(KeyDown));
EventManager.RegisterClassHandler(typeof(ComboBox), UIElement.KeyDownEvent, new KeyEventHandler(KeyDown));
}
private void button1_Click(object sender, EventArgs e)
{
RegisteredObjects.AddConnection(typeof(GoogleBigQueryDataConnection));
using (Report report = new Report())
{
string reportFileName = "report.frx";
if (File.Exists(reportFileName))
{
report.Load(reportFileName);
}
report.Design();
}
}
public IActionResult Index()
{
string filepath = TempData["FilePath"] as string;
currentReportPath = filepath;
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
WebReport webReport = new WebReport();
webReport.Report.Load(filepath);
ViewBag.WebReport = webReport;
ViewBag.ReportName = currentReportPath;
return(View());
}
private static void Configure(IUnityContainer container)
{
// инициализируем Environment
container.RegisterType <IWmsEnvironmentInfoProvider, WebWmsEnvironmentInfoProvider>(
new ContainerControlledLifetimeManager());
container.RegisterType <ILocalData, WebLocalData>(new ContainerControlledLifetimeManager());
WmsEnvironment.Init(container.Resolve <IWmsEnvironmentInfoProvider>(), container.Resolve <ILocalData>());
// запускаем wf
WorkflowServicesUnityConfigurator.Configure(container, true);
// настраиваем fr
FastReport.Utils.Config.WebMode = true;
RegisteredObjects.AddConnection(typeof(OracleDataConnection));
}
public IActionResult BasicReport(string ReportName)
{
var report = _businessLayer.GetAllReportInfos().Where(x => x.ReportName == ReportName).FirstOrDefault();
string filepath = @"Reports\" + report.ReportPath;
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
WebReport webReport = new WebReport();
webReport.Report.Load(filepath);
ViewBag.ReportTitle = report.ReportName;
ViewBag.WebReport = webReport;
ViewBag.ReportName = filepath;
return(View(report));
}
public MeGonnaBeRandomAssemblyInitializer()
{
if (!isInitied)
{
isInitied = true;
RegisteredObjects.AddConnection(typeof(MeGonnaBeRandom), "Генератор случайных величин");
Utils.Register(new DateGenerator());
Utils.Register(new FirstNameGenerator());
Utils.Register(new FullNameGenerator());
Utils.Register(new LastNameGenerator());
Utils.Register(new IntGenerator());
Utils.Register(new MixedGenerator());
}
}
public static Reports GetReportRaznaryadka(string dt, string reportName, string Raion, string Oblast)
{
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
Reports webR = new Reports();
webR.report = new WebReport();
/*
* MsSqlDataConnection _con = new MsSqlDataConnection();
* _con.ConnectionString = spDAL.connStr;
* _con.CreateAllTables();
* webR.report.Report.Dictionary.Connections.Add(_con);
*/
string _path = System.IO.Directory.GetCurrentDirectory();
_path = _path
+ System.IO.Path.DirectorySeparatorChar
+ "FastReports"
+ System.IO.Path.DirectorySeparatorChar
+ "CA"
+ System.IO.Path.DirectorySeparatorChar
+ reportName
+ ".frx";
int m = Int32.Parse(dt.Substring(0, 2));
int y = Int32.Parse(dt.Substring(3, 4));
webR.report.Report.Load(_path);
webR.report.Report.Dictionary.Connections[0].ConnectionString = spDAL.connStr;
webR.report.Report.SetParameterValue("yyyy", y);
webR.report.Report.SetParameterValue("mm", m);
if (Raion is null)
{
Raion = "";
}
if (Oblast is null)
{
Oblast = "";
}
webR.report.Report.SetParameterValue("raion", Raion);
webR.report.Report.SetParameterValue("Oblast", Oblast);
//webR.report.Report.Prepare();
webR.dt = dt;
webR.ReportName = reportName;
//TableDataSource table = webR.report.Report.GetDataSource("v1") as TableDataSource;
//table.SelectCommand = "";
return(webR);
}
public IActionResult Generate([FromBody] ReportDto query)
{
string mime = "application/pdf"; //MIME-header with default value
string webRootPath = _hostingEnvironment.WebRootPath; //Define the path to the wwwroot folder
string reportPath = (webRootPath + "/Report.frx"); //Define the path to the report
using (MemoryStream stream = new MemoryStream()) //Create the stream for the report
{
try
{
using (DataSet dataSet = new DataSet())
{
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
WebReport webReport = new WebReport();
MsSqlDataConnection sqlConnection = new MsSqlDataConnection();
sqlConnection.ConnectionString = Configuration.GetConnectionString("DefaultConnection");
sqlConnection.CreateAllTables();
webReport.Report.Dictionary.Connections.Add(sqlConnection);
webReport.Report.Load(reportPath);
webReport.Report.SetParameterValue("AmostraId", query.AmostraId);
for (int i = 0; i < query.Ensaios.Length; i++)
{
webReport.Report.SetParameterValue($"EnsaioSelecionados{i+1}", query.Ensaios[i]);
}
webReport.Report.Prepare();
PDFSimpleExport pdfExport = new PDFSimpleExport();
pdfExport.Export(webReport.Report, stream);
}
//Get the name of resulting report file with needed extension
var file = String.Concat($"Laudo-{DateTime.Now}", ".", "pdf");
return(File(stream.ToArray(), mime, file)); // attachment
}
catch (Exception ex)
{
throw new AppError(ex.Message);
return(new NoContentResult());
}
finally
{
stream.Dispose();
}
}
}
public static void Register(HttpConfiguration config)
{
// Configuración y servicios de API web
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
// Rutas de API web
config.MapHttpAttributeRoutes();
config.Routes.MapHttpRoute(
name: "Index",
routeTemplate: "{id}.html",
defaults: new { id = "index" }
);
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
}
public IActionResult Index(string reportName)
{
if (string.IsNullOrEmpty(reportName))
{
reportName = "GameReport";
}
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
WebReport webReport = new WebReport();
MsSqlDataConnection sqlConnection = new MsSqlDataConnection();
sqlConnection.ConnectionString = @"Data Source=prog3050.daehwa.ca;Initial Catalog=TheWizardsGameShop;Persist Security Info=True;User ID=sa;Password=TheWizards!";
sqlConnection.CreateAllTables();
webReport.Report.Dictionary.Connections.Add(sqlConnection);
webReport.Report.Load($".//Reports//{reportName}.frx");
webReport.ShowPreparedReport = false;
webReport.ShowExports = false;
webReport.ShowZoomButton = false;
ViewBag.report = webReport;
return(View());
}
public IActionResult Index()
{
using (ctx = new MerkatoDbContext(null))
{
WebReport report = new WebReport();
//Report.Report.Load($@"Reports/Simple List.frx");
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
report.Report.Load($@"Reports/LocationForm.frx");
var data = (from location in ctx.Location
join outlet in ctx.Outlet on location.Id equals outlet.LocationId
select new { Location = location, Outlet = outlet })
.Select(a => new Location {
Code = a.Outlet.Name, Name = a.Location.Name
}).ToList();
//var data = ctx.Outlet.ToList().AsEnumerable();
//var databand = (DataBand)report.Report.AllObjects[6];
//databand.Report.RegisterData(data, "LocationDS");
//var source = new FastReport.Data.
//databand.DataSource =
// .LoadData(new System.Collections.ArrayList(data));
//databand.InitDataSource();
//var dataSet = new DataSet();
//dataSet.ReadXml(@"Reports/nwind.xml");
report.Report.RegisterData(data, "LocationDS");
report.Report.GetDataSource("LocationDS").Enabled = true;
var databand = (DataBand)report.Report.FindObject("Data1");
databand.DataSource = report.Report.GetDataSource("LocationDS");
ViewBag.WebReport = report;
return(View());
}
}
public RavenDBAssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(RavenDBDataConnection));
}
public JsonAssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(JsonDataConnection));
}
public OracleODPCoreAssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(OracleDataConnection));
}
public SQLiteAssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(SQLiteDataConnection));
}
/// <summary>
/// Registers all core objects, wizards, export filters.
/// </summary>
public AssemblyInitializer()
{
// report
RegisteredObjects.AddReport(typeof(Report), 134);
// pages
RegisteredObjects.AddPage(typeof(ReportPage), "ReportPage", 135);
// data items
RegisteredObjects.Add(typeof(Column), "", 0);
RegisteredObjects.Add(typeof(CommandParameter), "", 0);
RegisteredObjects.Add(typeof(Relation), "", 0);
RegisteredObjects.Add(typeof(Parameter), "", 0);
RegisteredObjects.Add(typeof(Total), "", 0);
RegisteredObjects.Add(typeof(TableDataSource), "", 0);
RegisteredObjects.Add(typeof(ViewDataSource), "", 0);
RegisteredObjects.Add(typeof(BusinessObjectDataSource), "", 0);
RegisteredObjects.Add(typeof(SliceCubeSource), "", 0);
RegisteredObjects.AddConnection(typeof(XmlDataConnection));
RegisteredObjects.AddConnection(typeof(CsvDataConnection));
// json
RegisteredObjects.Add(typeof(Data.JsonConnection.JsonTableDataSource), "", 0);
//RegisteredObjects.Add(typeof(Data.JsonConnection.JsonObjectDataSource), "", 0);
//RegisteredObjects.Add(typeof(Data.JsonConnection.JsonArrayDataSource), "", 0);
RegisteredObjects.AddConnection(typeof(Data.JsonConnection.JsonDataSourceConnection));
// formats
RegisteredObjects.Add(typeof(BooleanFormat), "", 0);
RegisteredObjects.Add(typeof(CurrencyFormat), "", 0);
RegisteredObjects.Add(typeof(CustomFormat), "", 0);
RegisteredObjects.Add(typeof(DateFormat), "", 0);
RegisteredObjects.Add(typeof(GeneralFormat), "", 0);
RegisteredObjects.Add(typeof(NumberFormat), "", 0);
RegisteredObjects.Add(typeof(PercentFormat), "", 0);
RegisteredObjects.Add(typeof(TimeFormat), "", 0);
// bands
RegisteredObjects.Add(typeof(ReportTitleBand), "", 154, "Objects,Bands,ReportTitle");
RegisteredObjects.Add(typeof(ReportSummaryBand), "", 155, "Objects,Bands,ReportSummary");
RegisteredObjects.Add(typeof(PageHeaderBand), "", 156, "Objects,Bands,PageHeader");
RegisteredObjects.Add(typeof(PageFooterBand), "", 157, "Objects,Bands,PageFooter");
RegisteredObjects.Add(typeof(ColumnHeaderBand), "", 158, "Objects,Bands,ColumnHeader");
RegisteredObjects.Add(typeof(ColumnFooterBand), "", 159, "Objects,Bands,ColumnFooter");
RegisteredObjects.Add(typeof(DataHeaderBand), "", 160, "Objects,Bands,DataHeader");
RegisteredObjects.Add(typeof(DataFooterBand), "", 161, "Objects,Bands,DataFooter");
RegisteredObjects.Add(typeof(DataBand), "", 162, "Objects,Bands,Data");
RegisteredObjects.Add(typeof(GroupHeaderBand), "", 163, "Objects,Bands,GroupHeader");
RegisteredObjects.Add(typeof(GroupFooterBand), "", 164, "Objects,Bands,GroupFooter");
RegisteredObjects.Add(typeof(ChildBand), "", 165, "Objects,Bands,Child");
RegisteredObjects.Add(typeof(OverlayBand), "", 166, "Objects,Bands,Overlay");
// report objects
RegisteredObjects.Add(typeof(TextObject), "ReportPage", 102, 1);
RegisteredObjects.Add(typeof(PictureObject), "ReportPage", 103, 2);
RegisteredObjects.AddCategory("ReportPage,Shapes", 106, 4, "Objects,Shapes");
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 105, "Objects,Shapes,Line", 0, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 107, "Objects,Shapes,DiagonalLine", 1, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 150, "Objects,Shapes,DiagonalLine", 2, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 151, "Objects,Shapes,DiagonalLine", 3, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 152, "Objects,Shapes,DiagonalLine", 4, true);
//RegisteredObjects.Add(typeof(BezierObject), "ReportPage,Shapes", 239, "Objects,Shapes,Bezier", 5, true);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 108, "Objects,Shapes,Rectangle", 0);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 109, "Objects,Shapes,RoundRectangle", 1);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 110, "Objects,Shapes,Ellipse", 2);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 111, "Objects,Shapes,Triangle", 3);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 131, "Objects,Shapes,Diamond", 4);
RegisteredObjects.Add(typeof(PolyLineObject), "ReportPage,Shapes", 240, "Objects,Shapes,Polyline");
RegisteredObjects.Add(typeof(PolygonObject), "ReportPage,Shapes", 241, "Objects,Shapes,Polygon");
RegisteredObjects.Add(typeof(PolygonObject), "ReportPage,Shapes", 242, "Objects,Shapes,Pentagon", 0x50);
RegisteredObjects.Add(typeof(PolygonObject), "ReportPage,Shapes", 243, "Objects,Shapes,Hexagon", 0x60);
RegisteredObjects.Add(typeof(PolygonObject), "ReportPage,Shapes", 244, "Objects,Shapes,Heptagon", 0x70);
RegisteredObjects.Add(typeof(PolygonObject), "ReportPage,Shapes", 245, "Objects,Shapes,Octagon", 0x80);
RegisteredObjects.Add(typeof(SubreportObject), "ReportPage", 104, 5);
RegisteredObjects.Add(typeof(ContainerObject), "ReportPage", 144, 5);
RegisteredObjects.Add(typeof(TableObject), "ReportPage", 127, 6);
RegisteredObjects.Add(typeof(TableColumn), "", 215);
RegisteredObjects.Add(typeof(TableRow), "", 216);
RegisteredObjects.Add(typeof(TableCell), "", 214);
RegisteredObjects.Add(typeof(MatrixObject), "ReportPage", 142, 7);
#if !COMMUNITY
RegisteredObjects.Add(typeof(CrossViewObject), "ReportPage", 247, 8);
#endif
RegisteredObjects.AddCategory("ReportPage,Barcodes", 123, 9, "Objects,BarcodeObject");
for (int i = 0; i <= Barcodes.Items.Length - 1; i++)
{
RegisteredObjects.Add(typeof(BarcodeObject), "ReportPage,Barcodes", -1, "ComponentMenu,Barcode,Barcodes,Barcode" + i, i);
}
RegisteredObjects.Add(typeof(CheckBoxObject), "ReportPage", 124, 10);
RegisteredObjects.Add(typeof(ZipCodeObject), "ReportPage", 129, 14);
RegisteredObjects.Add(typeof(CellularTextObject), "ReportPage", 121, 15);
RegisteredObjects.AddCategory("ReportPage,Gauge", 140, 17, "Objects,Gauge");
RegisteredObjects.Add(typeof(LinearGauge), "ReportPage,Gauge", -1, "Objects,Gauge,Linear", 0, false);
RegisteredObjects.Add(typeof(SimpleGauge), "ReportPage,Gauge", -1, "Objects,Gauge,Simple", 0, false);
RegisteredObjects.Add(typeof(RadialGauge), "ReportPage,Gauge", -1, "Objects,Gauge,Radial", 0, false);
RegisteredObjects.Add(typeof(SimpleProgressGauge), "ReportPage,Gauge", -1, "Objects,Gauge,SimpleProgress", 0, false);
// RegisteredObjects.Add(typeof(CrossBandObject), "ReportPage", 11, "Cross-band line", 0);
// RegisteredObjects.Add(typeof(CrossBandObject), "ReportPage", 11, "Cross-band rectangle", 1);
RegisteredObjects.Add(typeof(HtmlObject), "ReportPage", 246, 18);
// exports
RegisteredObjects.AddExport(typeof(ImageExport), "Image", "Export,Image,File");
// functions
RegisteredObjects.AddCategory("Functions", -1, "");
StdFunctions.Register();
}
/// <summary>
/// Registers all standard objects, wizards, export filters.
/// </summary>
public AssemblyInitializer()
{
// report
RegisteredObjects.AddReport(typeof(Report), 134);
// pages
RegisteredObjects.AddPage(typeof(DialogPage), "DialogPage", 136);
RegisteredObjects.AddPage(typeof(ReportPage), "ReportPage", 135);
// data items
RegisteredObjects.Add(typeof(Column), "", 0);
RegisteredObjects.Add(typeof(CommandParameter), "", 0);
RegisteredObjects.Add(typeof(Relation), "", 0);
RegisteredObjects.Add(typeof(Parameter), "", 0);
RegisteredObjects.Add(typeof(Total), "", 0);
RegisteredObjects.Add(typeof(TableDataSource), "", 0);
RegisteredObjects.Add(typeof(ViewDataSource), "", 0);
RegisteredObjects.Add(typeof(BusinessObjectDataSource), "", 0);
RegisteredObjects.AddConnection(typeof(MsAccessDataConnection));
RegisteredObjects.AddConnection(typeof(XmlDataConnection));
RegisteredObjects.AddConnection(typeof(OleDbDataConnection));
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
RegisteredObjects.AddConnection(typeof(OdbcDataConnection));
// formats
RegisteredObjects.Add(typeof(BooleanFormat), "", 0);
RegisteredObjects.Add(typeof(CurrencyFormat), "", 0);
RegisteredObjects.Add(typeof(CustomFormat), "", 0);
RegisteredObjects.Add(typeof(DateFormat), "", 0);
RegisteredObjects.Add(typeof(GeneralFormat), "", 0);
RegisteredObjects.Add(typeof(NumberFormat), "", 0);
RegisteredObjects.Add(typeof(PercentFormat), "", 0);
RegisteredObjects.Add(typeof(TimeFormat), "", 0);
// dialog controls
RegisteredObjects.Add(typeof(ButtonControl), "DialogPage", 115);
RegisteredObjects.Add(typeof(CheckBoxControl), "DialogPage", 116);
RegisteredObjects.Add(typeof(CheckedListBoxControl), "DialogPage", 148);
RegisteredObjects.Add(typeof(ComboBoxControl), "DialogPage", 119);
RegisteredObjects.Add(typeof(GridControl), "DialogPage", 122);
RegisteredObjects.Add(typeof(DataSelectorControl), "DialogPage", 128);
RegisteredObjects.Add(typeof(DateTimePickerControl), "DialogPage", 120);
RegisteredObjects.Add(typeof(GroupBoxControl), "DialogPage", 143);
RegisteredObjects.Add(typeof(LabelControl), "DialogPage", 112);
RegisteredObjects.Add(typeof(ListBoxControl), "DialogPage", 118);
RegisteredObjects.Add(typeof(ListViewControl), "DialogPage", 203);
RegisteredObjects.Add(typeof(MaskedTextBoxControl), "DialogPage", 147);
RegisteredObjects.Add(typeof(MonthCalendarControl), "DialogPage", 145);
RegisteredObjects.Add(typeof(NumericUpDownControl), "DialogPage", 146);
RegisteredObjects.Add(typeof(PanelControl), "DialogPage", 144);
RegisteredObjects.Add(typeof(PictureBoxControl), "DialogPage", 103);
RegisteredObjects.Add(typeof(RadioButtonControl), "DialogPage", 117);
RegisteredObjects.Add(typeof(RichTextBoxControl), "DialogPage", 205);
RegisteredObjects.Add(typeof(TextBoxControl), "DialogPage", 113);
RegisteredObjects.Add(typeof(TreeViewControl), "DialogPage", 204);
// bands
RegisteredObjects.Add(typeof(ReportTitleBand), "", 154, "Objects,Bands,ReportTitle");
RegisteredObjects.Add(typeof(ReportSummaryBand), "", 155, "Objects,Bands,ReportSummary");
RegisteredObjects.Add(typeof(PageHeaderBand), "", 156, "Objects,Bands,PageHeader");
RegisteredObjects.Add(typeof(PageFooterBand), "", 157, "Objects,Bands,PageFooter");
RegisteredObjects.Add(typeof(ColumnHeaderBand), "", 158, "Objects,Bands,ColumnHeader");
RegisteredObjects.Add(typeof(ColumnFooterBand), "", 159, "Objects,Bands,ColumnFooter");
RegisteredObjects.Add(typeof(DataHeaderBand), "", 160, "Objects,Bands,DataHeader");
RegisteredObjects.Add(typeof(DataFooterBand), "", 161, "Objects,Bands,DataFooter");
RegisteredObjects.Add(typeof(DataBand), "", 162, "Objects,Bands,Data");
RegisteredObjects.Add(typeof(GroupHeaderBand), "", 163, "Objects,Bands,GroupHeader");
RegisteredObjects.Add(typeof(GroupFooterBand), "", 164, "Objects,Bands,GroupFooter");
RegisteredObjects.Add(typeof(ChildBand), "", 165, "Objects,Bands,Child");
RegisteredObjects.Add(typeof(OverlayBand), "", 166, "Objects,Bands,Overlay");
// report objects
RegisteredObjects.Add(typeof(TextObject), "ReportPage", 102);
RegisteredObjects.Add(typeof(PictureObject), "ReportPage", 103);
RegisteredObjects.AddCategory("ReportPage,Shapes", 106, "Objects,Shapes");
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 105, "Objects,Shapes,Line", 0, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 107, "Objects,Shapes,DiagonalLine", 1, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 150, "Objects,Shapes,DiagonalLine", 2, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 151, "Objects,Shapes,DiagonalLine", 3, true);
RegisteredObjects.Add(typeof(LineObject), "ReportPage,Shapes", 152, "Objects,Shapes,DiagonalLine", 4, true);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 108, "Objects,Shapes,Rectangle", 0);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 109, "Objects,Shapes,RoundRectangle", 1);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 110, "Objects,Shapes,Ellipse", 2);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 111, "Objects,Shapes,Triangle", 3);
RegisteredObjects.Add(typeof(ShapeObject), "ReportPage,Shapes", 131, "Objects,Shapes,Diamond", 4);
RegisteredObjects.Add(typeof(SubreportObject), "ReportPage", 104);
RegisteredObjects.Add(typeof(TableObject), "ReportPage", 127);
RegisteredObjects.Add(typeof(TableColumn), "", 215);
RegisteredObjects.Add(typeof(TableRow), "", 216);
RegisteredObjects.Add(typeof(TableCell), "", 214);
RegisteredObjects.Add(typeof(MatrixObject), "ReportPage", 142);
RegisteredObjects.Add(typeof(BarcodeObject), "ReportPage", 123);
RegisteredObjects.Add(typeof(RichObject), "ReportPage", 126);
RegisteredObjects.Add(typeof(CheckBoxObject), "ReportPage", 124);
RegisteredObjects.Add(typeof(MSChartObject), "ReportPage", 125);
RegisteredObjects.Add(typeof(MSChartSeries), "", 130);
RegisteredObjects.Add(typeof(ZipCodeObject), "ReportPage", 129);
RegisteredObjects.Add(typeof(CellularTextObject), "ReportPage", 121);
// RegisteredObjects.Add(typeof(CrossBandObject), "ReportPage", 11, "Cross-band line", 0);
// RegisteredObjects.Add(typeof(CrossBandObject), "ReportPage", 11, "Cross-band rectangle", 1);
// wizards
RegisteredObjects.AddWizard(typeof(BlankReportWizard), 134, "Wizards,BlankReport", false);
RegisteredObjects.AddWizard(typeof(InheritedReportWizard), 134, "Wizards,InheritedReport", false);
RegisteredObjects.AddWizard(typeof(StandardReportWizard), 133, "Wizards,StandardReport", false);
RegisteredObjects.AddWizard(typeof(LabelWizard), 133, "Wizards,Label", false);
RegisteredObjects.AddWizard(typeof(NewPageWizard), 135, "Wizards,NewPage", true);
RegisteredObjects.AddWizard(typeof(NewDialogWizard), 136, "Wizards,NewDialog", true);
RegisteredObjects.AddWizard(typeof(NewDataSourceWizard), 137, "Wizards,NewDataSource", true);
// exports
RegisteredObjects.AddExport(typeof(PDFExport), "Export,Pdf,File", 201);
RegisteredObjects.AddExport(typeof(RTFExport), "Export,RichText,File", 190);
RegisteredObjects.AddExport(typeof(HTMLExport), "Export,Html,File");
RegisteredObjects.AddExport(typeof(MHTExport), "Export,Mht,File");
RegisteredObjects.AddExport(typeof(XMLExport), "Export,Xml,File", 191);
RegisteredObjects.AddExport(typeof(Excel2007Export), "Export,Xlsx,File", 191);
RegisteredObjects.AddExport(typeof(PowerPoint2007Export), "Export,Pptx,File");
RegisteredObjects.AddExport(typeof(ODSExport), "Export,Ods,File");
RegisteredObjects.AddExport(typeof(ODTExport), "Export,Odt,File");
RegisteredObjects.AddExport(typeof(XPSExport), "Export,Xps,File");
RegisteredObjects.AddExport(typeof(CSVExport), "Export,Csv,File");
RegisteredObjects.AddExport(typeof(DBFExport), "Export,Dbf,File");
RegisteredObjects.AddExport(typeof(TextExport), "Export,Text,File");
RegisteredObjects.AddExport(typeof(ImageExport), "Export,Image,File");
#if false
RegisteredObjects.AddExport(typeof(Word2007Export), "Export,Docx,File");
#endif
// functions
RegisteredObjects.AddCategory("Functions", -1, "");
StdFunctions.Register();
}
public ClickHouseAssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(ClickHouseDataConnection));
}
public MySqlAssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(MySqlDataConnection));
}
public App()
{
RegisteredObjects.AddConnection(typeof(SqlCeDataConnection));
EventManager.RegisterClassHandler(typeof(TextBox), UIElement.KeyDownEvent, new KeyEventHandler(KeyDown));
EventManager.RegisterClassHandler(typeof(ComboBox), UIElement.KeyDownEvent, new KeyEventHandler(KeyDown));
}
public AssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(CassandraDataConnection));
}
public static IApplicationBuilder UseReport(this IApplicationBuilder app)
{
RegisteredObjects.AddConnection(typeof(MySqlDataConnection));
app.UseFastReport();
return(app);
}
public AssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(FirebirdDataConnection));
}
public AssemblyInitializer()
{
RegisteredObjects.AddConnection(typeof(PostgresDataConnection));
}
public static Reports GetReport(string dt, string reportName, string KIDro)
{
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
Reports webR = new Reports();
webR.report = new WebReport();
//webR.report.Dictionary.Connections[0].ConnectionString = spDAL.connStr;
//webR.report.Report.Dictionary.Connections[0].ConnectionString = spDAL.connStr;
/*
* MsSqlDataConnection _con = new MsSqlDataConnection();
* _con.ConnectionString = spDAL.connStr;
* _con.CreateAllTables();
* webR.report.Report.Dictionary.Connections.Add(_con);
*/
string _path = System.IO.Directory.GetCurrentDirectory();
_path = _path
+ System.IO.Path.DirectorySeparatorChar
+ "FastReports"
+ System.IO.Path.DirectorySeparatorChar
+ reportName
+ ".frx";
//_path = _path + "\\FastReports\\"+ reportName +".frx";
string m;
int y = 0;
// check the CtVet2 report
//
if (dt.Contains("/"))
{
//m = Int32.Parse(dt.Substring(5,1));
m = dt.Substring(5, 1);
y = Int32.Parse(dt.Substring(0, 4));
}
else
if (dt.Contains("-"))
{
m = dt.Substring(5, dt.Length - 5);
y = Int32.Parse(dt.Substring(0, 4));
}
else
{
//m = Int32.Parse(dt.Substring(0,2));
m = Int32.Parse(dt.Substring(0, 2)).ToString();
y = Int32.Parse(dt.Substring(3, 4));
}
RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
webR.report.ShowExcel2007Export = true;
webR.report.Report.Load(_path);
webR.report.Report.Dictionary.Connections[0].ConnectionString = spDAL.connStr;
webR.report.Report.SetParameterValue("yyyy", y);
webR.report.Report.SetParameterValue("mm", m);
webR.report.Report.SetParameterValue("idro", KIDro);
//webR.report.Report.Prepare();
webR.dt = dt;
webR.ReportName = reportName;
//TableDataSource table = webR.report.Report.GetDataSource("v1") as TableDataSource;
//table.SelectCommand = "";
return(webR);
}
