var result = from c in ds.Tables["pay"].AsEnumerable()
group c by c.Field<string> ("pay_type") into g
select new
{
type=g.Key ,
cash = g.Sum (c=>c.Field <decimal >("paying"))
};
foreach (var re in result)
{
switch (re.type)
{
case "现金":
MyModule.cash = re.cash.ToString ();
break ;
case "银行卡":
MyModule.bank = re.cash.ToString ();
break ;
case "网销":
MyModule.net = re.cash.ToString();
break ;
case "储值卡":
MyModule.card = re.cash.ToString();
break ;
}
group c by c.Field<string> ("pay_type") into g
select new
{
type=g.Key ,
cash = g.Sum (c=>c.Field <decimal >("paying"))
};
foreach (var re in result)
{
switch (re.type)
{
case "现金":
MyModule.cash = re.cash.ToString ();
break ;
case "银行卡":
MyModule.bank = re.cash.ToString ();
break ;
case "网销":
MyModule.net = re.cash.ToString();
break ;
case "储值卡":
MyModule.card = re.cash.ToString();
break ;
}