求吴旗娃分页控件如何传多个参数

------------------------------------

--用途：读取招聘推荐信息(用于分页) 

--项目名称：

--说明：

--时间：wk by 2007-4-27 9:54:43

------------------------------------



CREATE  procedure SearchBase_GetPageZPInfo_fy

(

@ZPDL VarChar(10),

@CityBh VarChar(10),

@LinkType VarChar(10),

@Keyboard VarChar(100),

@pagesize int,

@pageindex int,

@docount bit)

as

set nocount on

declare @PageLowerBound int

declare @PageUpperBound int

declare @SQL VarChar(1000)

declare @wheretj VarChar(1000)

declare @insstr VarChar(1000)

set @SQL=''

set @wheretj=''



if (@ZPDL<>'')

begin

	set @wheretj=@wheretj+' and O.ZPDL='''+ @ZPDL +''''

end



if (@CityBh<>'')

begin

	set @wheretj=@wheretj+' and O.CityBh='''+ @CityBh +''''

end



if (@LinkType<>'')

begin

	set @wheretj=@wheretj+' and O.LinkType='''+ @LinkType +''''

end





if(@docount=1)

begin	

   set @SQL=@SQL+'SELECT  O.*,t.City FROM ZP_INFO O,ZD_CITY t   where O.CityBh=t.CityBh  ' + @wheretj +' and isdeled = 0  order by O.ZPDL, O.CityBh,O.ScBZ desc,O.LinkTime desc,O.id desc'

   exec (@SQL)

end

else

begin

 set @PageLowerBound=(@pageindex-1)*@pagesize

 set @PageUpperBound=@PageLowerBound+@pagesize

 create table #pageindex(id int identity(1,1) not null,nid int)

 set rowcount @PageUpperBound

 set @insstr='insert into #pageindex(nid) select  O.id from ZP_INFO O,ZD_CITY t  where  O.CityBh=t.CityBh  and  O.isdeled = 0  ' + @wheretj

  exec (@insstr)

 set @SQL=@SQL+'SELECT  O.*,t.City FROM ZP_INFO O,#pageindex p,ZD_CITY t where O.CityBh=t.CityBh  and  O.id=p.nid and p.id>'+  CONVERT(VarChar(10),@PageLowerBound) +'  and p.id<='+ CONVERT(VarChar(10),@PageUpperBound) + @wheretj +' and isdeled = 0   order by O.ZPDL, O.CityBh,O.ScBZ desc,O.LinkTime desc,O.id desc'

 exec (@SQL)

end

set nocount off

GO