﻿CREATE PROCEDURE sq_cbf001sy.admin_g_s1
as 
begin 
select * from admin_g_s order by id desc
end
GO




CREATE PROC sq_cbf001sy.adminmovieall
@cId        NVARCHAR(50)
   
AS
BEGIN


SELECT @cId cid,name,canlook,movieserver,list,caiji from movie order by cid desc
END
GO



CREATE proc sq_cbf001sy.adminmovieall2
@TableName VARCHAR(200),     --表名

@FieldList VARCHAR(2000),    --显示列名，如果是全部字段则为*

@PrimaryKey VARCHAR(100),    --单一主键或唯一值键

@Where VARCHAR(2000),        --查询条件 不含'where'字符，如id>10 and len(userid)>9

@Order VARCHAR(1000),        --排序 不含'order by'字符，如id asc,userid desc，必须指定asc或desc

--注意当@SortType=3时生效，记住一定要在最后加上主键，否则会让你比较郁闷

@SortType INT,               --排序规则 1:正序asc 2:倒序desc 3:多列排序方法

@RecorderCount INT,          --记录总数 0:会返回总记录

@PageSize INT,               --每页输出的记录数

@PageIndex INT,              --当前页数

@TotalCount INT OUTPUT,      --记返回总记录

@TotalPageCount INT OUTPUT   --返回总页数

AS
BEGIN

declare @sqlStr varchar(8000)

 
set @sqlStr = ' select top ' +convert(varchar,@pageSize*@pageIndex) +' cid,name,canlook,movieserver,list,caiji,cbftype ' +
'from movie where (cid<(SELECT MIN(cid) FROM (SELECT TOP 1 cid FROM movie order by cid desc) AS tblTMP)) order by cid asc'
exec(@sqlStr)
END

GO


CREATE PROCEDURE adminmovieall3
    (
     @Table_Name varchar(5000),    --表名
     @Sign_Record varchar(50),     --主键
     @Filter_Condition varchar(1000),    --筛选条件,不带where
     @Page_Size int,     --页大小
     @Page_Index int,       --页索引       
   @TaxisField varchar(1000), --排序字段
     @Taxis_Sign int,     --排序方式 1为 DESC, 0为 ASC
 @Find_RecordList varchar(1000),   --查找的字段
     @Record_Count int     --总记录数
     )
     AS
      BEGIN 
      DECLARE @Start_Number int
      DECLARE @End_Number int
      DECLARE @TopN_Number int
     DECLARE @sSQL varchar(8000)
 if(@Find_RecordList='')
 BEGIN
 SELECT @Find_RecordList='*'
 END
     SELECT @Start_Number =(@Page_Index-1) * @Page_Size
      IF @Start_Number<=0
     SElECT @Start_Number=0
      SELECT @End_Number=@Start_Number+@Page_Size
      IF @End_Number>@Record_Count
     SELECT @End_Number=@Record_Count
     SELECT @TopN_Number=@End_Number-@Start_Number
     IF @TopN_Number<=0
     SELECT @TopN_Number=0
      print @TopN_Number
     print @Start_Number
     print @End_Number
     print @Record_Count
 IF @TaxisField=''
 begin
 select @TaxisField=@Sign_Record
 end
     IF @Taxis_Sign=0
       BEGIN
         IF @Filter_Condition=''
         BEGIN
           SELECT @sSQL='SELECT '+@Find_RecordList+' FROM '+@Table_Name+' 
           WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@TopN_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
            WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@End_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
          ORDER BY '+@TaxisField+') order by '+@TaxisField+' DESC)order by '+@TaxisField
         END
        ELSE
        BEGIN
        SELECT @sSQL='SELECT '+@Find_RecordList+' FROM '+@Table_Name+' 
     WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@TopN_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
     WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@End_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
     WHERE '+@Filter_Condition+' ORDER BY '+@TaxisField+') and '+@Filter_Condition+' order by '+@TaxisField+' DESC) and '+@Filter_Condition+' order by '+@TaxisField
         END
      END
    ELSE
      BEGIN
      IF @Filter_Condition=''
        BEGIN
          SELECT @sSQL='SELECT '+@Find_RecordList+' FROM '+@Table_Name+' 
     WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@TopN_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
     WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@End_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
     ORDER BY '+@TaxisField+' DESC) order by '+@TaxisField+')order by '+@TaxisField+' DESC'
     END
      ELSE
      BEGIN
        SELECT @sSQL='SELECT '+@Find_RecordList+' FROM '+@Table_Name+' 
     WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@TopN_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
     WHERE '+@Sign_Record+' in (SELECT TOP '+CAST(@End_Number AS VARCHAR(10))+' '+@Sign_Record+' FROM '+@Table_Name+' 
     WHERE '+@Filter_Condition+' ORDER BY '+@TaxisField+' DESC) and '+@Filter_Condition+' order by '+@TaxisField+') and '+@Filter_Condition+' order by '+@TaxisField+' DESC'
     END
      END
      EXEC (@sSQL)
      IF @@ERROR<>0
      RETURN -3 
     RETURN 0
     END
     
     PRINT @sSQL
 

