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;
}
}
public void 使用内置特性的异常信息()
{
Assert.ThrowsException <ArgumentException>(() => Sample07.Run <Sample07.ExcelModel2>());
try
{
Sample07.Run <Sample07.ExcelModel2>();
}
catch (Exception ex)
{
Assert.AreEqual(ex.Message, $@"无效的单元格:C6");
Assert.AreEqual(ex.InnerException.Message, $@"张三5的性别'其他'填写不正确");
}
}
public void 未使用内置特性的异常信息()
{
Assert.ThrowsException <ArgumentException>(() => Sample07.Run <Sample07.ExcelModel>());
try
{
Sample07.Run <Sample07.ExcelModel>();
}
catch (Exception ex)
{
Assert.AreEqual(ex.Message, $@"无效的单元格:C6");
Assert.AreEqual(ex.InnerException.Message, $@"未找到请求的值“其他”。");
}
}
public void TestMethod1()
{
var excelList = Sample07.Run <Sample07.ExcelModel>();
var resultList = excelList.GetEmpty().ToList();
resultList.Add(new Sample07.ExcelModel {
序号 = 1, 字 = "张三1", 性别 = Sample07.Gender.男, 出生日期 = Convert.ToDateTime("1999/9/9"), 身份证号码 = "11111111111111111", 年龄 = 15
});
resultList.Add(new Sample07.ExcelModel {
序号 = 2, 字 = "张三2", 性别 = Sample07.Gender.女, 出生日期 = Convert.ToDateTime("1999/9/9"), 身份证号码 = "11111111111111111", 年龄 = 16
});
resultList.Add(new Sample07.ExcelModel {
序号 = 3, 字 = "张三3", 性别 = Sample07.Gender.未知, 出生日期 = Convert.ToDateTime("1999/9/9"), 身份证号码 = "11111111111111111", 年龄 = 17
});
resultList.Add(new Sample07.ExcelModel {
序号 = 4, 字 = "张三4", 性别 = null, 出生日期 = Convert.ToDateTime("1999/9/9"), 身份证号码 = "11111111111111111", 年龄 = 18
});
resultList.Add(new Sample07.ExcelModel {
序号 = 5, 字 = "张三5", 性别 = null, 出生日期 = Convert.ToDateTime("1999/9/9"), 身份证号码 = "11111111111111111", 年龄 = 19
});
CollectionAssert.AreEqual(excelList, resultList);
}
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();
}
