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); }