回答:${if(month1=12,
"SELECT
pk_psndoc,f_1,f_190,f_31,f_39,f_40,f_41,f_42,f_43,f_44,f_45
FROM
wa_data a
WHERE
a.cperiod BETWEEN '"+month+"'
AND '12'
AND a.cyear = '"+year+"'
AND pk_wa_class = '1001A11000000000155V'
UNION
SELECT
pk_psndoc,f_1,f_190,f_31,f_39,f_40,f_41,f_42,f_43,f_44,f_45
FROM
wa_data a
WHERE
a.cperiod BETWEEN '"+month+"'
AND '12'
AND a.cyear = '"+year+"'
AND pk_wa_class = '1001A11000000000436F'
UNION
SELECT
pk_psndoc,f_1,f_190,f_31,f_39,f_40,f_41,f_42,f_43,f_44,f_45
FROM
wa_data a
WHERE
a.cperiod = '01'
AND a.cyear = '"+year+"' + 1
AND pk_wa_class = '1001A11000000000153U'
UNION
SELECT
pk_psndoc,f_1,f_190,f_31,f_39,f_40,f_41,f_42,f_43,f_44,f_45
FROM
wa_data a
WHERE
a.cperiod = '01'
AND a.cyear = '"+year+"' + 1
AND pk_wa_class = '1001A11000000000155V'"
,
"SELECT
pk_psndoc,f_1,f_190,f_31,f_39,f_40,f_41,f_42,f_43,f_44,f_45
FROM
wa_data a
WHERE
a.cperiod BETWEEN '"+month+"'
AND '"+month1+"'
AND a.cyear = '"+month+"'
AND pk_wa_class = '1001A11000000000155V'
UNION
SELECT
pk_psndoc,f_1,f_190,f_31,f_39,f_40,f_41,f_42,f_43,f_44,f_45
FROM
wa_data a
WHERE
a.cperiod BETWEEN '"+month+"'
AND '"+month1+"'
AND a.cyear = '"+year+"'
AND pk_wa_class = '1001A11000000000436F'"
)}