linq 多表分组左连接查询查询统计
发布日期:2021-05-09 01:20:02 浏览次数:24 分类:博客文章

本文共 2349 字,大约阅读时间需要 7 分钟。

return (from merchantsInfo in base.GetIQueryable(x => x.IsLogicDelete == false && x.FID != fid)                    join userAccount in UserAccountDal.GetIQueryable(x => x.PrivilegeLevel > 0)                    on merchantsInfo.UserAccountID equals userAccount.FID                    join merchantsfrom in MerchantsInfoFormDAL.GetIQueryable(x => !x.IsLogicDelete)                    on merchantsInfo.FID equals merchantsfrom.MerchantsInfoID into data                    from merchants in data.DefaultIfEmpty()                    group new { merchants.MerchantsInfoID } by new                    {                        merchantsInfo.FID,                        merchantsInfo.Name,                        merchantsInfo.BrandLabel,                        merchantsInfo.MainPicture,                        merchantsInfo.MerchantsAmountMax,                        merchantsInfo.MerchantsAmountMin,                        merchantsInfo.MerchantsAmountType,                        merchantsInfo.ProjectName,                        merchantsInfo.BelongIndustry,                        merchantsInfo.BelongIndustryChild,                        merchantsInfo.MerchantsArea,                        merchantsInfo.MerchantsAreaCity,                        merchantsInfo.MerchantsAreaCitySubset,                        merchants.MerchantsInfoID                    } into g                    select new MerchantsModel                    {                        FID = g.Key.FID,                        Name = g.Key.Name,                        BrandLabel = g.Key.BrandLabel,                        MainPicture = g.Key.MainPicture,                        MerchantsAmountMax = g.Key.MerchantsAmountMax,                        MerchantsAmountMin = g.Key.MerchantsAmountMin,                        MerchantsAmountType = g.Key.MerchantsAmountType,                        ProjectName = g.Key.ProjectName,                        BelongIndustry = g.Key.BelongIndustry,                        BelongIndustryChild = g.Key.BelongIndustryChild,                        MerchantsArea = g.Key.MerchantsArea,                        MerchantsAreaCity = g.Key.MerchantsAreaCity,                        MerchantsAreaCitySubset = g.Key.MerchantsAreaCitySubset,                        ApplyNum = g.Key.MerchantsInfoID == null ? 0 : g.Count()                    }).Take(row).ToList();

 

上一篇:多线程之旅(准备阶段)
下一篇:Expression表达式目录树

发表评论

最新留言

逛到本站,mark一下
[***.202.152.39]2025年05月04日 06时09分40秒