国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

可以用sql的跟蹤器來(lái)驗(yàn)證程序?qū)?shù)據(jù)庫(kù)的操作次數(shù)；
//多表儲(chǔ)存過(guò)程(使用性更強(qiáng)，性能更強(qiáng))
CREATE Procedure SP_Pagering
@tablename varchar(50),
@primarykey varchar(50),
@colunmnames varchar(1000),
@otherjoin varchar(1000),
@where varchar(1000),
@index int,
@size int
AS

declare @temp int

set @temp=@size*(@index-1)
exec('select top '+@size+' '+@colunmnames+' from '+@tablename+' '+@otherjoin +' where  '+@where +' '+@primarykey+' not in (select top '+@temp +' '+@primarykey+' from '+@tablename+' order by '+@primarykey+' )')

GO

//原始存儲(chǔ)過(guò)程
create Procedure SP_Pager
@size int ,
@pageIndex int,
@count int,
@tablename varchar(50),
@primarykey varchar(50),
as
declare @tempcount int
declare @totalpage int

if @size<0
set @size=10
if @count%@size>0
begin
set @totalpage=@count/@size+1
end
else
begin
set @totalpage=@count/@size
end
if @pageindex<=0
set @pageindex=1
if @pageindex>@totalpage
begin
set @pageindex=@totalpage
end
set @tempcount=@size*(@pageindex-1)
if @pageindex<=@totalpage and @pageindex>=1
execute('select top '+@size+' * from '+@tablename+' where '+@primarykey+ not in (select top '+@tempcount+' '+@primarykey+' from '+@tablename+')'')
GO

//多表連接查詢總數(shù)的存儲(chǔ)過(guò)程
CREATE Procedure SP_TotalCount
@tablename varchar(50),
@primarykey varchar(50),
@otherjoin varchar(1000),
@where varchar(1000)
AS

exec('select count('+@primarykey+') from '+@tablename+' '+@otherjoin+' ' +@where )
GO

//DAL調(diào)用多表的兩個(gè)存儲(chǔ)過(guò)程
       private string sp_Pagering = "SP_Pagering";
       private string sp_TotalCount = "SP_TotalCount";

       public DataTable Pagering(string tableName,string primaryKey,string colunmNames,string otherJoin,string where,int index,int size)
       {

           if (where != String.Empty)
           {
               where = where + " and ";
           }
          return SqlHelper.ExecuteDataset(DataProvider.ConnectionString,sp_Pagering,tableName, primaryKey, colunmNames, otherJoin, where, index, size).Tables[0];
       
       }

       public int TotalCount(string tableName,string primaryKey,string otherJoin,string where)
       {
           if (where != String.Empty)
           {
               where =  " where "+where;
           }
           return (int)SqlHelper.ExecuteScalar(DataProvider.ConnectionString,sp_TotalCount, tableName, primaryKey, otherJoin, where);
       }

本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊舉報(bào)。