FastReport.NET 2023使用DataTable报表数据源配置JsonDataSourceConnection连接|C/S开发框架|C/S框架网

FastReport.NET 2023使用DataTable报表数据源配置JsonDataSourceConnection连接|C/S开发框架

作者:csframework|C/S框架网发布日期:2024/10/20 11:52:39

FastReport.NET 2023使用DataTable报表数据源配置JsonDataSourceConnection连接|C/S开发框架

FastReport.NET 2023使用DataTable报表数据源配置JsonDataSourceConnection连接

JsonDataSourceConnection 参考代码

C# 全选

        private void InitDataSource(Report report, DataSet demoData)
        {
            //生成一个本地json文件
            var json = Newtonsoft.Json.JsonConvert.SerializeObject(demoData.Tables[0]);
            var jsonFile = Path.Combine(Application.StartupPath, "demo.json");
            File.WriteAllText(jsonFile, json, System.Text.Encoding.UTF8);

            //生成报表数据源            
            RegisteredObjects.AddConnection(typeof(JsonDataSourceConnection));
            JsonDataSourceConnection connection = new JsonDataSourceConnection();
            connection.ConnectionString = "Json=" + jsonFile;
            //connection.CreateAllTables();
            report.Dictionary.Connections.Add(connection);

            //注册数据源                        
            report.RegisterData(demoData.Tables[0], "M");
            var ds = report.GetDataSource("M");
            (report.GetDataSource("M") as TableDataSource).Enabled = true; //重要

            //给DataBand(主表数据)绑定数据源
            DataBand masterBand = report.FindObject("Data1") as DataBand;
            masterBand.DataSource = report.GetDataSource("M"); //主表

            report.Parameters.FindByName("pReportTitle").Value = $"C/S开发框架报表生成器 by {_wizard.ReportControlType}";
            report.Parameters.FindByName("pPrintUser").Value = "C/S框架网(admin)";
            report.Parameters.FindByName("pPrintTime").Value = DateTime.Now;

        }