var query=from sh in dbo.SwipeHistories
          join us in dbo.UserSwipeFlows  on  sh.PhysicsCardNo equals us.PhysicsCardNo
          join sf in dbo.ABFlowNodes  on us.CurrentFlowNode equals sf.ABFlowNodeID
          join sp in dbo.SwipePoints on sf.PointCode equals sp.PointCode 
          where sh.CreateDate==SwipeHistories.Where(a=>a.UserName== sh.UserName).Select(a=>a.CreateDate).Max()
          orderby sh.CreateDate
          select sh;

//代码手写，谨提供思路参考