编辑代码

-- 根据procedure参数动态生成SQL查询
${if(procedure=="battery_spc_gather_auto",
"select distinct bsga.\"FurnaceID\" as \"FurnaceID\"
from battery_spc_gather_auto bsga 
where bsga.workshop = 'C1'
order by bsga.\"FurnaceID\"",
"")}

${if(procedure=="spc_anneal_sheet_resistance_online",
"select distinct bsga.\"FurnaceID\" as \"FurnaceID\"
from spc_anneal_sheet_resistance_online bsga 
where bsga.workshop = 'C1'
order by bsga.\"FurnaceID\"",
"")}

-- 增加工序
${if(procedure=="battert_spc_scales_texturing",
"select distinct bsga.\"lineNo\" as \"FurnaceID\"
from battert_spc_scales_texturing bsga 
where bsga.workshop = 'C1'
order by bsga.\"lineNo\"",
"")}

${if(procedure=="battert_spc_scales_alkalicase",
"select distinct bsga.\"lineNo\" as \"FurnaceID\"
from battert_spc_scales_alkalicase bsga 
where bsga.workshop = 'C1'
order by bsga.\"lineNo\"",
"")}

${if(procedure=="spc_texturing_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_texturing_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}
${if(procedure=="spc_alkalicase_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_alkalicase_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}

${if(procedure=="spc_pepoly_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_pepoly_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}
${if(procedure=="spc_alumina1_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_alumina1_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}

${if(procedure=="spc_alumina2_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_alumina2_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}
${if(procedure=="spc_positive_membrane_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_positive_membrane_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}

${if(procedure=="spc_dorsal_membrane_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_dorsal_membrane_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}
${if(procedure=="spc_pullingforce1_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_pullingforce1_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}

${if(procedure=="spc_pullingforce2_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_pullingforce2_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}
${if(procedure=="spc_threepointbendingresistance_offline",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from spc_threepointbendingresistance_offline bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}

${if(procedure=="battert_spc_scales_silk",
"select distinct bsga.\"equipmentNo\" as \"FurnaceID\"
from battert_spc_scales_silk bsga 
where bsga.workshop = 'C1'
order by bsga.\"equipmentNo\"",
"")}