GO





CREATE PROCEDURE sq_cbf001sy.cai1
as 
begin 
select cid,name,webname,caiconten from caiji order by cid
end


GO





CREATE PROCEDURE sq_cbf001sy.cai2
as 
set nocount on 
begin 
select cid,name,webname,caiconten from caiji
end

GO







CREATE PROC sq_cbf001sy.cai3
@intcId        NVARCHAR(50)
   
AS
BEGIN
select * from caiji where cid=@intcId

END


GO






CREATE PROCEDURE sq_cbf001sy.cbftype1
as 
begin 
select * from cbftype where index_type<>1
end

GO




CREATE PROCEDURE sq_cbf001sy.cbftype2
as 
begin 
select movie_type from cbftype where index_type<>1
end

GO





CREATE PROCEDURE sq_cbf001sy.cbftype3
as 
begin 
select movie_type from cbftype where index_type=0
end

GO





CREATE PROCEDURE cbftype4
as 
begin 
select movie_type from cbftype where index_type=0
end

GO






CREATE PROCEDURE sq_cbf001sy.cbfusers1
as 
begin 
select * from cbfusers
end

GO









CREATE PROCEDURE sq_cbf001sy.cbfusers2
as 
begin 
select cid,users from cbfusers
end

GO







CREATE PROC sq_cbf001sy.class
@tbname     sysname,               --要分页显示的表名
@FieldKey   nvarchar(1000),      --用于定位记录的主键(惟一键)字段,可以是逗号分隔的多个字段
@PageCurrent int,               --要显示的页码
@PageSize   int,                --每页的大小(记录数)
@FieldShow nvarchar(1000)='',      --以逗号分隔的要显示的字段列表,如果不指定,则显示所有字段
@FieldOrder nvarchar(1000)='',      --以逗号分隔的排序字段列表,可以指定在字段后面指定DESC/ASC
@Where    nvarchar(1000)='',     --查询条件
@PageCount int OUTPUT             --总页数
AS
SET NOCOUNT ON
--检查对象是否有效
IF OBJECT_ID(@tbname) IS NULL
BEGIN
    RAISERROR(N'对象"%s"不存在',1,16,@tbname)
    RETURN
END
IF OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsTable')=0
    AND OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsView')=0
    AND OBJECTPROPERTY(OBJECT_ID(@tbname),N'IsTableFunction')=0
BEGIN
    RAISERROR(N'"%s"不是表、视图或者表值函数',1,16,@tbname)
    RETURN
END

--分页字段检查
IF ISNULL(@FieldKey,N'')=''
BEGIN
    RAISERROR(N'分页处理需要主键（或者惟一键）',1,16)
    RETURN
END

--其他参数检查及规范
IF ISNULL(@PageCurrent,0)<1 SET @PageCurrent=1
IF ISNULL(@PageSize,0)<1 SET @PageSize=10
IF ISNULL(@FieldShow,N'')=N'' SET @FieldShow=N'*'
IF ISNULL(@FieldOrder,N'')=N''
    SET @FieldOrder=N''
ELSE
    SET @FieldOrder=N'ORDER BY '+LTRIM(@FieldOrder)
