| | |
| | | join h in _context.Areas on zz.City equals h.CodeId |
| | | join i in _context.Areas on zz.AreaId equals i.CodeId |
| | | |
| | | join zzz in _context.PltUsers.Where(x => x.RecStatus == "A") |
| | | on a.Creater equals zzz.Id |
| | | into zsssss |
| | | from zzzzz in zsssss.DefaultIfEmpty() |
| | | |
| | | |
| | | |
| | | |
| | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.City) || zz.City == searchEntity.City.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || zz.AreaId == searchEntity.AreaId.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Viscustomer) || a.Viscustomer == searchEntity.Viscustomer.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Creater) || zz.Creater == searchEntity.Creater.Trim()) |
| | | select new IntentionVisitDTO |
| | | { |
| | | Id = a.Id, |
| | |
| | | Talk = a.Talk, |
| | | Khfk = a.Khfk, |
| | | Yx = a.Yx, |
| | | CreaterName = zzzzz.UserName, |
| | | |
| | | Jy = a.Jy, |
| | | Creater = a.Creater, |