-
Notifications
You must be signed in to change notification settings - Fork 270
/
LoadFromCollectionSortOrderAttributeTests.cs
134 lines (117 loc) · 4.07 KB
/
LoadFromCollectionSortOrderAttributeTests.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
using Microsoft.VisualStudio.TestTools.UnitTesting;
using OfficeOpenXml;
using OfficeOpenXml.Attributes;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace EPPlusTest.LoadFunctions
{
[TestClass]
public class LoadFromCollectionSortOrderAttributeTests
{
[EPPlusTableColumnSortOrder(Properties = new string[] { nameof(Name), nameof(Obj), nameof(Id) })]
[EpplusTable]
public class Outer
{
[EpplusTableColumn]
public int Id { get; set; }
[EpplusNestedTableColumn]
public Inner Obj { get; set; }
[EpplusTableColumn]
public string Name { get; set; }
}
[EPPlusTableColumnSortOrder(Properties = new string[] { nameof(Name), nameof(Id) })]
public class Inner
{
[EpplusTableColumn]
public int Id { get; set; }
[EpplusTableColumn]
public string Name { get; set; }
}
[EPPlusTableColumnSortOrder(Properties = new string[] { nameof(Name), nameof(Obj), nameof(Id) })]
[EpplusTable]
public class Outer2
{
[EpplusTableColumn]
public int Id { get; set; }
[EpplusNestedTableColumn]
public Inner2 Obj { get; set; }
[EpplusTableColumn]
public string Name { get; set; }
}
[EPPlusTableColumnSortOrder(Properties = new string[] { nameof(Name), nameof(Id), nameof(Email) })]
public class Inner2
{
[EpplusTableColumn]
public int Id { get; set; }
[EpplusTableColumn]
public string Name { get; set; }
[EpplusNestedTableColumn]
public InnerEmail Email { get; set; }
}
[EPPlusTableColumnSortOrder(Properties = new string[] { nameof(Email), nameof(Id) })]
public class InnerEmail
{
[EpplusTableColumn]
public int Id { get; set; }
[EpplusTableColumn]
public string Email { get; set; }
}
[TestMethod]
public void SortBySortorderAttribute1()
{
var outer = new Outer
{
Id = 1,
Obj = new Inner
{
Id = 2,
Name = "Inner"
},
Name = "Outer"
};
var items = new List<Outer> { outer };
using (var package = new ExcelPackage())
{
var sheet = package.Workbook.Worksheets.Add("Sheet 1");
sheet.Cells["A1"].LoadFromCollection(items);
Assert.AreEqual("Outer", sheet.Cells["A1"].Value);
Assert.AreEqual("Inner", sheet.Cells["B1"].Value);
Assert.AreEqual(2, sheet.Cells["C1"].Value);
Assert.AreEqual(1, sheet.Cells["D1"].Value);
}
}
[TestMethod]
public void SortBySortorderAttribute2()
{
var outer = new Outer2
{
Id = 1,
Obj = new Inner2
{
Id = 2,
Name = "Inner",
Email = new InnerEmail
{
Id = 3,
Email = "[email protected]"
}
},
Name = "Outer"
};
var items = new List<Outer2> { outer };
using (var package = new ExcelPackage())
{
var sheet = package.Workbook.Worksheets.Add("Sheet 1");
sheet.Cells["A1"].LoadFromCollection(items);
Assert.AreEqual("Outer", sheet.Cells["A1"].Value);
Assert.AreEqual("Inner", sheet.Cells["B1"].Value);
Assert.AreEqual(2, sheet.Cells["C1"].Value);
Assert.AreEqual("[email protected]", sheet.Cells["D1"].Value);
Assert.AreEqual(3, sheet.Cells["E1"].Value);
Assert.AreEqual(1, sheet.Cells["F1"].Value);
}
}
}
}