项目实战之服务端分页的实现——SQL
CREATE Procedure AppGetEmpList@EID int,
@LGID int,
@pagesize int,
@pageindex int
As
Begin
select count(*) count from appemployee
Select a.ID,a.EID,Case When @LGID=2052 Then Name Else eName End Name,DepTitle,JobTitle
,Case When b.xEID is null Then 0 Else 1 End Fav
,Case When Isnull(a.Reportto,0)=@EID Then 1 Else 0 End IsSub
From (select row_number() over(order by left(a.ename,1))> From appemployee a
Where a.LGID=@LGID and Isnull(a.Status,0)4) a
Left Join AppEmpFavorites b on a.EID=b.EID and b.xEID=@EID
where a.ID between (@pageindex-1)*@pagesize+1 and @pageindex*@pagesize
End
页:
[1]