cocos中将战绩改为显示最近3天数据

创胜棋牌系统将战绩改为调用最新3天内的的数据，这个需要更改sql函数

-- 游戏记录条目
CREATE PROC GSP_WEB_GetRecordIDList
	@dwUserID INT,
	@ClubID INT,
	@start int,
	@end	int,
	@KindID int,
	@day	int							
WITH ENCRYPTION AS

-- 设置属性
SET NOCOUNT ON

-- 执行逻辑
BEGIN	 
	WITH tmp
     AS ( SELECT   ROW_NUMBER() OVER ( ORDER BY RRS.RecordTime DESC ) AS Num ,
                  COUNT(RoomIndex) OVER ( ) AS Total , RoomIndex AS ID FROM RYRecordDB.DBO.RecordRoomScore RRS ,RYRecordDB..RecordRoom RR
				WHERE RRS.RoomIndex = RR.ID and RR.KindID = @KindID and  UserID= @dwUserID AND DATEDIFF(DAY, RRS.RecordTime, GETDATE()) < 3 
	)
	SELECT  *
	FROM    tmp
	WHERE   tmp.Num BETWEEN @start AND @end;
	
END

RETURN 0

GO

修改GSP_WEB_GetRecordIDList函数，其中

DATEDIFF(DAY, RRS.RecordTime, GETDATE()) < 3

调用3天内的数据，需要调用其他条件改这个调用就行