Example #1
0
        public void TestMethod1()
        {
            var dataSource = new Dictionary <string, long?>();

            dataSource.Add("事业1部", 1);
            dataSource.Add("事业2部", 2);
            dataSource.Add("事业3部", null);

            var excelList  = Sample05.Run(dataSource);
            var resultList = excelList.GetEmpty().ToList();

            resultList.Add(new Sample05.ExcelModel {
                序号 = 1, 部门 = new KV <string, long?>("事业1部", 1), 部门2 = new KV <string, long?>("事业1部", 1)
            });
            resultList.Add(new Sample05.ExcelModel {
                序号 = 2, 部门 = new KV <string, long?>("事业2部", 2), 部门2 = new KV <string, long?>("111")
            });
            resultList.Add(new Sample05.ExcelModel {
                序号 = 3, 部门 = new KV <string, long?>("事业3部", null), 部门2 = new KV <string, long?>("222")
            });

            var index = 2;
            var a     = excelList[index];
            var b     = resultList[index];

            CollectionAssert.AreEqual(excelList, resultList);
        }
Example #2
0
        static void Main(string[] args)
        {
            string demo = "Sample11";

            switch (demo)
            {
            case "Sample1": Sample01.Demo();
                break;

            case "Sample2": Sample02.Demo();
                break;

            case "Sample3":
                Sample03.Demo();
                break;

            case "Sample4":
                Sample04.Demo();
                break;

            case "Sample5":
                Sample05.Demo();
                break;

            case "Sample6":
                Sample06.Demo();
                break;

            case "Sample7":
                Sample07.Demo();
                break;

            case "Sample8":
                Sample08.Demo();
                break;

            case "Sample9":
                Sample09.Demo();
                break;

            case "Sample10":
                Sample10.Demo();
                break;

            case "Sample11":
                Sample11.Demo();
                break;

            default:
                break;
            }
        }
