var strCon = "";
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon ="FEmployeeName like '%"+window.form1.FEmployeeName.value+"%'";
if(con2!="")
strCon ="FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon ="FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon ="FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";以上是只能单个查询,如果要con1,con2,con3,con4两个或者三个不为空的时候 查询咋办
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon ="FEmployeeName like '%"+window.form1.FEmployeeName.value+"%'";
if(con2!="")
strCon ="FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon ="FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon ="FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";以上是只能单个查询,如果要con1,con2,con3,con4两个或者三个不为空的时候 查询咋办
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon +="and FEmployeeName like '%"+window.form1.FEmployeeName.value+"%' ";
if(con2!="")
strCon +="and FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon +="and FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon +="and FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";
strCon=strCon.TrimStart("and");
或者 if(con1!=""&&con2!="")
你自己拼凑嘛
JS没有TrimStart方法
你可以初始让
var strCon = "1=1 ";
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon +="and FEmployeeName like '%"+window.form1.FEmployeeName.value+"%' ";
if(con2!="")
strCon +="and FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon +="and FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon +="and FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";
这样就不会出错了
var strCon = "1=1 ";