| | |
| | | |
| | | join zz in _context.CooperatecustomCustomers |
| | | on a.Viscustomer equals zz.Id |
| | | |
| | | //join g in _context.Areas on zz.Sheng equals g.CodeId |
| | | //join h in _context.Areas on zz.City equals h.CodeId |
| | | //join i in _context.Areas on zz.AreaId equals i.CodeId |
| | | |
| | | //join g in _context.Areas on zz.Sheng equals g.CodeId |
| | | //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() |
| | | |
| | | |
| | | where a.RecStatus == "A" |
| | |
| | | Jy = a.Jy, |
| | | Creater = a.Creater, |
| | | Createtime = a.Createtime, |
| | | |
| | | CreaterName = zzzzz.UserName, |
| | | RecStatus = a.RecStatus, |
| | | Modifier = a.Modifier, |
| | | Modifytime = a.Modifytime, |