public void Sum4_CalculateRevenue每4個一組()
{
//arrange
var target = new Sum();
int SumSize = 4;
string SumField = "Revenue";
var products = new List<Record>() {
new Record() {Id=1, Cost=1, Revenue=11, SellPrice=21},
new Record() {Id=2, Cost=2, Revenue=12, SellPrice=22},
new Record() {Id=3, Cost=3, Revenue=13, SellPrice=23},
new Record() {Id=4, Cost=4, Revenue=14, SellPrice=24},
new Record() {Id=5, Cost=5, Revenue=15, SellPrice=25},
new Record() {Id=6, Cost=6, Revenue=16, SellPrice=26},
new Record() {Id=7, Cost=7, Revenue=17, SellPrice=27},
new Record() {Id=8, Cost=8, Revenue=18, SellPrice=28},
new Record() {Id=9, Cost=9, Revenue=19, SellPrice=29},
new Record() {Id=10, Cost=10, Revenue=20, SellPrice=30},
new Record() {Id=11, Cost=11, Revenue=21, SellPrice=31}
};
var expected = new List<int> { 50, 66, 60 };
//act
var actual = target.CalCostSum(SumSize, SumField, products);
//assert
CollectionAssert.AreEqual(expected, actual);
}
public void FieldSumInGroupByRowCountTest_4筆一組取Revenue總和()
{
//arrange
var target = new Sum();
var groupRowSize = 4;
var sumField = "Revenue";
var orders = new List<Order>()
{
new Order() { Id = 1, Cost = 1, Revenue = 11, SellPrice = 21 },
new Order() { Id = 2, Cost = 2, Revenue = 12, SellPrice = 22 },
new Order() { Id = 3, Cost = 3, Revenue = 13, SellPrice = 23 },
new Order() { Id = 4, Cost = 4, Revenue = 14, SellPrice = 24 },
new Order() { Id = 5, Cost = 5, Revenue = 15, SellPrice = 25 },
new Order() { Id = 6, Cost = 6, Revenue = 16, SellPrice = 26 },
new Order() { Id = 7, Cost = 7, Revenue = 17, SellPrice = 27 },
new Order() { Id = 8, Cost = 8, Revenue = 18, SellPrice = 28 },
new Order() { Id = 9, Cost = 9, Revenue = 19, SellPrice = 29 },
new Order() { Id = 10, Cost = 10, Revenue = 20, SellPrice = 30 },
new Order() { Id = 11, Cost = 11, Revenue = 21, SellPrice = 31 }
};
var expected = new int[] { 50, 66, 60 };
//act
var actual = target.FieldSumInGroupByRowCount<Order>(groupRowSize, sumField, orders);
//assert
CollectionAssert.AreEqual(expected, actual);
}
public void Sum4_CalculateRevenue每4個一組()
{
//arrange
var target = new Sum();
int SumSize = 4;
string SumField = "Revenue";
var products = new List <Record>()
{
new Record()
{
Id = 1, Cost = 1, Revenue = 11, SellPrice = 21
},
new Record()
{
Id = 2, Cost = 2, Revenue = 12, SellPrice = 22
},
new Record()
{
Id = 3, Cost = 3, Revenue = 13, SellPrice = 23
},
new Record()
{
Id = 4, Cost = 4, Revenue = 14, SellPrice = 24
},
new Record()
{
Id = 5, Cost = 5, Revenue = 15, SellPrice = 25
},
new Record()
{
Id = 6, Cost = 6, Revenue = 16, SellPrice = 26
},
new Record()
{
Id = 7, Cost = 7, Revenue = 17, SellPrice = 27
},
new Record()
{
Id = 8, Cost = 8, Revenue = 18, SellPrice = 28
},
new Record()
{
Id = 9, Cost = 9, Revenue = 19, SellPrice = 29
},
new Record()
{
Id = 10, Cost = 10, Revenue = 20, SellPrice = 30
},
new Record()
{
Id = 11, Cost = 11, Revenue = 21, SellPrice = 31
}
};
var expected = new List <int> {
50, 66, 60
};
//act
var actual = target.CalCostSum(SumSize, SumField, products);
//assert
CollectionAssert.AreEqual(expected, actual);
}