IF ISNULL(@Where,N'')=N''
    SET @Where=N''
ELSE
    SET @Where=N'WHERE ('+@Where+N')'

--如果@PageCount为NULL值,则计算总页数(这样设计可以只在第一次计算总页数,以后调用时,把总页数传回给存储过程,避免再次计算总页数,对于不想计算总页数的处理而言,可以给@PageCount赋值)
IF @PageCount IS NULL
BEGIN
    DECLARE @sql nvarchar(4000)
    SET @sql=N'SELECT @PageCount=COUNT(*)'
        +N' FROM '+@tbname
        +N' '+@Where
    EXEC sp_executesql @sql,N'@PageCount int OUTPUT',@PageCount OUTPUT
    SET @PageCount=(@PageCount+@PageSize-1)/@PageSize
END

--计算分页显示的TOPN值
DECLARE @TopN varchar(20),@TopN1 varchar(20)
SELECT @TopN=@PageSize,
    @TopN1=(@PageCurrent-1)*@PageSize

--第一页直接显示
IF @PageCurrent=1
    EXEC(N'SELECT TOP '+@TopN
        +N' '+@FieldShow
        +N' FROM '+@tbname
        +N' '+@Where
        +N' '+@FieldOrder)
ELSE
BEGIN
    --处理别名
    IF @FieldShow=N'*'
        SET @FieldShow=N'a.*'

    --生成主键(惟一键)处理条件
    DECLARE @Where1 nvarchar(4000),@Where2 nvarchar(4000),
        @s nvarchar(1000),@Field sysname
    SELECT @Where1=N'',@Where2=N'',@s=@FieldKey
    WHILE CHARINDEX(N',',@s)>0
        SELECT @Field=LEFT(@s,CHARINDEX(N',',@s)-1),
            @s=STUFF(@s,1,CHARINDEX(N',',@s),N''),
            @Where1=@Where1+N' AND a.'+@Field+N'=b.'+@Field,
            @Where2=@Where2+N' AND b.'+@Field+N' IS NULL',
            @Where=REPLACE(@Where,@Field,N'a.'+@Field),
            @FieldOrder=REPLACE(@FieldOrder,@Field,N'a.'+@Field),
            @FieldShow=REPLACE(@FieldShow,@Field,N'a.'+@Field)
    SELECT @Where=REPLACE(@Where,@s,N'a.'+@s),
        @FieldOrder=REPLACE(@FieldOrder,@s,N'a.'+@s),
        @FieldShow=REPLACE(@FieldShow,@s,N'a.'+@s),
        @Where1=STUFF(@Where1+N' AND a.'+@s+N'=b.'+@s,1,5,N''),    
        @Where2=CASE
            WHEN @Where='' THEN N'WHERE ('
            ELSE @Where+N' AND ('
            END+N'b.'+@s+N' IS NULL'+@Where2+N')'

    --执行查询
    EXEC(N'SELECT TOP '+@TopN
        +N' '+@FieldShow
        +N' FROM '+@tbname
        +N' a LEFT JOIN(SELECT TOP '+@TopN1
        +N' '+@FieldKey
        +N' FROM '+@tbname
        +N' a '+@Where
        +N' '+@FieldOrder
        +N')b ON '+@Where1
        +N' '+@Where2
        +N' '+@FieldOrder)
END
GO










CREATE PROCEDURE sq_cbf001sy.class1
    @TableName varchar(50),            --表名     
    @Fields varchar(5000) = '*',    --字段名(全部字段为*)     
    @OrderField varchar(5000),      --排序字段(必须!支持多字段)     
    @OrderType bit = 0,                -- 设置排序类型, 非 0 值则降序     
    @sqlWhere varchar(5000) = Null,    --条件语句(不用加where)     
    @PageIndex int = 1 ,            --指定当前为第几页     
    @PageSize int = 10,             --每页多少条记录     
    @TotalRecord int output,     
    @TotalPage int output           --返回总页数     
