select currentlyvalue from fw_sysconfig where PARAMCODE=‘isDegreeCourse’
–注:currentlyvalue=‘是’ 下面sql中使用条件:isdegreecourse = ‘是’ ;否则使用条件 studytypecode = 1
SELECT *
FROM base_trainschemecourse
where isdegreecourse=(case when (select currentlyvalue from fw_sysconfig where PARAMCODE=‘isDegreeCourse’)='是’then ‘是’ else isdegreecourse end)
and studytypecode=(case when (select currentlyvalue from fw_sysconfig where PARAMCODE=‘isDegreeCourse’)='是’then studytypecode else ‘1’ end)