
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();
发表评论
最新留言
逛到本站,mark一下
[***.202.152.39]2025年05月04日 06时09分40秒
关于作者

喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
推荐文章
"WARNING: Increasing RAM size to 1GB" and "Cannot set up guest memory 'xxx.ram': Invalid argument".
2023-01-23
#if 0 #elif 1 #else #endif 用法
2023-01-23
#include <gdiplus.h>出错
2023-01-23
$ajax({}).done 和 $ajax({}) success 区别
2023-01-23
(反射+内省机制的运用)处理jdbc的结果集
2023-01-23
(反射+内省机制的运用)简单模拟spring IoC容器的操作
2023-01-23
(转)SQLServer全局变量
2023-01-23
(转)tomcat7.0 manager app和host manager web管理
2023-01-23
(转)【英雄会即时报道】五大CTO畅谈软件公司如何招聘技术人才
2023-01-23
(转)使用公用表表达式的递归查询(SQLSERVER2005)
2023-01-23
(转)在CListView列表视图中添加右键菜单的方法
2023-01-23
(转)考虑错误情况
2023-01-23
++b&&a--运算结果解析
2023-01-23
.Net(C#)实现异步编程
2023-01-23
.Net中webBrowser控件JS交互
2023-01-23
.Net中webBrowser控件指定IE版本
2023-01-23
0-1背包问题:贪心算法与动态规划的比较
2023-01-23
C++ switch混淆
2023-01-23