好记性不如烂笔头,日志中记录了本人学习时遇到的知识点,方便自己回顾所学,也给有需要的童孩提供参考。欢迎大家阅读,并提出宝贵意见。

QTP:select case语句

上一篇 / 下一篇  2013-04-08 16:57:15 / 个人分类:QTP技术

select case语句与Switch语句差不多,但是select case更富层次感
例子:
    Select Case ExamType
        Case "按时考试"
            QTP_CheckSearch"组织考试_按时考试","select COUNT(*)as ReData from dbo.ExamConfig where ExamID=(select ExamID from dbo.ExamPaper where ExamName='QTPS随机生成试卷'and ExamType=1)","ReData"
        Case "随到随考"
            QTP_CheckSearch"组织考试_随到随考","select COUNT(*)as ReData from dbo.ExamConfig where ExamID=(select ExamID from dbo.ExamPaper where ExamName='QTPS随机生成试卷'and ExamType=2)","ReData"
        Case "练习"
            QTP_CheckSearch"组织考试_练习","select COUNT(*)as ReData from dbo.ExamConfig where ExamID=(select ExamID from dbo.ExamPaper where ExamName='QTPS随机生成试卷'and ExamType=3)","ReData"
    End Select



TAG:

 

评分:0

我来说两句

Open Toolbar