8,497
社区成员
发帖
与我相关
我的任务
分享
var data = (from a in context.WF_PROC_INSTS
join b in context.WF_MANUAL_WORKITEMS on a.PROC_INST_ID equals b.PROC_INST_ID into g
from b in g.OrderByDescending(x=>x.CreateDate).First()
where b.CurrentUser=="xiaoming"
join c in context.WF_ACTIVITY_INSTS on b.ACTIVITY_INST_ID equals c.ID
orderby a.STARTED_DATE descending
select new { StartDate = a.STARTED_DATE}).Skip((entity.PageCount - 1) * entity.PageSize).Take(entity.PageSize);