AS     
BEGIN     
         
     Begin Tran --开始事务     
     
    Declare @sql nvarchar(4000);      
     
    if @TotalRecord<=0 begin     
        --计算总记录数     
                  
        if (@SqlWhere='' or @sqlWhere=NULL)     
            set @sql = 'select @TotalRecord = count(*) from ' + @TableName     
        else     
            set @sql = 'select @TotalRecord = count(*) from ' + @TableName + ' with(nolock) where ' + @sqlWhere     
     
        EXEC sp_executesql @sql,N'@TotalRecord int OUTPUT',@TotalRecord OUTPUT--计算总记录数            
    end     
     
    --计算总页数     
    select @TotalPage=CEILING((@TotalRecord+0.0)/@PageSize)     
     
    if (@SqlWhere='' or @sqlWhere=NULL)     
        if @OrderType != 0     
            set @sql = 'Select * FROM (select ROW_NUMBER() Over(order by ' + @OrderField + ' DESC) as RowID,' + @Fields + ' from ' + @TableName      
        else     
            set @sql = 'Select * FROM (select ROW_NUMBER() Over(order by ' + @OrderField + ' ASC) as RowID,' + @Fields + ' from ' + @TableName      
    else     
        if @OrderType != 0     
            set @sql = 'Select * FROM (select ROW_NUMBER() Over(order by ' + @OrderField + ' DESC) as RowID,' + @Fields + ' from ' + @TableName + ' with(nolock) where ' + @SqlWhere         
        else     
            set @sql = 'Select * FROM (select ROW_NUMBER() Over(order by ' + @OrderField + ' ASC) as RowID,' + @Fields + ' from ' + @TableName + ' with(nolock) where ' + @SqlWhere         
             
     
    --处理页数超出范围情况     
    if @PageIndex<=0      
        Set @PageIndex = 1     
         
    if @PageIndex>@TotalPage     
        Set @PageIndex = @TotalPage     
     
     --处理开始点和结束点     
    Declare @StartRecord int     
    Declare @EndRecord int     
         
    set @StartRecord = (@PageIndex-1)*@PageSize + 1     
    set @EndRecord = @StartRecord + @PageSize - 1     
     
    --继续合成sql语句     
    set @Sql = @Sql + ') as t where RowID between ' + Convert(varchar(50),@StartRecord) + ' and ' +  Convert(varchar(50),@EndRecord)     
     print @sql        
    Exec(@Sql)     
    ---------------------------------------------------     
    If @@Error <> 0     
      Begin     
        RollBack Tran     
        Return -1     
      End     
     Else     
      Begin     
        Commit Tran     
        Return @TotalRecord ---返回记录总数     
      End        
END


GO











CREATE PROCEDURE sq_cbf001sy.movie1
as 
begin 
select * from movie
end



GO










CREATE proc  sq_cbf001sy.movieSearch
(
@dt smalldatetime,
@Name varchar(20) 
)
as
declare @isAddWhere bit
declare @sqlStr varchar(300) 

set @sqlStr='select cid,convert(varchar(10),times,111) as times,Name,stanrting from movie ' 

if(@dt is null)
   set @isAddWhere=1
