导航

基于slick grid做infinite scroll(1)

Posted on 2013-07-19 22:01  zhustar  阅读(202)  评论(0编辑  收藏  举报

要在ALM web ui上用的grid做上infinite scroll,目前没啥想法。

需要一个很多defect做实验,今天通过classic ui加了好多,加到28个时候,突然意识到可以写个存储过程做这事。

CREATE PROCEDURE createMultipleBugs
AS
BEGIN TRANSACTION
declare @num int
begin
set @num = 29
while @num < 500
begin
INSERT INTO [default_72_db].[td].[BUG] (
[BG_BUG_ID],
[BG_SUMMARY], 
[BG_DESCRIPTION],
[BG_STATUS],
[BG_REPRODUCIBLE], 
[BG_SEVERITY],
[BG_DETECTED_BY],
[BG_DETECTION_DATE],
[BG_BUG_VER_STAMP],
[BG_VTS]) 
VALUES (@num,'sample','sample', 'Open', 'Y','3-High','sa','2013-07-15 00:00:00.000',1,'2013-07-18 10:48:23')
set @num = @num +1
end
end
COMMIT TRANSACTION