| | |
|---|
| | | from kkk in ksssss.DefaultIfEmpty() |
|---|
| | | |
|---|
| | | join h in _context.HrDepts.Where(x => x.RecStatus == "A" && x.QiyongStatus == "A") |
|---|
| | | on kkk.DeptId equals h.Id |
|---|
| | | on a.DeptId equals h.Id |
|---|
| | | into hsss |
|---|
| | | from hhh in hsss.DefaultIfEmpty() |
|---|
| | | |
|---|
| | |
|---|
| | | where a.RecStatus == "A" |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.WorkTime) || (a.WorkTime >= WorkTimestart && a.WorkTime <= WorkTimeend)) |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.PayType) || ccc.Pieceratetype == searchEntity.PayType.Trim()) |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.DeptId) || kkk.DeptId == searchEntity.DeptId.Trim()) |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.DeptId) || a.DeptId == searchEntity.DeptId.Trim()) |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.UserName) || kkk.UserName.Contains(searchEntity.UserName.Trim())) |
|---|
| | | |
|---|
| | | |
|---|