Example #3
0
        public void 数据源缺少事业2部_会异常()
        {
            var dataSource = new Dictionary <string, long?>();

            dataSource.Add("事业1部", 1);
            //dataSource.Add("事业2部", 2);
            dataSource.Add("事业3部", null);
            Assert.ThrowsException <ArgumentException>(() => Sample05.Run(dataSource));
            try
            {
                Sample05.Run(dataSource);
            }
            catch (Exception ex)
            {
                Assert.AreEqual(ex.Message, $@"'事业2部'在数据库中未找到
参数名: 部门");
            }
        }
Example #4
0
    private void CreateGUI()
    {
        var root = rootVisualElement;

        root.styleSheets.Add(styleSheet);
        visualTree.CloneTree(root);
        root.Bind(new SerializedObject(this));

        root.Q <Button>("sample01").clicked += async() =>
        {
            var ret = await Sample01.OnClick(out code);

            result = $"{ret}";
        };

        root.Q <Button>("sample02").clicked += async() =>
        {
            var ret = await Sample02.OnClick(out code);

            result = $"{ret}";
        };

        root.Q <Button>("sample03").clicked += async() =>
        {
            var ret = await Sample03.OnClick(out var c, out var globals);

            code   = $"{c}, {globals}";
            result = $"{ret}";
        };

        root.Q <Button>("sample04").clicked += () =>
        {
            result = Sample04.OnClick(out code);
        };

        root.Q <Button>("sample05").clicked += () =>
        {
            var ret = Sample05.OnClick(out code);
            result = string.Join("\n", ret.Select(e => e.Name));
        };
    }
Example #5
0
        static void Main(string[] args)
        {
            Console.Title = Constants.AppName;

            ILogger logger = new Logger(Constants.AppName, new ILog[] { new FileLog(), new ColoredConsoleLog() })
            {
                Deep = LogDeep.OnlyApplicationCalls, Status = LogStatus.Running
            };

            logger.Debug(">Start Logging<");

            // 01. Generate sample 01
            logger.Info("");
            logger.Info("> Shows the use of how creates a report");
            Sample01.Generate(logger);

            // 02. Generate sample 02
            logger.Info("");
            logger.Info("> Shows the use of how creates a report with minicharts");
            Sample02.Generate(logger);

            // 03. Generate sample 03
            logger.Info("");
            logger.Info("> Shows the use of how creates a report with minicharts and conditional inserts");
            Sample03.Generate(logger);

            // 04. Generate sample 04
            logger.Info("");
            logger.Info("> Shows the use of how serialize and deserialize global settings, styles, pictures, shapes and mini-charts");
            Sample04.Generate(logger);

            // 05. Generate sample 05
            logger.Info("");
            logger.Info("> Shows the use of how insert an autofilter");
            Sample05.Generate(logger);

            // 06. Generate sample 06
            logger.Info("");
            logger.Info("> Shows how to use insert datatable and generic collections");
            Sample06.Generate(logger);

            // 07. Generate sample 07
            logger.Info("");
            logger.Info("> Shows how to insert a pictures");
            Sample07.Generate(logger);

            // 08. Generate sample 08
            logger.Info("");
            logger.Info("> Shows how to insert a shapes with shape effects");
            Sample08.Generate(logger);

            // 09. Generate sample 09
            logger.Info("");
            logger.Info("> Shows how to insert an image from uri (stream)");
            Sample09.Generate(logger);

            // 10. Generate sample 10
            logger.Info("");
            logger.Info("> Shows how to insert a pictures with shape effects");
            Sample10.Generate(logger);

            // 11. Generate sample 11
            logger.Info("");
            logger.Info(">  Shows how to copy ranges");
            Sample11.Generate(logger);

            // 12. Generate sample 12
            logger.Info("");
            logger.Info(">  Shows how to transpose a range of data");
            Sample12.Generate(logger);

            // 13.Generate sample 13
            logger.Info("");
            logger.Info(">  Shows how to use aggregate functions with a data range");
            Sample13.Generate(logger);

            // 14.Generate sample 14
            logger.Info("");
            logger.Info(">  Shows the use stacked charts");
            Sample14.Generate(logger);

            // 15.Generate sample 15
            logger.Info("");
            logger.Info(">  Shows the use charts with more than one chart type and secondary axis");
            Sample15.Generate(logger);

            logger.Info("");
            logger.Debug(">End Logging<");
            Console.ReadKey();
        }
Example #6
0
        static void Main(string[] args)
        {
            Console.Title = Constants.AppName;

            ILogger logger = new Logger(Constants.AppName, new ILog[] { new FileLog(), new ColoredConsoleLog() })
            {
                Deep = LogDeep.OnlyApplicationCalls, Status = LogStatus.Running
            };

            logger.Debug(">Start Logging<");

            // 01. Generate sample 01 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 01");
            logger.Info(" > Shows the use of text and image replacement");
            Sample01.Generate(logger);

            // 02. Generate sample 02 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 02");
            logger.Info(" > Shows the use of html table replacement in a pdf document");
            Sample02.Generate(logger);

            // 03. Generate sample 03 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 03");
            logger.Info(" > Shows the use of merge action");
            Sample03.Generate(logger);

            // 04. Generate sample 04 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 04");
            logger.Info(" > Shows the header replacement after merge action");
            Sample04.Generate(logger);

            // 05. Generate sample 05 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 05");
            logger.Info(" > Shows the use of System Tags such as page number");
            Sample05.Generate(logger);

            // 06. Generate sample 06 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 06");
            logger.Info(" > Shows the use of test mode");
            Sample06.Generate(logger, useTestMode: YesNo.Yes);

            // 07.Generate sample 07 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 07");
            logger.Info(" > Shows the use of save as zip a input with user-defined filename");
            Sample07.Generate(logger);

            // 08. Generate sample 08 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 08");
            logger.Info(" > Shows the use of save as zip merged output");
            Sample08.Generate(logger);

            // 09. Generate sample 09 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 09");
            logger.Info(" > Shows the use of compression threshold (>2MB) when merge and zip files (NO zipped)");
            Sample09.Generate(logger);

            // 10.Generate sample 10 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 10");
            logger.Info(" > Shows the use of save as zip a input with random name");
            Sample10.Generate(logger);

            // 12. Generate sample 12 report
            logger.Info("");
            logger.Info("> Start Pdf Sample 12");
            logger.Info(" >  Shows the use of how serialize and deserialize text, image and table styles");
            Sample12.Generate(logger);

            logger.Info("");
            logger.Debug(">End Logging<");
            Console.ReadKey();
        }