else
begin 
   set @sqlStr=@sqlStr+' where times='''+convert(varchar(10),@dt,111)+''''
   set @isAddWhere=0
end

if(@Name<>'') 
begin
   if(@isAddWhere=1)
   begin
    set @sqlStr=@sqlStr+' where '
    set @isAddWhere=0
   end 
   else
   begin
    set @sqlStr=@sqlStr+' and '
   end

   set @sqlStr=@sqlStr+'( Name like ''%'+@Name +'%'' or  stanrting like ''%'+@Name+'%'')' 
end 

exec(@sqlStr)


GO









CREATE proc  sq_cbf001sy.movieSearchname
(
@dt smalldatetime,
@Name varchar(20) 
)
as
declare @isAddWhere bit
declare @sqlStr varchar(300) 

set @sqlStr='select top 9  cid,convert(varchar(10),times,111) as times,Name,stanrting from sq_cbf001sy.movie ' 

if(@dt is null)
   set @isAddWhere=1
else
begin 
   set @sqlStr=@sqlStr+' where times='''+convert(varchar(10),@dt,111)+''''
   set @isAddWhere=0
end

if(@Name<>'') 
begin
   if(@isAddWhere=1)
   begin
    set @sqlStr=@sqlStr+' where '
    set @isAddWhere=0
   end 
   else
   begin
    set @sqlStr=@sqlStr+' and '
   end

   --set @sqlStr=@sqlStr+' Name like '''+@Name +'%''   order by cid desc'
   set @sqlStr=@sqlStr+' Charindex('''+@Name +''',name)>0  order by cid desc'

end 

exec(@sqlStr)
GO








CREATE proc  sq_cbf001sy.movieSearchstanrting
(
@dt smalldatetime,
@Name varchar(20) 
)
as
declare @isAddWhere bit
declare @sqlStr varchar(300) 

set @sqlStr='select top 9 cid,convert(varchar(10),times,111) as times,Name,stanrting from sq_cbf001sy.movie ' 

if(@dt is null)
   set @isAddWhere=1
else
begin 
   set @sqlStr=@sqlStr+' where times='''+convert(varchar(10),@dt,111)+''''
   set @isAddWhere=0
end

if(@Name<>'') 
begin
   if(@isAddWhere=1)
   begin
    set @sqlStr=@sqlStr+' where '
    set @isAddWhere=0
   end 
   else
   begin
    set @sqlStr=@sqlStr+' and '
   end
-- set @sqlStr=@sqlStr+'Stanrting like '''+@Name +'%''   order by cid desc'
   set @sqlStr=@sqlStr+' Charindex('''+@Name +''',Stanrting)>0   order by cid desc'
end 

exec(@sqlStr)
GO





CREATE proc sq_cbf001sy.movieaspurl
@name VARCHAR(2000)
AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr ='select top 30 a.cid,a.name,b.cid,b.url from movie a join  movieurl b on a.CID=b.nameid where a.name like '''+@name+'%'''



exec(@sqlStr)

END
GO







CREATE PROC sq_cbf001sy.moviecid
@mcId        NVARCHAR(50)
   
AS
BEGIN
select * from movie where cid=@mcId

END

GO





CREATE PROC sq_cbf001sy.moviename
@mncId        NVARCHAR(50)
   
AS
BEGIN
select * from movie where name=@mncId

END

GO







CREATE PROCEDURE sq_cbf001sy.movieserver1
as 
begin 
select * from movieserver

end




GO






CREATE PROCEDURE sq_cbf001sy.movieserver2
as 
begin 
select cid from movieserver

end
GO




CREATE proc sq_cbf001sy.moviesourl
@name VARCHAR(2000)
AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr ='select  top 30 c=c.name,ccid=c.cid,a=a.name,acid=a.cid,bcid=b.cid,b=b.url from 
  movie a 
join  
  movieurl b 
on 
  a.CID=b.nameid 
join
  PLAY c
on 
  convert(int,substring(a.play,1,charindex('','',a.play)-1)) =c.cid
where 
  a.name like  '''+@name+'%'''



exec(@sqlStr)
END
GO






CREATE proc sq_cbf001sy.movietop14

AS
BEGIN
SET   NOCOUNT   ON
declare @sqlStr varchar(1000)

set @sqlStr = 'select top 14 cid,name from movie where vip=0 order by cid desc'


exec(@sqlStr)

END

GO






CREATE proc sq_cbf001sy.movietop4
@pageSize varchar(1000)

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select top 4 cid,name,imgurl from movie where vip=0 and cbftype='''+@pageSize+''' order by cid desc'


exec(@sqlStr)

END


GO






CREATE PROC sq_cbf001sy.movieurl1
@cId        NVARCHAR(50)
   
AS
BEGIN
select * from movieurl where nameid=@cId

END



GO






CREATE PROC sq_cbf001sy.movieurl2
@cId        NVARCHAR(50)
   
AS
BEGIN
select cid from movieurl where nameid=@cId

END
GO







CREATE PROC sq_cbf001sy.movieurl3
@cId        NVARCHAR(50)
   
AS
BEGIN
select cid,url from movieurl where nameid=@cId

END
GO








CREATE PROCEDURE sq_cbf001sy.play1
as 
begin 
select * from play
end



GO










CREATE PROCEDURE sq_cbf001sy.play2
as 
begin 
select cid,name from play
end



