Создание отчетов и дашбордов | Форум пользователей Stimulsoft

Код: Выделить всё

using System;
using System.Windows.Forms;
using System.Collections;
using System.Data;
using Stimulsoft.Report;
using Stimulsoft.Report.Dictionary;

namespace ReportStimul
{
    public static class Report
    {
        private static string ReportFilesPath;
        private static string ConnectionString;

        public static object RecordSet;
        public static Hashtable Fields;

        public static void Init(string ConnectionString)
        {
            Report.ConnectionString = ConnectionString;
            ReportFilesPath = System.IO.Directory.GetCurrentDirectory();
            StiConfig.LoadLocalization(ReportFilesPath + @"\ru.xml");
            Fields = new Hashtable();
        }

        public static void Generate(string ReportName, bool ShowPreview, bool LoadOnce)
        {
            try
            {
                using (StiReport report = StiReport.GetReportFromAssembly(ReportFilesPath + ReportName + ".dll", LoadOnce))
                {
                    if (RecordSet != null)
                    {
                        if (RecordSet is DataSet) report.RegData(RecordSet as DataSet);
                        else if (RecordSet is DataTable) report.RegData(RecordSet as DataTable);
                        else if (RecordSet is DataView) report.RegData(RecordSet as DataView);
                    }
                    else
                    {
                        report.Dictionary.Databases.Clear();
                        report.Dictionary.Databases.Add(new StiSqlDatabase("Connection", ConnectionString));
                    }
                    if (Fields.Count > 0)
                    {
                        foreach (DictionaryEntry de in Fields)
                        {
                            if (de.Value != null) report[de.Key.ToString()] = de.Value;
                        }
                    }
                    if (ShowPreview)
                    {
                        report.Show(true);
                    }
                    else
                    {
                        report.Print(false);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex);
            }
            finally
            {
                RecordSet = null;
                Fields.Clear();
            }
        }
    }
}