每隔5分钟后自动在表格之间进行随机播放 [英] Auto shuffle between forms every after 5 min
问题描述
亲爱的所有人，
我有三种窗体形式，如下所示。
表格1代码：
WITH q1 AS
（
SELECT
RouteCode，
sum（Units）as Cases，
count（distinct Customercode）作为客户，
计数（不同的产品代码）为UY，
SUM（CASE WHEN产品代码IN（X6，X9）THEN Units ELSE 0 END）AS SPAR，
SUM（CASE WHEN productcode IN（ X1，X2）那么单位ELSE 0 END）AS STI，
SUM（产品类型为（X4，X5）然后单位为0结束时的情况）作为其他人，
格式（最大值（[日期]）， 'hh \：mm'）作为[Last Transaction time]，
Route_Name = case RouteCode
当'NA'然后'OK'
当'P5'然后'Ph'
'N3'然后'Jd'
'N5'然后'Aber'
'P2'然后'Fis'
当'NE'然后'Ih'
时当'N7'时，'P6'然后是'Ha'
Harsna'
当'NB'然后'Murha'
否则
结束
来自[INTERFACE]。[dbo]。[v_JU]
其中[DeliveryDate]> ; CAST（FLOOR（CAST（GETDATE（）AS FLOAT））AS DATETIME）
- 和（RouteCode LIKE'NA'或RouteCode LIKE'P5'或RouteCode LIKE'N3'或RouteCode LIKE'N5'或RouteCode LIKE 'P2'或RouteCode LIKE'NE'或RouteCode LIKE'P6'或RouteCode LIKE'N7'或RouteCode LIKE'NB'）
AND RouteCode IN（'NA'，'P5'，'N3'，'N5 '，'P2'，'NE'，'P6'，'N7'，'NB'）
GROUP BY [RouteCode]
），
q2 AS
（
SELECT
RouteCode，
count（distinct（当AccessCode = 0然后是CustomerCode结束时的情况））为Best
FROM [INTERFACE]。[dbo]。[LOJ]
WHERE CONVERT（DATE，Date）= CONVERT（Date，GETDATE（））
--AND（RouteCode LIKE'NA'或RouteCode LIKE'P5'或RouteCode LIKE'N3'或RouteCode LIKE'N5'或RouteCode LIKE' P2'或RouteCode LIKE'NE'或RouteCode LIKE'P6'或RouteCode LIKE'N7'或RouteCode LIKE'NB'）
AND RouteCode IN（'NA'，'P5'，'N3'，'N5' ， 'P2'， '东北'，"P6 ，'N7'，'NB'）
GROUP BY [RouteCode]
），
q3 AS
（
SELECT
RouteCode，
count（CustomerCode）as Number
FROM [INTERFACE]。[dbo]。[v_ VPlan]
WHERE CONVERT（DATE，VisitDay）= CONVERT（Date，GETDATE（））
--AND （RouteCode LIKE'NA'或RouteCode LIKE'P5'或RouteCode LIKE'N3'或RouteCode LIKE'N5'或RouteCode LIKE'P2'或RouteCode LIKE'NE'或RouteCode LIKE'P6'或RouteCode LIKE'N7'或RouteCode喜欢'NB'）
和RouteCode IN（'NA'，'P5'，'N3'，'N5'，'P2'，'NE'，'P6'，'N7'，'NB'）
GROUP BY [RouteCode]
）
SELECT
q1.RouteCode，
sum（q1.sti）+ SUM（q1.SPAR）+ SUM（q1.OTHERS） as Total，
sum（q1.sti）as sti，
SUM（q1.SPAR）AS Spar，
SUM（q1.OTHERS）AS OTHERS，
SUM（q2。最好的，最好的，
SUM（q3.Number）AS预定，
SUM（q1.Customers）作为客户，
q1.RouteCode为空时然后为null否则为max（q1.Route_Name ）以Route_Name
FROM结束q1
LEFT JOIN q2 ON q2。[RouteCode] = q1。[RouteCode]
LEFT JOIN q3 ON q3。[RouteCode] = q1。[RouteCode]
GROUP BY q1。[RouteCode] WITH ROLLUP
表单2：Microsoft Powerpoint文件
来自网络文件夹（路径）的多个powerpoint文件
表格3：多个视频文件（MP4，FLV，MOV等）
网络文件夹中的多个视频文件（路径）
要求：
每个表格应该在5分钟后更改并显示。
示例： 第一个form1应该显示，然后5分钟后，form1应该最小化并且
;  form2应该显示幻灯片，然后5分钟后，form2应该最小化，form3应该播放视频和
;        然后在5分钟后，form3应该最小化并暂停视频，然后form1应该显示。
它应该继续执行与上面相同的步骤。
请告知...
在隐藏的主窗体中使用计时器并在表单执行时切换。
Dear All,
I am having three windows forms, as follows.
Forms 1 code :
WITH q1 AS
(
SELECT
RouteCode,
sum(Units) as Cases,
count(distinct Customercode) as Customers,
count(distinct productcode) as UY,
SUM(CASE WHEN productcode IN (X6,X9) THEN Units ELSE 0 END) AS SPAR,
SUM(CASE WHEN productcode IN (X1,X2) THEN Units ELSE 0 END) AS STI,
SUM(CASE WHEN PRODUCTCODE IN (X4,X5) THEN UNITS ELSE 0 END ) AS OTHERS,
FORMAT(max([Date]),'hh\:mm') as [Last Transaction time],
Route_Name = case RouteCode
when 'NA' then 'OK'
when 'P5' then 'Ph'
when 'N3' then 'Jd'
when 'N5' then 'Aber'
when 'P2' then 'Fis'
when 'NE' then 'Ih'
when 'P6' then 'Ha'
when 'N7' then 'Harsna'
when 'NB' then 'Murha'
else null
end
FROM [INTERFACE].[dbo].[v_JU]
where [DeliveryDate] > CAST(FLOOR(CAST(GETDATE() AS FLOAT))AS DATETIME)
--and (RouteCode LIKE 'NA' or RouteCode LIKE 'P5' or RouteCode LIKE 'N3' or RouteCode LIKE 'N5' or RouteCode LIKE 'P2' or RouteCode LIKE 'NE' or RouteCode LIKE 'P6' or RouteCode LIKE 'N7' or RouteCode LIKE 'NB')
AND RouteCode IN ('NA','P5','N3','N5','P2','NE','P6','N7','NB')
GROUP BY [RouteCode]
),
q2 AS
(
SELECT
RouteCode,
count(distinct (case when AccessCode = 0 then CustomerCode end)) as Best
FROM [INTERFACE].[dbo].[LOJ]
WHERE CONVERT(DATE,Date)=CONVERT(Date,GETDATE())
--AND (RouteCode LIKE 'NA' or RouteCode LIKE 'P5' or RouteCode LIKE 'N3' or RouteCode LIKE 'N5' or RouteCode LIKE 'P2' or RouteCode LIKE 'NE' or RouteCode LIKE 'P6' or RouteCode LIKE 'N7' or RouteCode LIKE 'NB')
AND RouteCode IN ('NA','P5','N3','N5','P2','NE','P6','N7','NB')
GROUP BY [RouteCode]
),
q3 AS
(
SELECT
RouteCode,
count(CustomerCode) as Number
FROM [INTERFACE].[dbo].[v_ VPlan]
WHERE CONVERT(DATE,VisitDay)=CONVERT(Date,GETDATE())
--AND (RouteCode LIKE 'NA' or RouteCode LIKE 'P5' or RouteCode LIKE 'N3' or RouteCode LIKE 'N5' or RouteCode LIKE 'P2' or RouteCode LIKE 'NE' or RouteCode LIKE 'P6' or RouteCode LIKE 'N7' or RouteCode LIKE 'NB')
AND RouteCode IN ('NA','P5','N3','N5','P2','NE','P6','N7','NB')
GROUP BY [RouteCode]
)
SELECT
q1.RouteCode,
sum(q1.sti) + SUM(q1.SPAR) +SUM(q1.OTHERS) as Total,
sum(q1.sti) as sti,
SUM(q1.SPAR) AS Spar,
SUM(q1.OTHERS) AS OTHERS,
SUM(q2.Best) AS best,
SUM(q3.Number) AS Scheduled,
SUM(q1.Customers) as Customers,
case when q1.RouteCode is null then null else max(q1.Route_Name) end as Route_Name
FROM q1
LEFT JOIN q2 ON q2.[RouteCode] = q1.[RouteCode]
LEFT JOIN q3 ON q3.[RouteCode] = q1.[RouteCode]
GROUP BY q1.[RouteCode] WITH ROLLUP Forms 2: Microsoft Powerpoint file
multiple powerpoint files from network folder(path)
Forms 3: Multiple video files (MP4,FLV,MOV,etc)
Multiple video files from network folder(Path)
Requirement:
Each forms should change and display every after 5 min.
example : first form1 should display then after 5 mins form1 should minimized and
form2 should show the slideshow and then after 5 mins form2 should minimized and form3 should play the video and
then after 5 mins form3 should minimized and pause the video then form1 should display.
It should keep doing the same steps as above.
Please advise...
Use a timer in a hidden main form and switch your forms when it executes.
这篇关于每隔5分钟后自动在表格之间进行随机播放的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
