From a8b475881959d4a88d821951a615f03e7d0d1725 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期四, 07 八月 2025 13:28:30 +0800 Subject: [PATCH] feat:字典优化 --- FlexJobApi.User.Application/Enterprises/Queries/EnterprisesQueryHandler.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/FlexJobApi.User.Application/Enterprises/Queries/EnterprisesQueryHandler.cs b/FlexJobApi.User.Application/Enterprises/Queries/EnterprisesQueryHandler.cs index a8917d7..fdece96 100644 --- a/FlexJobApi.User.Application/Enterprises/Queries/EnterprisesQueryHandler.cs +++ b/FlexJobApi.User.Application/Enterprises/Queries/EnterprisesQueryHandler.cs @@ -50,11 +50,11 @@ } var s = (from e in q join a in repEnterpriseAuth.AsQueryable().AsNoTracking() on e.EnterpriseAuthId equals a.Id - join p in repDictionaryData.AsQueryable().AsNoTracking() on e.ProvinceId equals p.Id into pg + join p in repDictionaryData.AsQueryable().AsNoTracking() on e.ProvinceCode equals p.Code into pg from pgi in pg.DefaultIfEmpty() - join c in repDictionaryData.AsQueryable().AsNoTracking() on e.CityId equals c.Id into cg + join c in repDictionaryData.AsQueryable().AsNoTracking() on e.CityCode equals c.Code into cg from cgi in cg.DefaultIfEmpty() - join i in repDictionaryData.AsQueryable().AsNoTracking() on e.IndustryTypeId equals i.Id into ig + join i in repDictionaryData.AsQueryable().AsNoTracking() on e.IndustryTypeCode equals i.Code into ig from igi in ig.DefaultIfEmpty() select new GetEnterprisesQueryResultItem { -- Gitblit v1.9.1