public void TestMethod1()
{
var excelList = Sample12.Run <Sample12.ExcelModel1>(true);
var resultList = excelList.GetEmpty().ToList();
resultList.Add(new Sample12.ExcelModel1
{
序号 = 1,
姓名 = "娃娃",
班级 = "1",
JanuaryStatistics = 4,
FebruaryStatistics = 7
});
resultList.Add(new Sample12.ExcelModel1
{
序号 = 2,
姓名 = "菲菲",
班级 = "2班",
JanuaryStatistics = 5,
FebruaryStatistics = 8
});
resultList.Add(new Sample12.ExcelModel1
{
序号 = 3,
姓名 = "佩琪",
班级 = "2班",
JanuaryStatistics = 6,
FebruaryStatistics = 9
});
CollectionAssert.AreEqual(excelList, resultList);
}
public void 应该抛异常()
{
Assert.ThrowsException <Exception>(() => Sample12.Run <Sample12.ExcelModel2>(true));
try
{
Sample12.Run <Sample12.ExcelModel2>(true);
}
catch (Exception ex)
{
// Assert.AreEqual(ex.Message, $@"程序报错:Message:
//无效的数字
//参数名: 姓名(B列)
//");
Assert.AreEqual(ex.Message, $@"程序报错:Message:
无效的数字
参数名: 姓名(B列),
无效的数字
参数名: 班级(C列)
");
}
try
{
Sample12.Run <Sample12.ExcelModel2>(false);
}
catch (Exception ex)
{
// Assert.AreEqual(ex.Message, $@"程序报错:Message:
//无效的数字
//参数名: 姓名(B3,B4,B5)
//");
Assert.AreEqual(ex.Message, $@"程序报错:Message:
无效的数字
参数名: 姓名(B3,B4,B5),
无效的数字
参数名: 班级(C4,C5)
");
}
}
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();
}
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();
}
