private static void SubTotal(DataTable dt)
{
DataTable newDt = new DataTable();
newDt = dt.Clone();
var products = dt.AsEnumerable();
try
{
var sumquery = from product in products
group product by new
{
Col1 = product.Field<string>("Date"),
} into g
select new
{
Sum = g.Sum(product => product.Field<Int64>("Sum")),
Gender = g.Sum(product => product.Field<Int16>("Gender")),
};
var totalsumquery = from product in products
group product by new
{
} into g
select new
{
Sum = g.Sum(product => product.Field<Int64>("Sum")),
Gender = g.Sum(product => product.Field<Int16>("Gender")),
};
foreach (var sumData in sumquery)
{
DataRow dr = newDt.NewRow();
dr["Date"] = "[¼Ò °è]";
dr["Sum"] = sumData.Sum;
dr["Gender"] = sumData.Gender;
newDt.Rows.Add(dr);
}
foreach (var sumData in totalsumquery)
{
DataRow dr = newDt.NewRow();
dr["Date"] = "[ÇÕ °è]";
dr["Sum"] = sumData.Sum;
dr["Gender"] = sumData.Gender;
newDt.Rows.Add(dr);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
dt.Merge(newDt);
}
ÀÌ ¸Þ¼Òµå¸¦ ÅëÇؼ
±â°£ ÃÑ±Ý¾× ¼ºº°
2020³â 2¿ù 500 ³²
2020³â 2¿ù 600 ¿©
2020³â 3¿ù 100 ³²
2020³â 3¿ù 900 ¿©
ÀÌ·± Å×ÀÌºí¿¡¼
±â°£ ÃÑ±Ý¾× ¼ºº°
2020³â 2¿ù 500 ³²
2020³â 2¿ù 600 ¿©
[¼Ò °è] 1100
2020³â 3¿ù 100 ³²
2020³â 3¿ù 900 ¿©
[¼Ò °è] 1000
[ÇÕ °è] 2200
ÀÌ·± Å×À̺í·Î ¸¸µé°í ½ÍÀºµ¥
±â°£ ÃÑ±Ý¾× ¼ºº°
2020³â 2¿ù 500 ³²
2020³â 2¿ù 600 ¿©
2020³â 3¿ù 100 ³²
2020³â 3¿ù 900 ¿©
[¼Ò °è] 1100
[¼Ò °è] 1000
[ÇÕ °è] 2200
ÀÌ·¸°Ô¸¸ ³ª¿À´Âµ¥ ¹æ¹ýÀÌ ÀÖÀ»±î¿ä?
|