使用实体框架或linq显示记录

查询应该类似于:

var res = from x in MyTable
          group x by x.voucher_Date into y
          select new 
          { 
              Voucher_Date = y.Voucher_Date, 
              Sale = y.Sum(z => z.Voucher_type == "sale" ? z.Total : 0),
              Purchase = y.Sum(z => z.Voucher_type == "purchase" ? z.Total : 0),
          }

注意,我不确定EF是否支持 Sum 我用过。

等效的SQL查询应为:

SELECT Voucher_Date,
       SUM(CASE WHEN Voucher_type = 'sale' THEN Total ELSE 0 END) Sale,
       SUM(CASE WHEN Voucher_type = 'purchase' THEN Total ELSE 0 END) Purchase
       FROM MyTable
       GROUP BY voucher_Date

您必须将记录分组 Voucher_Date 然后根据 Voucher_Type 是的 sale 或 purchase :

var result = from v in db.Vouchers
             group v by v.Voucher_Date into g
             select new
                 {
                  Date = g.Key,
                  Sale = g.Where(x=>x.Voucher_Type == "sale").Sum(y=y.Total),
                  Purchase = g.Where(x=>x.Voucher_Type == "purchase").Sum(x=>x.Total)
                 }