如何快速生成一个全能的表（视图）数据集

wwip

数据集
人力资源表_P

SELECT * FROM `t_humanres`
where 1=1
${if(len(hid)==0,nofilter," and Id = '" + hid + "'")}
${if(len(login)==0,nofilter," and login = '" + login + "'")}
${if(len(pwd)==0,nofilter," and pwd = '" + pwd + "'")}
${if(len(empname)==0,nofilter," and empname = '" + empname + "'")}
${if(len(area)==0,nofilter," and area = '" + area + "'")}
${if(len(department)==0,nofilter," and department = '" + department + "'")}
${if(len(employment)==0,nofilter," and employment = '" + employment + "'")}
${if(len(professional)==0,nofilter," and professional = '" + professional + "'")}
${if(len(job)==0,nofilter," and job = '" + job + "'")}
${if(len(realjob)==0,nofilter," and realjob = '" + realjob + "'")}
${if(len(Jobseq)==0,nofilter," and Jobseq = '" + Jobseq + "'")}
${if(len(coefficient)==0,nofilter," and coefficient = '" + coefficient + "'")}
order by ${if(len(t_inter_cname) == 0,"1=1"," "+ t_inter_cname +" ")}${if(len(orderby)==0,""," "+ orderby +" " )}