USE [AutoMonitorDBV3]
GO

/****** Object:  StoredProcedure [dbo].[ProcV2GetRmtCtrlCmdTskList]    Script Date: 10/29/2019 15:06:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

/***********************************************************************************************************************                  
 Author          :   LIMAOPENG                  
 Add date        :   2009-04-10                  
 Description     :   ProcV2GetRmtCtrlCmdTskList根据命令状态及用户获取命令执行状态信息列表             
 Test SQL        :   exec [ProcV2GetRmtCtrlCmdTskList]  10,1,-1,150100000022,'LD150122000030'                
************************************************************************************************************************/                  
CREATE proc [dbo].[ProcV2GetRmtCtrlCmdTskList]          
	@PageSize   int,   --每页多少条            
	@PageCurr   int,   --第几页           
	@CmdState int,          
	@pscode Bigint,    
	@DGIMN varchar(14)          
as
begin          
	declare @RowCount int          
	declare @RowBegin int          
	declare @RowEnd int          
	          
	set @RowBegin = @PageSize * @PageCurr - @PageSize + 1          
	set @RowEnd = @RowBegin + @PageSize-1          
          
	if @CmdState>-1        
	begin        
		--获取总记录数          
		select @RowCount = count(1) from ViewRmtCtrlCmdTskList          
		where taskStatus =@CmdState          
		and pscode =@pscode and AdapterCode = @DGIMN     

		--分页查询          
		select TaskSN,PSCode,AdapterCode,left(TaskName,( Charindex('|',TaskName)-1)) as TaskName ,  
		right(TaskName,( len(TaskName)- Charindex('|',TaskName))) as UserName ,BuildTime,EndTime,CmdContent,TaskStatus,  
		RcvInfoContent,IPAddress,Port  
		,convert(varchar,BuildTime,120)+' ' as BuildTimeStr,convert(varchar,EndTime,120)+' ' as EndTimeStr,
		[dbo].[f_GetISEPOPS](PSCode) as ISEPOPS  
		from           
		(          
			select *,ROW_NUMBER() OVER (order by BuildTime desc) as RowNumber from           
			(          
				select * from  MonitorOperationData.RmtCtrlCmdTskList           
				where  taskStatus =@CmdState and pscode =@pscode and AdapterCode = @DGIMN    
			) tb            
		) pg           
		where pg.RowNumber between @RowBegin and @RowEnd             

		select @RowCount          
	end        
	else        
	begin        
		--获取总记录数          
		select @RowCount = count(1)   
		from  MonitorOperationData.RmtCtrlCmdTskList           
		where   pscode =@pscode and AdapterCode = @DGIMN        

		--分页查询          
		select TaskSN,PSCode,AdapterCode,left(TaskName,( Charindex('|',TaskName)-1)) as TaskName ,  
		right(TaskName,( len(TaskName)- Charindex('|',TaskName))) as UserName ,BuildTime,EndTime,CmdContent,TaskStatus,  
		RcvInfoContent,IPAddress,Port  
		,convert(varchar,BuildTime,120)+' ' as BuildTimeStr,convert(varchar,EndTime,120)+' ' as EndTimeStr 
		,[dbo].[f_GetISEPOPS](PSCode) as ISEPOPS 
		from           
		(          
			select *,ROW_NUMBER() OVER (order by BuildTime desc) as RowNumber from           
			(          
				select * from  MonitorOperationData.RmtCtrlCmdTskList           
				where pscode =@pscode and AdapterCode = @DGIMN     
			) tb            
		) pg           
		where pg.RowNumber between @RowBegin and @RowEnd             

		select @RowCount 
	end  
end        
GO