新增文章

文章标题分类内容

begin tran 
      
         Update IC_MAxNum set FFlag = 1 where FUserID = @UserID and FTableName = @TableName and FNumber = @FNumber   
         set @FInterID = @FNumber  
      commit

begin transaction  
         ------------------------------------------------------------------------------------------------------------------------------------------------------------
            if @FinterID = -1 
            
               set @Sql = 'Insert Into ICMaxNum(FTableName,FMaxNum) values(''' + @tableName + ''',' + str(1000 + @iStep) + ') '  
            else
               set @Sql = 'update ICMaxNum set FMaxNum = ' + str(1000 + @iStep) + ' where FTableName = ''' + @tableName + ''''
              
            ------------------------------------------------------------------------------------------------------------------------------------------------------------
            while @i< = @iStep begin
	        
	            set @Sql = @Sql + ' insert into IC_MAxNum(FTableName,FUserID,FNumber) values(''' + @TableName + ''',' + str(ltrim(@UserID)) + ',' + str(1000 + @i) + ')  '  
	            set @i = @i + 1  
	         end  
	         
            set @Sql = @Sql + ' Update IC_MAxNum set FFlag = 1 where FUserID = ' + str(ltrim(@UserID)) + ' and FTableName = ''' + @TableName + ''' and FNumber = 1001'   
            
            exec (@Sql)  
         ------------------------------------------------------------------------------------------------------------------------------------------------------------
         if @@error = 0 begin    
            commit    
            select @FInterID = 1001    
         end    
         else begin    
            rollback    
            select @FinterID = -1    
         end