set ANSI_NULLS ON set QUOTED_IDENTIFIER ON goALTER procedure [dbo].[s_Page_Where] ( @pagesize int, @pageindex int, @Filed varchar(100), @table varchar(50), @where varchar(500) ) as set nocount on create table #indextable (id int identity(1,1),nid int) declare @PageLowerBound int declare @PageUpperBound int set @PageLowerBound=(@pageindex-1)*@pagesize set @PageUpperBound=@PageLowerBound+@pagesize set rowcount @PageUpperBound exec ('insert #indextable (nid) select ID from '+@table+' where '+@where+' order by ID desc') declare @a varchar(8000) set @a='select '+@Filed+' from '+@table+' O,#indextable t where O.ID=t.nid and t.id>'+cast(@PageLowerBound as varchar(10))+' and t.id<='+cast(@PageUpperBound as varchar(10))+' order by o.id desc' exec(@a) set nocount off
fileds.Add("PageIndex") fileds.Add("PageSize") fileds.Add("Filed") fileds.Add("Table") fileds.Add("where") texts.Add(AspNetPager1.CurrentPageIndex.ToString()) texts.Add(GZztbClass.NewDateCount.ToString()) texts.Add("*") texts.Add("Zj_info_doc") texts.Add(Str_Where.ToString()) Dim i As Integer Dim dr As SqlDataReader GZztbClass.Open() Dim cmd As New SqlCommand("s_Page_Where", GZztbClass.Conn) cmd.CommandType = CommandType.StoredProcedure For i = 0 To fileds.Count - 1 Dim iStoredProcedure As String iStoredProcedure = "@" iStoredProcedure = iStoredProcedure & fileds(i) 'CREATE Dim Paramet As New SqlParameter(iStoredProcedure, texts(i)) cmd.Parameters.Add("@" & fileds(i), texts(i))
Next i dr = cmd.ExecuteReader() rpt.DataSource = dr rpt.DataBind() AspNetPager1.CustomInfoText = "当前页/总页数:" & AspNetPager1.CurrentPageIndex & "/" & AspNetPager1.PageCount & ",每页记录:" & AspNetPager1.PageSize ' NewDateCount GZztbClass.Close()
set QUOTED_IDENTIFIER ON
goALTER procedure [dbo].[s_Page_Where]
(
@pagesize int,
@pageindex int,
@Filed varchar(100),
@table varchar(50),
@where varchar(500)
)
as
set nocount on
create table #indextable (id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
exec ('insert #indextable (nid) select ID from '+@table+' where '+@where+' order by ID desc')
declare @a varchar(8000)
set @a='select '+@Filed+' from '+@table+' O,#indextable t where O.ID=t.nid and t.id>'+cast(@PageLowerBound as varchar(10))+' and t.id<='+cast(@PageUpperBound as varchar(10))+' order by o.id desc'
exec(@a)
set nocount off
fileds.Add("PageSize")
fileds.Add("Filed")
fileds.Add("Table")
fileds.Add("where") texts.Add(AspNetPager1.CurrentPageIndex.ToString())
texts.Add(GZztbClass.NewDateCount.ToString())
texts.Add("*")
texts.Add("Zj_info_doc")
texts.Add(Str_Where.ToString()) Dim i As Integer
Dim dr As SqlDataReader GZztbClass.Open()
Dim cmd As New SqlCommand("s_Page_Where", GZztbClass.Conn)
cmd.CommandType = CommandType.StoredProcedure
For i = 0 To fileds.Count - 1
Dim iStoredProcedure As String
iStoredProcedure = "@"
iStoredProcedure = iStoredProcedure & fileds(i) 'CREATE
Dim Paramet As New SqlParameter(iStoredProcedure, texts(i))
cmd.Parameters.Add("@" & fileds(i), texts(i))
Next i
dr = cmd.ExecuteReader()
rpt.DataSource = dr
rpt.DataBind()
AspNetPager1.CustomInfoText = "当前页/总页数:" & AspNetPager1.CurrentPageIndex & "/" & AspNetPager1.PageCount & ",每页记录:" & AspNetPager1.PageSize ' NewDateCount
GZztbClass.Close()