| | |
|---|
| | | } |
|---|
| | | 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 |
|---|
| | | { |
|---|
