日期:2014-05-17  浏览次数:20851 次

datalist分页第二页无法显示数据……急急急
存储过程如下:
@pagesize int ,--每页记录数
  @currentpage int,--当前页
  @wh_month varchar(15),--维护月份
  @wh_baoyang varchar(20),--保养要求
  @pagecount int output,--总记录数
  @pages int output--总页数

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
  declare @page int
  declare @sql nvarchar(1000)

  declare @numtemp int
  -- Insert statements for procedure here
/*set @sql='select @pc= count(*) from (select B_device.zichannum,b_device.baoyang,b_device.devicename,
  b_device.cfadress,weihu_v.wh_date,weihu_v.wh_id,wh_danhao from weihu_v left outer join B_device on  
  weihu_v.zch_num= b_device.zichannum) #temptable where wh_id<>'''' and baoyang like ''%'+@wh_baoyang+'%'' and wh_date like ''%'+@wh_month+'%'' '
 exec sp_executesql @sql,N'@pc int output',@page output*/
select @pagecount=count(*) from wh_JH where wh_id<>'' and baoyang like @wh_baoyang and wh_date like @wh_month 

if @pagecount=0
begin
  set @pages=1
end
else
begin
set @numtemp=@pagecount%@pagesize
  if @numtemp=0
  begin
  set @pages=(@pagecount/@pagesize)
  end
  else
  begin 
  set @pages=@pagecount/@pagesize+1
  end
end


--if @currentpage=1
--begin
  select * from (select top ((@currentpage)*(@pagesize)) row_number()over(order by wh_id desc)id , * from wh_JH where wh_id<>'' and baoyang like @wh_baoyang and wh_date like @wh_month)t where id>((@currentpage-1)*(@pagesize)) order by wh_id desc
 
cs代码如下:


protected void BindDataList(int pindex)
  {
   
  // Response.Write("{0} {1} {2}{3}", PDS.PageSize, Convert.ToInt32(curpage.Text), year.SelectedItem.Text + DropDownList1.SelectedItem.Text,DropDownList4.SelectedItem.Text);
   
  SqlCommand Command = new SqlCommand();
   
  PagedDataSource PDS = new PagedDataSource();
  PDS.AllowPaging = true;
  PDS.PageSize = 15;

  if (conn.State == ConnectionState.Closed)
  {
  conn.Open(); 
  }
   
  Command.Connection = conn;
  Command.CommandType = CommandType.StoredProcedure;
  Command.CommandText = "WH_finishpage";

  SqlParameter page = new SqlParameter("@pagesize", SqlDbType.Int);
  page.Value = PDS.PageSize;
  Command.Parameters.Add(page);

  SqlParameter current = new SqlParameter("@currentpage", SqlDbType.Int);
  current.Value = pindex;
  Command.Parameters.Add(current);

  SqlParameter month = new SqlParameter("@wh_month", SqlDbType.VarChar, 20);
  month.Value ="%"+ year.SelectedItem.Text + "-" + DropDownList1.SelectedItem.Text+"%";
  Command.Parameters.Add(month);

  SqlParameter baoyang = new SqlParameter("@wh_baoyang", SqlDbType.VarChar, 20);
  baoyang.Value ="%"+ DropDownList4.SelectedItem.Text+"%";
  Command.Parameters.Add(baoyang);

  SqlParameter pcount = new SqlParameter("@pagecount", SqlDbType.In