--创建人：zengfanlong

--创建时间：-- ::

--说明：根据公司简写代码获取当前待同步的气瓶档案数据(分页获取)

ALTER PROCEDURE [UP_GasBottles_GetSyncData_ByPage]

    (

      @CompanyAbbrCode NVARCHAR() = '' ,

      @LatastRowVersion_BigInt BIGINT ,

      @CurrentMaxRowVersion_BigInt BIGINT ,

      @StartPageIndex INT =  ,

      @EndPageIndex INT =  ,

      @TotalCount INT OUTPUT

    )

AS

    BEGIN

 --()、定义SQL查询

        SELECT  *

        INTO    #tempTb

        FROM    dbo.GasBottles AS gs WITH ( NOLOCK )

        WHERE   ISNULL(GasBottleNo, '') <> ''

                AND REPLACE(( SUBSTRING(gs.GasBottleNo, , ) ), '-', '') = @companyAbbrCode

                AND ( CAST([RowVersion] AS BIGINT) > @LatastRowVersion_BigInt

                      AND CAST([RowVersion] AS BIGINT) <= @CurrentMaxRowVersion_BigInt

                    )

        IF ( @StartPageIndex <=

             AND @EndPageIndex <=

           )

            BEGIN 

                SELECT  *

                FROM    #tempTb

                --返回总页数

                SET @TotalCount = ( SELECT  COUNT()

                                    FROM    #tempTb

                                  )

            END

        ELSE

            BEGIN

 --分页获取数据

                SELECT  ROW_NUMBER() OVER ( ORDER BY GETDATE() ) AS 'Row' ,

                        *

                INTO    #tempAll

                FROM    #tempTb

                SELECT  *

                FROM    #tempAll

                WHERE   Row BETWEEN @StartPageIndex AND @EndPageIndex

                TRUNCATE TABLE #tempAll

                DROP TABLE #tempAll

            END

         --删除历史表

        TRUNCATE TABLE #tempTb

        DROP TABLE #tempTb  

    END

GO