| | |
| | | |
| | | join d in _context.WfApplytypes |
| | | on k.Applytiye equals d.Applyno |
| | | into dsssss |
| | | from ddd in dsssss.DefaultIfEmpty() |
| | | |
| | | join b in _context.PltUsers |
| | | on k.Creater equals b.Id |
| | |
| | | Applyno = k.Applyno, |
| | | CreaterName = b.UserName, |
| | | DeptName = c.DeptName, |
| | | Applytiye = d.Applytiye, |
| | | Applytiye = ddd.Applytiye, |
| | | Content = k.Content, |
| | | ShenpiStatusName = eee.Comments, |
| | | Resivetime = a.Resivetime, |
| | |
| | | Modifytime = a.Modifytime, |
| | | |
| | | } |
| | | ).OrderBy(x => x.Sort).ThenByDescending(x => x.Resivetime).ToList(); |
| | | ).OrderByDescending(x=>x.Applyno).ThenBy(x => x.Sort).ThenByDescending(x => x.Resivetime).ToList(); |
| | | |
| | | |
| | | |
| | | if (searchEntity.totalrows == 0) |
| | | //if (searchEntity.totalrows == 0) |
| | | searchEntity.totalrows = query.Count(); |
| | | var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); |
| | | data.LoadData(searchEntity, lianlist); |