GO







CREATE proc sq_cbf001sy.rssclassid
@cId int
AS
BEGIN

select movie_type from cbftype where cid=@cId

END
GO





CREATE proc sq_cbf001sy.rssclassidm

@pageSize VARCHAR(2000)
AS
BEGIN

declare @sqlStr varchar(2000)

set @sqlStr = 'select top 500 * from movie where cbftyp'+@pageSize+' order by cid desc'



exec(@sqlStr)

END
GO







CREATE PROC sq_cbf001sy.rsss
   
AS
BEGIN
select * from cbftype where classid>0
END
GO





CREATE PROC sq_cbf001sy.toptype

   
AS
BEGIN


SELECT a.cid,a.classid,a.movie_type FROM sq_cbf001sy.cbftype a,f_Cid('0') b WHERE a.cID=b.cID and look=1
END


GO




CREATE proc sq_cbf001sy.vipcaigvod1
@PageSize INT, 

@TableName VARCHAR(2000), 

@cbftypes varchar(2000),

@wheres VARCHAR(2000)



AS
BEGIN

declare @sqlStr varchar(2000)

set @sqlStr = 'select top ' +convert(varchar,@pageSize) +' cid from movie where play='''+@TableName+''' and cbftype='''+@cbftypes+''' order by '+@wheres


exec(@sqlStr)

END


GO








CREATE proc sq_cbf001sy.vipcaigvod2

@wheres VARCHAR(2000),
@wvod VARCHAR(2000)

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select * from cbftype where  '+@wheres+' order by [top] desc'




exec(@sqlStr)

END


GO








CREATE proc sq_cbf001sy.vipcaimovie1
@pageSize int

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select cid,name,imgurl,stanrting,content from movie where cid='+convert(varchar,@pageSize) 


exec(@sqlStr)

END

GO









CREATE proc sq_cbf001sy.vipmoviename
@pageSize VARCHAR(2000)

AS
BEGIN


select cid,name from movie where name=@pageSize



END


GO





CREATE proc sq_cbf001sy.vipmovieurl

@pageSize int

AS
BEGIN
        SELECT url FROM movieurl WHERE nameid=@pageSize

END


GO






CREATE proc sq_cbf001sy.vipnewmovie
@pageSize int

AS
BEGIN



select * from movie where cid=@pageSize




END


GO









CREATE proc sq_cbf001sy.vod2008classcyte1
@pageSize VARCHAR(2000)
AS
BEGIN
SET   NOCOUNT   ON
declare @sqlStr varchar(1000)

set @sqlStr = 'select * from cbftype where movie_type='''+@pagesize+''' and  look=1 order by [top] desc'


exec(@sqlStr)

END


GO










CREATE proc sq_cbf001sy.vod2008classtop10
@pageSize VARCHAR(2000)
AS
BEGIN
SET   NOCOUNT   ON
declare @sqlStr varchar(1000)

set @sqlStr = 'select top 10 cid,imgurl,name,content from movie where list=1 and vip=0 '+@pagesize

exec(@sqlStr)

END


GO









CREATE proc sq_cbf001sy.vod2008classtopnwe10

AS
BEGIN
SET   NOCOUNT   ON
declare @sqlStr varchar(1000)

set @sqlStr ='select top 10 cid,name from movie where list=1 and vip=0 order by cid desc'

exec(@sqlStr)

END


GO









CREATE proc sq_cbf001sy.vod2008ctye2
@PageSize INT

AS
BEGIN

declare @sqlStr varchar(2000)

set @sqlStr = 'select cid,movie_type  from cbftype where classid=' +convert(varchar,@pageSize) +'  and look=1 order by [top] desc'

exec(@sqlStr)

END


GO









CREATE proc sq_cbf001sy.vod2008hits24

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select top 24  cid,name,imgurl,content from movie WHERE  gud=1 and  list=1 and vip=0 order by hits desc'


exec(@sqlStr)

END


GO








CREATE PROCEDURE sq_cbf001sy.vod2008home
as 
begin 
select * from home
end


GO




CREATE proc sq_cbf001sy.vod2008htm3
@PageSize INT

AS
BEGIN

declare @sqlStr varchar(2000)

set @sqlStr = 'select top ' +convert(varchar,@pageSize)+' cid from movie order by cid desc'

exec(@sqlStr)

END
GO







CREATE proc sq_cbf001sy.vod2008index20

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select top 20 cid,name,cbftype,imgurl,imgurl from movie WHERE  gud=1 and  list=1 and vip=0 order by cid desc'


exec(@sqlStr)

END


GO







CREATE proc sq_cbf001sy.vod2008indexctye

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select cid,movie_type from cbftype where [index_type]=1 and [classid]=0  order by [top] desc'


exec(@sqlStr)

END


GO





CREATE proc sq_cbf001sy.vod2008indexctye4

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select top 4 cid,movie_type from cbftype where [index_type]=1 and [classid]=0 order by [top] desc'


exec(@sqlStr)

END


GO





CREATE proc sq_cbf001sy.vod2008indexnew4
@pageSize VARCHAR(2000)
AS
BEGIN
SET   NOCOUNT   ON
declare @sqlStr varchar(1000)

set @sqlStr = 'select top 3 cid,name,imgurl,content from movie where  cbftype in ('+@pagesize+') and  list=1 and vip=0 order by cid desc'


exec(@sqlStr)

END


GO




CREATE proc sq_cbf001sy.vod2008indexnew9
@pageSize VARCHAR(2000)
AS
BEGIN
SET   NOCOUNT   ON
declare @sqlStr varchar(1000)

set @sqlStr = 'select top 9 cid,name,imgurl,content from movie where  cbftype in ('+@pagesize+') and  list=1 and vip=0 order by cid desc'


exec(@sqlStr)

END


GO









CREATE proc sq_cbf001sy.vod2008indexto4
@pageSize VARCHAR(2000)
AS
BEGIN
SET   NOCOUNT   ON
declare @sqlStr varchar(1000)

set @sqlStr = 'select top 9 cid,name,imgurl,hits,cbftype from movie where cbftype in('+@pageSize+') and  list=1 and vip=0 order by hits desc'


exec(@sqlStr)

END


GO






CREATE proc sq_cbf001sy.vod2008indextop11
@pageSize VARCHAR(2000)
AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select top 11 cid,name,cbftype,imgurl,hits,content,stanrting from movie WHERE  gud=1 and  list=1 and vip=0 order by '+@pageSize+' desc'


exec(@sqlStr)

END


GO





CREATE proc sq_cbf001sy.vod2008movie1
@pageSize int

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select top 1 cid,name,cbftype,imgurl,stanrting,play,times,hits,caijiname,caijiurl,how,exhibition,movieb,keywords,bturl,content,server1,server2,server3,server4,server5,server6,vip,ress,canlook from movie where list=1 and cid='+convert(varchar,@pageSize) 


exec(@sqlStr)

END


GO




CREATE proc sq_cbf001sy.vod2008newurl

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select top 1 cid from movieurl order by cid desc'


exec(@sqlStr)

END


GO







CREATE proc sq_cbf001sy.vod2008piltype
AS
BEGIN

select cid,movie_type from cbftype where index_type<>1




END
GO






CREATE proc sq_cbf001sy.vod2008play

AS
BEGIN

select cid,name,list,time from play

END
GO





CREATE proc sq_cbf001sy.vod2008playid
@pageSize int

AS
BEGIN

declare @sqlStr varchar(1000)

set @sqlStr = 'select * from play where cid='+convert(varchar,@pageSize) 


exec(@sqlStr)

END
GO





CREATE proc sq_cbf001sy.vod2008typecid
@PageSize INT

AS
BEGIN

declare @sqlStr varchar(2000)

set @sqlStr = 'select cid,movie_type from cbftype where cid=' +convert(varchar,@pageSize) 

exec(@sqlStr)

END


GO







CREATE proc sq_cbf001sy.vod2008vodasp
@PageSize INT

AS
BEGIN

declare @sqlStr varchar(2000)

set @sqlStr = 'select cid,movie_type from cbftype where classid=' +convert(varchar,@pageSize)+' and look=1'


exec(@sqlStr)

END
GO