• linq group by


    var linqResult = from c in Result.AsEnumerable()
    group c by new
    {

    a = c.site_address_apartment,
    b = c.deli_dt

    } into s
    select new CommunityAnalysisVO
    {
    deli_dt=s.Select(p=>p.deli_dt).First(),
    site_address_apartment=s.Select(p=>p.site_address_apartment).First(),
    deli_per=s.Sum(p=>p.deli_per),
    fist_deli=s.Sum(p=>p.fist_deli),
    deli_weight=s.Sum(p=>p.deli_weight),
    deli_amount=s.Sum(p=>p.deli_amount),

    };

    Result.GroupBy(a => new { a.deli_dt, a.deli_per }).Select(b=>new CommunityAnalysisVO{
    deli_dt=b.Select(ee=>ee.deli_dt).First(),
    deli_per=b.Sum(ee=>ee.deli_per)

    }
    );

  • 相关阅读:
    申请加分项
    课程评价
    本周总结
    热词2
    热词1
    php大作业
    css网格布局
    php实验4
    本周总结
    css边框图像
  • 原文地址:https://www.cnblogs.com/zengpeng/p/10431972.html
Copyright © 2020-2023  润新知