一个在页面中写代码的组合查询语句

string sql="";

if (DTRequest.GetFormString("area")!="") //工作地点不为空

{

    sql=sql+" and jobArea='"+DTRequest.GetFormString("area")+"'";

}

if (DTRequest.GetFormString("jobType")!="") //工作岗位不为空

{

    sql=sql+" and jobTitle like '%"+DTRequest.GetFormString("jobType")+"%'";

}

if (DTRequest.GetFormString("selPostDateRange")!="") //几天内

{

    sql=sql+" and   Datediff(day,add_time,GetDate())<"+DTRequest.GetFormInt("selPostDateRange")+"";

}

if (DTRequest.GetFormString("dept")!="") //招聘公司

{

    sql=sql+" and jobCompany='"+DTRequest.GetFormString("dept")+"'";

}

if (DTRequest.GetFormString("keyword")!="") //工作地点不为空

{

    sql=sql+" and jobtitle like '%"+DTRequest.GetFormString("dept")+"%'";

}