| | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | join k in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A") |
|---|
| | | join k in _context.PltUsers.Where(x => x.RecStatus == "A") |
|---|
| | | on a.UserId equals k.Id |
|---|
| | | into ksssss |
|---|
| | | from kkk in ksssss.DefaultIfEmpty() |
|---|
| | |
|---|
| | | |
|---|
| | | //if (searchEntity.totalrows == 0) |
|---|
| | | searchEntity.totalrows = query.Count(); |
|---|
| | | data.Heji1 = Math.Round(query.Sum(x => x.Gongzi) ?? 0, 2); |
|---|
| | | data.Heji2 = Math.Round(query.Sum(x => x.Shuliang ?? 0), 2); |
|---|
| | | var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); |
|---|
| | | data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.Gongzi) ?? 0, 2); |
|---|
| | | data.DangyeHeji2 = Math.Round(lianlist.Sum(x => x.Shuliang ?? 0), 2); |
|---|
| | | data.LoadData(searchEntity, lianlist); |
|---|
| | | return data; |
|---|
| | | } |
|---|
