SET @strSQL = @strSQL + '''' AND  BB= @ckBB''''

     END

IF @BuyType<>-1

     BEGIN

         SET @strSQL = @strSQL + '''' AND  BuyType= @ckBuyType''''

     END

IF @FunctionState<>-1

     BEGIN

         SET @strSQL = @strSQL + '''' AND  FunctionState= @ckFunctionState''''

     END

--- Add Where Key Word ---

--- Run SQL Begin ---

EXECUTE sp_executesql @strSQL,

         N''''   @ckScoreSettingID INT,

              @ckFunctionID INT,

              @ckOperationID INT,

              @ckRoleTypeID INT,

上一页  [1] [2] [3] [4] [5]  下一页